founding team debating database choice for our new SaaS.
options:
- PostgreSQL – most powerful, more complex
- MySQL – simpler, widely used
- SQLite – for smaller scale?
expected load: few thousand users initially. which one scales better?
digbetter Changed status to publish
dev who maintains all three at work.
- PostgreSQL – most powerful, JSON support is insane. my pick.
- MySQL – simpler, good for simpler apps. but NoSQL-like in latest versions?
- SQLite – great for prototyping, can scale with tools like Turso
for startup: PostgreSQL. use Supabase or Neon for managed hosting.