Just Use Postgres! - Denis Magda

pro $24.99 per month

• access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
• choose one free eBook per month to keep
• exclusive 50% discount on all purchases
• renews monthly, pause or cancel renewal anytime

lite $19.99 per month

• access to all Manning books, including MEAPs!

team

5, 10 or 20 seats+ for your team - learn more

about the technology

You know that PostgreSQL is a fast, reliable, SQL compliant RDBMS. You may not know that it’s also great for geospatial systems, time series, full-text search, JSON documents, AI vector embeddings, and many other specialty database functions. For almost any data task you can imagine, you can use Postgres.

about the book

Just Use Postgres! covers recipes for using Postgres in dozens of applications normally reserved for single-purpose databases. Written for busy application developers, each chapter explores a different use case illuminating the breadth and depth of Postgres’s capabilities. Along the way, you’ll also meet an incredible ecosystem of Postgres extensions like pgvector, PostGIS, pgmq, and TimescaleDB. You’ll be amazed at everything you can accomplish with Postgres!

what's inside

• Generative AI, geospatial, and time-series applications
• Modern SQL including window functions and CTEs
• Full-text search and JSON
• B-trees, GIN, GiST, HNSW, and more

about the reader

For application developers, software engineers, and architects who know the basics of SQL.

about the author

Denis Magda is a recognized Postgres expert and software engineer who worked on Java at Sun Microsystems and Oracle before focusing on databases and large-scale distributed systems.

Please log in to add this book to your reading list.

I was pleasantly surprised to learn many new things from this book.

An excellent guide covering everything from basics to cutting-edge features.

Pleasant, easy to read with tonnes of great code.

Well-organized and easy to search.

The missing guide to understanding and using Postgres.

Postgres has quietly become the default data layer for the modern world. This book tells the story of how a thirty-year-old idea turned into the engine for everything from transactions to generative AI.