PostgreSQL Server Programming - Second Edition

PostgreSQL Server Programming - Second Edition

<p><b>Extend PostgreSQL using PostgreSQL server programming to create, test, debug, and optimize a range of user-defined functions in your favorite programming language</b></p> <h2>About This Book</h2><ul><li>Acquaint yourself with all the options to extend PostgreSQL using the programming language of your choice such as C++ and PL/Python</li><li>Work with PostgreSQL 9.4 so you can immediately take advantage of all the improvements and new features</li><li>Utilize the extensive code examples and many novel tips and tricks for maximum performance gain</li></ul><h2>Who This Book Is For</h2><p>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.</p><h2>What You Will Learn</h2><ul> <li>Write functions in the built-in PL/pgSQL language or your language of choice</li> <li>Define and use user-defined functions (UDF)</li> <li>Scale your data with PL/Proxy</li> <li>Extend PostgreSQL to overcome the limitations of classical SQL servers</li> <li>Debug using NOTIFY and using PL/pgSQL debugging extensions</li> <li>Discover the new features in PostgreSQL 9.4 such as event triggers and other improvements relevant to server-side programming</li> <li>Fully integrate the database layer into your development</li> </ul><h2>In Detail</h2><p>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.</p><p>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.</p>