Overview
Battle-tested open-source relational database with rich types, full-text search, JSON support, and an extension ecosystem (pgvector, PostGIS, partman).
What you get
Tools in this category cover database hosting, auto-generated APIs, file storage, real-time subscriptions, queues, scheduled jobs, and increasingly first-class auth. Many replace ‘spin up a server, plug in Postgres’ with a managed service and SDK.
Where it fits in your stack
They sit behind your frontend (React, Vue, native mobile, or server-rendered HTML) and replace several of the moving parts you’d otherwise build yourself. Teams pair them with hosting providers, payment processors, and CDNs to make a complete product.
Who it’s for
PostgreSQL suits teams that want this specific capability without rolling it from scratch. When evaluating, look at the community, hosting story, escape hatches, and how the costs scale as the project grows.
Pricing & licensing
PostgreSQL is open source / free to use. Hosted offerings or commercial add-ons are documented on the project site.