Hüppa põhisisu juurde
Raamatukoi
Tõde ja õigus

Just Use Postgres!

Denis Magda · Manning Publications · 2026

Just Use Postgres!

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

Saadavus
71,00 €

Uus kasutamata raamat

Täna tellides on tarneaeg umbes 10 päeva (27.11.2026)Tellimuse täitmise aeg on umbkaudne ja sõltub nädalapäevast, millal tellimus tehakse. Reeglina ei kulu üle kahe nädala.

Tarne ja kättesaamine

Detailid

ISBN
9781633435698
Aasta
2026
Keel
inglise
Köide
Kõva kaas
Lehekülgi
400
Teema
Teatmeteosed ja üldteadmised › Teadustöö ja teadusinfo — Research & information: general
Kaal
728 g