Personally, I’ve been enjoying cozy games like Dorfromantik, Rail Route, or even Transport Fever 2 (I just play with unlimited money and build great transit networks that I wish existed in my home country.)

The laptops are manufactured in Taiwan. There’s so much unpredictability in the tariffs so they’re delaying until it settles down. Tariffs are going to impact US companies and US residents.

Oh that would be nice. I would use that to just go into the database and fix all my broken music metadata which I can’t see to fix any other way.

That’s a good reason for people to take the money they would have spent buying a proprietary solution and instead donate that money to an open source project. For me it’s not always about the cost, but what I get out of it. I’d rather the money go to the community and better it.

Here’s a good reason why you should pin to specific sha hashes, not just release versions.

it doesn’t seem to open when I’m on the extension store

Firefox marks certain pages as privileged and no extensions will run on them. You’re probably encountering this issue. You can see the full list here.

Its only everything from other instances and communities that the current instance subscribes to. It doesn’t subscribe to the full pipe of everything.

What’s likely happening is people in aggregate generally subscribe to the most popular communities and those communities have the most upvoted posts.

but completely backwards in thinking that an undocumented bluetooth backdoor is worse than the worst vulnerability found since the invention of the internet

Right HeartBleed was way worse than this, not on the same level. I wasn’t claiming the opposite.

I was responding to the comment that appeared to suggest they were on the same level.

No way they’re on the same level. Heartbleed allowed for remote memory reads. This requires you to have access to change the firmware and just gives you some more APIs to control the WiFi system and possibly bypass firmware verification.

It all depends on how it’s represented on disk though and how the query is executed. Sqlite only supports numbers and strings, and if you keep using a VARCHAR, a read of those rows are going to have materialize a string into memory inside the sqlite library. DuckDB has more types, but if you’re using varchars everywhere, something has to read that string into memory unless you can push down logic into a query that doesn’t actually have to read the actual value, such as one that can use indices.

The best way is to change the representation on disk, such as converting low-cardinality columns like the station into a numeric id. A standard int being four bytes is a lot more efficient than an n-byte string + a header and it can be compared by value.

This is where file formats, like Parquet, shine. They’re oriented more towards parsing by systems. JSON is geared towards human parsing.

Back in early 2024, I got a survey asking me why I chose to cancel my prime membership and I gave them multiple reasons.

The companion post, I Went To SQL Injection Court, goes into detail about the court process and witness testimony. One of the interesting things is just how different computer people think about security vs lawyers. Somebody might say that having a schema would help a malicious actor a small amount, and a lawyer will jump on that to deny the request. The idea that the schema would help a malicious actor is the same as a map helping a bank robber. The vault security and security guards are the relevant factors for this, not the map.

I’ll keep this in mind the next time I’m an expert witness in a computer case (based on this, I hope I’m not.)

On Windows the system wakes up when connected or disconnected from an AC adapter. On Linux the system will momentarily wake up but immediately go back into suspend.

I get why this could be a source of bugs, but if I unplug my laptop while its asleep why would I want it to turn on?

Do the services themselves have any logs? Do you have a reverse proxy? Does it provide any logs? 503 means something received the request and tried to pass it on so something should have logs.

Interesting. I just learned about Rye today. Has anybody tried it? Does it live up to the promise?

Totally. I used to contribute to Google maps quite a bit and got higher up in the Local Guides levels, but now I find myself contributing a lot to OSM. I feel a lot better about contributing to an open platform vs letting a company close up my changes.

I just haven’t made the switch to use it as a mobile client yet

I’ve been eagerly looking forward to the time when I can replay my Echo Dots with a self-hosted solution, but so far I haven’t found hardware that I really liked the look and style of.