PostgreSQL
Relational SQL databaseOpen source· verified Sep 2026
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
Vite + React + Supabase + Vercel
Authorization at the data layer
Next.js + Postgres + Prisma + Vercel
Primary datastore
FastAPI + Postgres + SQLAlchemy
Primary datastore
B2B SaaS (organizations / multi-tenant): Next.js + Postgres + Better Auth
Shared database; organization ID on every tenant-owned row
TypeScript API service: NestJS + Postgres + Prisma
Primary datastore
Collaborative editing (local-first): Yjs + Hocuspocus + Tiptap + Postgres
Persisted Yjs state alongside app data