High Performance Postgresql For Rails

High Performance PostgreSQL for Rails

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: A computer running macOS, Linux, or Windows and WSL2 PostgreSQL version 16, installed by package manager, compiled, or running with Docker An Internet connection

High Performance PostgreSQL for Rails

Rails Scales!

Rails doesn't scale. So say the naysayers. They’re wrong. Ruby on Rails runs some of the biggest sites in the world, impacting the lives of millions of users while efficiently crunching petabytes of data. This book reveals how they do it, and how you can apply the same techniques to your applications. Optimize everything necessary to make an application function at scale: monitoring, product design, Ruby code, software architecture, database access, caching, and more. Even if your app may never have millions of users, you reduce the costs of hosting and maintaining it. Optimize every aspect of your Ruby on Rails applications for world-class performance. Tweak your Rails app for snappy responsiveness. Find bottlenecks that slow your code. Scale an app for massive data sets. This book introduces techniques, patterns, and tricks to make your Rails application become more performant and scale to billions of requests per day. And it does it in an entertaining and fun way, sharing real-life stories of all kinds: tales from the trenches of working on massive Rails apps, and anecdotes from working on much smaller projects in tiny organizations of a handful of engineers. Through all these experiences you will learn that scaling Rails applications is a multifaceted task, including aspects such as monitoring, query tuning, and memory-aware coding. This book is for programmers of all levels of experience, from beginners to experienced Rails veterans. You can even show your nontechnical colleagues the features and limitations of Rails at scale. Reading this book will help you make Rails applications that fly. And it will make you enjoy the process. What You Need: In the course of this book we will be using Rails 8.0 and Ruby 3.4. The data stores used will be MySQL, Postgres, Redis, and Memcached.