PostgreSQL: Up and Running: A Practical Guide to the Advanced Open Source Database, 3/e (Paperback)

Regina O. Obe, Leo S. Hsu

  • 出版商: O'Reilly
  • 出版日期: 2017-11-28
  • 定價: $1,550
  • 售價: 9.0$1,395
  • 語言: 英文
  • 頁數: 314
  • 裝訂: Paperback
  • ISBN: 1491963417
  • ISBN-13: 9781491963418
  • 相關分類: PostgreSQLSQL資料庫
  • 立即出貨 (庫存=1)

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

商品描述

Thinking of migrating to PostgreSQL? This clear, fast-paced introduction helps you understand and use this open source database system. Not only will you learn about the enterprise class features in versions 9.5 to 10, you’ll also discover that PostgeSQL is more than a database system—it’s an impressive application platform as well.

With examples throughout, this book shows you how to achieve tasks that are difficult or impossible in other databases. This third edition covers new features, such as ANSI-SQL constructs found only in proprietary databases until now: foreign data wrapper (FDW) enhancements; new full text functions and operator syntax introduced in version 9.6; XML constructs new in version 10; query parallelization features introduced in 9.6 and enhanced in 10; built-in logical replication introduced in Version 10.e.

If you’re a current PostgreSQL user, you’ll pick up gems you may have missed before.

  • Learn basic administration tasks such as role management, database creation, backup, and restore
  • Apply the psql command-line utility and the pgAdmin graphical administration tool
  • Explore PostgreSQL tables, constraints, and indexes
  • Learn powerful SQL constructs not generally found in other databases
  • Use several different languages to write database functions
  • Tune your queries to run as fast as your hardware will allow
  • Query external and variegated data sources with foreign data wrappers
  • Learn how to use built-in replication to replicate data

商品描述(中文翻譯)

考慮遷移到PostgreSQL嗎?這本清晰而節奏快的介紹將幫助您了解和使用這個開源數據庫系統。您不僅將學習有關9.5到10版本的企業級功能,還將發現PostgreSQL不僅僅是一個數據庫系統,還是一個令人印象深刻的應用平台。

本書通過示例向您展示如何完成在其他數據庫中難以或不可能完成的任務。本書的第三版涵蓋了新功能,例如直到現在只有專有數據庫中才能找到的ANSI-SQL構造:外部數據封裝器(FDW)增強功能;在9.6版本中引入的新的全文本函數和運算符語法;在10版本中新增的XML構造;在9.6版本中引入並在10版本中進一步增強的查詢並行化功能;以及在10版本中引入的內建邏輯複製功能。

如果您是當前的PostgreSQL用戶,您將學到之前可能錯過的寶藏。

- 學習基本管理任務,如角色管理、數據庫創建、備份和還原
- 使用psql命令行工具和pgAdmin圖形管理工具
- 探索PostgreSQL表、約束和索引
- 學習在其他數據庫中通常找不到的強大SQL構造
- 使用多種不同的語言編寫數據庫函數
- 調整查詢以在硬件允許的情況下運行得更快
- 使用外部數據封裝器查詢外部和多樣化的數據源
- 學習如何使用內建複製功能複製數據