High Performance PostgreSQL for Rails: Reliable, Scalable, Maintainable Database Applications (Paperback)
暫譯: 高效能 PostgreSQL 與 Rails:可靠、可擴展、可維護的資料庫應用程式 (平裝本)

Atkinson, Andrew

  • 出版商: Pragmatic Bookshelf
  • 出版日期: 2024-07-23
  • 售價: $2,610
  • 貴賓價: 9.5$2,480
  • 語言: 英文
  • 頁數: 456
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 9798888650387
  • ISBN-13: 9798888650387
  • 相關分類: PostgreSQLRubyJVM 語言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

商品描述(中文翻譯)

建立更快速、更可靠的 Rails 應用程式,利用最優秀的進階 PostgreSQL 和 Active Record 功能,解決應用程式的擴展和成長挑戰。獲得舒適處理多 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
- 一個互聯網連接