PostgreSQL is an advanced, enterprise-class, and open-source relational database system. PostgreSQL supports both SQL (relational) and JSON (non-relational) querying.
The following are the common use cases of PostgreSQL.
LAPP stands for Linux, Apache, PostgreSQL, and PHP (or Python and Perl). PostgreSQL is primarily used as a robust back-end database that powers many dynamic websites and web applications.
Large corporations and startups alike use PostgreSQL as the primary database to support their applications and products.
PostgreSQL with the PostGIS extension supports geospatial databases for geographic information systems (GIS).
PostgreSQL supports the most popular programming languages:
- Python
- Java
- C#
- C/C+
- Ruby
- JavaScript (Node.js)
- Perl
- Go
- Tcl
PostgreSQL has many advanced features that other enterprise-class database management systems offer, such as:
- User-defined types
- Table inheritance
- Sophisticated locking mechanism
- Foreign key referential integrity
- Views, rules, subquery
- Nested transactions (savepoints)
- Multi-version concurrency control (MVCC)
- Asynchronous replication
PostgreSQL is designed to be extensible. PostgreSQL allows you to define your data types, index types, functional languages, and so on.