This second edition of the book includes a whole new chapter about PostgreSQL Extensions.
Written by the author of the CREATE EXTENSION command!
The Art of PostgreSQL is the new title of “Mastering PostgreSQL in Application Development”, acclaimed one of the very best resources around to learn SQL!
Improved Book Design
Because the first edition of the book has been so well received, the second edition is now available as a redesigned paperback printed format, making it a strong fit for your library!
Learn how to deal with SQL in your developer workflow: versioning, testing, code reviewing, deployment. Best practice and tools are covered.
Learn advanced SQL with practical examples and datasets that help you get the most of the book! Every query solves a practical use case and is given in context.
The book covers (de-)normalisation with simple practical examples to dive into this seemingly complex topic, including Caching and Indexing Strategy.
This book is for developers, covering advanced SQL techniques for data processing. Learn how to get exactly the result set you need in your application’s code!
Writing efficient SQL is easier than it looks, and begins with database modeling and writing clear code. The book teaches you how to write fast queries!
The book comes with open data sets and instructions to get them so that you can run all the SQL queries at home, edit them and learn from them. Advanced psql setup is even included!
The Book is a 438 pages full of SQL queries. 334 of them actually, all answering a very clear use-case, that is given in plain English. Every query is explained in details.
Interviews from industry veterans who began building web application in the previous century. They’ve been there and have opinions to share about how to approach SQL.
The whole electronic reading kit for all your devices: tablet, phone and desktop computer are covered. The PDF is carefully edited to target modern display formats (try it on your tablet!).
A PostgreSQL instance loaded with all the data from the book, and running a web based application that allows playing with every SQL query from the book!
The datasets from the book with 56 tables already loaded from their Open Data sources. We all learn better with concrete examples. You have 15 datasets available in the docker image.
Share the book and the docker instance with up to 15 people in your enterprise! Yes, you buy once, then share. You may even run each your own container if you prefer that, of course.
We also cover how to design a database model and why as a developer you should care about normalizing it. With practical examples and normalization scripts.
The Enterprise Edition’s docker image also includes the 334 queries as .sql files, plus the code of the sample applications presented in the book.
The application code is available with its SQL Regression Testing suite, using RegreSQL. Check out this tool, you might need it soon…
Thanks for your fantastic book. It's helped me immensely in my current job. Technical books can often be a bore and hard to digest, but Mastering PostgreSQL was a pleasure to read.”
At last the definitive Postgres book for app developers is out, and from the amazing @tapoueh no less. Go get it!”
Peter van Hardenberg
Full edition of “Mastering PostgreSQL…” is BRILLIANT! Not just best PG resource ever but best tech-learning package I've ever seen!”
I knew “Mastering PostgreSQL” had to be good, but being typeset with XeTeX tops it!”
Bought the ultimate PostgreSQL book for app developers from @tapoueh Go get it! You will learn many things!”
The culprit seems to be @tapoueh's book and a few commits by someone learning #PostgreSQL best practices…”
I just discovered your book and am super excited to order it!”
Not convinced yet? Get a FREE chapter including the full Table of Contents!