TECHNOLOGY INDEX / REFERENCESQL / PERSISTENCE / DATA INTEGRITYOBJECT-RELATIONAL DATABASE
REFERENCE / POSTGRESQL

PostgreSQL

PostgreSQL is an open-source object-relational database system that stores, queries and manages structured data using SQL.

WHAT IT DOES / 01

RELATED RECORDS.
EXPLICIT RULES.

It gives applications transactions, relationships, constraints and indexes for keeping data consistent and finding it efficiently.

KEY CONCEPTS / 02

THE CORE
IDEAS.

  1. 01

    RELATIONS & CONSTRAINTS

    Connect tables with keys and enforce rules about valid data.

  2. 02

    TRANSACTIONS

    Group changes into explicit units so related updates succeed or fail together.

  3. 03

    EXTENSIBILITY

    Use JSON, full-text search, custom types and extensions alongside relational records.

KEEP EXPLORING / 03

OFFICIAL
RESOURCES.

BACK TO ARCHIVEALL PROJECTS←