News for hackers. Stuff that matters.
Re:Distributed, high-performance blob storage on SQLite by sgarland on Thursday November 19, 2026 @10:10AM (#50561133)
> What we learned along the way… Deleting rows doesn’t shrink SQLite files

This is true of every RDBMS I am aware of. It would be horribly inefficient to constantly run page merges in order to be able to free some of them.

Whenever I read things on posts that are a. discussed in documentation b. should be apparent from first principles, I immediately lose faith in the product.

Re:Distributed, high-performance blob storage on SQLite by guywithahat on Thursday November 19, 2026 @11:15AM (#50562025)
I once interviewed with a NYC robotics startup and, reflecting on his past job, he said they migrated away from SQLite3 because they needed a WAL database for their smart grocery cart.

It was hard to take him seriously after that

Re:Distributed, high-performance blob storage on SQLite by tomasol on Thursday November 19, 2026 @11:26AM (#50562195)
Everybody learns. Coming from other databases it might not be obvious that you need to enable vacuum explicitly.
Re:Distributed, high-performance blob storage on SQLite by mbreese on Thursday November 19, 2026 @11:45AM (#50562495)
Especially if you started in an age of remote cloud databases. The further we get away from the infrastructure we use, the less we know about nuances like this. What used to be considered common knowledge gets lost when you don't have experience with running a DB server.

I mean, today, why would you? It used to be that starting a new CRUD project meant at least an hour of setting up web servers, database servers, proxies, etc. Today, that's all abstracted away for pennies an hour.

Re:Distributed, high-performance blob storage on SQLite by AtlasBarfed on Thursday November 19, 2026 @12:29PM (#50563132)
Is there really no way to use Cassandra for this use case? A distributed and relatively battle tested database? They didn't want to use SSDB because it lacked support. Okay.

I mean you're one-off vibe-coded distributed database isn't a database until aphyer puts it through it's paces, and until it encounters most CAP its edge cases over years of use.

Otherwise, this isn't a database. It's a black hole of uncertainty that will almost certainly drop writes and commits silently

Re:Distributed, high-performance blob storage on SQLite by simonw on Thursday November 19, 2026 @12:47PM (#50563391)
The problem with that attitude is that you're actively encouraging people to not talk about things they've just learned that might be obvious, for fear of being judged negatively by people like you. That harms the discourse.