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 databasepostgres://quotes/prodcurrent_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
- database — A program that stores data in an organised way and answers questions about it, such as PostgreSQL.
- relational database — A database that stores data in tables and links rows in one table to rows in another through shared key values.
- Amazon RDS — Amazon Relational Database Service, which runs relational database engines such as PostgreSQL and MySQL as a managed service.
- SQL — The standard language for defining, querying and changing data in a relational database.
- psycopg — The most widely used Python driver for PostgreSQL databases.
- SQLite — A small relational database that runs as a library inside your program and keeps the whole database in one file.
- database server — A database that runs as its own long-lived program and serves many client programs over network connections.
- MySQL — A popular open source relational database server, often used by web applications.
- psql — PostgreSQL's interactive command-line client for running SQL statements.
- write-ahead log — The log where PostgreSQL records every change before applying it to the data files, so it can recover after a crash.
- logical decoding — The PostgreSQL feature that turns write-ahead log entries into readable row changes, such as inserts and updates with their values.
- backing service — Any service an application uses over the network, such as a database, cache, queue, mail relay or payments provider.
- row-level security — A database feature that filters which rows each query may see or change, using policies the database enforces itself.
- Testcontainers — A family of libraries that start real dependencies such as databases in throwaway containers for the length of a test.
- semantic conventions — OpenTelemetry's agreed names for common attributes, such as http.route and db.system, so every library records the same fact the same way.
Taught in
- Vector Indexes And Databases — AI Engineering: LLM Apps, RAG & Agents
- Keyword And Hybrid Search — AI Engineering: LLM Apps, RAG & Agents
- Cloud Concepts Sprint: Twelve Cards — AWS Certified Cloud Practitioner (CLF-C02) Exam Prep
- One Database Doing Five Jobs — AWS Certified Cloud Practitioner (CLF-C02) Exam Prep
- The Morning An Availability Zone Went Dark — AWS Certified Solutions Architect – Associate (SAA-C03) Exam Prep
- The Network As A Control: CIDR, Routes, ACLs And Security Groups — AWS Certified Solutions Architect – Associate (SAA-C03) Exam Prep
- Databases That Survive: Standbys, Replicas And Global Tables — AWS Certified Solutions Architect – Associate (SAA-C03) Exam Prep
- Database Performance: Caches, Proxies And Capacity Units — AWS Certified Solutions Architect – Associate (SAA-C03) Exam Prep
- Database Cost: Serverless, Capacity Modes And Reservations — AWS Certified Solutions Architect – Associate (SAA-C03) Exam Prep
- The Full Mock And Your Review Plan — AWS Certified Solutions Architect – Associate (SAA-C03) Exam Prep
- Managed Relational Databases (RDS) — Cloud Infrastructure & Hyperscaler Architecture
- Static Application Security Testing with Semgrep — Cloud Security & DevSecOps Engineering
- Kubernetes NetworkPolicies & Microsegmentation — Cloud Security & DevSecOps Engineering
- Runtime Anomaly Detection with Falco & eBPF — Cloud Security & DevSecOps Engineering
- The Connector That Was Created Twice — Confluent Apache Kafka Certifications (CCDAK and CCAAK) Exam Prep
- Security Architecture Gap Analysis — Cybersecurity Fundamentals, GRC & Cryptography
- Config And Backing Services — DevOps & Site Reliability Engineering
- Environment Configuration: Secrets & Multi-Stage — Production Full-Stack Engineering
- Multi-Tenant Identity: Tenant Isolation & Middleware — Production Full-Stack Engineering
- Database Integration With Testcontainers — Modern Java: Virtual Threads & High-Throughput Services
- Dual Writes And Why They Lose Data — Apache Kafka & Event Streaming
- The Transactional Outbox — Apache Kafka & Event Streaming
- Change Data Capture In Principle — Apache Kafka & Event Streaming
- The Three Signals: Logs, Metrics And Traces — Full-Stack Observability: Metrics, Tracing & Logging
- Traces, Spans And Context Propagation — Full-Stack Observability: Metrics, Tracing & Logging
- Data Types And What To Choose — PostgreSQL, Indexing & Relational Data Modeling
- Where PostgreSQL Differs From SQLite — PostgreSQL, Indexing & Relational Data Modeling
- Integration Testing With Containers — Automated Testing, TDD & Quality Engineering
- Literal Types: String, Number, Boolean Literals And const — Production TypeScript
- When awk Runs Out: Python Data Types, Modules And Virtual Environments For Admins — CompTIA Linux+ (XK0-006) Exam Prep
- Forbidden, With Perfect Permissions: Paths, ACL Masks And SELinux Denials — CompTIA Linux+ (XK0-006) Exam Prep
References
- PostgreSQL: what is PostgreSQL?
- PostgreSQL documentation
- About PostgreSQL
- PostgreSQL documentation: transactions
- Testcontainers: Postgres module
- PostgreSQL documentation
- PostgreSQL: PREPARE
Certification courses
- AWS AIP-C01 course and practice exam: AI engineering with LLM apps, RAG and agents
- AWS Cloud Practitioner course and practice exam: CLF-C02
- AWS Solutions Architect Associate course and practice exam: SAA-C03
- CCDAK and CCAAK course and practice exams: Confluent Apache Kafka certifications
- CompTIA Linux+ course and practice exam: XK0-006