News for hackers. Stuff that matters.
Re:SQLite is all you need for durable workflows by peterspath on Friday May 29, 2026 @03:32PM (#48328114)
That’s why there are billions of SQLite databases right?

SQLite is likely used more than all other database engines combined. Billions and billions of copies of SQLite exist in the wild. SQLite is found in:

Every Android device Every iPhone and iOS device Every Mac Every Windows 10/11 installation Every Firefox, Chrome, and Safari web browser Every instance of Skype Every instance of iTunes Every Dropbox client Every TurboTax and QuickBooks PHP and Python Most television sets and set-top cable boxes Most automotive multimedia systems Countless millions of other applications

https://sqlite.org/mostdeployed.html

Re:SQLite is all you need for durable workflows by mr_toad on Friday May 29, 2026 @03:39PM (#48328191)
That’s a comprehensive list of single user devices.
Re:SQLite is all you need for durable workflows by ibejoeb on Friday May 29, 2026 @04:25PM (#48328750)
Single-user, a single natural person, doesn't striclty mean single-accessor though. I don't think anyone here is suggesting that sqlite is a viable replacement a for any networked client/server postgresql system, but it is certainly capable of handling more than the most basic 1:1 tasks. Beyond that, the point is that you only need a file, so when you have natural data boundaries, a lot of problems decompose to that single user/single concern paradigm.
Re:SQLite is all you need for durable workflows by larubbio on Friday May 29, 2026 @04:55PM (#48329128)
'production' doesn't equal 'multi-user concurrent access'. There are production uses where sqlite is a valid choice even if it may not be the best choice for multi-user production use cases.
Re:SQLite is all you need for durable workflows by therealdrag0 on Friday May 29, 2026 @06:42PM (#48330289)
strawman? I have seen a dozens of these debates and never once have I seen someone questioned the validity of it for embedded usecases.
Re:SQLite is all you need for durable workflows by pibaker on Friday May 29, 2026 @03:51PM (#48328309)
GP calls out concurrency as a weakness of SQLite. Most of the examples here don't experience the same load even a moderately sized web service experience day to day.

And no, being a part of the python standard library doesn't means it is being used by the average python user. These days I'd say at least half of them are just there for machine learning.

Re:SQLite is all you need for durable workflows by OutOfHere on Friday May 29, 2026 @06:16PM (#48330039)
SQLite is good for read-concurrency, not great for write-concurrency.
Re:SQLite is all you need for durable workflows by simonw on Friday May 29, 2026 @06:24PM (#48330112)
SQLite requires writes run sequentially. Most SQLite write operations take single digit milliseconds or even microseconds. If your writes are inexpensive (inserting or updating single small rows) you'll probably never even notice the queue.
Re:SQLite is all you need for durable workflows by zarzavat on Saturday May 30, 2026 @05:30AM (#48334351)
Exactly, people confuse "doesn't scale" with "is a bottleneck". There's many applications whereby hitting the limits of SQLite is either a physical impossibility, or implies that the application has achieved success such that replacing SQLite is the least of anyone's problems.

I visited a piano store once that was running everything off MS Access. If only they had switched to HA technologies, they would be able to sell millions of pianos a day!

Re:SQLite is all you need for durable workflows by ksd482 on Friday May 29, 2026 @03:52PM (#48328324)
levkk is talking about concurrency. The list you gave doesn't explain high concurrency requirements for usage.
Re:SQLite is all you need for durable workflows by rpdillon on Friday May 29, 2026 @04:02PM (#48328448)
My read is that levkk is conflating concurrency with "real production apps" and this whole thread is starting to surface that "real production apps" and "high concurrency" are not measuring the same thing at all.

Sqlite is used in real production apps more than any other database.

Sqlite is also weak at any sort of write concurrency.

Both can be true.

Re:SQLite is all you need for durable workflows by DANmode on Saturday May 30, 2026 @11:31AM (#48337301)
Why doesn’t each of your users have a SQLite database writing up to a main?

You can have as many as you want - and one is often plenty.

Re:SQLite is all you need for durable workflows by petcat on Friday May 29, 2026 @03:57PM (#48328382)
sqlite is great for the contacts app on your phone, but that's it.

Hipp even said that it is not a replacement for a real multi-user, concurrent RDMS. Its primary competitor is "fsync".

Re:SQLite is all you need for durable workflows by Rohansi on Saturday May 30, 2026 @12:06AM (#48332453)
SQLite is able to handle tens of thousands of write transactions per second on modern hardware. That is probably similar to or more than your real, multi-user, concurrent RDBMS.
Re:SQLite is all you need for durable workflows by andersmurphy on Saturday May 30, 2026 @03:00PM (#48339560)
Hundreds of thousands*
Re:SQLite is all you need for durable workflows by slashdave on Saturday May 30, 2026 @01:55AM (#48333062)
I mean... if you count flat files as "databases", there are a heck of a lot more