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


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

Wireless Communications: 2007 CNIT Thyrrenian Symposium (Signals and Communication Technology)
Wireless Communications: 2007 CNIT Thyrrenian Symposium (Signals and Communication Technology)
The 18th Tyrrhenian Workshop on digital communications is devoted to wireless communications. In the last decade, wireless communications research boosted launching new standards and proposing new techniques for the access technology. We moved from the UTRA standard capable to transmit 0.5 bit/s/Hz to WLAN which is promising 2.7 bit/s/Hz. Now...
Ethics and Law for School Psychologists
Ethics and Law for School Psychologists
This completely updated edition of the leading ethics and law guide for students, as well as practicing school psychologists, provides authoritative, timely information on professional standards and legal requirements pertinent to the delivery of school psychological services. Ethics and Law for School

Psychologists, Fourth Edition covers a...

CCNA Cisco Certified Network Associate Study Guide, 4th Edition (640-801)
CCNA Cisco Certified Network Associate Study Guide, 4th Edition (640-801)
Here's the book you need to prepare for Cisco's revised CCNA exam, 640-801. This new edition of the best-selling CCNA Study Guide provides:
  • In-depth coverage of every CCNA exam objective
  • Practical information on Cisco internetworking solutions
  • ...

Aperture 3: Portable Genius
Aperture 3: Portable Genius

Compact, fluff-free, full-color guide to getting the most out of Apple’s Aperture digital photography software

This handy Portable Genius guide is designed to help you avoid hassle, save time, and quickly learn what you need to know to use Apple’s Aperture digital photography software effectively—and have...

Building a Web Site For Dummies (Computer/Tech)
Building a Web Site For Dummies (Computer/Tech)
Whether you’re in the preliminary stages of planning a site or you’re looking to improve the look of an existing site, this reference book covers it all. Now updated with the latest site tools, design techniques, and commerce options, this new edition of the bestseller offers a solid framework for building a Web site from scratch....
Practical Scala DSLs: Real-World Applications Using Domain Specific Languages
Practical Scala DSLs: Real-World Applications Using Domain Specific Languages
Build domain specific languages (DSLs) using Java's most popular functional programming language: Scala. This book introduces the basics of Scala and DSLs using a series of practical examples. In Practical Scala DSLs, you’ll learn to create pragmatic and complete code examples that explain the actual use of...
©2021 LearnIT (support@pdfchm.net) - Privacy Policy