PostgreSQL

A widely used open source relational database server with strict typing, rich data types and extensions.

In more detail

PostgreSQL runs as a separate server that applications connect to over the network, with many clients reading and writing at once. It enforces column types and foreign keys, supports transactions and rich data types, and can be extended with many extensions. It is a common choice for production web applications.

Examples

The database plan in m06l01 sets "engine": "postgres" on Amazon RDS.
The course runs postgres:16-alpine in a container.
postgres://quotes/prod  # a second deploy of the same build, attached to a different database
postgres://quotes/prod
current_setting('app.tenant') passes the tenant to row-level security policies.
new PostgreSQLContainer<>("postgres:16")
The course trace records db.system="postgresql" on the SELECT basket span.
The SQL course shows PostgreSQL syntax for comparison while running its exercises in SQLite.
In this course: It is a common choice for container-based integration tests, started from a pinned official image. Its SQL dialect, constraints and isolation behaviour are what a real-database test verifies.

Related terms

Taught in

References

Certification courses