Developing Modern Database Applications with PostgreSQL: Use the highly available and object-relational PostgreSQL to build scalable and reliable apps

Le, Quan Ha, Diaz, Marcelo

  • 出版商: Packt Publishing
  • 出版日期: 2021-08-13
  • 售價: $1,750
  • 貴賓價: 9.5$1,663
  • 語言: 英文
  • 頁數: 440
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1838648143
  • ISBN-13: 9781838648145
  • 相關分類: PostgreSQLJVM 語言SQL資料庫
  • 立即出貨 (庫存=1)

買這商品的人也買了...

商品描述

Get up to speed with core PostgreSQL tasks such as database administration, application development, database performance monitoring, and database testing


Key Features:

  • Build real-world enterprise database management systems using Postgres 12 features
  • Explore the development, administrative and security aspects of PostgreSQL 12
  • Implement best practices from industry experts to build powerful database applications


Book Description:

PostgreSQL is an open-source object-relational database management system (DBMS) that provides enterprise-level services, including high performance and scalability. This book is a collection of unique projects providing you with a wealth of information relating to administering, monitoring, and testing PostgreSQL. The focus of each project is on both the development and the administrative aspects of PostgreSQL.


Starting by exploring development aspects such as database design and its implementation, you'll then cover PostgreSQL administration by understanding PostgreSQL architecture, PostgreSQL performance, and high-availability clusters. Various PostgreSQL projects are explained through current technologies such as DevOps and cloud platforms using programming languages like Python and Node.js. Later, you'll get to grips with the well-known database API tool, PostgREST, before learning how to use popular PostgreSQL database testing frameworks. The book is also packed with essential tips and tricks and common patterns for working seamlessly in a production environment. All the chapters will be explained with the help of a real-world case study on a small banking application for managing ATM locations in a city.


By the end of this DBMS book, you'll be proficient in building reliable database solutions as per your organization's needs.


What You Will Learn:

  • Set up high availability PostgreSQL database clusters in the same containment, a cross-containment, and on the cloud
  • Monitor the performance of a PostgreSQL database
  • Create automated unit tests and implement test-driven development for a PostgreSQL database
  • Develop PostgreSQL apps on cloud platforms using DevOps with Python and Node.js
  • Write robust APIs for PostgreSQL databases using Python programming, Node.js, and PostgREST
  • Create a geospatial database using PostGIS and PostgreSQL
  • Implement automatic configuration by Ansible and Terraform for Postgres


Who this book is for:

This PostgreSQL book is for database developers, database administrators, data architects, or anyone who wants to build end-to-end database projects using Postgres. This book will also appeal to software engineers, IT technicians, computer science researchers, and university students who are interested in database development and administration. Some familiarity with PostgreSQL and Linux is required to grasp the concepts covered in the book effectively.

商品描述(中文翻譯)

快速掌握核心的 PostgreSQL 任務,如資料庫管理、應用程式開發、資料庫效能監控和資料庫測試。

主要特點:
- 使用 Postgres 12 功能建立真實世界的企業級資料庫管理系統
- 探索 PostgreSQL 12 的開發、管理和安全方面
- 實施行業專家的最佳實踐,建立強大的資料庫應用程式

書籍描述:
PostgreSQL 是一個開源的物件關聯式資料庫管理系統(DBMS),提供企業級服務,包括高性能和可擴展性。本書是一個收集了多個獨特專案的集合,為您提供了大量關於 PostgreSQL 管理、監控和測試的資訊。每個專案的重點都放在 PostgreSQL 的開發和管理方面。

從探索資料庫設計和實施等開發方面開始,然後通過了解 PostgreSQL 架構、性能和高可用性集群來覆蓋 PostgreSQL 管理。使用 Python 和 Node.js 等程式語言,通過 DevOps 和雲平台等當前技術來解釋各種 PostgreSQL 專案。之後,您將熟悉著名的資料庫 API 工具 PostgREST,然後學習如何使用流行的 PostgreSQL 資料庫測試框架。本書還充滿了在生產環境中無縫工作的必要技巧、技巧和常見模式。所有章節都將通過一個關於在城市中管理 ATM 位置的小型銀行應用程式的實際案例研究來解釋。

通過閱讀本資料庫管理系統書籍,您將能夠根據組織的需求建立可靠的資料庫解決方案。

學到什麼:
- 在相同容器、跨容器和雲端中建立高可用性的 PostgreSQL 資料庫集群
- 監控 PostgreSQL 資料庫的性能
- 為 PostgreSQL 資料庫創建自動化單元測試,並實施測試驅動開發
- 使用 Python 和 Node.js 在雲平台上開發 PostgreSQL 應用程式,並進行 DevOps
- 使用 Python 編程、Node.js 和 PostgREST 為 PostgreSQL 資料庫創建強大的 API
- 使用 PostGIS 和 PostgreSQL 創建地理空間資料庫
- 使用 Ansible 和 Terraform 為 Postgres 實現自動配置

本書適合資料庫開發人員、資料庫管理員、資料架構師或任何想要使用 Postgres 建立端到端資料庫專案的人。本書還適合軟體工程師、IT 技術人員、計算機科學研究人員和對資料庫開發和管理感興趣的大學生。為了有效理解本書中涵蓋的概念,需要對 PostgreSQL 和 Linux 有一定的熟悉程度。