SQLite

“A decade of SQLite use has also made me comfortable with the underpinnings”

“SQLite does a great job to support single writer and multiple readers. That's what we use for aggregation right now.”

“Generally I target enterprise b2b customers... you can go far further than you think on sqlite”

“the 'Lightspeed' version of Messenger was something of an engineering marvel. Specically the way it was centered around SQLite as the datastore”

“based on socket.io and sqlite. It works vastly better for my use cases, since socketio and sqlite are so mature.”

“Litestream for me at least is what makes SQLite viable for a web app”

“I've been running unfederated Matrix instance with sqlite for 10 years for 10-20 people... In WAL mode sqlite is fine”

“we run a fairly busy systems on sqlite + litestream. ... Vastly simpler than running + maintaining postgres/mysql”

“by switching to SQLite/Litestream > Cloudflare R2 replication to avoid needing to using a managed RDBMS”

“we switched to SQLite which worked extremely well”

“a SQLite DB with some basic turn key CRUD admin tools was fantastic.”

“I did a SQLite course and I've been using those skills in a big way in two recent software projects.”

“Thanks to its simplicity for development and hosting SQLite has become our first choice for new Apps.”

“We have that issue at work, though I solved it by including the sqlite database within the container image that we use.”

“I've been using a lot of bun:sqlite lately which has an amazing DX”

“we've still not had any outages related to SQLite in the 8+ years we've been using it in prod.”

“The Android & iOS apps used SQLite for this since 2020 (I built the Android version IIRC)”

“sometimes SQLite is a better fit-- when a DB is only a few MB on an internal app etc.”

“I'm of the opinion that SQLite is the musl of the SQL world. By deciding that you'll support it first-class”

“We have 10 servers federating in production, each housing around 270,000 users, and it all runs on disk and sqlite, quite affordable!”

“Building new-fangled single-binary PHP executables, using sqlite in prod, deploying WITHOUT Docker: these make it enjoyable for me.”

“yes, we use BEGIN IMMEDIATE with a 2 second busy timeout”

“we moved to sqlite for performance reasons once the files started getting to multi-gigabyte sizes. It works great”

“I would not be at all afraid to use SQLite in prod for internal tools etc.”

“we've seen good performance at low cost”

“We've been using SQLite in production as our exclusive means for getting bytes to/from disk for going on 6 years now.”

“I've ran sqlite in production for a variety of products over the years and for the most part it's great.”

“I can use SQLite as an in-memory database for unit tests, which makes those much faster”

“it's so much easier to add new queries using SQL compared to writing IDB iterations - and it's faster. So we switched to using native SQLite”

“The coolest piece of tech we use is probably a toss-up between .NET Core, Blazor and SQLite.”

“we have been using SQLite as our only datastore for almost 5 years now without a single DB-related incident.”

“I have run several production web apps on sqlite, it's fine unless you have enough traffic”

“at Dannea we use sqlite compiled to JS... so it allows us to have sqlite powered web apps which can be emailed to others and is true server less”

“In 8 years, 2158341079 writes, and probably 100x that many reads, I don't think I've ever had a single failure or bug with SQLite itself.”

“We use SQLite extensively in Minuum and I couldn't be happier.”

“Until 2010, I ran a forum on SQLite with 600 users/day + around 1000 posts/day on a single OpenBSD machine”

“I have successfully used EF with SQLite in production”