alt Hacker NewsI use SQLite for everything, and I'm perfectly happy with it. I'm aware of the concurrent writer issues, but at my scale it doesn't even matter.
Replies
joewils • today at 2:37 PM
Same, I posted some corrections to Dr. Bauer's article: https://joecode.com/2026-08-19-sqlite3/
Thaxll • today at 3:12 PM
The main issue with SQLite is the very poor type system, after testing it for an app I was shocked.
➕ show 1 reply
bensyverson • today at 2:32 PM
Yes, especially for a web app where there’s realistically only a need for one VM/server. By the time you outgrow that approach, a very straightforward migration to Postgres is probably the least complex problem you face.
taoh • today at 2:10 PM
[dead]
Perfectly reasonable:
I'm a huge PG fan, so I start everything with it, but SQLite is sane, and it generally has a happy upgrade path to PG If you need it.