Название: Mastering PostgreSQL: Accelerate Your Weekend Projects and Seamlessly Scale to Millions
Автор: Denis Magda, Jimmy Angelakos
Издательство: Manning Publications/Supabase
Год: 2026
Страниц: 116
Язык: английский
Формат: pdf (true), epub
Размер: 10.1 MB

Postgres is more than a relational database, it's a powerful general-purpose platform that blends SQL elegance with practical features for modern applications. These books guide developers, DBAs, and data practitioners through the depth and breadth of Postgres capabilities as well as ideas and pitfalls that matter most when building reliable, high-performance apps with Postgres. You’ll learn not only how to use Postgres, but how to use it well to its full extent: applying contemporary SQL techniques, leveraging built-in full-text capabilities, choosing appropriate data types, and avoiding common table and index design mistakes that cost performance and correctness.

Most people, however, are still familiar with SQL as defined by the SQL-92 standard, which fully completed the original relational model and idea. But much has changed since the introduction of that standard. The scope of relational databases has expanded far beyond the relational model, and these changes have been reflected in subsequent versions of the language. Modern SQL introduces new capabilities that not only make the language more readable and easier to follow but also simplify complex calculations and enable working with unstructured and semi-structured data.

Let’s explore the modern SQL capabilities of Postgres as we build a music streaming service that thousands of people use to listen to their favorite songs and artists. We’ll see how modern SQL makes it easy to analyze user preferences, song popularity, and the other data the service tracks.

What's inside:
Contemporary SQL techniques
Built-in full-text capabilities
Choosing appropriate data types
Avoiding table and index design mistakes that cost performance and correctness