Beginning Databases with Post Gresql

by Neil Matthew, Richard Stones, Jon Parise

Book Overview

PostgreSQL is rapidly on its way to becoming the most successful open source relational database system. It has had an explosive growth, from its roots in academia, to the Internet, through the... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 1861005156
• ISBN13: 9781861005151
• Release Date: January 2001
• Publisher: Wrox Press
• Length: 592 Pages
• Weight: 2.15 lbs.
• Dimensions: 1.4" x 7.2" x 8.9"

Customer Reviews

The best database book I have ever read

My most favorites PostgreSQL book and even can be used for the beginner to learn about the database design as well as some of the good SQL statements (I have learnt some of the SQL commands from this book for my PHP and MySql web application). The spoon-feeding style of explanation is very clear and lots of examples will help any beginner up and running in no time! I am waiting for the second edition and hopefully will be loaded with more JSP and servlet examples.

Ignoring typos & grammar, a great introduction to PostgreSQL

I've been a PostgreSQL user for over a year, but I wanted to know more about databases in general and PostgreSQL in particular. "Beginning Databases with PostgreSQL" (BDWP) answered the questions I had and introduced me to the power of this open source database. My favorite aspect of the book was its use of "Try It Out" sections, where readers experiment with sample tables provided at the publisher's web site. These hands-on exercises reinforced the lessons of the text. I was able to install, configure, and manipulate a PostgreSQL database on FreeBSD following the authors' guidance. Windows fans can follow the authors' instructions for running PostgreSQL on Cygwin. Few other books give such attention to detail. The book's major drawback is its sloppy grammar and frequent, repeating typos. The term 'However' appeared in many sentences for no good reason. Commas also popped up in odd locations. Thanks to the publisher's web site errata listing, I was able to correct most of the book's technical mistakes. Still, these other errors were unnerving. Since I'm not a developer, I didn't pay much attention to chapters 13-17, where the authors describe ways to access a database using C, PHP, Perl, and Java. I was content with the user- and administrator-based material of the first 12 chapters. If you use a PostgreSQL database or need to create one, I recommend BDWP. You won't gain insight into the deeper mysteries of database administration, but the hands-on lessons will provide enough tools to get you started.

A good, step-by-step guide

To help me setup an accounting system on a PostgreSQL database, I purchased two books: I found that PostgreSQL Essential Reference answered 10% of my questions, and Beginning Databases with PostgreSQL answered 90% of my questions. Beginning Databases with PostgreSQL provided good step-by-step information that enabled me to get the application up and running with minimum frustration.

Does the job nicely

I must own a dozen or more of these red-cover books from Wrox, and this one continues to meet the high standards of readability and thoroughness I have come to expect from the publisher. A great first book on PostgreSQL, the frequent "Try it Out" sections make it quite suitable for self-study.

Good for beginners but not shallow

This book from Wrox assumes very little database knowledge and lives in the real world where most desktop computers run Windows not Linux. It has the kind of quality and attention to detail you expect from Wrox, but with only two authors it has a consistent feel to it.A colleague of mine thought it was strange that the book included information on how to access PostgreSQL data via MS Excel/ODBC, but for many users Excel is how you access and manipulate data. Details like how to configure an ODBC data source are covered down to the level of screen shots of the appropriate forms. Note they mean it when they use the word "Beginning" in the title. It includes a brief history of database types, Relational Database Principles in Chapter 2 and Database Design in chapter 12. Chapter 5 covers the graphical tools that can be used with PostgreSQL. It covers both the Postgres specific tools like pgAdmin and pgAccess, and how you can use a generic database tool like MS Access with ODBC. It takes the view of PostgreSQL as a relational database and generally skips over its more exotic features such as user defined data types or Object Database features. Despite more than 10 years of experience using SQL databases I did find myself saying "a ha, true" when reading the database design chapter. This was when reading the paragraphs on modelling a hierarchical relationship. It explains how you could do it, but shouldn't and how you probably ought to do it. I even picked up a few pointers on JDBC programming that I intend to try out, despite having spent more than a year doing intensive JDBC for a living. It would be excellent as an undergraduate course book on practical database work.Four chapters 14-17 are devoted to accessing PostgreSQL via different language. These cover C, PHP, Perl and Java. I was surprised they didn't include some ODBC/Visual Basic examples, though there would be very little difference between programming using PostgreSQL and Access or SQL Server as the back end for this type of programming. All 33 pages of chapter 10 are devoted to Stored Procedures and Triggers, a PostgreSQL specific technology but a very important one. In a year of using PostgreSQL I have yet to use this technology but when I do this will be the documentation I turn to.The windows specific information is particularly handy as most of the information on the web concentrates on the Linux platform. I managed to configure up PostgreSQL under NT from information I gathered on the web, but it would have been very useful to have had this book to hand to help. The book includes screen shots from installing the Cygwin system for emulating some of the Unix APIs under Windows. Until I read this book I didn't know it was possible to run PostgreSQL as a Windows NT service, despite reading everything I could find about PostgreSQL on the web. I had run it from a cygwin bash prompt but that approach means you need the little black window of the console running whenever you want