{"product_id":"just-use-postgres-9781633435698","title":"Just Use Postgres!","description":"\u003cp\u003e\u003cb\u003eYou probably don’t need a collection of specialty databases. Just use Postgres instead!\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003eWritten for application developers and database pros, \u003ci\u003eJust Use Postgres!\u003c\/i\u003e shows you how to get the most out of the powerful Postgres database.\u003cbr\u003e\u003cbr\u003eIn \u003ci\u003eJust Use Postgres! \u003c\/i\u003eyou’ll learn how to:\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eUse Postgres as an RDBMS for transactional workloads\u003c\/li\u003e\n\u003cli\u003eDevelop generative AI, geospatial, and time-series applications\u003c\/li\u003e\n\u003cli\u003eTake advantage of modern SQL including window functions and CTEs\u003c\/li\u003e\n\u003cli\u003ePerform full-text search and process JSON documents\u003c\/li\u003e\n\u003cli\u003eUse Postgres as a message queue\u003c\/li\u003e\n\u003cli\u003eOptimize performance with various index types including B-trees, GIN, GiST, HNSW, and more\u003c\/li\u003e\n\u003c\/ul\u003eOver the decades, PostgreSQL, aka Postgres, has grown into the most powerful general-purpose database and has become the de facto standard for developers worldwide. \u003ci\u003eJust Use Postgres!\u003c\/i\u003e 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.\u003cbr\u003e\u003cbr\u003eForeword by Josh Long. Afterword by Vlad Mihalcea.\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAbout the technology\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003eYou 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.\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAbout the book\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e\u003ci\u003eJust Use Postgres!\u003c\/i\u003e 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!\u003cbr\u003e\u003cbr\u003e\u003cb\u003eWhat's inside\u003c\/b\u003e\u003cul\u003e\n\u003cli\u003eGenerative AI, geospatial, and time-series applications\u003c\/li\u003e\n\u003cli\u003eModern SQL including window functions and CTEs\u003c\/li\u003e\n\u003cli\u003eFull-text search and JSON\u003c\/li\u003e\n\u003cli\u003eB-trees, GIN, GiST, HNSW, and more\u003c\/li\u003e\n\u003c\/ul\u003e\u003cb\u003eAbout the reader\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003eFor application developers, software engineers, and architects who know the basics of SQL.\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAbout the author\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e\u003cb\u003eDenis Magda\u003c\/b\u003e 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.\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003ePart 1\u003cbr\u003e1 Meeting Postgres\u003cbr\u003e2 Standard RDBMS capabilities\u003cbr\u003e3 Modern SQL\u003cbr\u003e4 Indexes\u003cbr\u003ePart 2\u003cbr\u003e5 Postgres and JSON\u003cbr\u003e6 Postgres for full-text search\u003cbr\u003ePart 3\u003cbr\u003e7 Postgres extensions\u003cbr\u003e8 Postgres for generative AI\u003cbr\u003e9 Postgres for time series\u003cbr\u003e10 Postgres for geospatial data\u003cbr\u003e11 Postgres as a message queue\u003cbr\u003eAppendixes\u003cbr\u003eA Five optimization tips\u003cbr\u003eB When not to use Postgres","brand":"Denis Magda","offers":[{"title":"Default Title","offer_id":56489604743510,"sku":"9781633435698","price":57.69,"currency_code":"EUR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0886\/3206\/6390\/files\/9781633435698.jpg?v=1793913304","url":"https:\/\/www.bookshop.lt\/en\/products\/just-use-postgres-9781633435698","provider":"Bookshop","version":"1.0","type":"link"}