PostgreSQL
In depthDatabase
Also known as: Postgres
Powerful open-source relational database with rich support for complex queries and extensions.
PostgreSQL, explained
Written by EduVerseWhat it is
PostgreSQL, often called Postgres, is an open-source relational database known for following the SQL standard closely and for being easy to extend. Besides regular tables, it supports JSON columns, arrays, full-text search and custom types. Extensions such as PostGIS add entire new capabilities, like geographic queries.
Why teams use it
Teams pick PostgreSQL when they want reliable data integrity, with transactions, constraints and foreign keys, plus room to grow into more specialized features. Its JSONB columns cover many cases where people would otherwise reach for a document database. Every major cloud provider offers it as a managed service.
An example from work
You set DATABASE_URL in your .env to something like postgresql://postgres:secret@localhost:5432/shop and run your ORM’s migration command. Then you open psql, connect to the database and type \dt to list the tables the migration just created. Typing \d users shows each column of that table with its type and constraints.
Our own explanation, not a quote from the book.
In the book
Sentences from The Software Realm, Decoded that mention PostgreSQL, exactly as printed.
1 more passages about PostgreSQL in the full book
Read every conversation where PostgreSQL comes up, with the interactive slides and demos.
Where it fits
Enterprise web applications, geodata (PostGIS), analytical queries
Coverage in the book
Covered in depth: multiple pages with explanations, examples and simulations.
