2ndQuadrant | PostgreSQL
PostgreSQL Solutions for the Enterprise
+39 0574 159 3000
  • Kontakt
  • DE
    • EN
    • FR
    • IT
    • ES
  • Support & Dienstleistungen
    • Support
      • 24/7 PostgreSQL Support
      • IBM Z Production Support
        • Performance Analysis
      • Developer Support
    • DBA Services
      • Remote DBA for PostgreSQL
      • PostgreSQL Database Monitoring Sevices
    • Consulting Services
      • PostgreSQL Health Check
      • PostgreSQL-Tuning
      • PostgreSQL Database Security Audit
      • Upgrade PostgreSQL
    • Migration Services
      • PostgreSQL Migration Assessment
      • Migrate from Oracle to PostgreSQL
  • Products
    • PostgreSQL with High Availability
    • BDR
      • IoT Solution
      • Deployment Options
    • 2ndQPostgres
    • pglogical
      • Installation instruction for pglogical
      • Documentation
    • repmgr
      • Installation Instruction for repmgr
    • Barman
    • Postgres Cloud Manager
    • SQL Firewall
    • Postgres-XL
    • OmniDB
    • Postgres Installer
    • 2UDA
  • Downloads
    • Postgres Installer
    • 2UDA
  • Postgres Learning Center
    • Webinars
      • You forgot to put the WHERE in DELETE?
    • Whitepapers
      • Highly Available Postgres Clusters
      • AlwaysOn Postgres
      • Postgres-BDR
      • PostgreSQL Security Best Practices
    • Case Studies
      • Performance Tuning
        • BenchPrep
        • tastyworks
      • Distributed Clusters
        • ClickUp
        • Telefónica del Sur
        • Animal Logic
      • Database Administration
        • Agilis Systems
      • Professional Training
        • Met Office
        • London & Partners
      • Database Upgrades
        • Alfred Wegener Institute (AWI)
      • Database Migration
        • Healthcare Software Solutions (HSS)
        • Navionics
    • Training
      • Training Catalog and Scheduled Courses
        • Advanced Development & Performance
    • Books
      • PostgreSQL 11 Administration Cookbook
      • PostgreSQL 10 Administration Cookbook
      • PostgreSQL High Availability Cookbook – Second Edition
      • PostgreSQL 9 Administration Cookbook – 3rd Edition
      • PostgreSQL Server Programming Cookbook – 2nd Edition
      • PostgreSQL 9 Cookbook : Chinese Edition
    • PostgreSQL
      • PostgreSQL – History
      • Wer nutzt PostgreSQL
      • PostgreSQL FAQ
      • PostgreSQL vs MySQL
      • geschäftsrelevante PostgreSQL-Fallstudien
      • Security Information
    • Events
    • Blog
  • Über uns
    • Impressum
    • What Does „2ndQuadrant“ Mean?
    • 2ndQuadrant’s Passion for PostgreSQL
    • Ask Simon
    • News
    • Careers
    • unser-team
  • Blog
  • Menü
Du bist hier: Startseite / Books / PostgreSQL Server Programming Cookbook – 2nd Edition

PostgreSQL Server Programming Cookbook – 2nd Edition

Kirk Roybal, Hannu Krosing, Jim Mlodgenski & Usama Dar.

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.

Buy Now

Overview

  • 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

What you will learn from this book

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

Approach

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

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.

Buy Now
  • Twitter
  • Linkedin
  • Facebook
  • Youtube
  • Mail

DE +49 711 400 557-00

UK +44 (0)870 766 7756

US +1 650 378 1218

Support & Services

24/7 Production Support

Developer Support

Remote DBA for PostgreSQL

PostgreSQL Database Monitoring

PostgreSQL Health Check

PostgreSQL Performance Tuning

Database Security Audit

Upgrade PostgreSQL

PostgreSQL Migration Assessment

Migrate from Oracle to PostgreSQL

Products

HA Postgres Clusters

Postgres-BDR

2ndQPostgres

pglogical

repmgr

Barman

Postgres Cloud Manager

SQL Firewall

Postgres-XL

OmniDB

Postgres Installer

2UDA

Postgres Learning Center

Introducing Postgres

Blog

Webinars

Books

Videos

Training

Case Studies

Events

About Us

About 2ndQuadrant

What does 2ndQuadrant Mean?

News

Careers 

Team Profile

©2001-2019 2ndQuadrant Ltd. All rights reserved | Privacy Policy
  • Twitter
  • LinkedIn
  • Facebook
  • Youtube
  • Mail
Nach oben scrollen
×