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?
SQLite for prototypes, PostgreSQL for production!
Dev/Prototype: SQLite. No setup, instant, perfect for side projects. Prisma/Drizzle work great with it.
Production: PostgreSQL. More robust, handles concurrency better, better data integrity.
The cool thing is: start with SQLite, switch to PostgreSQL later (Supabase/Neon). Same syntax! 👍