Start Now

PostgreSQL

PostgreSQL is an open-source, single-node relational database management system (RDBMS).

PostgreSQL originated from the POSTGRES package written at the University of California at Berkeley. The implementation of POSTGRES began in 1986, with the first “demoware” system becoming operational a year later.

In 1994, a SQL language interpreter was added, and it was rebranded as Postgres95. In 1996, the project was renamed PostgreSQL to better reflect its support for SQL. The first PostgreSQL release was version 6.0 on January 29, 1997.

PostgreSQL includes robust performance, security, programming extensions/add-ons, and configuration features. Code can be written in SQL, Perl, Python, Java (and many other languages), and there is support for a wide range of data types.

PostgreSQL is a SQL-compliant database, meeting nearly all the core features of the SQL standard. However, it also supports several NoSQL-like behaviors (storing documents using JSON, for example). This flexibility has helped make PostgreSQL the gold standard for operational databases.

Today, PostgreSQL is a popular database with a strong reputation thanks to its proven architecture, reliability, data integrity, robust feature set, extensibility, and the dedication of an experienced, open-source community who continue to make significant and innovative code contributions.

Additional PostgreSQL Topics to Explore