I’ve used SQLite for some small projects and it was a very pleasant experience.
Does anyone have examples of the complex/ big projects that use SQLite ? I’m curious what problems they ran into, and how they were addressed.
Does anyone have examples of the complex/ big projects that use SQLite ? I’m curious what problems they ran into, and how they were addressed.
There were other systems that would use these hundreds of databases a few gigabytes each and create models from them for early failure detection and other things.
I wish I could say this was difficult or didn't work but pretty basic scripting and sqlite on commodity hardware doing normal cpu computation got us there beyond our expectations using cheap digital ocean VPS servers with modest memory. I can be a pretty obnoxious brat when open source things are broken and nobody is taking them seriously. Here though, people took it seriously and it wasn't broken. I'm continually impressed by it. This was pre-pandemic for a timeline.
One twitter-famous Core Data/SQLite engineer's bio on Twitter used to read "Over one trillion databases served", or something to that effect.
One of the problems is that the history may grow excessively large, which SQLite handles well but the History UI does not :)
"Bedrock was built by Expensify, and is a networking and distributed transaction layer built atop SQLite, the fastest, most reliable, and most widely distributed database in the world." (https://bedrockdb.com/)