SQLite is Underrated
Most apps do not need Postgres. They need SQLite and a clear schema.
I keep coming back to SQLite. Every time I start a new side project, I reach for Postgres out of habit, then realize I am building a todo app for one person and a 200MB database server is absurd.
SQLite handles more than people think. It can do millions of reads per second. It supports JSON columns. It works on phones, servers, and embedded devices. Your browser uses it right now.
The real advantage is not performance, though. It is simplicity. Your database is a file. You can email it. You can version control it. You can deploy it by copying a file. No connection strings, no user management, no cluster configuration.
For 90% of the side projects I see developers building, SQLite is the right choice. The other 10% need Postgres. But most people reach for Postgres for 100% of projects because that is what the tutorial used.
I am not saying abandon Postgres. I am saying think about what you actually need before reaching for the heavy tools.
- Mohan
- Mohan