Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
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

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

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

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.

(HTML tags aren't allowed.)

The Structural Representation of Proximity Matrices With Matlab (ASA-SIAM Series on Statistics and Applied Probability)
The Structural Representation of Proximity Matrices With Matlab (ASA-SIAM Series on Statistics and Applied Probability)

The Structural Representation of Proximity Matrices with MATLAB presents and demonstrates the use of functions within a MATLAB computational environment, affecting various structural representations for the proximity information that is assumed to be available on a set of objects. The representations included in the book have been developed...

Introducing 3ds Max 2008
Introducing 3ds Max 2008
Introducing 3ds Max 2008 breaks down the complexities of 3D modeling, texturing, animating, and visual effects. You'll jump right into the 3ds Max pipeline—from preproduction through postproduction—with clear-cut explanations, tutorials, and hands-on projects to build your skills. A special color insert includes real-world...
Introducing Ubuntu: Desktop Linux
Introducing Ubuntu: Desktop Linux
Completely free and highly robust, Ubuntu has the power to bring the Linux desktop to the masses. Introducing Ubuntu: Desktop Linux is your key to learning this new, userfriendly, and free alternative to Windows. Think of it as a personal tutorial, a one-on-one class with an expert user of Ubuntu. It begins by helping you choose the right Ubuntu...

Mac OS X Power User's Guide (Mac/Graphics)
Mac OS X Power User's Guide (Mac/Graphics)
So what is the big deal about a new operating system from Apple?

Just those very words: new, operating, system, and Apple are enough to get the blood of every Mac geek on the planet boiling with anticipation. But why should the rest of us care?

Having specialized in the Linux operating system for
Mastering Social Media Mining with R
Mastering Social Media Mining with R

Extract valuable data from your social media sites and make better business decisions using R

About This Book

  • Explore the social media APIs in R to capture data and tame it
  • Employ the machine learning capabilities of R to gain optimal business value
  • A hands-on guide with...
The Case for Virtual Business Processes : Reduce Costs, Improve Efficiencies, and Focus on Your Core Business
The Case for Virtual Business Processes : Reduce Costs, Improve Efficiencies, and Focus on Your Core Business

The dot-com collapse generally discredited the idea of leveraging the Internet to build viable businesses. Many market pundits have decried the concept without examining the underlying dynamics associated with these companies' failures. The truth is, prior business models were built on a flawed business case, not bad technology....

©2018 LearnIT (support@pdfchm.net) - Privacy Policy