This book explores ways to use Postgres for areas such as geospatial systems, time series, full-text search, JSON documents, AI vector embeddings, and other specialty database functions. Denis Magda covers recipes for using Postgres in applications normally reserved for single-purpose databases. Along the way, Magda also introduces the ecosystem of Postgres extensions like pgvector, PostGIS, pgmq, and TimescaleDB.

<ASIN:1633435695>

Author: Denis Magda
Publisher: Manning
Date: December 2025
Pages: 400
ISBN: 978-1633435698
Print: 1633435695
Kindle: B0FLQKY932
Audience: Postgres developers
Level: Intermediate
Category: Database

Topics include:

• Use Postgres as an RDBMS for transactional workloads
• Develop generative AI, geospatial, and time-series applications
• Take advantage of modern SQL including window functions and CTEs
• Perform full-text search and process JSON documents
• Use Postgres as a message queue
• Optimize performance with various index types including B-trees, GIN, GiST, HNSW, and more

For more Book Watch just click.

Book Watch is I Programmer's listing of new books and is compiled using publishers' publicity material. It is not to be read as a review where we provide an independent assessment. Some, but by no means all, of the books in Book Watch are eventually reviewed.

To have new titles included in Book Watch contact  BookWatch@i-programmer.info

Follow @bookwatchiprog on Twitter or subscribe to I Programmer's Books RSS feed for each day's new addition to Book Watch and for new reviews.