What is PostgreSQL?
PostgreSQL is an advanced, enterprise class open source relational database that supports both SQL (relational) and JSON (non-relational) querying. It is a highly stable database management system, backed by more than 20 years of community development which has contributed to its high levels of resilience, integrity, and correctness. PostgreSQL is used as the primary data store or data warehouse for many web, mobile, geospatial, and analytics applications. The latest major version is PostgreSQL 11.
PostgreSQL has a rich history for support of advanced data types, and supports a level of performance optimization that is common across its commercial database counterparts, like Oracle and SQL Server. AWS supports PostgreSQL through a fully managed database service with Amazon Relational Database Service (RDS). Amazon Aurora with PostgreSQL compatibility is also built using PostgreSQL.
Benefits of using PostgreSQL
Rich features and extensions
Reliability and standards compliance
Open source license
History of PostgreSQL
Popular use cases for PostgreSQL
General purpose OLTP database
Federated hub database
LAPP open source stack
PostgreSQL supports most leading programming languages and protocols, including:
Fully managed PostgreSQL on AWS
Sign up for Amazon RDS
Learn with Simple Tutorials
Start building with Amazon RDS