By Hannu Krosing, Kirk Roybal, Jim Mlodgenski
Extend PostgreSQL and combine the database layer into your improvement framework.
Understand the extension framework of PostgreSQL, and leverage it in ways in which you haven't even invented yet.
• Write capabilities, create your personal facts varieties, all on your favorite programming language;
• step by step instructional with lots of information and tips to kick-start server programming.
Learn easy methods to paintings with PostgreSQL as though you spent the decade engaged on it. PostgreSQL is in a position to supplying you with all the suggestions that you've got on your favorite improvement language after which extending that correct directly to the database server. With this information in hand, it is possible for you to to reply to the present call for for complicated PostgreSQL talents in a profitable and booming market.
PostgreSQL Server Programming will convey you that PostgreSQL is much more than a database server. in reality, it will probably also be obvious as an program improvement framework, with the additional bonuses of transaction aid, large facts garage, journaling, restoration and a bunch of different gains that the PostgreSQL engine provides.
This ebook will take you from studying the elemental components of a PostgreSQL functionality, then writing them in languages except the integrated PL/PgSQL. you can find tips to create libraries of worthwhile code, crew them into much more valuable parts, and distribute them to the neighborhood. one can find tips on how to extract facts from a large number of international information resources, after which expand PostgreSQL to do it natively. and you'll do all of this in a nifty debugging interface that might let you do it successfully and with reliability.
What you are going to research from this book
• Write services within the integrated PL/PgSQL language or your language of choice;
• Extract info from international info sources;
• upload operators, info varieties, and different customized elements;
• Debug and code efficiently;
• come to a decision what computer assets your method will use;
• Create your personal facts forms, operators, capabilities, aggregates, or even your personal language;
• totally combine the database layer into your development.
This sensible consultant leads you thru a variety of elements of operating with PostgreSQL. step-by-step examples let you simply arrange and expand PostgreSQL.
Who this ebook is written for
PostgreSQL Server Programming is for average to complicated PostgreSQL database professionals.
To get the simplest knowing of this booklet, you'll have normal event in writing SQL, a uncomplicated suggestion of question tuning, and a few coding adventure in a language of your selection.