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.
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?
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.
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".
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?
I'm working on adding ActivityPub to my Hugo blog right now. I support RSS, but I figured AP support means that you can get it into your Mastodon feed or even Lemmy feed making it easy to follow. Additionally, commenting (assuming it doesn't get taken over by spammers.)
How many users are using browsers that are old enough they don't even support JS? It's one thing to disable it for security/privacy (which the OP was talking about), because those users are probably more tech savy.
I tried self hosting Pixelfed but gave up because it wouldn't work. I'm used to Docker containers that are able to just start up by themselves, but the guide didn't work for me. Maybe it's time to try again.
No, the cable isn't going to implement the protocol. You need endpoints that are able to talk that protocol. That might be done with a firmware update or require new hardware.
I just saw this one mention endurain, a fitness tracker. I've been looking for something to self host data about my health, fitness, etc. Has anyone tried this or anything else in the self-hosted or open source fitness space?
I think I ignored a lot of signs and indications under the feeling that well "I'm promo tracked to the next level and I worked hard so I'll ignore it." My partner told me to talk to somebody, friends said I worked hard. But then slowly my motivation to work at my job decreased. I delivered less, I made up excuses, I stop caring about projects when I used to really care. Which was a huge difference because I used to be a top tier developer every year.
But the big part was my personal life. After work I was tired and not motivated, even though I would barely do any work. loosing interest in hobbies was a big indication. Going to the gym, but not really pushing myself, etc. I think there's some parallels with depression, but I never felt like I had that because I kept getting out of bed doing things.
I had a friend deacribe their experience and I just started thinking yeah I feel the same way. I finally had a health issue/mental breakdown that caused me to go to the doctor and pursue FMLA leave which is giving me partial pay to just focus on myself, focus on friends, and talk to a therapist. I don't know what I'll do when it ends. Probably won't go back to the company.
Weirdly, a lot of my friends in the big tech industry have hit a breaking point and are leaving or on leaves.
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.