Название: PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries, 2nd Edition
Автор: Неnriеttа Dоmbrоvskауа, Воris Nоvikоv, Аnnа Ваilliеkоvа
Издательство: Apress
Год: 2024
Страниц: 583
Язык: английский
Формат: pdf
Размер: 13.5 MB

Write optimized queries. This book helps you write queries that perform fast and deliver results on time. You will learn that query optimization is not a dark art practiced by a small, secretive cabal of sorcerers. Any motivated professional can learn to write efficient queries from the get-go and capably optimize existing queries. You will learn to look at the process of writing a query from the database engine’s point of view, and know how to think like the database optimizer. The book begins with a discussion of what a performant system is and progresses to measuring performance and setting performance goals. It introduces different classes of queries and optimization techniques suitable to each, such as the use of indexes and specific join algorithms. You will learn to read and understand query execution plans along with techniques for influencing those plans for better performance. The book also covers advanced topics such as the use of functions and procedures, dynamic SQL, and generated queries. All of these techniques are then used together to produce performant applications, avoiding the pitfalls of object-relational mappers. This second edition includes new examples using Postgres 15 and the newest version of the PostgresAir database. It includes additional details and clarifications about advanced topics, and covers configuration parameters in greater depth. Finally, it makes use of advancements in NORM, using automatically generated functions.

Название: Hands-on Test-Driven Development: Using Ruby, Ruby on Rails, and RSpec
Автор: Grеg Dоnаld
Издательство: Apress
Год: 2024
Страниц: 237
Язык: английский
Формат: pdf
Размер: 10.2 MB

Learn to properly test Ruby and Ruby on Rails applications by first writing failing tests, and then by implementing application code to make the failing tests pass. This book will teach you how to employ test-driven development (TDD) using RSpec while building a blog from start to finish. By the end of the book, you will be ready to deploy their fully tested blog to their own production web server using the latest versions of Ruby 3 and Ruby on Rails 7. We’ll be using the Ruby programming language and the Ruby on Rails web framework to build everything. These are the best tools for the job, in my opinion. Ruby is a very expressive and powerful programming language, and Ruby on Rails is a very powerful web framework. We’ll use the test-driven development (TDD) style of software design and engineering, which means we’ll write failing tests first and only then write our implementation code to get our failing tests passing. We’ll use the RSpec testing framework to write our tests. RSpec describes itself as a tool for performing “behavior-driven development” and is in fact the best tool available for testing Ruby code. If you’ve never used RSpec before, don’t worry; in this book, I’ll cover more than enough to get you started and productive. We will use the PostgreSQL relational database management system (RDBMS) to store our project’s data. For beginner to intermediate Ruby software engineers who are interested in learning to use TDD with RSpec to test and build web applications using Ruby on Rails.

Название: Procedural Programming with PostgreSQL PL/pgSQL: Design Complex Database-Centric Applications with PL/pgSQL
Автор: Ваji Shаik, Dinеsh Кumаr Сhеmuduru
Издательство: Apress
Год: 2023
Страниц: 326
Язык: английский
Формат: pdf (true), epub, mobi
Размер: 10.1 MB

Learn the fundamentals of PL/PGSQL, the programming language of PostgreSQL which is most robust Open Source Relational Database. This book provides practical insights into developing database code objects such as functions and procedures, with a focus on effectively handling strings, numbers, and arrays to achieve desired outcomes, and transaction management. The unique approach to handling Triggers in PostgreSQL ensures that both functionality and performance are maintained without compromise. You'll gain proficiency in writing inline/anonymous server-side code within the limitations, along with learning essential debugging and profiling techniques. Additionally, the book delves into statistical analysis of PL/PGSQL code and offers valuable knowledge on managing exceptions while writing code blocks.

Название: Postgres: The First Experience
Автор: Раvеl Luzаnоv, Еgоr Rоgоv, Igоr Lеvshin
Издательство: Postgres Professional
Год: 2023
Страниц: 175
Язык: английский
Формат: pdf (true)
Размер: 10.4 MB

This short pamphlet provides an overview of PostgreSQL DBMS, covering the history of its development, the main features, and a product roadmap. I you are just getting started, you can use this book as a step-by-step installation and configuration guide. PostgreSQL is the most feature-rich free open-source database system. Originally developed in the academic environment, it has managed to bring together a wide developer community through its long history. Nowadays, PostgreSQL offers everything that most customers need, and it is actively used all over the world to create high-load business-critical systems. PostgreSQL is one of the most popular databases. Based on the solid foundation of academic development, over several decades PostgreSQL has evolved into an enterprise-level product that is now a real alternative to commercial databases. You can see it for yourself by looking at the key features of PostgreSQL 15, which is the latest released version right now.

Название: PostgreSQL for Jobseekers: Introduction to PostgreSQL administration for modern DBAs
Автор: Sonia Valeja, David Gonzalez
Издательство: BPB Publications
Год: 2023
Страниц: 318
Язык: английский
Формат: pdf (true)
Размер: 28.5 MB

A practical guide that will help you learn and leverage PostgreSQL's core features. PostgreSQL is a powerful open-source relational database management system (RDBMS) that is widely used in the industry. If you are seeking to acquire knowledge about PostgreSQL, this book is for you. This comprehensive book provides you with a solid foundation in working with PostgreSQL, a popular open-source database management system. It covers a broad spectrum of topics, allowing you to successfully install and configure PostgreSQL across various platforms and methods. By delving into the internal components that constitute a PostgreSQL service and their interplay, you will gain a deep understanding of how these elements collaborate to deliver a robust and dependable solution. From comprehending the process model and shared memory to mastering query execution and optimization, you will acquire comprehensive knowledge of PostgreSQL's internal workings. Furthermore, the book explores essential tasks performed by a database administrator (DBA), including backup and restore operations, security measures, performance tuning, and troubleshooting techniques. Lastly, it explores widely used extensions and compatible tools that can enhance the functionality of PostgreSQL.

Название: PostgreSQL 15 Cookbook: 100+ expert solutions across scalability, performance optimization, essential commands
Автор: Peter G.
Издательство: GitforGits
Год: 2023
Страниц: 364
Язык: английский
Формат: pdf, epub, mobi
Размер: 10.2 MB

If you're a PostgreSQL database administrator looking for a comprehensive guide to managing your databases, look no further than the PostgreSQL 15 Cookbook. With 100 ready solutions to common database management challenges, this book provides a complete guide to administering and troubleshooting your databases using latest PostgreSQL 15.Starting with cloud provisioning and migration, the book covers all aspects of database administration, including replication, transaction logs, partitioning, sharding, auditing, realtime monitoring, backup, recovery, and error debugging. Each solution is presented in a clear, easy-to-follow format, using a real database called 'adventureworks' to provide an on-job practicing experience.Throughout the book, you'll learn how to use tools like pglogical, pgloader, WAL, repmgr, Patroni, HAProxy, PgBouncer, pgBackRest, pgAudit and Prometheus, gaining valuable experience and expertise in managing your databases.

Название: PostgreSQL 14 Internals
Автор: Egor Rogov
Издательство: Postgres Professional
Год: 2023
Страниц: 629
Язык: английский
Формат: pdf (true)
Размер: 10.1 MB

This book is for those who will not settle for a black-box approach when working with a database. If you are eager to learn, prefer not to take expert advice for granted, and would like to figure out everything yourself, follow along. I assume that the reader has already tried using PostgreSQL and has at least some general understanding of how it works. Entry-level users may find the text a bit difficult. For example, I will not tell anything about how to install the server, enter psql commands, or set configuration parameters. I hope that the book will also be useful for those who are familiar with another database system, but switch over to PostgreSQL and would like to understand how they differ. A book like this would have saved me a lot of time several years ago. And that’s exactly why I finally wrote it. In the introductory chapter, I briefly touch upon the main database concepts that will serve as the foundation for all the further narration. I do not expect you to get much new information from this chapter but still include it to complete the big picture. Besides, this overview can be found useful by those who are migrating from other database systems.

Название: Learn PostgreSQL From Basics: A Complete Guide To Learn PostgreSQL Quickly For Absolute Beginners
Автор: Silas Burch
Издательство: Independently published
Год: 2023
Страниц: 106
Язык: английский
Формат: epub
Размер: 10.2 MB

This book will help you build efficient and fault-tolerant PostgreSQL applications. You'll thoroughly examine the advanced features of PostgreSQL, including logical replication, database clusters, performance tuning, monitoring, and user management. You'll also work with the PostgreSQL optimizer, configure PostgreSQL for high speed. As you progress through the chapters, you'll cover transactions, locking, indexes, and how to optimize queries for improved performance. Additionally, you'll learn how to manage network security and explore backups and replications while understanding useful PostgreSQL extensions to help you in optimizing the performance of large databases. By the end of this PostgreSQL book, you'll be able to get the most out of your database by implementing advanced administrative tasks effortlessly.

Название: Building Modern Business Applications: Reactive Cloud Architecture for Java, Spring, and PostgreSQL
Автор: Реtеr Rоуаl
Издательство: Apress
Год: 2023
Страниц: 189
Язык: английский
Формат: pdf (true), epub, mobi
Размер: 10.2 MB

Discover a new way of thinking about business applications in light of the massive industry shift toward cloud computing and reactive programming technologies. This book synthesizes technologies and techniques such as event sourcing, command query responsibility segregation (CQRS), property-based testing, and GraphQL into a cohesive guide for modern business applications that benefit every developer. The book begins with a look at the fundamentals of modern business applications. These fundamentals include business rules and the managing of data over time. The benefits of reactive techniques are explained, including how they are fundamentally aligned with what application developers strive to achieve in their work. Author Peter Royal equips you with sound guidance to follow as you evolve your existing systems, as well as examples of how to build those systems using modern techniques in Spring, Java, and PostgreSQL.

Название: PostgreSQL 15 изнутри
Автор: Poгoв E.B.
Издательство: ДМК Пресс
Год: 2023
Страниц: 664
Язык: русский
Формат: pdf
Размер: 12.7 MB

В книге рассматривается внутреннее устройство СУБД PostgreSQL: детали реализации многоверсионности и изоляции на основе снимков данных, включая процедуру очистки неактуальных версий строк; буферный кеш и журнал предзаписи; использование блокировок различных уровней; планирование и выполнение SQL-запросов; принципы расширяемости и особенности имеющихся индексных методов доступа. Большое внимание уделяется возможностям, предоставляемым для самостоятельного изучения механизмов функционирования PostgreSQL. В настоящем издании учтены замечания читателей и исправлены опечатки, а также отражены изменения, произошедшие в версии PostgreSQL 15.