PostgreSQL 11 Server Side Programming Quick Start Guide: Effective database programming and interaction

Luca Ferrari

  • 出版商: Packt Publishing
  • 出版日期: 2018-11-29
  • 售價: $1,680
  • 貴賓價: 9.5$1,596
  • 語言: 英文
  • 頁數: 260
  • 裝訂: Paperback
  • ISBN: 1789342228
  • ISBN-13: 9781789342222
  • 相關分類: PostgreSQLSQL資料庫
  • 下單後立即進貨 (約3~4週)

商品描述

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

Key Features

  • Learn the concepts of PostgreSQL 11 with lots of real-world datasets and examples
  • Learn queries, data replication, and database performance
  • Extend the functionalities of your PostgreSQL instance to suit your organizational needs

Book Description

PostgreSQL is a rock-solid, scalable, and safe enterprise-level relational database. With a broad range of features and stability, it is ever increasing in popularity.This book shows you how to take advantage of PostgreSQL 11 features for server-side programming. Server-side programming enables strong data encapsulation and coherence.

The book begins with the importance of server-side programming and explains the risks of leaving all the checks outside the database. To build your capabilities further, you will learn how to write stored procedures, both functions and the new PostgreSQL 11 procedures, and create triggers to perform encapsulation and maintain data consistency.

You will also learn how to produce extensions, the easiest way to package your programs for easy and solid deployment on different PostgreSQL installations.

What you will learn

  • Explore data encapsulation
  • Write stored procedures in different languages
  • Interact with transactions from within a function
  • Get to grips with triggers and rules
  • Create and manage custom data types
  • Create extensions to package code and data
  • Implement background workers and Inter-Process Communication (IPC)
  • How to deal with foreign languages, in particular Java and Perl

Who this book is for

This book is for database administrators, data engineers, and database engineers who want to implement advanced functionalities and master complex administrative tasks with PostgreSQL 11.

Table of Contents

  1. PostgreSQL Server-side Programming
  2. Statement Tricks: UPSERTs, RETURNING, and CTEs
  3. The PL/pgSQL Language
  4. Stored Procedures
  5. PL/Perl and PL/Java
  6. Triggers
  7. Rules and the Query Rewriting System
  8. Extensions
  9. Inter Process Communications and Background Workers
  10. Custom Data Types

商品描述(中文翻譯)

使用PostgreSQL伺服器編程來擴展PostgreSQL,以在您喜歡的編程語言中創建、測試、調試和優化各種自定義函數。

主要特點:
- 通過大量的真實世界數據集和示例學習PostgreSQL 11的概念
- 學習查詢、數據複製和數據庫性能
- 擴展您的PostgreSQL實例的功能以滿足組織需求

書籍描述:
PostgreSQL是一個堅固、可擴展和安全的企業級關聯數據庫。憑藉其廣泛的功能和穩定性,它在人氣上不斷增加。本書將向您展示如何利用PostgreSQL 11的功能進行伺服器端編程。伺服器端編程可以實現強大的數據封裝和一致性。

本書首先介紹了伺服器端編程的重要性,並解釋了將所有檢查工作留在數據庫外的風險。為了進一步提升您的能力,您將學習如何編寫存儲過程,包括函數和新的PostgreSQL 11存儲過程,並創建觸發器以實現封裝和維護數據一致性。

您還將學習如何生成擴展,這是在不同的PostgreSQL安裝上輕鬆且穩定地部署程序的最簡單方法。

您將學到的內容:
- 探索數據封裝
- 用不同的語言編寫存儲過程
- 從函數內部與事務交互
- 熟悉觸發器和規則
- 創建和管理自定義數據類型
- 創建擴展以打包代碼和數據
- 實現後台工作程序和進程間通信(IPC)
- 如何處理外國語言,特別是Java和Perl

本書適合對象:
本書適合數據庫管理員、數據工程師和數據庫工程師,他們希望實現高級功能並掌握PostgreSQL 11的複雜管理任務。

目錄:
1. PostgreSQL伺服器端編程
2. 語句技巧:UPSERT、RETURNING和CTE
3. PL/pgSQL語言
4. 存儲過程
5. PL/Perl和PL/Java
6. 觸發器
7. 規則和查詢重寫系統
8. 擴展
9. 進程間通信和後台工作程序
10. 自定義數據類型