Building another side project (who isn’t lol) and need to pick a database.
What I’m building: simple SaaS with users, posts, comments, basic analytics
My understanding:
- PostgreSQL – Most powerful, bit complex
- MySQL – Simpler, widely used
- SQLite – For small stuff, no setup
Currently leaning towards Supabase (PostgreSQL) but plain MySQL seems easier?
PostgreSQL all the way. Here’s why:
PostgreSQL – Most features, best performance, JSON support, row-level security. Free and open source. Used by everyone from startups to big tech.
MySQL – Simpler but less powerful. Good for simple read-heavy apps. MariaDB is the open-source alternative.
SQLite – Great for local dev, prototypes, small apps. No server needed!
For side projects: Start with Supabase (PostgreSQL). Easy setup, generous free tier, scales with you. 🔥