chaospatterns

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.

I stopped using it to pay because then I'd have to set up a PIN, and then type in the PIN every time I want to use it

This shocked me when I went from my Galaxy Watch 3 to a Galaxy Watch 6. I used to only have to put a PIN when I wanted to pay, but now it's anything on the watch?

Because of that, I also disabled the payment app.

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.

In this context, SKU refers to a variant of this product. That is the correct acronym as I understand

I use Jellyfin for music mostly and it struggles with metadata. For example, if a song has two artists on it and I edit to correct it, it won't update correctly and I'll edit up with the artist "Artist A; Artist B".

Have you tried a packet capture with Wireshark or tcpdump to see what it's doing? It might give better clues than a general error message.

Yeah, I'm a little disappointed. I was hoping Unifi would do something like release an AP with integrated Thread support so users could benefit from the already pre-positioned APs to then add Thread coverage.