Customer Reviews

Perl Database Programming

5 star:		(3)
4 star:		(0)
3 star:		(1)
2 star:		(1)
1 star:		(1)

 

 

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.

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"

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.

I really enjoyed reading this book. The whole book is like a big piece of source code with line-by-line explaination. If you are like me, knowing perl but not so familiar with it, sometime perl can be hard to decipher. This book solves this by going though a lot of source codes line by line and explain the details. I wish every book on perl can be written this way.

This book will be called Perl and MySQL database programming, the book comment say that this include access to many databases, including Oracle and PostgreSQL, when you read this, you can see that the only database that Brent use is MySQL. MySQL is good database but not the best, I prefer PostgreSQL over MySQL, and my book is now archived.

Regards

Libro muy bien estructurado y muy didactico. Imprescindible para manejo de bases de datos mediante Perl