- Paperback: 476 pages
- Publisher: Network Theory Ltd.; Revised ed. edition (November 30, 2010)
- Language: English
- ISBN-10: 1906966060
- ISBN-13: 978-1906966065
- Product Dimensions: 6 x 1.1 x 9 inches
- Shipping Weight: 1.5 pounds (View shipping rates and policies)
- Average Customer Review: 1 customer review
- Amazon Best Sellers Rank: #3,131,220 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 9.0 Reference Manual - Volume 2: Programming Guide Paperback – November 30, 2010
See the Best Books of 2018 So Far
Looking for something great to read? Browse our editors' picks for the best books of the year so far in fiction, nonfiction, mysteries, children's books, and much more.
Frequently bought together
Customers who bought this item also bought
From the Publisher
For each copy of this manual sold 1 USD is donated to the PostgreSQL project by the publisher, Network Theory Ltd.
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
My primary interest in this database is to support my programming efforts for my clients. I also design in SQL Server( GenturaDX ), MySQL( Connelly & Assoc. ), Oracle( Aurora Biosciences ), and SQLite 3( TuneUp Media ). So, I have some experience in comparing database designs. My favorite two databases are PostgreSQL and SQL Server. PostgreSQL gives me the highest convenience in modeling my data tables using data types and arrays that match my exterior software objects. This reduces my design and testing time and lets my software remain clean and effective. SQL Server is more awkward to use in developing data records that match my DTOs and software object contents, but it makes up for it considerably by giving me more convenience with ADO and LINQ constructions. There are many books written for SQL Server, but very few for PostgreSQL. So, I want to congratulate the publisher for providing this work because it is the primary method for most programmers to gain in depth knowledge about this database and to work out thorny problems in using this database in their programs.
I bought this book because I am serious about using PostgreSQL very competently and effectively. If you are trying to take the easy way out or if you want someone to tell you everything needed to write the interface to your program by copying text, don't buy this book, its far too serious for your needs. In that case try to find your program answers on the internet.
I work primarily in Windows, specifically in C#, this requires me to use the NPGSQL interface, which is not covered in this book. Since I need a multi-platform database, I also need to study the alternate interface libraries covered in this book. If your needs are similar to mine then this this book is a good choice for you. The program interfaces in this book are libpq, ECPG, and SQL extensions. The first two interfaces are more prevalent in usage on Linux. The SQL extensions for functions are of use everywhere.
Every database has both internal and external interfaces. The external interfaces are needed to connect the database to program control and the internal interface provides specialized triggers and complex stored procedures that can handle user defined functions. I try to create an programming environment in which any of my favored databases can be chosen for program support. This gives me the most flexibility for my client's needs and legacy database providers. Try telling your client that he has to scrap thirty man years of work because you can't find a way to program your latest whiz-bang features into his existing database and you'll be doing all your newest database designs in your head only.
This book demonstrates the latest programming capabilities in PostgreSQL 9. It is intensive, detailed, and a bit obscure. You will have to experiment with the information to get it to complete your programming needs. This book is not a how to book, it is almost entirely and only a reference. So, plan to experiment with it and refer to another how-to book to get your program working with the latest features. I have been reading it for a month on and off and I expect to take a few more weeks to extract what I need. It has found an honored place on my reference shelves. I am going to use it to displace SQL Server and SQLite from my client's preferred database list.
I prefer that new references are up to date in covering all the major connections to their subject. NPGSQL has been in use since 2004 and favoring only Linux programming libraries is an issue with me. Also, the array column type is almost unique with PostgreSQL and the failure to cover it anywhere in this volume set is practically an insult to the modern design of the database. For these reasons I have detracted a star from the rating.