Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
PostgreSQL Server Programming - Second Edition

Buy

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.)

Just Enough CRM
Just Enough CRM

The decision-maker's guide to competitive advantage with CRM

  • Getting real benefits from CRM--fast

  • A complete roadmap for auditing and

  • improving your current CRM processes

  • ...
Design for Kids: Digital Products for Playing and Learning
Design for Kids: Digital Products for Playing and Learning

Emotion. Ego. Impatience. Stubbornness. Characteristics like these make creating sites and apps for kids a daunting proposition. However, with a bit of knowledge, you can design experiences that help children think, play, and learn. With Design for Kids, you'll learn how to create digital products for today's connected...

HP ProLiant Servers AIS : Official Study Guide and Desk Reference
HP ProLiant Servers AIS : Official Study Guide and Desk Reference

The all-in-one HP ProLiant best-practice reference and HP Certified Professional AIS prep guide

Covers hardware, operating systems, storage, and much more

Authored by members of the HP ProLiant AIS and ASE...


VB.NET: A Laboratory Course
VB.NET: A Laboratory Course
VB.NET: A Laboratory Course teaches the reader how to program in Visual Basic from an object-oriented viewpoint, which is important becuase of the object-oriented flavor of VB.NET. The emphasis of this book is not on the fancy users interface tricks you can perform with VB.NET, but on the fundamentals of writing correct and efficient VB programs....
Elements of Modern Algebra
Elements of Modern Algebra

ELEMENTS OF MODERN ALGEBRA 7e, with its user-friendly format, provides you with the tools you need to get succeed in abstract algebra and develop mathematical maturity as a bridge to higher-level mathematics courses.. Strategy boxes give you guidance and explanations about techniques and enable you to become more proficient at constructing...

Nanoparticles: From Theory to Application
Nanoparticles: From Theory to Application

An introduction to the science of nanoparticles, from fundamental principles to their use in novel applications.
As a basis for understanding nanoparticle behavior, the book first outlines the principles of quantum size behavior, nanoparticles architecture, formation of semiconductor and metal nonoparticles. It then
...

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