PostgreSQL

Relational SQL databaseOpen source

A mature, standards-compliant relational database with strong JSON support and a large extension ecosystem, including PostGIS for geospatial data and pgvector for embeddings.

Official site

Reach for it when

The primary database for most applications
Relational data with some JSON
Vector search without a separate service

In stack playbooks

Next.js + Postgres + Prisma + Vercel

Primary datastore

FastAPI + Postgres + SQLAlchemy

Primary datastore

More in Databases & backends

Supabase SQLite Firebase Redis MongoDB Prisma Drizzle Pinecone Qdrant DuckDB