High Performance PostgreSQL for Rails

High Performance PostgreSQL for Rails
Author :
Publisher : Pragmatic Bookshelf
Total Pages : 667
Release :
ISBN-10 : 9798888651087
ISBN-13 :
Rating : 4/5 (87 Downloads)

Book Synopsis High Performance PostgreSQL for Rails by : Andrew Atkinson

Download or read book High Performance PostgreSQL for Rails written by Andrew Atkinson and published by Pragmatic Bookshelf. This book was released on 2024-06-17 with total page 667 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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 Related Books

High Performance PostgreSQL for Rails
Language: en
Pages: 667
Authors: Andrew Atkinson
Categories: Computers
Type: BOOK - Published: 2024-06-17 - Publisher: Pragmatic Bookshelf

DOWNLOAD EBOOK

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
PostgreSQL 10 High Performance
Language: en
Pages: 499
Authors: Enrico Pirozzi
Categories: Computers
Type: BOOK - Published: 2018-04-30 - Publisher: Packt Publishing Ltd

DOWNLOAD EBOOK

Leverage the power of PostgreSQL 10 to design, administer and maintain a high-performance database solution Key Features Obtain optimal PostgreSQL 10 database p
PostgreSQL 9 High Availability Cookbook
Language: en
Pages: 662
Authors: Shaun M. Thomas
Categories: Computers
Type: BOOK - Published: 2014-07-17 - Publisher: Packt Publishing Ltd

DOWNLOAD EBOOK

A comprehensive series of dependable recipes to design, build, and implement a PostgreSQL server architecture free of common pitfalls that can operate for years
PostgreSQL High Performance Cookbook
Language: en
Pages: 354
Authors: Chitij Chauhan
Categories: Computers
Type: BOOK - Published: 2017-03-29 - Publisher: Packt Publishing Ltd

DOWNLOAD EBOOK

Get to know effective ways to improve PostgreSQL's performance and master query optimization, and database monitoring. About This Book Perform essential databas
PostgreSQL High Availability Cookbook
Language: en
Pages: 530
Authors: Shaun M. Thomas
Categories: Computers
Type: BOOK - Published: 2017-02-08 - Publisher: Packt Publishing Ltd

DOWNLOAD EBOOK

Master over 100 recipes to design and implement a highly available server with the advanced features of PostgreSQL About This Book Create a PostgreSQL cluster t