Scripting Languages in Database Programming

Paul's "MySQL and Perl for the Web" touches upon some topics
that NONE OF THE BOOKS out there ever covered in so much details.

The style and examples are amazing. He makes use of Perl5's Object
Oriented features which itself tells you that it's a professional
textbook for professional web-programmers.

The book teaches you neither Perl nor MySQL from basics. It
assumes you already have some basic knowledge of Perl and MySQL.
So it starts off at the most fun part without waisting neither his nor
the readers' time.

Here I'll go over the chapters in case the table of contents
don't tell you much (they didn't to me).

Chapter 1 and chapter 2 go over some basic things that you need
in order to understand and/or try out the examples in the book.

Chapter 2 goes over configurting your MySQL and Apache. I believe
if you are on a hosting service, this should've been done for you already.
It also teaches you to write "A Simple Web-Based Application - To-do List
Maintenance". Although the application doesn't require a lot of
brains to create, but it does cover some basic concepts that
you'll be using all the time in web-programming.

Chapter 3 gives some information on "Improving Performance with mod_perl"
and how to write scripts that work in mod_perl compiled servers.

Chapter 4, "Generating and Proccessing Forms" goes over "Form Anatomy"
and does introduce some concepts of "Form Desgin Issues"

Chapter 5, "Writing form-Based applications" is probably the wealthiest
chapter of the book. Following sections are available under this chapter:
"Product registration", "Using Email from Within Applications", "Running a
Giveaway contest", "Conducting a Poll", "Storing and Retriving Images",
"Electronic Greeting Cards - Send a Friend a Greeting".
This chapter lasts over 80 pages.

Chapter 6, "Automating the Form-Handling process" introduces some
concepts that you can make use of in order to automate the form handling
process through the use of MySQL's table metadata, which is available
through DESC table_name ( or SHOW COLUMNS FROM table_name ) query.
Using his concept I introduced a new module to CPAN.org, MySQL::TableInfo.

Chapter 7, "Performing Searches" covers "Writing a Form-Based Serch
Application" and "Extending" it. It also introduces the concept of
"Link-Based Navigation". It also teaches you how to split the results of the search
over several pages; suppose you have a result of 100 rows in your search, and
you show only 20 results at a page, and provide [previos] and [next] links
so that users could navigate over your pages. Neat, isn't it?

Cahpter 8, "Session Management" was the one I have been wating for so long.
It goes over some "State Maintenance Techqniques" used in web applications, then
introduces the most favorite one, "Active Client Identification" method.
The sections the chapter covers are: "State Maintenance Techqniques", "Implementing
Session Support", "Expiring Sessions", "Storing User Prefernces", "Implementing Resumable
Sessions" and "When Sessions aren't enough"

Chapter 9, "Security and Privacy" teaches you the ways of precaution you could
take against "bad guys" ( hackers? ) to insure the security of your site/database.
Also shows you how to write a login page to provide access to some sensitive information
using the techniques he just mentioned.

Chapter 10, "E-Commerce Applications" covers such topics as Shopping carts,
credit card validation and in the end of the chapter completed a fully operating
commercial web-site.

Although the book concentrates on MySQL, I wrote several applications that make use of
Berkeley Database using the same techniques as Paul suggested. I tell you, I lerned a lot....

 

Average Customer Review:

Write an online review and share your thoughts with other customers.

This is the most important book in my library (of over 300), January 29, 2004
 

The attention to detail and accuracy of the examples is just incredible!

This is by far the most used reference book in my library. After repeatedly having to tape the book together, I finally gave it away and bought a new one.

Following his examples eliminates many potential pitfalls that would otherwise result in hours of troubleshooting.

I can't imagine how I would have ever learned this information without the expert advice of the author, Paul DuBois. His coverage of CGI.pm is essential as well as his list of other books to read.

I think I have all his other books as well.

He even returned email almost immediately!

My only complaint is that it isn't bound in leather!

 

Clear explanations and excellent examples, November 3, 2003
 

I bought the book and started patching elements of the example applications together until I what I needed almost working. One problem delayed me a couple of days so I emailed DuBois with a question and received a solution within the hour.

I'd recommend this book to anyone who has a moderate grasp of Perl and Apache. It's one of the most lucid computer books I've ever read.

 

0 of 1 people found the following review helpful:

MySQL and Perl but no templates?, August 20, 2003
 

Seems like a big omission to me. YMMV.

 

1 of 1 people found the following review helpful:

very good intermediate book, November 13, 2002
 

Even though I'm not keen on using Perl - it's a preference, this book is excellent for learning good practices in writing scripts for various tasks.

This book is best for someone who's somewhat familiar with Perl and MySQL. So far, through the first 5 chapters, it has not been Perl intensive at all which is good for me.

Copyright © 1996-2007 by Dr. Nikolai Bezroukov. www.softpanorama.org was created as a service to the UN Sustainable Development Networking Programme (SDNP) in the author free time. Submit comments This document is an industrial compilation designed and created exclusively for educational use and is placed under the copyright of the Open Content License(OPL). Original materials copyright belong to respective owners. Quotes are made for educational purposes only in compliance with the fair use doctrine.

Standard disclaimer: The statements, views and opinions presented on this web page are those of the author and are not endorsed by, nor do they necessarily reflect, the opinions of the author present and former employers, SDNP or any other organization the author may be associated with. We do not warrant the correctness of the information provided or its fitness for any purpose.