Название: High Performance PostgreSQL for Rails : Reliable, Scalable, Maintainable Database Applications
Автор: Andrew Atkinson
Издательство: Pragmatic Bookshelf
Год: June 2024 (Book version: P1.0)
Страниц: 440
Язык: английский
Формат: pdf (true), epub, mobi + Code
Размер: 14.3 MB

Build faster, more reliable Rails apps by taking the best advanced PostgreSQL and Active Record capabilities, and using them to solve your application scale and growth challenges.

Build faster, more reliable Rails apps by taking the best advanced PostgreSQL and Active Record capabilities, and using them to solve your application scale and growth challenges. Gain the skills needed to comfortably work with multi-terabyte databases, and with complex Active Record, SQL, and specialized Indexes. Develop your skills with PostgreSQL on your laptop, then take them into production, while keeping everything in sync. Make slow queries fast, perform any schema or data migration without errors, use scaling techniques like read/write splitting, partitioning, and sharding, to meet demanding workload requirements from Internet scale consumer apps to enterprise SaaS.

Deepen your firsthand knowledge of high-scale PostgreSQL databases and Ruby on Rails applications with dozens of practical and hands-on exercises. Unlock the mysteries surrounding complex Active Record. Make any schema or data migration change confidently, without downtime. Grow your experience with modern and exclusive PostgreSQL features like SQL Merge, Returning, and Exclusion constraints. Put advanced capabilities like Full Text Search and Publish Subscribe mechanisms built into PostgreSQL to work in your Rails apps. Improve the quality of the data in your database, using the advanced and extensible system of types and constraints to reduce and eliminate application bugs. Tackle complex topics like how to improve query performance using specialized indexes. Discover how to effectively use built-in database functions and write your own, administer replication, and make the most of partitioning and foreign data wrappers. Use more than 40 well-supported open source tools to extend and enhance PostgreSQL and Ruby on Rails. Gain invaluable insights into database administration by conducting advanced optimizations—including high-impact database maintenance—all while solving real-world operational challenges.

Take your new skills into production today and then take your PostgreSQL and Rails applications to a whole new level of reliability and performance.

What You Need:
PostgreSQL version 16, Ruby version 3.2, and Ruby on Rails 7.1. Docker. A text editor.
A computer running macOS, Linux, or Windows and WSL
PostgreSQL version 16, installed by package manager, compiled, or running with Docker
An Internet connection

Who Is This Book For?
Topics are chosen for back-end engineers looking to deepen their knowledge and skills with PostgreSQL and Ruby on Rails. Whether you’re working on consumer scale Internet applications or enterprise B2B Software as a Service (SaaS), scaling PostgreSQL and Rails application codebases is mission critical for the success of your business. Your team expects to build on and operate these technologies while managing huge data growth amidst shifting business priorities.
If your job responsibilities or career aspirations include any of the following descriptions, this book will help you grow:

• Ruby on Rails application developers sharpening their database skills
• PostgreSQL database administrators (DBAs) learning Ruby on Rails
• Infrastructure and DevOps engineers learning Ruby on Rails
• Database reliability engineers (DBRE) learning how to perform sharding, replication, and table partitioning
• Developers coming from other relational databases
• Web developers with experience in frameworks like Laravel or Django, learning Ruby on Rails
• Data engineers learning PostgreSQL, replication, and change data capture (CDC)

Two major categories of database work are transactional work, also called online transaction processing (OLTP), and analytical, also called online analytical processing (OLAP). Here, we’re focused on OLTP. OLTP has short-duration queries running in high volume, with high concurrency. The result set sizes are small. Wikipedia defines online transaction processing as follows: Such systems are expected to respond to user requests and process them in real time.