{"product_id":"just-use-postgres-all-the-database-you-need-1633435695","title":"Just Use Postgres!: All the database you need","description":"\u003cp\u003e\u003cstrong\u003eISBN:\u003c\/strong\u003e 1633435695\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eAuthor:\u003c\/strong\u003e Magda, Denis\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eCondition:\u003c\/strong\u003e New\u003c\/p\u003e\u003cp\u003eYou probably dont 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! youll 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 moreOver 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 databases 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 technologyYou know that PostgreSQL is a fast, reliable, SQL compliant RDBMS. You may not know that its 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 bookJust 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 Postgress capabilities. Along the way, youll also meet an incredible ecosystem of Postgres extensions like pgvector, PostGIS, pgmq, and TimescaleDB. Youll 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 moreAbout the readerFor application developers, software engineers, and architects who know the basics of SQL.About the authorDenis 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 ContentsPart 11 Meeting Postgres2 Standard RDBMS capabilities3 Modern SQL4 IndexesPart 25 Postgres and JSON6 Postgres for full-text searchPart 37 Postgres extensions8 Postgres for generative AI9 Postgres for time series10 Postgres for geospatial data11 Postgres as a message queueAppendixesA Five optimization tipsB When not to use PostgresGet 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.\u003c\/p\u003e","brand":"Manning","offers":[{"title":"Default Title","offer_id":52226714763552,"sku":"NEW1633435695","price":67.77,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0980\/7426\/3840\/files\/71siOhx9KdL.jpg?v=1787321127","url":"https:\/\/miakarts.com\/products\/just-use-postgres-all-the-database-you-need-1633435695","provider":"Miakarts Books","version":"1.0","type":"link"}