Book Image

PostgreSQL 11 Server Side Programming Quick Start Guide

By : Luca Ferrari
Book Image

PostgreSQL 11 Server Side Programming Quick Start Guide

By: Luca Ferrari

Overview of this book

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.

Related Content you might be interested in

Current Title:

Small book image
PostgreSQL 11 Server Side Programming Quick Start Guide
Luca Ferrari
Nov, 2018 | 260 pages
Small book image
Learn PostgreSQL
Luca Ferrari | Enrico Pirozzi
Oct, 2020 | 650 pages
Small book image
Learn PostgreSQL
Luca Ferrari | Enrico Pirozzi
Oct, 2023 | 744 pages
Small book image
Learning PostgreSQL 11
Salahaldin Juba | Andrey Volkov
Jan, 2019 | 556 pages
Table of Contents (12 chapters)
Preface
Preface
Who this book is for
What this book covers
To get the most out of this book
Get in touch
Free Chapter
1
PostgreSQL Server-side Programming
PostgreSQL Server-side Programming
What is server-side programming?
The example database
Summary
2
Statement Tricks: UPSERTs, RETURNING, and CTEs
Statement Tricks: UPSERTs, RETURNING, and CTEs
Inserting, updating, or both?
Getting back modified data with RETURNING
Common Table Expressions (CTEs)
Summary
References
3
The PL/pgSQL Language
The PL/pgSQL Language
An introduction to PL/pgSQL
Variables and variable assignment
Conditionals
Iterations
Exceptions and error handling
Executing dynamic statements
Throwing away a query result set
The FOUND Global Variable
Summary
References
4
Stored Procedures
Stored Procedures
Using functions, procedures, and routines
Functions
Procedures
Summary
References
5
PL/Perl and PL/Java
PL/Perl and PL/Java
PL/Perl
PL/Java
Summary
References
6
Triggers
Triggers
Data manipulation triggers
Data definition triggers
Summary
References
7
Rules and the Query Rewriting System
Rules and the Query Rewriting System
Introducing the query rewriting system
Rules
Summary
References
8
Extensions
Extensions
Extensions
Extension management
Creating your own extension
Extension data and backups
Adding an object to an existing extension
The PostgreSQL Extension Network (PGXN)
Summary
References
9
Inter Process Communication and Background Workers
Inter Process Communication and Background Workers
Inter-Process Communication (IPC)
Background Workers
Summary
References
10
Custom Data Types
Custom Data Types
Custom data types
Enumerations
Composite types
Basic types
Summary
References
11
Other Books You May Enjoy
Other Books You May Enjoy
Leave a review - let other readers know what you think

Leave a review - let other readers know what you think

Please share your thoughts on this book with others by leaving a review on the site that you bought it from. If you purchased the book from Amazon, please leave us an honest review on this book's Amazon page. This is vital so that other potential readers can see and use your unbiased opinion to make purchasing decisions, we can understand what our customers think about our products, and our authors can see your feedback on the title that they have worked with Packt to create. It will only take a few minutes of your time, but is valuable to other potential customers, our authors, and Packt. Thank you!

Previous Section
End of Chapter 11
Next Chapter