Synopsis
You probably don’t need a collection of specialty databases. Just use Postgres instead!
Written for application developers and database pros, Just Use Postgres! shows you how to get the most out of the powerful Postgres database.
In Just Use Postgres! you’ll learn how to:
• 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
Over the decades, PostgreSQL, aka Postgres, has grown into the most powerful general-purpose database and has become the de facto standard for developers worldwide. Just Use Postgres! takes a modern look at Postgres, exploring the database’s most up-to-date features for AI, time-series, full-text search, geospatial, and other application workloads.
Foreword by Josh Long. Afterword by Vlad Mihalcea.
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.
Table of Contents
Part 1
1 Meeting Postgres
2 Standard RDBMS capabilities
3 Modern SQL
4 Indexes
Part 2
5 Postgres and JSON
6 Postgres for full-text search
Part 3
7 Postgres extensions
8 Postgres for generative AI
9 Postgres for time series
10 Postgres for geospatial data
11 Postgres as a message queue
Appendixes
A Five optimization tips
B When not to use Postgres
Get a free eBook (PDF or ePub) from Manning as well as access to the online liveBook format (and its AI assistant that will answer your questions in any language) when you purchase the print book.
"synopsis" may belong to another edition of this title.
About the Author
Denis Magda is a software engineer who started his career at Sun Microsystems and Oracle, working on the Java platform and leading one of the Java development teams. After mastering Java from the inside, he ventured into the world of Postgres and other databases, where he has stayed ever since.
"About this title" may belong to another edition of this title.
Search results for Just Use Postgres!: All the database you need
Stock Image
Just Use Postgres! : All the Database You Need
Seller: GreatBookPrices, Columbia, MD, U.S.A.
Seller rating 5 out of 5 stars
Condition: New. Seller Inventory # 51721685-n
Stock Image
Just Use Postgres!
Seller: PBShop.store US, Wood Dale, IL, U.S.A.
Seller rating 5 out of 5 stars
HRD. Condition: New. New Book. Shipped from UK. Established seller since 2000. Seller Inventory # PB-9781633435698
Stock Image
Just Use Postgres!
Seller: PBShop.store UK, Fairford, GLOS, United Kingdom
Seller rating 5 out of 5 stars
HRD. Condition: New. New Book. Shipped from UK. Established seller since 2000. Seller Inventory # PB-9781633435698
Buy New
US$ 54.21
US$ 7.88 shipping
Ships from United Kingdom to U.S.A.
Ships from United Kingdom to U.S.A.
Quantity: 15 available
Seller Image
Just Use Postgres!: All the Database You Need (Paperback or Softback)
Published by
Manning Publications 12/16/2025, 2025
ISBN 10: 1633435695
ISBN 13: 9781633435698
New
Paperback or Softback
Seller: BargainBookStores, Grand Rapids, MI, U.S.A.
Seller rating 5 out of 5 stars
Paperback or Softback. Condition: New. Just Use Postgres!: All the Database You Need. Book. Seller Inventory # BBS-9781633435698
Stock Image
Just Use Postgres!: All the database you need
Seller: California Books, Miami, FL, U.S.A.
Seller rating 4 out of 5 stars
Condition: New. Seller Inventory # I-9781633435698
Stock Image
Just Use Postgres! (Hardcover)
Published by
Manning Publications, New York, 2026
ISBN 10: 1633435695
ISBN 13: 9781633435698
New
Hardcover
Seller: Grand Eagle Retail, Bensenville, IL, U.S.A.
Seller rating 5 out of 5 stars
Hardcover. Condition: new. Hardcover. Juggling multiple databases slows every project and drains precious developer mental bandwidth. Imagine serving analytics, AI, and search from the same Postgres engine. Modern Postgres already solves these challenges, you only need the roadmap. Skip encyclopedic references, jump straight into working code and clear patterns. Build streaming, geospatial, and time series features faster than ever before. Stop overthinking your stack, just use Postgres and ship with confidence. Use-case chapters (eCommerce, streaming, IoT): Translate abstract concepts into relatable, production tested patterns. Modern SQL techniques (CTEs, window functions, JSON): Write concise queries, reduce application code complexity. Extension deep-dives (PostGIS, pgvector, timescaledb): Add AI, geospatial, and time-series power without extra infrastructure. Performance primers (indexes, partitioning, tuning): Keep latency low and throughput high for demanding workloads. Ready-to-run code snippets and Docker files: Accelerate learning, eliminate environment setup roadblocks. Just Use Postgres! by veteran engineer Denis Magda is a concise, example-driven book that shows working developers exactly how to unlock Postgres for modern, multifaceted applications. Each chapter tackles a real product scenario, from shopping carts to music streams and IoT sensors. Magda guides you through schema choices, index strategies, and powerhouse extensions using clear diagrams and runnable code. Finish the book ready to build AI-enhanced, searchable, analytics-ready services on a single Postgres instance. Save licensing costs, simplify deployments, and slash maintenance by consolidating diverse workloads into one robust database. Perfect for developers who know basic SQL and now need production-grade scalability, search, and AI capabilities. Since its initial release in 1996, PostgreSQL, aka Postgres, has grown into the most popular and powerful full-featured open source RDBMS available. Just Use Postgres! takes a modern look at Postgres, exploring the databases most up-to-date features for AI, time-series, full-text search, geospatial, and other application workloads. Shipping may be from multiple locations in the US or from the UK, depending on stock availability. Seller Inventory # 9781633435698
Stock Image
Just Use Postgres! : All the Database You Need
Seller: GreatBookPricesUK, Woodford Green, United Kingdom
Seller rating 5 out of 5 stars
Condition: New. Seller Inventory # 51721685-n
Buy New
US$ 53.87
US$ 20.13 shipping
Ships from United Kingdom to U.S.A.
Ships from United Kingdom to U.S.A.
Quantity: Over 20 available
Seller Image
Just Use Postgres!
Published by
Manning Publications, US, 2026
ISBN 10: 1633435695
ISBN 13: 9781633435698
New
Hardcover
First Edition
Seller: Rarewaves USA, OSWEGO, IL, U.S.A.
Seller rating 5 out of 5 stars
Hardback. Condition: New. 1st. Juggling multiple databases slows every project and drains precious developer mental bandwidth. Imagine serving analytics, AI, and search from the same Postgres engine. Modern Postgres already solves these challenges, you only need the roadmap. Skip encyclopedic references, jump straight into working code and clear patterns. Build streaming, geospatial, and time series features faster than ever before. Stop overthinking your stack, just use Postgres and ship with confidence. Use-case chapters (eCommerce, streaming, IoT): Translate abstract concepts into relatable, production tested patterns. Modern SQL techniques (CTEs, window functions, JSON): Write concise queries, reduce application code complexity. Extension deep-dives (PostGIS, pgvector, timescaledb): Add AI, geospatial, and time-series power without extra infrastructure. Performance primers (indexes, partitioning, tuning): Keep latency low and throughput high for demanding workloads. Ready-to-run code snippets and Docker files: Accelerate learning, eliminate environment setup roadblocks. Just Use Postgres! by veteran engineer Denis Magda is a concise, example-driven book that shows working developers exactly how to unlock Postgres for modern, multifaceted applications. Each chapter tackles a real product scenario, from shopping carts to music streams and IoT sensors. Magda guides you through schema choices, index strategies, and powerhouse extensions using clear diagrams and runnable code. Finish the book ready to build AI-enhanced, searchable, analytics-ready services on a single Postgres instance. Save licensing costs, simplify deployments, and slash maintenance by consolidating diverse workloads into one robust database. Perfect for developers who know basic SQL and now need production-grade scalability, search, and AI capabilities. Seller Inventory # LU-9781633435698
Stock Image
Just Use Postgres!
Seller: THE SAINT BOOKSTORE, Southport, United Kingdom
Seller rating 5 out of 5 stars
Hardback. Condition: New. New copy - Usually dispatched within 4 working days. Seller Inventory # B9781633435698
Buy New
US$ 53.88
US$ 20.63 shipping
Ships from United Kingdom to U.S.A.
Ships from United Kingdom to U.S.A.
Quantity: 1 available
Seller Image
Just Use Postgres!
Published by
Manning Publications, US, 2026
ISBN 10: 1633435695
ISBN 13: 9781633435698
New
Hardcover
First Edition
Seller: Rarewaves.com USA, London, LONDO, United Kingdom
Seller rating 5 out of 5 stars
Hardback. Condition: New. 1st. Juggling multiple databases slows every project and drains precious developer mental bandwidth. Imagine serving analytics, AI, and search from the same Postgres engine. Modern Postgres already solves these challenges, you only need the roadmap. Skip encyclopedic references, jump straight into working code and clear patterns. Build streaming, geospatial, and time series features faster than ever before. Stop overthinking your stack, just use Postgres and ship with confidence. Use-case chapters (eCommerce, streaming, IoT): Translate abstract concepts into relatable, production tested patterns. Modern SQL techniques (CTEs, window functions, JSON): Write concise queries, reduce application code complexity. Extension deep-dives (PostGIS, pgvector, timescaledb): Add AI, geospatial, and time-series power without extra infrastructure. Performance primers (indexes, partitioning, tuning): Keep latency low and throughput high for demanding workloads. Ready-to-run code snippets and Docker files: Accelerate learning, eliminate environment setup roadblocks. Just Use Postgres! by veteran engineer Denis Magda is a concise, example-driven book that shows working developers exactly how to unlock Postgres for modern, multifaceted applications. Each chapter tackles a real product scenario, from shopping carts to music streams and IoT sensors. Magda guides you through schema choices, index strategies, and powerhouse extensions using clear diagrams and runnable code. Finish the book ready to build AI-enhanced, searchable, analytics-ready services on a single Postgres instance. Save licensing costs, simplify deployments, and slash maintenance by consolidating diverse workloads into one robust database. Perfect for developers who know basic SQL and now need production-grade scalability, search, and AI capabilities. Seller Inventory # LU-9781633435698
Buy New
US$ 81.77
Free Shipping
Ships from United Kingdom to U.S.A.
Ships from United Kingdom to U.S.A.
Quantity: 4 available