About PostgreSQL
PostgreSQL is a relational database system with more than 35 years of active development. It is open source and maintained by a worldwide community of developers.
What it does
PostgreSQL stores data in tables and answers questions with SQL. It supports advanced data types, custom functions and extensions, and transactions that keep data consistent when something fails. It is used for small apps and for large systems that need strong reliability.
Key features
- SQL queries with transactions
- JSON and other advanced data types
- Extensions that add new features
- Indexes for faster queries
- Runs on Windows, macOS and Linux
Who it's for
Developers and database administrators who need a dependable database they can self-host or run through a cloud provider. It fits web apps, analytics work and teams that value a long track record.
Pricing and good to know
PostgreSQL is free and open source, so there is no license fee. Costs come from hosting, backups and staff time. Each major version receives fixes for a limited period, so plan upgrades in advance and follow the published end-of-support dates.
Highlights
- SQL queries with transactions and constraints
- JSON and other advanced data types
- Extensions that add functions and data types
- Indexes that speed up common queries
- Runs on Windows, macOS and Linux
