Prompt
Do I need PostgreSQL if I'm only building a single-tenant app?
Latest observation
Oct 7, 2026
OpenAI APIWeb search: off
No — single-tenant does not require PostgreSQL.
“Single-tenant” only means one customer or organization has its own isolated app/data environment. You can build that with many storage options, for example:
- SQLite — simplest for small apps, prototypes, or low-concurrency use
- MySQL/MariaDB — common general-purpose relational databases
- PostgreSQL — great if you want strong features and scalability
- NoSQL / document stores — if your data model fits better
- Flat files / local storage — for very small or embedded apps
When PostgreSQL is worth it
Choose PostgreSQL if you want:
- reliable relational data handling
- advanced querying
- transactions and consistency
- future scalability
- features like JSONB, full-text search, constraints, etc.
When you probably don’t need it
PostgreSQL may be overkill if:
- your app is very small
- you want the simplest possible setup
- you have low traffic and minimal data complexity
- you’re fine with SQLite or another lighter database
Bottom line
Single-tenant is about isolation, not the database choice.
You can absolutely build a single-tenant app without PostgreSQL.
If you tell me what kind of app you’re building, I can suggest the best database option.