Hacker News new | past | comments | ask | show | jobs | submit | kiwijamo's comments login

Which other SQL engines do this? The ones I'm familiar with (MySQL, PostgreSQL, Microsoft SQL, Orcale to name a few) certainly don't behave anywhere close to how SQLite behaves.

Another question would be "Should Apache support HTTP/3?". Personally I'm happy with the status quo and would need some convincing that it's worth turning on a new protocol.

I've stuck with Apache given it is what I know, having used it for over 15 years. Despite its flaws, it does the job pretty well. I'm also more confident that Apache's code is more battle tested. On top of that I disable all the modules I don't need so my attack surface is pretty small. I run a static site so I basically run Apache with only a few of its core modules. I've tried others (especially Caddy) and while I appreciate some of the enhancements, they don't really add any significant improvements for my use cases.

It's not just that the cache is invalidated, I also suspect Google changes the JS code fairly frequently enough that the browser needs to download a fresh copy (even if the cache it has is not that old and could otherwise have been reused). Compiled apps on the other hand are much more static.

To be fair you only have to download the 70 MB once (+ the occasional updates). Gmail instead pushes its JS over and over again. Every time I load Gmail it feels like it's starting from Square One all over again but even actually using it (opening, replying, etc) feels slow. Thankfully one of my several $WORK email accounts is 365 based so I just redirect my two other $WORK_RELATED Gmail accounts there. Big productivity boost that way since I get instant access to my emails without having to wait for the JS to load over the network.

Not all users. ISPs around my part of the world do not behave as badly as US ISPs seem to. Most (although I actually believe it is all) ISPs in my home country do not do anything special to DNS lookups. This means there is literally no benefit to using an off-shore DNS resolver such as those provided by Google, Cloudflare, et al. It just makes DNS lookups slower for us.

Not every ISP has malicious DNS resolution. For many people outside the US, their ISP DNS server is a superior option to Google DNS.

Possibly, but not in Australia. Among other things our government has a secret blacklist it forces ISPs to implement. https://en.wikipedia.org/wiki/Internet_censorship_in_Austral...

The usual reasons are given - protecting children and preventing other illegal activity, which is all well and good and commendable in theory. However there have been instances where the filter has been used to silence opposing political opinions, as well as prevent access to materials on subjective moral grounds (ie "hardcore" pornography, online gambling, discussion of suicides, etc) where the government has decided Aussies shouldn't do that sort of thing, which seems a bit puritanical and mildly thought police-y.

It's not like we're in an "actual dictatorship", by and large the representative democracy trundles along as best these things do, and the life and freedoms we enjoy in Australia make us incredibly privileged compared to much of the world. But this whole online censorship and thought policing our government seems fond of is something I disagree with. In addition to banning certain forms of speech and text, they're now pushing through an act that sets the stage for de-anonymising all users online with a government-issued "Digital ID", the next step presumably being making it illegal to provide and use anonymous web services in Australia. That has broad implications for things like Reporters Without Borders, corporate and government whistleblowers, etc.

Coupled with a historical record of every blocked or "suspect" DNS attempt, and these trends paint a dire picture for individuals who may have legitimate interests or even just curiosity about something like "how are drugs made." Handing this information to the federal government seems risky to me because I don't know what they're going to decide to make illegal to read and write about in the future. Our government has talked seriously about banning encryption many times over the years, and are currently at war against social media, so who knows what they'll do.

That doesn't mean I agree that people should get away with heinous acts or organised crime, but it's why I personally avoid using my ISP's DNS resolution in Australia. I don't exactly trust Google either, but I'd rather they deal with my DNS lookup than our technophobe government.

Sorry for the long rant, probably could have just left it at my first sentence, but it all touches on the one subject in Australian politics that really rubs me the wrong way, and most people I talk to here are of the mind "if you're not doing something wrong, there's nothing to worry about." Just, gah!

Preloaded from the factory maybe?

Oh, OK. That didn't occur to me, as I thought to be timely ads would need to come from a server.

What SD brands do you usually buy? Are the Sandisk Extreme range any good?

Sandisk, Lexar, Prograde. Depends on the application.

My raspberry pi doesn't do many disk operations so the speed isn't critical and 90 MB/s is plenty. My digital camera, on the other hand, has dual SD card slots, and can record uncompressed(!) 10 bit 4k video @ 60fps but needs 2 x 400 MB/s continuous write, which is... a pretty specific need. And cost accordingly.

I find Samsung much more reliable than Sandisk in my pis

Been a while since I've used Debian but I'm sure Debian is already using NetworkManager. This means the Raspberry OS has actually removed NetworkManager from its Debian base and put in something else. I agree with the OP this shouldn't happen. For my Raspberry Pi, I ended up switching out the Raspberry Pi OS' default networking manager thingy in preference for NetworkManager so I could share wireless networking configuration among my devices. It also helps with troubleshooting as well since I can just use the same commands I use on other Linux machines even those running other distros.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact