PostgreSQL Server Programming (epub)

$13.00

Author Usama Dar, Hannu Krosing, Jim Mlodgenski, Kirk Roybal
Edition 2
Edition Year 2015
Format epub
ISBN 9781783980581
Language English
Number Of Pages 320
Publisher Packt Publishing

Description

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.

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

    About This Book

    • Acquaint yourself with all the options to extend PostgreSQL using the programming language of your choice such as C++ and PL/Python
    • Work with PostgreSQL 9.4 so you can immediately take advantage of all the improvements and new features
    • Utilize the extensive code examples and many novel tips and tricks for maximum performance gain

      In Detail

      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.

Additional information

Author

Usama Dar, Hannu Krosing, Jim Mlodgenski, Kirk Roybal

Edition

2

Edition Year

2015

Format

epub

ISBN

9781783980581

Language

English

Number Of Pages

320

Publisher

Packt Publishing

Reviews

There are no reviews yet.

Be the first to review “PostgreSQL Server Programming (epub)”

Your email address will not be published. Required fields are marked *