Aussie living in the San Francisco Bay Area.
Coding since 1998.
.NET Foundation member. C# fan
d.sb
Mastodon: @dan

This profile is from a federated server and may be incomplete. View on remote instance

dan ,
@dan@upvote.au avatar

This is one of the best comments I've ever read on Lemmy. Thanks for writing it. I fully agree with all your points!

dan , (edited )
@dan@upvote.au avatar

Depends on the dialect. I mostly use Presto and MySQL at work, and both allow !=.

Presto also lets you use NOT for booleans - instead of WHERE foo = false, you can do WHERE NOT foo.

dan ,
@dan@upvote.au avatar

SQL is definitely a programming language. Most dialects are Turing-complete in some way. Some allow custom functions and stored procedures.

dan ,
@dan@upvote.au avatar

Google's data shows that IPv6 is usually faster. Their metrics show an average of 10ms less latency over IPv6 in the USA and Canada: https://www.google.com/intl/en/ipv6/statistics.html#tab=per-country-ipv6-adoption

dan , (edited )
@dan@upvote.au avatar

In the USA, around 50% of Google traffic and 60% of Facebook traffic goes over IPv6. The largest mobile carriers in the US are nearly entirely IPv6-only too (customers don't get an IPv4 address, just an IPv6 one), using 464XLAT to connect to legacy IPv4-only servers. I'm sure we'd know if routing with IPv6 was slower. Google's data actually shows 10ms lower latency over IPv6: https://www.google.com/intl/en/ipv6/statistics.html#tab=per-country-ipv6-adoption

dan ,
@dan@upvote.au avatar

accidentally get subnets segmented off, no listening ports, have to explicitly configure port forwarding to be able to listen for connections

You can intentionally get that behaviour by using a firewall.

dan , (edited )
@dan@upvote.au avatar

Good luck finding the used ones.

That and the IPv6 address on client systems will periodically rotate (privacy extensions), so the IPs used today won't necessarily be the ones used tomorrow.

(you can disable that of course, and it's usually disabled by default on server-focused OSes)

dan ,
@dan@upvote.au avatar

There is this notion that IPv6 exposes any host directly to the internet, which is not correct.

TP-Link routers used to actually do this. They didn't have an IPv6 firewall at all. In fact they didn't add an IPv6 firewall to their "enterprise-focused" 10Gbps router (ER8411) until October 2023.

dan ,
@dan@upvote.au avatar

It's great that the address space is so large. When designing a new system, you want to make sure it'll hopefully never encounter the same issue as the old system, to ensure you don't have to migrate yet again.

dan , (edited )
@dan@upvote.au avatar

You can use ULAs (unique local addresses) or that purpose. Your devices can have a ULA IPv6 address that's constant, and a public IPv6 that changes. Both can be assigned using SLAAC (no manual config required).

I do this because the /56 IPv6 range provided by my ISP is dynamic, and periodically changes.

dan ,
@dan@upvote.au avatar

NAT is, and has always been, an ugly hack. Why would anyone like it?

dan ,
@dan@upvote.au avatar

You wouldn't need NAT. The ULA is used on the internal network, and the public IP is for internet access. Neither of those need NAT.

dan , (edited )
@dan@upvote.au avatar

If you use a single shared public ip then you’re using some amount of address translation

This is practically never the case with IPv6. Usually, each device gets its own public IP. This is how the IPv4 internet used to work in the old days (one IP = one device), and it solves so many problems. No need for NAT traversal since there's no NAT. No need for split horizon DNS since the same IP works both inside and outside your network.

There's still a firewall on the router, of course.

At least that’s how I understand ipv4 and I don’t think ipv6 is much different.

With IPv6, each network device can have multiple IPs. If you have an internal IP for whatever reason, it's in addition to your public IP, not instead of it.

IPs are often allocated using SLAAC (stateless address auto config). The router tells the client "I have a network you can use; its IP range is 2001:whatever/64, and the client auto-generates an IP in that range, either based on the MAC address (always the same) or random, depending on if privacy extensions are enabled - usually on for client systems and off for servers.

dan , (edited )
@dan@upvote.au avatar

There's no translation between them. With IPv6, one network interface can have multiple IPs. A ULA (internal IP) is only used on your local network. Any internet-connected devices will also have a public IPv6 address.

ULAs aren't too common. A lot of IPv6-enabled systems only have one IP: The private one.

dan ,
@dan@upvote.au avatar

Having a large range has a number of benefits though. Companies that have dozens of IPv4 ranges may be fine with a single IPv6 range, which simplifies routing rules.

A lot of features in IPv6 take advantage of the fact that networks have at least a /64 range (at least if they're built correctly according to RFC4291 and newer specs). SLAAC is a major one: Devices can auto-configure IP addresses without having to use something like a stateful DHCP server.

dan , (edited )
@dan@upvote.au avatar

your external IPs might change, such as when moving between ISPs

This is true

You would NAT a hosts external address to its internal address.

This is usually not true.

If you're worried about your external IP changing (like if you're hosting a server on it), you'd solve it the same way you solve it with IPv4: Using dynamic DNS. The main difference is that you run the DDNS client on the computer rather than the router. If there's multiple systems you want to be able to access externally, you'd habe multiple DDNS hostnames.

dan ,
@dan@upvote.au avatar

NodeBB is probably less painful to deal with as a system adminstrator, since it doesn't use Ruby.

Lots of forum software used to have threaded discussions, but most of them settled on a more linear commenting experience, maybe 20 years ago.

dan ,
@dan@upvote.au avatar

You can't fill it out with Firefox? I think pdf.js (which Firefox uses) supports PDF forms.

dan ,
@dan@upvote.au avatar

Ahh, it's probably using some proprietary features that only exist in Adobe products.

I'm not sure if they still sell it, but Adobe used to have a suite of form tools where the person filling out the form had to use Adobe Acrobat (it used some non-standard PDF form features), and the company collecting the form responses had to use software built on top of Adobe ColdFusion (which costs thousands of dollars per server). They really tried to lock people in to their form ecosystem.

dan ,
@dan@upvote.au avatar

DJI has 70% of the global drone market share, so banning this company might actually help innovation.

That's... Not how innovation works. Why would other companies want or need to innovate if their main competitor disappears? If anything, the opposite will happen - they won't have to try as hard to make a great product, since they no longer need to be better than the market leader.

Apple is bringing RCS to the iPhone in iOS 18 | The new standard will replace SMS as the default communication protocol between Android and iOS devices ( www.theverge.com )

The long-awaited day is here: Apple has announced that its Messages app will support RCS in iOS 18. The move comes after years of taunting, cajoling, and finally, some regulatory scrutiny from the EU....

dan , (edited )
@dan@upvote.au avatar

It's still common in the USA for some reason. I think because SMS has been free for a long time and people don't like change. Other apps gained popularity elsewhere in the world because SMSes were expensive.

dan , (edited )
@dan@upvote.au avatar

Apple have a surprising amount of open-source software. The OS that MacOS and iOS are built on top of (Darwin) is open-source, as is its kernel (XNU). The engine used by Safari (Webkit, forked from KDE's KHTML) is open-source too.

It's not really traditional open-source, though. It does use an OSS license, but they don't really accept public contributions, nor do they track bugs publicly or have a public roadmap.

dan , (edited )
@dan@upvote.au avatar

Twitter no longer loads newer tweets if you're logged out. Instead of showing a proper message, it either fails to load or redirects to the login page. They did that to prevent scraping.

dan ,
@dan@upvote.au avatar

I wonder if any of the other sharks will make an offer

dan , (edited )
@dan@upvote.au avatar

Threads is federated though. You can follow Threads accounts on Mastodon. It's still a work in progress though, and not everything is implemented yet.

dan ,
@dan@upvote.au avatar

Yeah I've only ever had one LED bulb die, and I think that was because it was faulty in some way. I've had a much better experience with them compared to CFLs.

dan ,
@dan@upvote.au avatar

In the San Francisco Bay Area, it's not uncommon for people that work here but can't afford to live here to have commutes of over an hour with good traffic (2+ hours with heavy traffic) each way. That's the case in a few major metro areas in countries like the USA and Australia.

dan ,
@dan@upvote.au avatar

A lot of people in Silicon Valley don't like this AI stuff either :)

A PR disaster: Microsoft has lost trust with its users, and Windows Recall is the straw that broke the camel's back ( www.windowscentral.com )

It's a nightmare scenario for Microsoft. The headlining feature of its new Copilot+ PC initiative, which is supposed to drive millions of PC sales over the next couple of years, is under significant fire for being what many say is a major breach of privacy and security on Windows. That feature in question is Windows Recall, a...

dan ,
@dan@upvote.au avatar

Safari is still a pain for frontend developers to deal with. At least IE6 was a static target and we were well aware of all the bugs. Some of the bugs and workarounds even had names, like the "peekaboo bug" and the Holly Hack".

Safari is a moving target that has so many bugs and issues that none of the other major browsers have.

dan ,
@dan@upvote.au avatar

A big reason Apple focuses on privacy and apps not being able to track the user is because they want to keep all that data for themselves. None of the restrictions they've introduced apply to first-party apps. It gives them ad targeting data that no other company can collect. They do have their own ad network (for things like ads in the App Store), and last I heard, they wanted to expand it.

dan , (edited )
@dan@upvote.au avatar

This post comes a bit late - Microsoft announced this four years ago. https://devblogs.microsoft.com/commandline/microsoft-open-sources-gw-basic/

dan ,
@dan@upvote.au avatar

Many people would prefer a paid service over an ad supported one.

dan ,
@dan@upvote.au avatar

Supermarkets maximizing profit: put ads everywhere and hide the most commonly bought foods!

Many supermarkets already do things like putting the milk and bread at opposite sides of the store, so you have to walk through the whole store to get both. You'd often be walking past the end caps while doing so, which are essentially ads (companies pay to have their products displayed at the end caps)

dan ,
@dan@upvote.au avatar

Unskippable ads on all pumps are absolutely a thing that are getting more popular

I never see these in my area... Maybe only some places have them?

dan ,
@dan@upvote.au avatar

apparently has been using Bing as it's back-end now.

A lot of stuff uses Bing to search, as it's the largest search engine with an official public API that any developer can just sign up and use. Voice assistants like Alexa use Bing too.

dan ,
@dan@upvote.au avatar

Some of the ads are charged by CPM (cost per 1000 impressions), meaning Google get paid just because people see the ads. That's similar to how ads in traditional media are billed - TV, billboards, newspapers, etc.

Not all ads use CPM though. Some use CPC (cost per click) and some use CPA (cost per action).

dan ,
@dan@upvote.au avatar

Unrelated to your question but which firewall app do you use?

dan OP ,
@dan@upvote.au avatar

That sounds reasonable to me.

It wouldn't help with the URL though. Maybe I could write a script that uploads the image then puts the right URL on the clipboard, and "share to" the script.

dan , (edited )
@dan@upvote.au avatar

My understanding is that 64-bit time fixes are only needed for 32-bit architectures, based on Debian's notes about the time_t migration project: https://wiki.debian.org/ReleaseGoals/64bit-time. 64-bit apps already have a 64-bit time_t, at least in Debian (and I assume Ubuntu too) with their standard compiler settings. It's mostly for 32-bit ARM CPUs. 64-bit architectures still need to be tested since build/code changes can unintentionally affect them too.

dan ,
@dan@upvote.au avatar

Glorified autocomplete

That's what I need most of the time, though. I don't see these AI things as replacing programmers or writing large chunks of code. I just see them as an improvement over the autocompletion/IntelliSense features we're all using already.

dan , (edited )
@dan@upvote.au avatar

I'm an Aussie in my early-mid 30s. I've been living in the USA for the past 11 years. I've been a software developer, mostly focusing on web development, since the late 90s personally and since the mid 2000s professionally. I was an early Digg user, moved to Reddit during the Digg exodus, then moved to Lemmy during the Reddit exodus.

I believe that people on the internet should own their platform, for example run their own blog or e-commerce site, participate in decentralized services like Lemmy, etc. Opera Unite was something I found very interesting in terms of allowing people to easily run their own decentralized stuff, and I'm kinda sad it never took off. I self-host things like email and DNS.

I'm a big believer in open-source software and released my first piece of OSS in 2005.

I love listening to people that are passionate about something and get excited when talking about it. Doesn't really matter what it is or if it's a topic I'm interested in.

dan ,
@dan@upvote.au avatar

11th gen is just a few years old. Very different to trying to run something on a Core 2 Duo which is probably close to 20 years old.

dan , (edited )
@dan@upvote.au avatar

I remember them being exactly the dame many years ago

This is one of the reason I like Debian. They don't change stuff unless there's a good reason to. Network configuration on my Debian servers is in /etc/network/interfaces in mostly the same format it was in 20 years ago (the only difference today is that I'm dual-stack IPv4/IPv6 everywhere).

dan ,
@dan@upvote.au avatar

"ButterFS" is one of the accepted pronunciations though.

dan ,
@dan@upvote.au avatar

shortest names possible

This film from 1975 is still relevant today: https://www.youtube.com/watch?v=7hdJQkn8rtA

Torrenting exposes your public IP. In a country where government doesn't care, does that pose a risk?

I honestly don't believe I will have any legal trouble because I don't do anything like cp or worse, I just pirate media I like, not even porn. But across users of communities, or on public trackers, is IP exposure something to be concerned about?

dan ,
@dan@upvote.au avatar

A VPN can also have a faulty config. Everything depends on correct configs :)

  • All
  • Subscribed
  • Moderated
  • Favorites
  • kbinchat
  • All magazines