Prompt
What should I use for a new app: PostgreSQL or MySQL?
Latest observation
Oct 7, 2026
OpenAI APIWeb search: off
For a new app, I’d usually recommend PostgreSQL unless you have a specific reason to choose MySQL.
Why PostgreSQL is often the better default
- Stronger feature set: richer SQL support, better indexing options, JSON support, window functions, CTEs, etc.
- Better data integrity: tends to enforce correctness more strictly.
- Great for complex queries: good choice if your app may grow in complexity.
- Excellent extensibility: custom types, functions, and extensions are a big plus.
When MySQL can be a good choice
- Your team already knows it well
- You’re working with an existing MySQL-based stack
- Your app is very simple and you want a familiar, widely supported option
- You’re using a platform or toolchain that strongly prefers MySQL
Simple rule of thumb
- Choose PostgreSQL for most greenfield projects.
- Choose MySQL if you already have operational or team reasons to.
If you want, I can also give you:
- a PostgreSQL vs MySQL comparison table, or
- a recommendation based on your app type (SaaS, e-commerce, mobile backend, etc.).
Brands