{"book":{"title":"AI-Native Relational Databases with PostgreSQL","subtitle":"From First Table to Production Intelligence","author":"Muhammad Usman Akbar","basePath":"/postgres-book","publishedAt":"2026-07-31","expectedPages":52},"chapters":[{"position":1,"slug":"about-this-book","title":"About This Book: Your PostgreSQL Zero-to-Expert Path","section":"Start Here","description":"Learn how this PostgreSQL book turns a complete beginner into a production and AI-native database practitioner through one progressive system.","url":"https://muhammadusmanakbar.com/postgres-book/about-this-book","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/about-this-book","updatedAt":"2026-07-31"},{"position":2,"slug":"relational-databases-and-ai-native-truth","title":"Relational Databases and AI-Native Truth","section":"Foundations","description":"Understand databases, tables, relationships, keys, SQL, and why trustworthy AI systems need governed relational truth.","url":"https://muhammadusmanakbar.com/postgres-book/relational-databases-and-ai-native-truth","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/relational-databases-and-ai-native-truth","updatedAt":"2026-07-31"},{"position":3,"slug":"install-postgresql-and-tools","title":"Install PostgreSQL and Build a Safe Learning Environment","section":"Foundations","description":"Install PostgreSQL, psql, and optional GUI tools; connect safely; identify the active server; and prepare an isolated learning database.","url":"https://muhammadusmanakbar.com/postgres-book/install-postgresql-and-tools","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/install-postgresql-and-tools","updatedAt":"2026-07-31"},{"position":4,"slug":"clusters-databases-schemas-and-objects","title":"Clusters, Databases, Schemas, and PostgreSQL Objects","section":"Foundations","description":"Navigate PostgreSQL's object hierarchy, understand connections and namespaces, control search_path, and inspect objects safely with psql.","url":"https://muhammadusmanakbar.com/postgres-book/clusters-databases-schemas-and-objects","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/clusters-databases-schemas-and-objects","updatedAt":"2026-07-31"},{"position":5,"slug":"build-your-first-signaldesk-schema","title":"Build Your First SignalDesk AI Schema","section":"Foundations","description":"Create organizations, customers, tickets, and messages with identity keys, constraints, relationships, timestamps, and a reproducible seed transaction.","url":"https://muhammadusmanakbar.com/postgres-book/build-your-first-signaldesk-schema","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/build-your-first-signaldesk-schema","updatedAt":"2026-07-31"},{"position":6,"slug":"psql-and-a-safe-data-workflow","title":"Master psql and a Safe Data Workflow","section":"Foundations","description":"Use psql for inspection, scripts, variables, transactions, output, timing, and recovery from mistakes without turning convenience into risk.","url":"https://muhammadusmanakbar.com/postgres-book/psql-and-a-safe-data-workflow","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/psql-and-a-safe-data-workflow","updatedAt":"2026-07-31"},{"position":7,"slug":"data-types-defaults-and-constraints","title":"PostgreSQL Data Types, Defaults, and Constraints","section":"SQL Fluency","description":"Choose precise PostgreSQL types and encode domain rules with nullability, checks, uniqueness, generated values, and foreign keys.","url":"https://muhammadusmanakbar.com/postgres-book/data-types-defaults-and-constraints","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/data-types-defaults-and-constraints","updatedAt":"2026-07-31"},{"position":8,"slug":"insert-update-delete-returning-and-upsert","title":"INSERT, UPDATE, DELETE, RETURNING, and UPSERT","section":"SQL Fluency","description":"Change PostgreSQL data safely with precise predicates, RETURNING evidence, conflict handling, transactions, and idempotent write design.","url":"https://muhammadusmanakbar.com/postgres-book/insert-update-delete-returning-and-upsert","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/insert-update-delete-returning-and-upsert","updatedAt":"2026-07-31"},{"position":9,"slug":"select-filter-sort-and-null","title":"SELECT, Filtering, Sorting, Pagination, and NULL","section":"SQL Fluency","description":"Read PostgreSQL data correctly with explicit projections, three-valued logic, stable ordering, keyset pagination, and tenant-safe filters.","url":"https://muhammadusmanakbar.com/postgres-book/select-filter-sort-and-null","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/select-filter-sort-and-null","updatedAt":"2026-07-31"},{"position":10,"slug":"joins-and-relationship-queries","title":"Joins and Relationship Queries Without Duplicate Surprises","section":"SQL Fluency","description":"Master inner, outer, lateral, semi, and anti joins while reasoning about cardinality, tenant keys, duplicates, and missing relationships.","url":"https://muhammadusmanakbar.com/postgres-book/joins-and-relationship-queries","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/joins-and-relationship-queries","updatedAt":"2026-07-31"},{"position":11,"slug":"aggregation-grouping-and-reporting","title":"Aggregation, Grouping, and Trustworthy Reporting","section":"SQL Fluency","description":"Build accurate PostgreSQL reports with aggregate functions, GROUP BY, FILTER, HAVING, grouping sets, time buckets, and verified denominators.","url":"https://muhammadusmanakbar.com/postgres-book/aggregation-grouping-and-reporting","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/aggregation-grouping-and-reporting","updatedAt":"2026-07-31"},{"position":12,"slug":"subqueries-ctes-sets-and-window-functions","title":"Subqueries, CTEs, Set Operations, and Window Functions","section":"SQL Fluency","description":"Compose advanced PostgreSQL queries with subqueries, CTEs, UNION/INTERSECT/EXCEPT, recursion, and window functions while preserving row grain.","url":"https://muhammadusmanakbar.com/postgres-book/subqueries-ctes-sets-and-window-functions","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/subqueries-ctes-sets-and-window-functions","updatedAt":"2026-07-31"},{"position":13,"slug":"advanced-sql-reasoning-and-debugging","title":"Advanced SQL Reasoning and Debugging","section":"SQL Fluency","description":"Debug complex PostgreSQL SQL systematically using grain, invariants, reduced fixtures, intermediate checks, plans, and property-based reasoning.","url":"https://muhammadusmanakbar.com/postgres-book/advanced-sql-reasoning-and-debugging","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/advanced-sql-reasoning-and-debugging","updatedAt":"2026-07-31"},{"position":14,"slug":"requirements-erds-and-invariants","title":"Turn Requirements into ER Diagrams and Invariants","section":"Data Modeling","description":"Translate business language into entities, relationships, cardinalities, lifecycles, constraints, and testable PostgreSQL invariants.","url":"https://muhammadusmanakbar.com/postgres-book/requirements-erds-and-invariants","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/requirements-erds-and-invariants","updatedAt":"2026-07-31"},{"position":15,"slug":"normalization-and-denormalization","title":"Normalization and Intentional Denormalization","section":"Data Modeling","description":"Use functional dependencies and normal forms to prevent anomalies, then denormalize only with ownership, refresh, and reconciliation rules.","url":"https://muhammadusmanakbar.com/postgres-book/normalization-and-denormalization","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/normalization-and-denormalization","updatedAt":"2026-07-31"},{"position":16,"slug":"keys-relationships-and-hierarchies","title":"Keys, Relationship Patterns, and Hierarchies","section":"Data Modeling","description":"Choose natural and surrogate keys, model one-to-one and many-to-many relationships, and represent trees with safe PostgreSQL patterns.","url":"https://muhammadusmanakbar.com/postgres-book/keys-relationships-and-hierarchies","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/keys-relationships-and-hierarchies","updatedAt":"2026-07-31"},{"position":17,"slug":"time-jsonb-files-and-derived-data","title":"Model Time, JSONB, Files, and Derived Data","section":"Data Modeling","description":"Represent instants, intervals, history, flexible JSON, external files, checksums, lineage, and rebuildable projections in PostgreSQL.","url":"https://muhammadusmanakbar.com/postgres-book/time-jsonb-files-and-derived-data","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/time-jsonb-files-and-derived-data","updatedAt":"2026-07-31"},{"position":18,"slug":"multi-tenancy-ownership-and-schema-evolution","title":"Multi-Tenancy, Data Ownership, and Schema Evolution","section":"Data Modeling","description":"Choose a PostgreSQL tenancy model, encode tenant ownership, evolve schemas safely, and prevent leakage across queries, jobs, retrieval, and operations.","url":"https://muhammadusmanakbar.com/postgres-book/multi-tenancy-ownership-and-schema-evolution","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/multi-tenancy-ownership-and-schema-evolution","updatedAt":"2026-07-31"},{"position":19,"slug":"server-architecture-storage-and-wal","title":"PostgreSQL Server Architecture, Storage, and WAL","section":"PostgreSQL Mechanics","description":"Understand PostgreSQL processes, shared memory, pages, relations, checkpoints, and write-ahead logging well enough to reason about failure and performance.","url":"https://muhammadusmanakbar.com/postgres-book/server-architecture-storage-and-wal","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/server-architecture-storage-and-wal","updatedAt":"2026-07-31"},{"position":20,"slug":"acid-transactions-and-mvcc","title":"ACID Transactions and MVCC","section":"PostgreSQL Mechanics","description":"Understand atomicity, consistency, isolation, durability, snapshots, tuple versions, and why PostgreSQL readers and writers interact as they do.","url":"https://muhammadusmanakbar.com/postgres-book/acid-transactions-and-mvcc","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/acid-transactions-and-mvcc","updatedAt":"2026-07-31"},{"position":21,"slug":"isolation-levels-and-anomalies","title":"Isolation Levels and Concurrency Anomalies","section":"PostgreSQL Mechanics","description":"Choose PostgreSQL isolation levels by invariant, reproduce anomalies with concurrent sessions, and design bounded serialization retries.","url":"https://muhammadusmanakbar.com/postgres-book/isolation-levels-and-anomalies","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/isolation-levels-and-anomalies","updatedAt":"2026-07-31"},{"position":22,"slug":"locks-deadlocks-and-concurrency-control","title":"Locks, Deadlocks, and Concurrency Control","section":"PostgreSQL Mechanics","description":"Use PostgreSQL row, table, and advisory locks deliberately; diagnose waits and deadlocks; and choose optimistic or pessimistic control.","url":"https://muhammadusmanakbar.com/postgres-book/locks-deadlocks-and-concurrency-control","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/locks-deadlocks-and-concurrency-control","updatedAt":"2026-07-31"},{"position":23,"slug":"views-materialized-views-functions-and-triggers","title":"Views, Materialized Views, Functions, and Triggers","section":"PostgreSQL Mechanics","description":"Place logic deliberately in PostgreSQL views, materialized views, functions, procedures, and triggers without creating hidden behavior or privilege risks.","url":"https://muhammadusmanakbar.com/postgres-book/views-materialized-views-functions-and-triggers","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/views-materialized-views-functions-and-triggers","updatedAt":"2026-07-31"},{"position":24,"slug":"query-planner-and-explain","title":"The Query Planner and EXPLAIN","section":"Performance and Scale","description":"Read PostgreSQL query plans, compare estimated and actual rows, interpret scans, joins, sorts, buffers, and tune from measured evidence.","url":"https://muhammadusmanakbar.com/postgres-book/query-planner-and-explain","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/query-planner-and-explain","updatedAt":"2026-07-31"},{"position":25,"slug":"btree-index-design","title":"B-Tree Index Design from Query Shapes","section":"Performance and Scale","description":"Design PostgreSQL B-tree indexes for equality, range, ordering, uniqueness, multicolumn predicates, and foreign-key workloads, then verify plans.","url":"https://muhammadusmanakbar.com/postgres-book/btree-index-design","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/btree-index-design","updatedAt":"2026-07-31"},{"position":26,"slug":"specialized-partial-expression-and-covering-indexes","title":"Specialized, Partial, Expression, and Covering Indexes","section":"Performance and Scale","description":"Choose GIN, GiST, BRIN, hash, partial, expression, and INCLUDE indexes from operators and workloads rather than fashion.","url":"https://muhammadusmanakbar.com/postgres-book/specialized-partial-expression-and-covering-indexes","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/specialized-partial-expression-and-covering-indexes","updatedAt":"2026-07-31"},{"position":27,"slug":"statistics-query-design-and-tuning","title":"Statistics, Query Design, and Systematic Tuning","section":"Performance and Scale","description":"Improve PostgreSQL performance through representative statistics, extended statistics, sargable queries, bounded work, and hypothesis-driven experiments.","url":"https://muhammadusmanakbar.com/postgres-book/statistics-query-design-and-tuning","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/statistics-query-design-and-tuning","updatedAt":"2026-07-31"},{"position":28,"slug":"connection-budgets-pooling-and-prepared-statements","title":"Connection Budgets, Pooling, and Prepared Statements","section":"Performance and Scale","description":"Budget PostgreSQL connections across services and workers, choose pool modes, configure timeouts, and understand prepared-statement tradeoffs.","url":"https://muhammadusmanakbar.com/postgres-book/connection-budgets-pooling-and-prepared-statements","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/connection-budgets-pooling-and-prepared-statements","updatedAt":"2026-07-31"},{"position":29,"slug":"vacuum-autovacuum-and-bloat","title":"Vacuum, Autovacuum, and Bloat","section":"Performance and Scale","description":"Understand PostgreSQL dead tuples, visibility, freezing, autovacuum thresholds, bloat, long transactions, and safe maintenance diagnosis.","url":"https://muhammadusmanakbar.com/postgres-book/vacuum-autovacuum-and-bloat","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/vacuum-autovacuum-and-bloat","updatedAt":"2026-07-31"},{"position":30,"slug":"partitioning-replicas-and-scaling-decisions","title":"Partitioning, Replicas, and Scaling Decisions","section":"Performance and Scale","description":"Scale PostgreSQL through efficient queries, vertical capacity, partitioning, read replicas, and justified distribution while preserving correctness.","url":"https://muhammadusmanakbar.com/postgres-book/partitioning-replicas-and-scaling-decisions","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/partitioning-replicas-and-scaling-decisions","updatedAt":"2026-07-31"},{"position":31,"slug":"roles-ownership-and-least-privilege","title":"Roles, Ownership, and Least Privilege","section":"Security and Operations","description":"Design PostgreSQL login, group, owner, migration, runtime, reporting, and support roles with explicit grants and safe default privileges.","url":"https://muhammadusmanakbar.com/postgres-book/roles-ownership-and-least-privilege","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/roles-ownership-and-least-privilege","updatedAt":"2026-07-31"},{"position":32,"slug":"row-level-security-for-multi-tenancy","title":"Row-Level Security for Multi-Tenancy","section":"Security and Operations","description":"Implement and test PostgreSQL row-level security policies, tenant transaction context, FORCE behavior, restrictive rules, and bypass risks.","url":"https://muhammadusmanakbar.com/postgres-book/row-level-security-for-multi-tenancy","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/row-level-security-for-multi-tenancy","updatedAt":"2026-07-31"},{"position":33,"slug":"sql-injection-secrets-tls-and-encryption","title":"SQL Injection, Secrets, TLS, and Encryption","section":"Security and Operations","description":"Protect PostgreSQL data with parameters, identifier allowlists, secret hygiene, authenticated TLS, storage encryption, rotation, and layered threat modeling.","url":"https://muhammadusmanakbar.com/postgres-book/sql-injection-secrets-tls-and-encryption","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/sql-injection-secrets-tls-and-encryption","updatedAt":"2026-07-31"},{"position":34,"slug":"monitoring-logs-metrics-and-slos","title":"Monitoring, Logs, Metrics, and Database SLOs","section":"Security and Operations","description":"Observe PostgreSQL through workload, saturation, waits, query statistics, logs, traces, SLOs, alerts, and runbooks without leaking data.","url":"https://muhammadusmanakbar.com/postgres-book/monitoring-logs-metrics-and-slos","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/monitoring-logs-metrics-and-slos","updatedAt":"2026-07-31"},{"position":35,"slug":"backups-point-in-time-recovery-and-restore-drills","title":"Backups, Point-in-Time Recovery, and Restore Drills","section":"Security and Operations","description":"Design PostgreSQL logical and physical backups, WAL archiving, PITR, retention, encryption, validation, and evidence-based restore drills.","url":"https://muhammadusmanakbar.com/postgres-book/backups-point-in-time-recovery-and-restore-drills","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/backups-point-in-time-recovery-and-restore-drills","updatedAt":"2026-07-31"},{"position":36,"slug":"replication-high-availability-and-failover","title":"Replication, High Availability, and Failover","section":"Security and Operations","description":"Understand physical and logical replication, synchronous tradeoffs, slots, promotion, fencing, failover, client recovery, and data-loss evidence.","url":"https://muhammadusmanakbar.com/postgres-book/replication-high-availability-and-failover","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/replication-high-availability-and-failover","updatedAt":"2026-07-31"},{"position":37,"slug":"upgrades-managed-postgres-and-disaster-response","title":"Upgrades, Managed PostgreSQL, and Disaster Response","section":"Security and Operations","description":"Plan PostgreSQL minor and major upgrades, evaluate managed services, rehearse rollback, and lead evidence-driven database incident response.","url":"https://muhammadusmanakbar.com/postgres-book/upgrades-managed-postgres-and-disaster-response","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/upgrades-managed-postgres-and-disaster-response","updatedAt":"2026-07-31"},{"position":38,"slug":"embeddings-and-vector-data","title":"Embeddings and Vector Data from First Principles","section":"AI-Native PostgreSQL","description":"Understand embeddings, dimensions, distance metrics, normalization, versioning, lineage, privacy, and when PostgreSQL vector search is appropriate.","url":"https://muhammadusmanakbar.com/postgres-book/embeddings-and-vector-data","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/embeddings-and-vector-data","updatedAt":"2026-07-31"},{"position":39,"slug":"pgvector-exact-and-approximate-search","title":"pgvector Exact and Approximate Search","section":"AI-Native PostgreSQL","description":"Install pgvector safely, store compatible vectors, query exact distance, build HNSW or IVFFlat indexes, filter tenants, and measure recall.","url":"https://muhammadusmanakbar.com/postgres-book/pgvector-exact-and-approximate-search","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/pgvector-exact-and-approximate-search","updatedAt":"2026-07-31"},{"position":40,"slug":"rag-data-model-and-ingestion","title":"RAG Data Modeling and Ingestion Pipelines","section":"AI-Native PostgreSQL","description":"Build a versioned PostgreSQL RAG ingestion model for documents, ACLs, parsing, chunks, embeddings, publication, retries, deletion, and rebuilds.","url":"https://muhammadusmanakbar.com/postgres-book/rag-data-model-and-ingestion","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/rag-data-model-and-ingestion","updatedAt":"2026-07-31"},{"position":41,"slug":"hybrid-retrieval-reranking-and-citations","title":"Hybrid Retrieval, Reranking, and Citations","section":"AI-Native PostgreSQL","description":"Combine PostgreSQL full-text and pgvector candidates, fuse ranks, rerank safely, build context, and validate resolvable citations.","url":"https://muhammadusmanakbar.com/postgres-book/hybrid-retrieval-reranking-and-citations","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/hybrid-retrieval-reranking-and-citations","updatedAt":"2026-07-31"},{"position":42,"slug":"retrieval-authorization-and-tenant-isolation","title":"Retrieval Authorization and Tenant Isolation","section":"AI-Native PostgreSQL","description":"Enforce tenant, group, document, version, sensitivity, and purpose policy before vector or lexical candidates become model context.","url":"https://muhammadusmanakbar.com/postgres-book/retrieval-authorization-and-tenant-isolation","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/retrieval-authorization-and-tenant-isolation","updatedAt":"2026-07-31"},{"position":43,"slug":"conversation-memory-tools-and-approvals","title":"Conversation Memory, Model Tools, and Human Approvals","section":"AI-Native PostgreSQL","description":"Model scoped AI memory, bounded PostgreSQL tools, proposals, approvals, idempotent execution, audit, retention, and safe failure.","url":"https://muhammadusmanakbar.com/postgres-book/conversation-memory-tools-and-approvals","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/conversation-memory-tools-and-approvals","updatedAt":"2026-07-31"},{"position":44,"slug":"safe-text-to-sql-and-database-agents","title":"Safe Text-to-SQL and Database Agents","section":"AI-Native PostgreSQL","description":"Build constrained natural-language database access with semantic tools, read-only roles, AST validation, limits, plan gates, approval, and evaluation.","url":"https://muhammadusmanakbar.com/postgres-book/safe-text-to-sql-and-database-agents","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/safe-text-to-sql-and-database-agents","updatedAt":"2026-07-31"},{"position":45,"slug":"evaluation-tracing-drift-latency-and-cost","title":"AI Evaluation, Tracing, Drift, Latency, and Cost","section":"AI-Native PostgreSQL","description":"Measure PostgreSQL-backed AI systems with versioned datasets, retrieval and answer metrics, traces, safety tests, drift detection, budgets, and release gates.","url":"https://muhammadusmanakbar.com/postgres-book/evaluation-tracing-drift-latency-and-cost","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/evaluation-tracing-drift-latency-and-cost","updatedAt":"2026-07-31"},{"position":46,"slug":"python-and-typescript-database-access","title":"Typed PostgreSQL Access from Python and TypeScript","section":"Application Delivery","description":"Build safe application data access with psycopg and node-postgres using parameters, transactions, pooling, timeouts, typed boundaries, and telemetry.","url":"https://muhammadusmanakbar.com/postgres-book/python-and-typescript-database-access","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/python-and-typescript-database-access","updatedAt":"2026-07-31"},{"position":47,"slug":"zero-downtime-migrations-and-backfills","title":"Zero-Downtime Migrations and Backfills","section":"Application Delivery","description":"Ship PostgreSQL schema changes through compatibility, lock analysis, staged constraints, concurrent indexes, batched backfills, observability, and rollback.","url":"https://muhammadusmanakbar.com/postgres-book/zero-downtime-migrations-and-backfills","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/zero-downtime-migrations-and-backfills","updatedAt":"2026-07-31"},{"position":48,"slug":"database-testing-ci-and-repeatable-environments","title":"Database Testing, CI, and Repeatable Environments","section":"Application Delivery","description":"Test PostgreSQL schemas, queries, migrations, concurrency, RLS, performance, recovery, and AI retrieval in disposable production-like environments.","url":"https://muhammadusmanakbar.com/postgres-book/database-testing-ci-and-repeatable-environments","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/database-testing-ci-and-repeatable-environments","updatedAt":"2026-07-31"},{"position":49,"slug":"capstone-your-first-business-database","title":"Capstone 1: Build Your First Business Database","section":"Capstones and Reference","description":"Design, implement, query, test, and explain a complete PostgreSQL support database from requirements through reproducible evidence.","url":"https://muhammadusmanakbar.com/postgres-book/capstone-your-first-business-database","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/capstone-your-first-business-database","updatedAt":"2026-07-31"},{"position":50,"slug":"capstone-secure-multi-tenant-saas","title":"Capstone 2: Operate a Secure Multi-Tenant SaaS Database","section":"Capstones and Reference","description":"Add roles, RLS, migrations, pooling, tuning, monitoring, backup, PITR, replication, failure drills, and production evidence to SignalDesk.","url":"https://muhammadusmanakbar.com/postgres-book/capstone-secure-multi-tenant-saas","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/capstone-secure-multi-tenant-saas","updatedAt":"2026-07-31"},{"position":51,"slug":"capstone-governed-postgresql-rag-assistant","title":"Capstone 3: Build a Governed PostgreSQL RAG Assistant","section":"Capstones and Reference","description":"Deliver an authorized, evaluated PostgreSQL and pgvector RAG system with versioned ingestion, hybrid retrieval, citations, safe tools, and operations.","url":"https://muhammadusmanakbar.com/postgres-book/capstone-governed-postgresql-rag-assistant","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/capstone-governed-postgresql-rag-assistant","updatedAt":"2026-07-31"},{"position":52,"slug":"production-checklist-decision-maps-and-glossary","title":"Production Checklist, Decision Maps, SQL Reference, and Glossary","section":"Capstones and Reference","description":"Use a practical PostgreSQL production checklist, architecture decision maps, psql and SQL reference, glossary, and continuing mastery plan.","url":"https://muhammadusmanakbar.com/postgres-book/production-checklist-decision-maps-and-glossary","contentApi":"https://muhammadusmanakbar.com/api/postgres-book-content/production-checklist-decision-maps-and-glossary","updatedAt":"2026-07-31"}]}