PostgreSQL Mistakes and How to Avoid Them. Jimmy Angelakos
- Издательство: Manning
- Артикул: BC-083021
- Наличие: В наличии
Recognize and avoid these common PostgreSQL mistakes!
The best mistakes to learn from are ones made by other people! In PostgreSQL Mistakes and How To Avoid Them you’ll explore dozens of common PostgreSQL errors so you can easily avoid them in your own projects, learning proactively why certain approaches fail and others succeed.
In PostgreSQL Mistakes and How To Avoid Them you’ll learn how to:
- Avoid configuration and operation issues
- Maximize PostgreSQL utility and performance
- Fix bad SQL practices
- Solve common security and administration issues
- Ensure smooth migration and upgrades
- Diagnose and fix a bad database
As PostgreSQL continues its rise as a leading open source database, mastering its intricacies is crucial. PostgreSQL Mistakes and How To Avoid Them is full of tested best practices to ensure top performance, and future-proof your database systems for seamless change and growth. Each of the 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.
about the technology
Fixing mistakes in PostgreSQL databases can be time-consuming and risky—especially when you’re making live changes to an in-use system. Fortunately, you can learn from the mistakes other Postgres pros have already made! This incredibly practical book lays out how to find and avoid the most common, dangerous, and sneaky errors you’ll encounter using PostgreSQL.about the book
PostgreSQL Mistakes and How To Avoid Them identifies Postgres problems in key areas like data types, features, security, and high availability. For each mistake you’ll find a real-world narrative that illustrates the pattern and provides concrete recommendations for improvement. You’ll especially appreciate the illustrative code snippets, schema samples, mind maps, and tables that show the pros and cons of different approaches.what's inside
- Diagnose configuration and operation issues
- Fix bad SQL code
- Address security and administration issues
- Ensure smooth migration and upgrades
about the reader
For PostgreSQL database administrators and application developers.about the author
Jimmy Angelakos is a systems and database architect and PostgreSQL Contributor. He works as a Senior Principal Engineer at Deriv.| Информация о книге | |
| Обложка | Мягкая |
| Иллюстрации | Черно-белые |
| Издательство | Manning |
| Год издания | 2025 |
| ISBN | 9781633436879 |
| Авторы | Jimmy Angelakos |
| Количество страниц | 232 |
| Тип бумаги | Офсетная |
| Язык издания | Английский |
Сопутствующие товары
Head First Git. Raju Gandhi
What will you learn from this book?Many people who use Git rely on "recipes"--copying and pasting commands they find on the internet without really understanding how Git actually works. But what do you do if you find yourself in a tight spot? You can..
1 250.00 грн.
AI and Machine Learning for On-Device Development: A Programmer's Guide. 1st Ed. Laurence Moroney
AI is nothing without somewhere to run it. Now that mobile devices have become the primary computing device for most people, it's essential that mobile developers add AI to their toolbox. This insightful book is your guide to creating models and runn..
720.00 грн.
Паттерны проектирования JavaScript. Ди Франческо Уго
Раскройте потенциал паттернов проектирования JavaScript. Найдите структурированные решения распространенных задач разработки, пригодные для многократного использования и повышающие масштабируемость, производительность и удобство сопровождения кода. У..
720.00 грн.
Head First Design Patterns, 2nd Edition by Eric Freeman, Elisabeth Robson
What will you learn from this book? You know you don't want to reinvent the wheel, so you look to Design Patterns: the lessons learned by those who've faced the same software design problems. With Design Patterns, you get to take advantage of the ..
1 150.00 грн.
Машинное обучение и безопасность
Эта книга - руководство для всех, кто намерен освоить использование технологии машинного обучения для обеспечения безопасности компьютерных систем, от выявления различных аномалий до защиты конечных пользователей. Представлены примеры возможного прак..
770.00 грн.
Машинное обучение на R: экспертные техники для прогностического анализа. Ланц Бретт
Язык R предлагает мощный набор методов машинного обучения, позволяющих быстро проводить нетривиальный анализ ваших данных. Книга является руководством, которое поможет применять методы машинного обучения в решении ежедневных задач. Бретт Ланц научит..
540.00 грн.
Power BI Masterclass 8 - Python, Finance, and Advanced DAX. Dan We
Key benefitsLearn data visualization, advanced DAX expression, Python integration, and custom visuals in Power BIFocus on hands-on learning to apply real-world scenario concepts and work with relevant datasetsExplore stock quotes/balance sheets, prov..
1 688.00 грн.
Machine Learning Engineering with Python. Second Edition. Andrew P. McMahon
The Second Edition of Machine Learning Engineering with Python is the practical guide that MLOps and ML engineers need to build solutions to real-world problems. It will provide you with the skills you need to stay ahead in this rapidly evolving fiel..
870.00 грн.