{"product_id":"postgresql-mistakes-and-how-to-jimmy-angelakos-9781633436879","title":"PostgreSQL Mistakes and How to Avoid Them","description":"\u003cb\u003eRecognize and avoid these sixty common PostgreSQL mistakes! \u003c\/b\u003e \u003cp\u003e\u003c\/p\u003eThe best mistakes to learn from are ones made by other people! In \u003ci\u003ePostgreSQL Mistakes and How To Avoid Them\u003c\/i\u003e you'll explore dozens of common PostgreSQL errors so you can easily avoid them in your own projects. \u003cp\u003e\u003c\/p\u003eIn \u003ci\u003ePostgreSQL Mistakes and How To Avoid Them\u003c\/i\u003e you'll learn how to: \u003cp\u003e\u003c\/p\u003e Avoid configuration and operation issues\u003cbr\u003e Maximize PostgreSQL utility and performance\u003cbr\u003e Fix bad SQL practices\u003cbr\u003e Solve common security and administration issues\u003cbr\u003e Ensure smooth migration and upgrades\u003cbr\u003e Diagnose and fix a bad database \u003cp\u003e\u003c\/p\u003e Fixing a PostgreSQL mistake can be tricky and time-consuming, especially when you're making risky live changes to an in-use system. \u003ci\u003ePostgreSQL Mistakes and How To Avoid Them\u003c\/i\u003e helps you spot and sidestep problems in setup, admin, querying, migrating, upgrading, and more. Follow these tested best practices to ensure top performance and future-proof your database systems for seamless change and growth. Each of the 60 mistakes is carefully described and accompanied by a demo, along with an explanation that expands your knowledge of PostgreSQL internals and helps you to build a stronger mental model of how the database engine works. \u003cp\u003e\u003c\/p\u003e Purchase of the print book includes a free eBook in PDF and ePub formats from Manning Publications. \u003cp\u003e\u003c\/p\u003e\u003cb\u003eAbout the book\u003c\/b\u003e \u003cp\u003e\u003c\/p\u003e \u003ci\u003ePostgreSQL Mistakes and How To Avoid Them\u003c\/i\u003e reveals dozens of configuration and operational mistakes you're likely to make with PostgreSQL. The book covers common problems across all key PostgreSQL areas, from data types, to features, security, and high availability. For each mistake you'll find a real-world narrative that lays out context and recommendations for improvement. \u003cp\u003e\u003c\/p\u003eAs you go, you'll appreciate the illustrative code snippets (both bad and good), database schema samples, mind maps, and comparison tables that show the pros and cons of different approaches. You'll soon have the pro-level knowledge of a battle-scarred PostgreSQL veteran without the pain of experiencing the mistakes in your own projects! \u003cp\u003e\u003c\/p\u003e \u003cb\u003eAbout the reader\u003c\/b\u003e \u003cp\u003e\u003c\/p\u003e For database administrators and application developers working with PostgreSQL databases. \u003cp\u003e\u003c\/p\u003e \u003cb\u003eAbout the author\u003c\/b\u003e \u003cp\u003e\u003c\/p\u003e \u003cb\u003eJimmy Angelakos\u003c\/b\u003e is a Systems and Database Architect and recognized PostgreSQL expert with a wealth of experience gained from his career in Software Architecture and key roles at 2ndQuadrant and EDB. He studied Computer Science at the University of Aberdeen and has worked with, and contributed to, Open-Source tools for 25+ years. Jimmy is a regular speaker at conferences and events focused on databases and Open-Source software, sharing his insights with the community.\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAuthor:\u003c\/b\u003e Jimmy Angelakos\u003cbr\u003e\u003cb\u003eISBN-10:\u003c\/b\u003e 163343687X\u003cbr\u003e\u003cb\u003eISBN-13:\u003c\/b\u003e 9781633436879\u003cbr\u003e\u003cb\u003ePublisher:\u003c\/b\u003e Manning Publications\u003cbr\u003e\u003cb\u003eLanguage:\u003c\/b\u003e English\u003cbr\u003e\u003cb\u003ePublished:\u003c\/b\u003e 07\/15\/2025\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 232\u003cbr\u003e\u003cb\u003eFormat:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003eWeight:\u003c\/b\u003e 0.71lbs","brand":"Jimmy Angelakos","offers":[{"title":"Paperback","offer_id":46974448369919,"sku":"9781633436879","price":49.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0662\/2982\/9887\/files\/img_275cf98c-6dab-472e-80ed-013867e3f9ff.jpg?v=1750875057","url":"https:\/\/www.whiterainbookhouse.com\/products\/postgresql-mistakes-and-how-to-jimmy-angelakos-9781633436879","provider":"WR Book House","version":"1.0","type":"link"}