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.
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.