PostgreSQL Server Programming - Second Edition Book PDF, ePub eBook

Join our eBook service for unlimited books & audiobooks. Get a free 7 day subscription! ↓↓↓↓↓


Book Descriptions:
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.

PostgreSQL Server Programming - Second Edition by Usama Dar, Hannu Krosing, Jim Mlodgenski, Kirk Roybal

From reader reviews:

Thad Whitehead:

Inside other case, little folks like to read book PostgreSQL Server Programming - Second Edition. You can choose the best book if you'd prefer reading a book. Given that we know about how is important the book PostgreSQL Server Programming - Second Edition. You can add knowledge and of course you can around the world with a book. Absolutely right, because from book you can understand everything! From your country right up until foreign or abroad you will be known. About simple issue until wonderful thing it is possible to know that. In this era, we can easily open a book as well as searching by internet device. It is called e-book. You should use it when you feel fed up to go to the library. Let's read.

Carla Spiegel:

What do you ponder on book? It is just for students as they are still students or the idea for all people in the world, what the best subject for that? Just simply you can be answered for that problem above. Every person has several personality and hobby for every other. Don't to be obligated someone or something that they don't desire do that. You must know how great and also important the book PostgreSQL Server Programming - Second Edition. All type of book can you see on many options. You can look for the internet methods or other social media.

James Fong:

A lot of people always spent their free time to vacation or go to the outside with them household or their friend. Do you realize? Many a lot of people spent many people free time just watching TV, or perhaps playing video games all day long. If you would like try to find a new activity that's look different you can read some sort of book. It is really fun for you. If you enjoy the book you read you can spent the entire day to reading a publication. The book PostgreSQL Server Programming - Second Edition it is extremely good to read. There are a lot of folks that recommended this book. These folks were enjoying reading this book. Should you did not have enough space to develop this book you can buy the e-book. You can m0ore easily to read this book from your smart phone. The price is not very costly but this book features high quality.

Peggy Dunn:

As we know that book is very important thing to add our expertise for everything. By a guide we can know everything we would like. A book is a list of written, printed, illustrated or perhaps blank sheet. Every year has been exactly added. This reserve PostgreSQL Server Programming - Second Edition was filled concerning science. Spend your extra time to add your knowledge about your science competence. Some people has several feel when they reading a book. If you know how big selling point of a book, you can feel enjoy to read a reserve. In the modern era like right now, many ways to get book which you wanted.