Skip to content
BENIBIX Learn

PostgreSQL

Development🗃️ DatabasesRelational Databases

Also known as Postgres, psql

A free, open-source SQL database with lots of tools. Many teams pick it first.

Think of it like

Think of it like a big free toolbox. It has a tool for nearly every job.

Example

Lucy starts a new booking app and picks PostgreSQL. Its server listens on port 5432 by default.

Why it matters

PostgreSQL is a safe choice for most new apps. It grows with you from one user to millions.

Definition

PostgreSQL is a free SQL database known for being careful. It is open source and full of tools. It keeps all four ACID promises and sticks close to the SQL standard. It can also store JSON, map data and text search in the same place. It began as a research project at a big school in 1986. Many teams now pick it as their first choice.

Example code

console
$ psql -d shop -c "SELECT count(*) FROM orders;"
 count
-------
  1200
(1 row)
This asks a Postgres database how many orders it holds.

Common mistake

Running it with the default settings on a big server. Its memory settings start small, so raise them.

Key takeaways

  1. 1
    Free and open. No licence fee.
  2. 2
    Careful. Strict about ACID and SQL.
  3. 3
    Many features. JSON, maps and text search too.

Compare