SQLite is the side-project database I keep coming back to
Every side project I start, I ask myself if I need Postgres. The answer is almost always no.
SQLite gives me:
- A single file I can back up by copying
- Zero ops
- More than enough performance for a side project
The caveat is concurrency. Once you have background jobs writing at the same time as requests, you need to think about WAL mode and busy timeouts. That's a 20-minute fix, not a reason to run a database server.
My current side project is Rails + SQLite, and the whole thing deploys as one container with a mounted volume.
I'm slowly reading about SQLite internals — the page format is a lot more approachable than I expected.
原文：https://www.a8q9.cn/en/article/sqlite-is-the-side-project-database-i-keep-coming-back-to-e3bbe7.html