PostgreSQL Server Programming - Second Edition

 
9781783980581: PostgreSQL Server Programming - Second Edition
View all copies of this ISBN 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.

"synopsis" may belong to another edition of this title.

About the Author:

Usama Dar

Usama Dar is a seasoned software developer and architect. During his 14 years' career, he has worked extensively with PostgreSQL and other database technologies. He worked on PostgreSQL internals extensively while he was working for EnterpriseDB. Currently, he lives in Munich where he works for Huawei's European Research Center. He designs the next generation of high-performance database systems based on open source technologies, such as PostgreSQL, which are used under high workloads and strict performance requirements.

"About this title" may belong to another edition of this title.

Buy New View Book
List Price: US$ 49.99
US$ 50.58

Convert currency

Shipping: FREE
From United Kingdom to U.S.A.

Destination, rates & speeds

Add to Basket

Top Search Results from the AbeBooks Marketplace

1.

Usama Dar, Hannu Krosing, Jim Mlodgenski
Published by Packt Publishing Limited, United Kingdom (2015)
ISBN 10: 1783980583 ISBN 13: 9781783980581
New Paperback Quantity Available: 10
Print on Demand
Seller:
The Book Depository
(London, United Kingdom)
Rating
[?]

Book Description Packt Publishing Limited, United Kingdom, 2015. Paperback. Condition: New. 2nd Revised edition. Language: English . Brand New Book ***** Print on Demand *****.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. Seller Inventory # AAV9781783980581

More information about this seller | Contact this seller

Buy New
US$ 50.58
Convert currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, rates & speeds

2.

Usama Dar, Hannu Krosing, Jim Mlodgenski
Published by Packt Publishing Limited, United Kingdom (2015)
ISBN 10: 1783980583 ISBN 13: 9781783980581
New Paperback Quantity Available: 10
Print on Demand
Seller:
Book Depository International
(London, United Kingdom)
Rating
[?]

Book Description Packt Publishing Limited, United Kingdom, 2015. Paperback. Condition: New. 2nd Revised edition. Language: English . Brand New Book ***** Print on Demand *****. 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. Seller Inventory # AAV9781783980581

More information about this seller | Contact this seller

Buy New
US$ 54.07
Convert currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, rates & speeds

3.

Dar, Usama
Published by Packt Publishing Limited (2015)
ISBN 10: 1783980583 ISBN 13: 9781783980581
New Quantity Available: > 20
Print on Demand
Seller:
Pbshop
(Wood Dale, IL, U.S.A.)
Rating
[?]

Book Description Packt Publishing Limited, 2015. PAP. Condition: New. New Book. Shipped from US within 10 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Seller Inventory # IQ-9781783980581

More information about this seller | Contact this seller

Buy New
US$ 50.09
Convert currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

4.

Usama Dar
Published by Packt Publishing Limited (2015)
ISBN 10: 1783980583 ISBN 13: 9781783980581
New Quantity Available: > 20
Print on Demand
Seller:
Books2Anywhere
(Fairford, GLOS, United Kingdom)
Rating
[?]

Book Description Packt Publishing Limited, 2015. PAP. Condition: New. New Book. Delivered from our UK warehouse in 4 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Seller Inventory # LQ-9781783980581

More information about this seller | Contact this seller

Buy New
US$ 43.54
Convert currency

Add to Basket

Shipping: US$ 11.82
From United Kingdom to U.S.A.
Destination, rates & speeds

5.

Dar, Usama
Published by Packt Publishing 2/28/2015 (2015)
ISBN 10: 1783980583 ISBN 13: 9781783980581
New Paperback or Softback Quantity Available: 10
Seller:
BargainBookStores
(Grand Rapids, MI, U.S.A.)
Rating
[?]

Book Description Packt Publishing 2/28/2015, 2015. Paperback or Softback. Condition: New. PostgreSQL Server Programming - Second Edition. Book. Seller Inventory # BBS-9781783980581

More information about this seller | Contact this seller

Buy New
US$ 63.44
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

6.

Dar, Usama
Published by Packt Publishing - ebooks Acco (2018)
ISBN 10: 1783980583 ISBN 13: 9781783980581
New Paperback Quantity Available: 20
Print on Demand
Seller:
Murray Media
(North Miami Beach, FL, U.S.A.)
Rating
[?]

Book Description Packt Publishing - ebooks Acco, 2018. Paperback. Condition: New. Never used! This item is printed on demand. Seller Inventory # 1783980583

More information about this seller | Contact this seller

Buy New
US$ 65.44
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

7.

Hannu Krosing
Published by Packt Publishing - ebooks Account
ISBN 10: 1783980583 ISBN 13: 9781783980581
New Paperback Quantity Available: > 20
Seller:
BuySomeBooks
(Las Vegas, NV, U.S.A.)
Rating
[?]

Book Description Packt Publishing - ebooks Account. Paperback. Condition: New. 312 pages. Dimensions: 9.2in. x 7.5in. x 0.9in.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 BookAcquaint yourself with all the options to extend PostgreSQL using the programming language of your choice such as C and PLPythonWork with PostgreSQL 9. 4 so you can immediately take advantage of all the improvements and new featuresUtilize the extensive code examples and many novel tips and tricks for maximum performance gainWho This Book Is ForThis 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. 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. Whats 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. This item ships from multiple locations. Your book may arrive from Roseburg,OR, La Vergne,TN. Paperback. Seller Inventory # 9781783980581

More information about this seller | Contact this seller

Buy New
US$ 73.26
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

8.

Usama Dar; Hannu Krosing; Jim Mlodgenski; Kirk Roybal
Published by Packt Publishing - ebooks Account (2015)
ISBN 10: 1783980583 ISBN 13: 9781783980581
New Softcover Quantity Available: 1
Seller:
Irish Booksellers
(Portland, ME, U.S.A.)
Rating
[?]

Book Description Packt Publishing - ebooks Account, 2015. Condition: New. book. Seller Inventory # M1783980583

More information about this seller | Contact this seller

Buy New
US$ 79.73
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

9.

Dar, Usama; Krosing, Hannu; Mlodgenski, Jim; Roybal, Kirk
Published by Packt Publishing - ebooks Account
ISBN 10: 1783980583 ISBN 13: 9781783980581
New PAPERBACK Quantity Available: > 20
Seller:
Russell Books
(Victoria, BC, Canada)
Rating
[?]

Book Description Packt Publishing - ebooks Account. PAPERBACK. Condition: New. 1783980583 Special order direct from the distributor. Seller Inventory # ING9781783980581

More information about this seller | Contact this seller

Buy New
US$ 74.99
Convert currency

Add to Basket

Shipping: US$ 7.00
From Canada to U.S.A.
Destination, rates & speeds

10.

Usama Dar
Published by Packt Publishing - ebooks Account (2015)
ISBN 10: 1783980583 ISBN 13: 9781783980581
New Paperback Quantity Available: 1
Seller:
Revaluation Books
(Exeter, United Kingdom)
Rating
[?]

Book Description Packt Publishing - ebooks Account, 2015. Paperback. Condition: Brand New. 2nd edition. 320 pages. 9.25x7.50 inches. In Stock. Seller Inventory # __1783980583

More information about this seller | Contact this seller

Buy New
US$ 103.34
Convert currency

Add to Basket

Shipping: US$ 9.85
From United Kingdom to U.S.A.
Destination, rates & speeds