The PostgreSQL Handbook: From First Query to Production Baixar grátis

Isbn 13: 9798173932426

The PostgreSQL Handbook: From First Query to Production odf de graça baixar

por

Escolha um formato:

Descrição do livro

The PostgreSQL Handbook is the complete guide to PostgreSQL for developers who write SQL for a living — from your first SELECT to running a database in production with confidence.
Most SQL material stops at the query. This book keeps going: through the capabilities that are the actual reason to choose PostgreSQL, and out the far side into indexes, query plans, security, backups, partitioning, and replication. Across five parts, twenty-three chapters and 501 pages, you build one system — Lumina Helpdesk, a support-ticketing database that grows chapter by chapter from an empty schema into something with real data, real constraints, real indexes, and real operational concerns.
No prior PostgreSQL expertise is assumed. Comfort with basic SQL is enough to start; everything past SELECT, WHERE, and JOIN is built on the page, in order, against that one running example.
You'll learn to:

  • Design a schema that holds up: tables, keys, data types chosen on purpose, and constraints that make bad data impossible
  • Think relationally — joins, aggregation, subqueries and CTEs, and window functions that keep complex logic inside SQL instead of spilling into application code
  • Use what makes PostgreSQL PostgreSQL: JSONB living beside relational columns, full-text search, server-side functions, triggers and procedures, and MVCC concurrency explained without hand-waving
  • Operate it: pick the right index for the shape of the question, read an EXPLAIN plan and act on it, set up roles and row-level security, take backups that restore, partition a table that outgrew itself, and stand up streaming replication with connection pooling
  • Connect it to your application — Npgsql from raw ADO.NET, EF Core over PostgreSQL, and pgvector for semantic and hybrid search in the database you already run
The last three chapters speak C# directly, but this is not a C# book: the first twenty contain none at all, and a reader who never opens Visual Studio loses nothing before Chapter 21.
Every SQL listing is real, executable SQL, verified against a live PostgreSQL 18.4 database by an automated harness before it was allowed into print. The output printed under a listing was captured from an actual run, never hand-typed. The database is deterministic by design — a fixed random seed and a fixed timestamp anchor — so when you run a listing you get the book's printed output exactly, on your machine, not "output may vary."
One script rebuilds the database to the exact state any chapter expects, so you can start reading anywhere, experiment freely, and reset when an experiment goes sideways.
Five appendices round it out: a native installation guide, a psql survival guide, the SQL style guide every listing in the book obeys, worked solutions to all 69 exercises, and a reference for what changed between PostgreSQL 16 and 18. A page-numbered index closes the book.
If you can write a SELECT, you can run PostgreSQL in production. This book is the path between the two.

Número de páginas :551
Isbn 13 :9798173932426
Encadernação The PostgreSQL Handbook: From First Query to Production:Capa Comum
Livros recentes
Livros relacionados