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

PL/Perl and PL/Java

In Chapter 4, Stored Procedures, we saw how to implement functions and procedures using the PL/pgSQL language. PostgreSQL allows developers to implement their executable code in pretty much any language they want. In order to demonstrate this, this chapter will show you how to implement code using Perl 5 and Java.

In particular, this chapter will focus on:

  • PL/Perl and PL/Java as possible implementation languages
  • The re-implementation of some of the code discussed in Chapter 4, Stored Procedures, using both of the above languages
  • The differences between using a scripting language and a compiled language in server-side programming and deployment
Previous Section
End of Section 1
Next Section