High Performance PostgreSQL for Rails: Reliable, Scalable, Maintainable Database Applications
Atkinson, Andrew
- 出版商: Pragmatic Bookshelf
- 出版日期: 2024-07-23
- 售價: $2,560
- 貴賓價: 9.5 折 $2,432
- 語言: 英文
- 頁數: 456
- 裝訂: Quality Paper - also called trade paper
- ISBN: 9798888650387
- ISBN-13: 9798888650387
-
相關分類:
PostgreSQL、Ruby、JVM 語言、SQL、資料庫
立即出貨 (庫存=1)
商品描述
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
商品描述(中文翻譯)
透過運用最佳的進階 PostgreSQL 和 Active Record 功能，以解決應用程式的規模和成長挑戰，建立更快速、更可靠的 Rails 應用程式。獲得與多 TB 資料庫和複雜的 Active Record、SQL 和專用索引一起工作的技能。在筆記型電腦上開發 PostgreSQL 技能，然後將其應用於生產環境，同時保持一切同步。使緩慢的查詢變快，執行任何模式或資料遷移而不出錯，使用讀寫分離、分區和分片等擴展技術，滿足從互聯網規模的消費者應用程式到企業 SaaS 的要求。
通過數十個實用且實際操作的練習，深入了解高規模 PostgreSQL 資料庫和 Ruby on Rails 應用程式。解開圍繞複雜 Active Record 的謎團。自信地進行任何模式或資料遷移的更改，無需停機。熟悉現代和獨特的 PostgreSQL 功能，如 SQL Merge、Returning 和 Exclusion 約束。將 PostgreSQL 內置的高級功能，如全文搜索和發布訂閱機制，應用於 Rails 應用程式。使用先進且可擴展的類型和約束系統改善資料庫中的數據質量，以減少和消除應用程式錯誤。解決如何使用專用索引提高查詢性能等複雜主題。發現如何有效使用內置的資料庫函數並編寫自己的函數，管理複寫，並充分利用分區和外部資料包裝器。使用超過 40 個得到良好支援的開源工具擴展和增強 PostgreSQL 和 Ruby on Rails。通過進行高影響的資料庫維護等高級優化，解決實際的運營挑戰，獲得寶貴的資料庫管理見解。
立即將您的新技能應用於生產環境，並將您的 PostgreSQL 和 Rails 應用程式提升到全新的可靠性和性能水平。
所需條件：
- 運行 macOS、Linux 或 Windows 和 WSL2 的電腦
- 透過套件管理器、編譯或使用 Docker 安裝的 PostgreSQL 版本 16
- 網路連線
