{"product_id":"just-use-postgres-all-the-database-you-need","title":"Just Use Postgres!: All the database you need","description":"You probably don’t need a collection of specialty databases. Just use Postgres instead!\n\nWritten for application developers and database pros, Just Use Postgres! shows you how to get the most out of the powerful Postgres database.\n\nIn Just Use Postgres! you’ll learn how to:\n\n• Use Postgres as an RDBMS for transactional workloads\n• Develop generative AI, geospatial, and time-series applications\n• Take advantage of modern SQL including window functions and CTEs\n• Perform full-text search and process JSON documents\n• Use Postgres as a message queue\n• Optimize performance with various index types including B-trees, GIN, GiST, HNSW, and more\n\nOver 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.\n\nForeword by Josh Long. Afterword by Vlad Mihalcea.\n\nAbout the technology\n\nYou 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.\n\nAbout the book\n\nJust 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!\n\nWhat's inside\n\n• Generative AI, geospatial, and time-series applications\n• Modern SQL including window functions and CTEs\n• Full-text search and JSON\n• B-trees, GIN, GiST, HNSW, and more\n\nAbout the reader\n\nFor application developers, software engineers, and architects who know the basics of SQL.\n\nAbout the author\n\nDenis 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.\n\nTable of Contents\n\nPart 1\n1 Meeting Postgres\n2 Standard RDBMS capabilities\n3 Modern SQL\n4 Indexes\nPart 2\n5 Postgres and JSON\n6 Postgres for full-text search\nPart 3\n7 Postgres extensions\n8 Postgres for generative AI\n9 Postgres for time series\n10 Postgres for geospatial data\n11 Postgres as a message queue\nAppendixes\nA Five optimization tips\nB When not to use Postgres\n\nGet 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.\u003cbr\u003eASIN: 1633435695\u003cbr\u003eVSKU: BVV.1633435695.G\u003cbr\u003eCondition: Good\u003cbr\u003eAuthor\/Artist:Magda, Denis\u003cbr\u003eBinding: Paperback\u003cbr\u003e\u003cb\u003eNote:\u003c\/b\u003e Any images shown are stock photographs and product may differ from what is shown.  \u003cbr\u003e\u003cb\u003eCondition Notes\u003c\/b\u003e: The item shows wear from consistent use, but it remains in good condition and works perfectly. All pages and cover are intact  including the dust cover, if applicable . Spine may show signs of wear. Pages may include limited notes and highlighting. May NOT include discs, access code or other supplemental materials.  \u003cbr\u003e","brand":"Blue Vase Books","offers":[{"title":"Default Title","offer_id":43331432284221,"sku":"BVV.1633435695.G","price":50.39,"currency_code":"USD","in_stock":true}],"url":"https:\/\/www.bluevasebooks.com\/products\/just-use-postgres-all-the-database-you-need","provider":"Blue Vase Books","version":"1.0","type":"link"}