Postgres
The open-source relational database — the default choice for production SQL workloads.
Definition
PostgreSQL is the most-respected open-source relational database, with strong support for JSON, full-text search, GIS via PostGIS, and pgvector for embedding storage. Most automation backends — n8n, Ghost on production setups, Airbyte, Metabase — run on Postgres in production. Hosted options include Supabase, Neon, AWS RDS, and DigitalOcean Managed Databases.
When to use
See also
- SQLite — Embedded, file-based SQL database — the most-deployed database in the world, runs without a server process.
- Redis — In-memory key-value store — the standard pick for caches, queues, rate-limit counters, and pub/sub.