PostgreSQL Server Programming - Second Edition

Extend PostgreSQL using PostgreSQL server programming to create, test, debug, and optimize a range of user-defined functions in your favorite programming language

PostgreSQL Server Programming - Second Edition

Usama Dar et al.

1 customer reviews
Extend PostgreSQL using PostgreSQL server programming to create, test, debug, and optimize a range of user-defined functions in your favorite programming language
Packt Subscription
FREE
$9.99/m after trial
eBook
$21.00
RRP $29.99
Save 29%
Print + eBook
$49.99
RRP $49.99
What do I get with a Packt subscription?
  • Exclusive monthly discount - no contract
  • Unlimited access to entire Packt library of 6500+ eBooks and Videos
  • 120 new titles added every month, on new and emerging tech
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
$0.00
$21.00
$49.99
$0 p/m after trial
RRP $29.99
RRP $49.99
Subscription
eBook
Print + eBook
Start 10 Day Trial

Frequently bought together


PostgreSQL Server Programming - Second Edition Book Cover
PostgreSQL Server Programming - Second Edition
$ 29.99
$ 21.00
PostgreSQL Administration Cookbook, 9.5/9.6 Edition Book Cover
PostgreSQL Administration Cookbook, 9.5/9.6 Edition
$ 47.99
$ 33.60
Buy 2 for $35.00
Save $42.98
Add to Cart

Book Details

ISBN 139781783980581
Paperback320 pages

Book Description

This book will show you that PostgreSQL is so much more than a database server. In fact, it could even be seen as an application development framework, with the added bonuses of transaction support, massive data storage, journaling, recovery, and a host of other features that the PostgreSQL engine provides.

You will get to grips with creating libraries of useful code, grouping them into even more useful components, and distributing them to the community. Then, you will take a look at user-defined functions, and how to define and utilize them efficiently. You will also learn how to extract data from a multitude of foreign data sources and extend PostgreSQL to do it natively. What's more, you can do all of this in a nifty debugging interface that will allow you to do it efficiently and reliably. This book explores all possible ways to extend PostgreSQL and write server-side code using various programming languages with concrete and easy-to-understand examples.

Table of Contents

What You Will Learn

  • Write functions in the built-in PL/pgSQL language or your language of choice
  • Define and use user-defined 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 server-side programming
  • Fully integrate the database layer into your development

Authors

Table of Contents

Book Details

ISBN 139781783980581
Paperback320 pages
Read More
From 1 reviews

Read More Reviews

Recommended for You

PostgreSQL Administration Cookbook, 9.5/9.6 Edition Book Cover
PostgreSQL Administration Cookbook, 9.5/9.6 Edition
$ 47.99
$ 33.60
PostgreSQL High Availability Cookbook - Second Edition Book Cover
PostgreSQL High Availability Cookbook - Second Edition
$ 43.99
$ 30.80
Learning PostgreSQL 10 - Second Edition Book Cover
Learning PostgreSQL 10 - Second Edition
$ 27.99
$ 19.60
PostgreSQL 9.6 High Performance Book Cover
PostgreSQL 9.6 High Performance
$ 39.99
$ 28.00
PostgreSQL High Performance Cookbook Book Cover
PostgreSQL High Performance Cookbook
$ 43.99
$ 30.80
PostgreSQL Development Essentials Book Cover
PostgreSQL Development Essentials
$ 31.99
$ 22.40