PostgreSQL logo

PostgreSQL

Open source object-relational database with SQL, transactions, triggers, and user-defined types

Open Source Alternative to
Repository activity
  • Stars21.2k
  • Forks5.7k
  • Open Issues0
postgres health score - Linux Foundation Insights
License

Other

Languages
  • C
  • PLpgSQL
  • Perl
PostgreSQL screenshot

About PostgreSQL

PostgreSQL is an advanced object-relational database management system. It stores and queries structured data using an extended subset of the SQL standard, with transactions, foreign keys, subqueries, triggers, user-defined types, and user-defined functions.

Because types and functions are user-extensible, you can model domain-specific data inside the database rather than working around a fixed schema. C language bindings let applications talk to the server directly, and the system runs as a self-hosted server on a wide range of operating systems.

PostgreSQL is released under its own permissive license and developed by the PostgreSQL Global Development Group. It is widely used as a general-purpose relational backend for everything from small applications to large production systems.

Key features

  • Extended SQL with transactions and foreign keys
  • Subqueries, triggers, and user-defined types
  • User-defined functions
  • C language bindings for client applications

Details

Type
Object-relational database
Query language
SQL
Language
C
Maintainer
PostgreSQL Global Development Group
Deployment
Self-hostable
License
PostgreSQL License