![]({"https://images-na.ssl-images-amazon.com/images/I/51CbwDR9upL._SX258_BO1,204,203,200_.jpg":[260,320],"https://images-na.ssl-images-amazon.com/images/I/51CbwDR9upL._SX404_BO1,204,203,200_.jpg":[406,500]})
Well, first what do I mean by server-side? Mostly, anything that is not just admin work that is carried out through execution on the server, rather than by standard insert/update/delete/select SQL. It also does not include DDL.
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.
- Paperback: 312 pages
- Publisher: Packt Publishing - ebooks Account; 2nd Revised ed. edition (February 26, 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: 6 customer reviews
-
Amazon Best Sellers Rank:
#1,275,803 in Books (See Top 100 in Books)
- #740 in Data Mining (Books)
- #1180 in Data Processing
- #970 in Database Storage & Design
Would you like to tell us about a lower price?
If you are a seller for this product, would you like to suggest updates through seller support?
If you are a seller for this product, would you like to suggest updates through seller support?
