Key Features
Book Description
This book is for moderate to advanced PostgreSQL database professionals who wish to extend PostgreSQL, utilizing the most updated features of PostgreSQL 9.4. For a better understanding of this book, familiarity with writing SQL, a basic idea of query tuning, and some coding experience in your preferred language is expected.What you will learn
- Write functions in the builtin PL/pgSQL language or your language of choice
- Define and use userdefined functions (UDF)
- Scale your data with PL/Proxy
- Extend PostgreSQL to overcome the limitations of classical SQL servers
- Debug using NOTIFY and using PL/pgSQL debugging extensions
- Discover the new features in PostgreSQL 9.4 such as event triggers and other improvements relevant to serverside programming
- Fully integrate the database layer into your development
Who this book is for
This book is for moderate to advanced PostgreSQL database professionals who wish to extend PostgreSQL, utilizing the most updated features of PostgreSQL 9.4. For a better understanding of this book, familiarity with writing SQL, a basic idea of query tuning, and some coding experience in your preferred language is expected.
Table of Contents
- Why 'program in the server'?
- Introduction to PostgreSQL server programming fundamentals
- Writing Your First PL/PgSQL Function
- Advanced PL/PgSQL - Creating Set Returning and Table Functions, Using Cursors
- Defining and Using PL/PgSQL TRIGGER functions
- Writing PostgreSQL Event Trigger Functions
- Debugging PL/PgSQL
- Using unrestricted language - PL/pythonu
- Writing Z Functions in C
- Scaling Your Database with pl/proxy
- PL/Perl - Perl Procedural Language
- PL/Tcl - Tcl Procedural Language
- Publishing Your Code as Extensions
- Learning More About PostgreSQL as Extensible RDBMS
Loading...
Loading...
