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

PostgreSQL Server Programming, 9781849516983 (1849516987), Packt Publishing, 2013

Take your skills with PostgreSQL to a whole new level with this fascinating guide to server programming. A step by step approach with illuminating examples will educate you in the full range of possibilities.

Understand the extension framework of PostgreSQL, and leverage it in ways that you haven't even invented yet.

  • Write functions, create your own data types, all in your favourite programming language
  • Step-by-step tutorial with plenty of tips and tricks to kick-start server programming.

In Detail

Learn how to work with PostgreSQL as if you spent the last decade working on it. PostgreSQL is capable of providing you with all of the options that you have in your favourite development language and then extending that right on to the database server. With this knowledge in hand, you will be able to respond to the current demand for advanced PostgreSQL skills in a lucrative and booming market.

"PostgreSQL Server Programming" 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.

This book will take you from learning the basic parts of a PostgreSQL function, then writing them in languages other than the built-in PL/PgSQL. You will see how to create libraries of useful code, group them into even more useful components, and distribute them to the community. You will see how to extract data from a multitude of foreign data sources, and then extend PostgreSQL to do it natively. And you can do all of this in a nifty debugging interface that will allow you to do it efficiently and with reliability.

What you will learn from this book

  • Write functions in the built-in PL/PgSQL language or your language of choice
  • Extract data from foreign data sources
  • Add operators, data types, and other custom elements
  • Debug and code efficiently
  • Decide what machine resources your process will use
  • Create your own data types, operators, functions, aggregates, and even your own language
  • Fully integrate the database layer into your development


This practical guide leads you through numerous aspects of working with PostgreSQL. Step by step examples allow you to easily set up and extend PostgreSQL.

Who this book is written for

"PostgreSQL Server Programming" is for moderate to advanced PostgreSQL database professionals. To get the best understanding of this book, you should have general experience in writing SQL, a basic idea of query tuning, and some coding experience in a language of your choice

(HTML tags aren't allowed.)

The Jini(TM) Specifications, Edited by Ken Arnold (2nd Edition)
The Jini(TM) Specifications, Edited by Ken Arnold (2nd Edition)
Built on top of the Java™ software infrastructure, Jini™ technology enables all types of services and devices to work together in a community--organized without extensive planning, installation, or human intervention. Jini technology allows the lines to blur between what is hardware and what is software by representing all hardware and...
Modelling of GPCRs: A Practical Handbook
Modelling of GPCRs: A Practical Handbook

G protein coupled receptors (GPCRs) comprise an important protein family, which is involved in signal transduction in the cell. Besides that a large number of drugs, available on market, address GPCRs. For an efficient and improved development of appropriate drugs, molecular modelling of GPCRs is – in order to understand the...

Raavan: Enemy of Aryavarta (Ram Chandra)
Raavan: Enemy of Aryavarta (Ram Chandra)



INDIA, 3400 BCE.

A land in tumult, poverty and chaos. Most people suffer quietly. A few rebel. Some fight for a better world. Some for themselves. Some don’t give a damn. Raavan. Fathered by one of the...

Intellectual Property in Academia: A Practical Guide for Scientists and Engineers
Intellectual Property in Academia: A Practical Guide for Scientists and Engineers

Given the increasing role of intellectual property (IP) in academic research, it is important for academic scientists to gain greater awareness and knowledge of the various issues involved with IP resulting from their research and inventions. In addition, the line between academic and industrial research has been blurred, and a large amount...

Ubiquitous Computing
Ubiquitous Computing

Near Field Communication (NFC) technology has become increasingly important for ubiquitous computing. Florian Resatsch investigates the optimal strategies for developing and evaluating ubiquitous computing applications based on NFC. He draws on a variety of current theories on ubiquitous computing, human-computer interaction, and technology...

Writing Secure Code for Windows Vista (Pro - Step By Step Developer)
Writing Secure Code for Windows Vista (Pro - Step By Step Developer)

Get the definitive guide to writing secure code and developing more-secure applications for Windows Vista--straight from the experts. Security is one of the greatest enhancements in Windows Vista, and developers will be urged to write more secure code on the platform to support a growing customer base. This reference delivers the straight scoop...

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