Django with PostgreSQL and the ORM

Build Reliable Database-Driven Applications with Models, Relationships, Queries, Migrations, and PostgreSQL

von Riley Frost

308 Seiten, Taschenbuch

Kurzbeschreibung des Verlags

Your Django application works. But is its database layer ready for real users, growing data, concurrent requests, and production traffic?Building Django models and running migrations is easy. Building a database-driven application that remains correct, fast, maintainable, and reliable as it grows requires a deeper understanding of what happens beneath the ORM.Django with PostgreSQL and the ORM takes you beyond basic CRUD development and shows you how Django's ORM and PostgreSQL work together to support serious, production-minded applications.Part of The Practical Django Series, this second book focuses on the database layer that powers modern Django projects. Instead of isolated examples, you will progressively build InventoryHub, a realistic inventory and purchasing application involving products, suppliers, purchase orders, stock movements, reporting, constraints, transactions, and evolving database requirements.You will learn how to design Django models that reflect real business rules, choose appropriate field types and relationships, enforce data integrity with PostgreSQL constraints, and build efficient QuerySets without treating the ORM as a black box. You will explore ForeignKey, one-to-one and many-to-many relationships, annotations, aggregations, subqueries, F expressions, select_related, prefetch_related, pagination, bulk operations, and techniques for eliminating N+1 queries.The book also takes you deeper into Django migrations and safe schema evolution, PostgreSQL indexes, EXPLAIN, query planning, full-text search, trigram matching, JSON, transactions, select_for_update, concurrency control, idempotency, deadlock recovery, database testing, connection management, backups, observability, and capacity planning.Just as importantly, you will learn when to trust the ORM, when to inspect the generated SQL, when PostgreSQL should enforce a business rule, and how to make database changes without putting production data at unnecessary risk.This book is ideal for developers who already understand basic Django development and are ready to build more reliable database-backed applications.If you want to move beyond simply making Django applications work and start designing data layers that can survive real-world growth, Django with PostgreSQL and the ORM gives you the practical foundation to do it.

• Reihe: Independently published
• ISBN: 9798174413740
• Sprache: Englisch
• Erscheinungsdatum: 15.09.2026
• Größe: 254 x 178 mm
• Verlag: Independently published