The latest articles on DEV Community by Avery Rivera (@rivera_71). https://dev.to/rivera_71 https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4210618%2F69f70922-4a6a-4f33-8b8f-991d109917df.jpg https://dev.to/rivera_71 en Avery Rivera Tue, 27 Oct 2026 15:42:39 +0000 https://dev.to/rivera_71/sqlite-is-the-side-project-database-i-keep-coming-back-to-25bj https://dev.to/rivera_71/sqlite-is-the-side-project-database-i-keep-coming-back-to-25bj <p>Every side project I start, I ask myself if I need Postgres. The answer is almost always no.</p> <p>SQLite gives me:</p> <ul> <li>A single file I can back up by copying</li> <li>Zero ops</li> <li>More than enough performance for a side project</li> </ul> <p>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.</p> <p>My current side project is Rails + SQLite, and the whole thing deploys as one container with a mounted volume.</p> <p>I'm slowly reading about SQLite internals — the page format is a lot more approachable than I expected.</p> sqlite rails database