PostgreSQL Development Essentials

Manpreet Kaur, Baji Shaik

  • 出版商: Packt Publishing
  • 出版日期: 2016-09-27
  • 售價: $1,770
  • 貴賓價: 9.5$1,682
  • 語言: 英文
  • 頁數: 210
  • 裝訂: Paperback
  • ISBN: 1783989009
  • ISBN-13: 9781783989003
  • 相關分類: PostgreSQLSQL
  • 海外代購書籍(需單獨結帳)

商品描述

Develop programmatic functions to create powerful database applications

About This Book

  • Write complex SQL queries and design a robust database design that fits your application's need
  • Improve database performance by indexing, partitioning tables, and query optimizing
  • A comprehensive guide covering the advanced PostgreSQL concepts without any hassle

Who This Book Is For

If you are a PostgreSQL developer with a basic knowledge of PostgreSQL development and you're want deeper knowledge to develop applications, then this book is for you. As this book does not cover basic installation and configurations, you should have PostgreSQL installed on your machine as a prerequisite.

What You Will Learn

  • Write more complex queries with advanced SQL queries
  • Design a database that works with the application exactly the way you want
  • Make the database work in extreme conditions by tuning, optimizing, partitioning, and indexing
  • Develop applications in other programming languages such as Java and PHP
  • Use extensions to get extra benefits in terms of functionality and performance
  • Build an application that does not get locked by data manipulation
  • Explore in-built db functions and data type conversions

In Detail

PostgreSQL is the most advanced open source database in the world. It is easy to install, configure, and maintain by following the documentation; however, it's difficult to develop applications using programming languages and design databases accordingly. This book is what you need to get the most out of PostgreSQL

You will begin with advanced SQL topics such as views, materialized views, and cursors, and learn about performing data type conversions. You will then perform trigger operations and use trigger functions in PostgreSQL. Next we walk through data modeling, normalization concepts, and the effect of transactions and locking on the database.

The next half of the book covers the types of indexes, constrains, and the concepts of table partitioning, as well as the different mechanisms and approaches available to write efficient queries or code. Later, we explore PostgreSQL Extensions and Large Object Support in PostgreSQL. Finally, you will perform database operations in PostgreSQL using PHP and Java. By the end of this book, you will have mastered all the aspects of PostgreSQL development. You will be able to build efficient enterprise-grade applications with PostgreSQL by making use of these concepts

Style and approach

Every chapter follows a step by step approach that first explains the concept , then shows you how to execute it practically so that you can implement them in your application.

商品描述(中文翻譯)

開發程式功能以創建強大的資料庫應用程式

關於本書

- 撰寫複雜的 SQL 查詢並設計符合應用程式需求的強大資料庫設計
- 通過索引、分區表和查詢優化來提升資料庫性能
- 全面指南,輕鬆理解高級 PostgreSQL 概念

本書適合對 PostgreSQL 開發有基本知識並希望深入了解開發應用程式的 PostgreSQL 開發人員。由於本書不涵蓋基本安裝和配置,因此您應該在開始閱讀之前在您的機器上安裝了 PostgreSQL。

您將學到什麼

- 使用高級 SQL 查詢撰寫更複雜的查詢
- 設計與應用程式完全符合需求的資料庫
- 通過調整、優化、分區和索引使資料庫在極端條件下運作
- 使用其他編程語言(如 Java 和 PHP)開發應用程式
- 使用擴展功能獲得額外的功能和性能優勢
- 構建不會被數據操作鎖定的應用程式
- 探索內置的資料庫函數和數據類型轉換

詳細內容

PostgreSQL 是世界上最先進的開源資料庫。按照文檔的指引,安裝、配置和維護都很容易;然而,使用編程語言開發應用程式並相應地設計資料庫則較為困難。本書將幫助您充分利用 PostgreSQL。

您將從高級 SQL 主題(如視圖、物化視圖和游標)開始,並學習執行數據類型轉換。然後,您將執行觸發器操作並在 PostgreSQL 中使用觸發器函數。接下來,我們將介紹數據建模、規範化概念以及事務和鎖對資料庫的影響。

本書的後半部分涵蓋了索引類型、約束和表分區的概念,以及撰寫高效查詢或代碼的不同機制和方法。之後,我們將探索 PostgreSQL 擴展和 PostgreSQL 中的大型對象支援。最後,您將使用 PHP 和 Java 在 PostgreSQL 中執行資料庫操作。通過閱讀本書,您將掌握 PostgreSQL 開發的所有方面,並能夠利用這些概念構建高效的企業級應用程式。

風格和方法

每個章節都遵循逐步的方法,首先解釋概念,然後展示如何實際執行,以便您可以在應用程式中實施這些概念。