Book Overview & Buying
Table Of Contents

PostgreSQL 11 Server Side Programming Quick Start Guide

By : Ferrari

5 (1)

Buy this Book

PostgreSQL 11 Server Side Programming Quick Start Guide

5 (1)

By: Ferrari

Buy this Book

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.

Preface

Who this book is for

What this book covers

To get the most out of this book

Get in touch

Free Chapter

PostgreSQL Server-side Programming

What is server-side programming?

The example database

Summary

Statement Tricks: UPSERTs, RETURNING, and CTEs

Inserting, updating, or both?

Getting back modified data with RETURNING

Common Table Expressions (CTEs)

Summary

References

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

Stored Procedures

Using functions, procedures, and routines

Functions

Procedures

Summary

References

PL/Perl and PL/Java

PL/Perl

PL/Java

Summary

References

Triggers

Data manipulation triggers

Data definition triggers

Summary

References

Rules and the Query Rewriting System

Introducing the query rewriting system

Rules

Summary

References

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

Inter Process Communication and Background Workers

Inter-Process Communication (IPC)

Background Workers

Summary

References

Custom Data Types

Custom data types

Enumerations

Composite types

Basic types

Summary

References

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