Perl Database Programming (Paperback)

~ (Author) "In this chapter, you receive an overview of database: the concepts and jargon, their purposes, what you can do with them..." (more)
Key Phrases: tem hash, return unless defined, comment about this program, Queens Road, Program Listings Listings, Database Basics (more...)

Editorial Reviews

Product Description

Author is an experienced Perl user who maintains the Perl area of Dr. Dobb's Journal Website.
* The first book to cover the full range of Perl database programming topics.
* Discusses practical applications such as online catalogs, Web-based photo databases, and Palm-powered applications.

From the Back Cover

Here’s your in-depth guide to creating database-driven applications using Perl.

In this authoritative reference, Perl expert Brent Michalski uses plenty of examples to help you master Perl’s capabilities in database applications with MySQL, PostgreSQL, and Oracle. Along the way, he explores practical applications for cutting-edge technologies like XML and Web services. If you’re a Perl novice, the comprehensive code samples and step-by-step explanations will have you writing database applications quickly and confidently. If you’re experienced, this definitive guidebook has everything you need to move ahead with Web programming, problem tracking, automatic e-mail reports, and much more.

You’ll learn how to:

• Understand different database models, DBIs, and DBDs
• Set up relational databases, retrieve information, and generate reports
• Tie a Perl hash to a database and track users with cookies
• Generate and deliver automatic e-mail reports
• Use tied hashes to create Web-based shopping carts
• Handle binary data and submit BLOB data
• Create phonebooks, photo albums, and a SOAP-based catalog

The companion Web site features source code from the book and other useful information.

See all Editorial Reviews

Product Details

• Paperback: 572 pages
• Publisher: Wiley; 1 edition (November 7, 2002)
• Language: English
• ISBN-10: 0764549561
• ISBN-13: 978-0764549564
• Product Dimensions: 9.2 x 7.4 x 1.2 inches
• Shipping Weight: 2 pounds (View shipping rates and policies)
• Average Customer Review: 3.5 out of 5 stars  See all reviews (6 customer reviews)
• Amazon.com Sales Rank: #885,763 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

15 of 15 people found the following review helpful:

5.0 out of 5 stars A great intro to databases for the impatient, June 17, 2003

By	Sean Burke (Ketchikan, Alaska, United States) - See all my reviews (REAL NAME)

This is the intro best book about Perl and databases out there. The book assumes you know nothing about databases and only the rudiments of Perl. It has lots and lots of examples, and several parts that I find myself coming back to often as a reference.

The book starts with a very brief introduction to the basic concepts and jargon of databases (about 35 pages), and then it jumps into the meat of the book, 13 chapters (about 450 pages) that mainly teach by example. That is, when a chapter explains something (whether it's a bit of SQL syntax like "select max(x) from y where...", or a concept like transactions, or an interface detail like templates or tied hashes), it explains it in terms of how it solves a problem.

Then the book illustrates each idea in terms of a real program that does a real task -- like a program for a CGI-based photo database, or a command-line program that searches a database of books, or a Tk-based (GUI) program that searches an address-book database. Each program's source is shown in full, and also with explanation of a few lines a time. Experienced and attentive readers can freely skip a lot of the commentary, but those explanations can come in very handy if you're not very experienced, or if you are reading the chapters out of order (as you might, if you jump in and want to try writing a program like in chapter 10, without reading all of 1-9 first). The Perl code is unassuming, clear, robust, and rigorously secure.

The book ends with 40 pages of appendices (plus 30 pages of index). The first of the four appendices is a tutorial on installing Perl, the Perl database modules, MySQL, and a web server -- I found this very helpful for setting up a development environment on my laptop so that I could experiment with database programming. The second appendix is a reference of the most common SQL commands, with examples. The third appendix is a reference of useful MySQL-specific commands, with examples. The last appendix is a reference to DBI commands (the Perl module for talking to databases). I have found all these appendices very worthwhile, and I refer to them quite often.

Before I read this book, I had been avoiding using real databases for years, and I instead used flakey substitutes like flat-file "databases", or simple Unix DBMs. I read this book on and off over the course of a few weeks, and at the end I thought "that's it!? This isn't so hard! What was I avoiding all these years!?". And I got up and within hours wrote a database-based CGI system that I had been meaning to write for ages. Over the years, I have come to recognize this feeling of "this book makes it look so easy! I REALLY wish I had read it years ago!" as the sign of a great book.

13 of 14 people found the following review helpful:

2.0 out of 5 stars totally misleading title, May 14, 2004

By A Customer

I bought this book to learn some advance database programming specifically with Oracle which the book claims it does cover. However, what I found was a perl mysql programming book that has devoted half its contents to web site development (which I'm not interested in). I think this book should be renamed to "website development using perl and mysql". If you really just want to learn database programming using perl read "programming DBI"

8 of 10 people found the following review helpful:

1.0 out of 5 stars Shame it wasn't proof read..., December 2, 2003

By	"jeelos" (Bristol, UK) - See all my reviews

I bought this book simply because it had a section on Session Management, so I went straight to that section (chapter 9). When I tried to get the code working, it became obvious that there was something missing, notably an HTML template. No problem I thought - there's probably an addendum on-line. Unfortunately not - a search led to Michalski's home page with nothing more useful than a statement saying it is his intention to get addenda for all his books up online at some point (but no indication as to when). The publishers, Wiley, have all the files from the book available for download, but unfortunately not the missing template.

Now I realise the pressure to get books into print in this fast moving field must be intense, but if your willing to let errors slip through then you must take your after sales service very seriously, and get an online addendum up and running when that book hits the shelves. This book has been available for over a year now, come on!

I did email Michalski direct 2 weeks ago but so far no response. I expect my email was lost in a torrent of spam.

I will persevere and try to work out what the missing html should look like - I guess it could be worse - it could have been the Perl code that was missing - but quite frankly I haven't got time to fill in gaps left by someone else's lack of professionalism - especially when I'm paying for it!

Thumbs down to support - I'll be avoiding Michalski and Wiley in future.