02 Dec 2025SQLite doesn't have MVCC! It only has a single writer! SQLite is for phones and mobile apps (and the occasional airliner)! For web servers use a proper database like Postgres! In this article I'll go over why being embedded and a single writer are not deficiencies but actually allow SQLite to scale so unreasonably well.PreludeFor the code examples I will be using Clojure. But, what they cover should be applicable to most programming language.The machine these benchmarks run on has th...