- Paperback: 312 pages
- Publisher: Packt Publishing - ebooks Account; 2 edition (February 27, 2015)
- Language: English
- ISBN-10: 1783980583
- ISBN-13: 978-1783980581
- Product Dimensions: 7.5 x 0.7 x 9.2 inches
- Shipping Weight: 1.5 pounds (View shipping rates and policies)
- Average Customer Review: 5 customer reviews
- Amazon Best Sellers Rank: #836,769 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
PostgreSQL Server Programming - Second Edition 2nd Edition
Use the Amazon App to scan ISBNs and compare prices.
The Amazon Book Review
Author interviews, book reviews, editors picks, and more. Read it now
Frequently bought together
Customers who viewed this item also viewed
About the Author
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.
If you buy a new print edition of this book (or purchased one in the past), you can buy the Kindle edition for only $2.99 (Save 84%). Print edition purchase must be sold by Amazon. Learn more.
For thousands of qualifying books, your past, present, and future print-edition purchases now lets you buy the Kindle edition for $2.99 or less. (Textbooks available for $9.99 or less.)
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
Which leaves you mostly with triggers and stored procedures, as well as some other things like sharding.
Why do you care? Could you not find this info on the internet?
Well, yes, you could. You could also spend hours tracking it down, between the different versions of postgres as well as reading posts by people who sometimes have a shaky grasp of how postgres operates. Basically, there is a lot of dross out there. And postgres is different, and sometimes more sophisticated than Oracle or SQL Server's procedural languages.
In any case, while I could find a few tidbits with examples here and there, nothing was comprehensive. The bulk of reliable info is really on the postgres docs themselves. Which are good, but intended as a reference, not an introduction to its subject.
On the other hand, I was able to quickly read this book, get a general idea of what postgres was capable of doing, and put that right into practice replacing some complicated and slow client-side SELECTs with a much tighter, faster and easier to understand and test postgres stored procedure.
That's because this book is both good at explaining, written by someone who really knows his subject and covers most of the basic knowledge you need to get started.
As a bonus, I was also able to quickly grasp what is meant by Python-based stored procedures. Not sure I have much use for them, despite using Python extensively on the client side, but now I know where to go if I need to.
Pros: Step by step samples to guide you writing code. very informative. There is useful information that not included in the official documentary.
Cons: some minor error in the sample codes introduced during the second edition. For example, at Chapter 9 section "create function add(int, int)" , the code " AS 'usr/lib/postgresql/9.3/lib/add_func', 'add_ab_null' " should be " AS 'usr/lib/postgresql/9.3/lib/add_func', 'add_ab' ". This error does't exist in first edition.
This 2nd edition updated for PostgreSQL 9.4 (and with size increased to ~300 pages) covers the following :
- PL/pgsql (most detailed coverage including debugging)
- PL/Proxy (one of the authors is it's original developer so I expect this chapter to be fully accurate)
as well as writing new functions in C and C++ and implementing and publishing other PostgreSQL expensions.
Personally I can't give it 5 stars because it doesn't cover PL/R and PL/sh but if you're not intereted in those, it's definitely closer to 5 stars.
Overall, definitely recommended.
This book is also written in a way that should be understandable to most programmers that haven't programmed in the database before. It covers a wide range of topics, including installing and setting up pgAdminIII and debugging your server-side programs.