PostgreSQL
PostgreSQL is an open-source object-relational database management system that implements SQL and supports transactional data storage and extensibility.
Just Use Postgres!
PostgreSQL is an open-source object-relational database management system with extensibility and support for SQL.
- How it is used
- Supports transactional applications while extending into JSON, vector search, time series, generative AI, and message-queue workloads.
- How deep it goes
- Demonstrates Docker deployment, SQL querying, relational features, extensions, and specialized workloads without comprehensive administration or deployment guidance.
- Examples
- Uses Docker containers, stock-trade aggregations, shopping carts, JSON orders, movie recommendations, smartwatch measurements, and DMV registration queues.
- What you can do after
- Operate/configure PostgreSQL locally with Docker and apply SQL, database functions, constraints, and extensions to practical application scenarios.
Build Python Web Apps with Streamlit
PostgreSQL is an open-source object-relational database management system that supports SQL, transactions, and extensible data types.
- How it is used
- Provides persistent relational storage for a Streamlit CRUD app that makes frequent changes to individual records.
- How deep it goes
- Walks through local setup, SQL CRUD, application connections, and managed deployment without exploring PostgreSQL internals.
- Examples
- Uses users and haikus tables, filtered SQL queries, a Python Database class, and a Neon production database.
- What you can do after
- Operate/configure it locally and through Neon, then apply it via Streamlit to read and change app records.
Read how Build Python Web Apps with Streamlit explains PostgreSQL →
PostgreSQL Mistakes and How to Avoid Them
PostgreSQL is a free, open-source object-relational database management system designed to implement SQL standards and support extensible data types and operations.
- How it is used
- Frames PostgreSQL as a versatile database whose safe use depends on matching workloads, configuration, and designs to actual needs.
- How deep it goes
- Explains client-server multiprocess behavior and operational consequences, while deferring exhaustive administration and tutorial instruction.
- Examples
- Uses failed MySQL or MariaDB imports involving latin1 encoding and numeric BOOLEAN values to demonstrate migration corrections.
- What you can do after
- Operate/configure it by recognizing cross-DBMS pitfalls and applying proactive configuration, migration, monitoring, and maintenance practices.
Read how PostgreSQL Mistakes and How to Avoid Them explains PostgreSQL →
Rust Servers, Services, and Apps
Postgres is an open-source object-relational database management system.
- How it is used
- Persists course data for an asynchronous Rust web service and replaces an in-memory store with durable relational storage.
- How deep it goes
- Builds installation, credentials, schema, seed data, pooled connectivity, querying, and service integration, stopping short of advanced database operations.
- Examples
- Uses the ezytutors database, ezy_course_c4 table, seeded courses, psql commands, and a Rust PgPool query.
- What you can do after
- Operate/configure PostgreSQL for a Rust service, create schemas and credentials, verify connectivity, and query persisted records through SQLx.
Read how Rust Servers, Services, and Apps explains PostgreSQL →
AI-Powered Developer: Build software with ChatGPT and Copilot
Postgres is an open-source object-relational database management system.
- How it is used
- Deploys a local PostgreSQL database for developing and populating an IT asset management system.
- How deep it goes
- Builds a working schema with permissions, keys, sequences, generated data, and ORM mappings, but does not discuss PostgreSQL internals.
- Examples
- Uses an itam_db container, itam schema, role permissions, relational tables, generated asset records, and Python ORM classes.
- What you can do after
- Operate/configure a local PostgreSQL instance, create an application schema, load relational data, and connect it to ORM models.
Read how AI-Powered Developer: Build software with ChatGPT and Copilot explains PostgreSQL →
Logs and Telemetry
PostgreSQL is an open-source object-relational database management system.
- How it is used
- Stores Fluent Bit log events in a queryable JSON-capable database destination.
- How deep it goes
- Explains pgsql connection and table settings through a complete configuration, while deferring PostgreSQL setup details.
- Examples
- Demonstrates HTTP events routed into a fluentbit PostgreSQL table and viewed through pgAdmin.
- What you can do after
- Operate/configure it as a Fluent Bit pgsql output by setting routing, connection, credentials, database, table, and timestamp options.
Architecting an Apache Iceberg Lakehouse
PostgreSQL is an open-source object-relational database management system.
- How it is used
- Provides the operational source from which Spark ingests transactional sales data into an Iceberg lakehouse.
- How deep it goes
- Defines a Docker service, connection settings, shell access, table creation, and sample inserts, but not PostgreSQL internals.
- Examples
- Uses a fashion_sales table populated with five mock retail transactions across products, stores, customer groups, and campaigns.
- What you can do after
- Operate/configure a containerized PostgreSQL source, connect to it locally, and prepare sales data for lakehouse ingestion.
Read how Architecting an Apache Iceberg Lakehouse explains PostgreSQL →
Latency
PostgreSQL is an open-source relational database management system that operates as a database server.
- How it is used
- Deploys PostgreSQL as the client-server database behind a Rust REST API and measures its request latency.
- How deep it goes
- Demonstrates installation, connectivity, pooled access, query execution, and latency measurement, but does not develop database internals.
- Examples
- Uses a /hello endpoint, SELECT 'hello world', Docker, psql, Rust, mobc, Actix Web, and wrk.
- What you can do after
- Operate PostgreSQL for a Rust REST API and benchmark its latency against SQLite using wrk.
Build Financial Software with Generative AI (From Scratch)
PostgreSQL is an open-source object-relational database management system known for SQL support, extensibility, and transactional reliability.
- How it is used
- Uses PostgreSQL to store parsed ACH files for Business Intelligence analytics in a modernized dashboard.
- How deep it goes
- Positions PostgreSQL in the application architecture but stops short of examining database capabilities or implementation details.
- Examples
- Uses an ACH dashboard whose files are parsed into PostgreSQL for analytics and backend processing.
- What you can do after
- Evaluate PostgreSQL as the relational database choice for an ACH modernization project and compare it with alternatives.
Read how Build Financial Software with Generative AI (From Scratch) explains PostgreSQL →
Microsoft Azure in Action
PostgreSQL is an open-source object-relational database management system known for advanced SQL features and standards compliance.
- How it is used
- Supports complex, high-scale relational applications as a managed Azure database service.
- How deep it goes
- Explains managed-service trade-offs and demonstrates Azure CLI provisioning, but stops short of detailed query tuning.
- Examples
- Uses the Banning Books ordering system and Azure CLI commands that create a PostgreSQL server and database.
- What you can do after
- Operate/configure Azure Database for PostgreSQL by provisioning a server and database with Azure CLI.
Learn Docker in a Month of Lunches, Second Edition
Postgres is an open-source relational database management system.
- How it is used
- Deploys a separate application database for larger containerized applications instead of storing data in local SQLite.
- How deep it goes
- Explains service configuration, networking, provider selection, and secrets, but does not detail SQL operations or database internals.
- Examples
- Uses a to-do application, the todo-db service, port mapping, provider configuration, and a PostgreSQL connection secret.
- What you can do after
- Operate/configure a containerized application with PostgreSQL using Docker Compose and verify its running containers.
Read how Learn Docker in a Month of Lunches, Second Edition explains PostgreSQL →
Related concepts
- databasekind of · A database is an organized collection of persistent data managed by software for storage, retrieval, querying, and modification.
- SQLuses · SQL is a standardized declarative language for defining, querying, and manipulating data and structures in relational database systems.
- queueuses · A queue is an ordered collection that holds items for retrieval or processing, typically removing them in the order they were added.
- SQLxused by · SQLx is a Rust asynchronous toolkit for interacting with relational databases, mapping query results to Rust types, and optionally checking SQL queries at compile time.
These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.