PostgreSQL Server Programming, 2/e（Paperback）

Extend PostgreSQL using PostgreSQL server programming to create, test, debug, and optimize a range of user-defined functions in your favorite programming language

About This Book

• Acquaint yourself with all the options to extend PostgreSQL using the programming language of your choice such as C++ and PL/Python
• Work with PostgreSQL 9.4 so you can immediately take advantage of all the improvements and new features
• Utilize the extensive code examples and many novel tips and tricks for maximum performance gain

Who This Book Is For

This book is for moderate to advanced PostgreSQL database professionals who wish to extend PostgreSQL, utilizing the most updated features of PostgreSQL 9.4. For a better understanding of this book, familiarity with writing SQL, a basic idea of query tuning, and some coding experience in your preferred language is expected.

What You Will Learn

• Write functions in the built-in PL/pgSQL language or your language of choice
• Define and use user-defined functions (UDF)
• Scale your data with PL/Proxy
• Extend PostgreSQL to overcome the limitations of classical SQL servers
• Debug using NOTIFY and using PL/pgSQL debugging extensions
• Discover the new features in PostgreSQL 9.4 such as event triggers and other improvements relevant to server-side programming
• Fully integrate the database layer into your development

In Detail

This book will show you that PostgreSQL is so much more than a database server. In fact, it could even be seen as an application development framework, with the added bonuses of transaction support, massive data storage, journaling, recovery, and a host of other features that the PostgreSQL engine provides.

You will get to grips with creating libraries of useful code, grouping them into even more useful components, and distributing them to the community. Then, you will take a look at user-defined functions, and how to define and utilize them efficiently. You will also learn how to extract data from a multitude of foreign data sources and extend PostgreSQL to do it natively. What's more, you can do all of this in a nifty debugging interface that will allow you to do it efficiently and reliably. This book explores all possible ways to extend PostgreSQL and write server-side code using various programming languages with concrete and easy-to-understand examples.

使用PostgreSQL伺服器編程來擴展PostgreSQL，以創建、測試、調試和優化一系列用戶定義函數，並使用您喜歡的編程語言。

關於本書
- 熟悉使用您選擇的編程語言（如C++和PL/Python）來擴展PostgreSQL的所有選項。
- 使用PostgreSQL 9.4，以便立即利用所有改進和新功能。
- 利用豐富的代碼示例和許多新穎的技巧，以獲得最大的性能提升。

本書適合對PostgreSQL數據庫有一定了解的專業人士，希望利用PostgreSQL 9.4的最新功能來擴展PostgreSQL。為了更好地理解本書，預期讀者具備SQL編寫的經驗、基本的查詢調優概念以及在所選編程語言中的一些編程經驗。

您將學到什麼
- 使用內置的PL/pgSQL語言或您選擇的語言編寫函數。
- 定義和使用用戶定義函數（UDF）。
- 使用PL/Proxy擴展您的數據。
- 擴展PostgreSQL以克服傳統SQL服務器的限制。
- 使用NOTIFY進行調試，並使用PL/pgSQL調試擴展進行調試。
- 探索PostgreSQL 9.4的新功能，如事件觸發器和其他與服務器端編程相關的改進。
- 將數據庫層完全集成到您的開發中。

詳細內容
本書將向您展示，PostgreSQL不僅僅是一個數據庫服務器，實際上，它甚至可以被視為一個應用程序開發框架，具有事務支持、大數據存儲、日誌記錄、恢復以及PostgreSQL引擎提供的一系列其他功能。

您將學習創建有用代碼庫，將其分組為更有用的組件並將其分發給社區。然後，您將研究用戶定義函數以及如何高效地定義和使用它們。您還將學習如何從多個外部數據源提取數據並本地擴展PostgreSQL以實現此功能。更重要的是，您可以在一個方便且可靠的調試界面中進行所有這些操作。本書通過具體且易於理解的示例探索了擴展PostgreSQL和使用各種編程語言編寫服務器端代碼的所有可能方法。