» » MySQL and Perl for the Web

MySQL and Perl for the Web epub

by Paul DuBois


MySQL and Perl for the Web epub

ISBN: 0735710546

ISBN13: 978-0735710542

Author: Paul DuBois

Category: Technology

Subcategory: Web Development & Design

Language: English

Publisher: Sams Publishing; 1 edition (August 13, 2001)

Pages: 552 pages

ePUB book: 1594 kb

FB2 book: 1353 kb

Rating: 4.6

Votes: 539

Other Formats: lit txt docx rtf





The amount of detail and depth behind this difficult to master technology combination, is beyond what you'd expect.

The amount of detail and depth behind this difficult to master technology combination, is beyond what you'd expect. Paul has once again written a masterpiece that I am proud to publish

Sort query results and generate summaries. Paul DuBois is one of the primary contributors to the MySQL Reference Manual, a renowned online manual that has supported MySQL administrators and database developers for years. He’s a member of the MySQL documentation team at Oracle and author of several books. With more than 200+ recipes, you’ll learn how to: classic, this remains  Athetrue best collection of.

In conclusion, I really found this book useful and would recommend it to aspiring and experienced web developers alike.

MySQL and Perl for the Web is the second MySQL-related book by Paul DuBois, who is a contributor to the MySQL documentation. I thought his first MySQL book a couple years ago was outstanding; naturally then, being a web developer myself, I was excited when I found this book on the shelves. In conclusion, I really found this book useful and would recommend it to aspiring and experienced web developers alike.

MySQL and Perl for the Web provides a much-needed handbook for database and Web developers seeking an extensive and detailed guide for using the combination of MySQL and Perl to build dynamic and interactive database-backed Web sites

MySQL and Perl for the Web provides a much-needed handbook for database and Web developers seeking an extensive and detailed guide for using the combination of MySQL and Perl to build dynamic and interactive database-backed Web sites. These tools provide developers with a solid foundation for creating applications that incorporate database content to create dynamic, up-to-date Web sites.

Are you sure you want to remove MySQL and Perl for the Web from your list? . There's no description for this book yet.

Are you sure you want to remove MySQL and Perl for the Web from your list? MySQL and Perl for the Web. 1st ed. by Paul DuBois.

Once in a while a book comes along that covers an area of development that has previously been largely ignored. MySQL and Perl for the Web" provides a much-needed handbook for database and Web developers seeking an extensive and detailed guide for using the combination of MySQL and Perl to build dynamic and interactive database-backed Web sites.

Paul DuBois (author). The book employs a practical learn-by-doing approach that demonstrates development techniques by building complete applications, not just fragmentary pieces. It shows what to do at each step of the way during the process of building live, working examples.

We’re dedicated to reader privacy so we never track you. We never accept ads. But we still need to pay for servers and staff. I know we could charge money, but then we couldn’t achieve our mission: a free online library for everyone.

English~New Riders~2001Databases~Web. MySQL and Perl for the Web. Author: Paul DuBois. Publisher: New Riders.

Inquiries may be sent to Paul DuBois. Last modified: June 19, 2016 .

Doorstop V"). MySQL is a comprehensive text that covers how to use and administer MySQL databases, and how to write MySQL-based programs in C, Perl (using DBI), and PHP (using PDO). It also includes several reference appendixes. Inquiries may be sent to Paul DuBois.

MySQL and Perl for the Web provides a much-needed handbook for database and Web developers seeking an extensive and detailed guide for using the combination of MySQL and Perl to build dynamic and interactive database-backed Web sites. It shows how to use Perl's DBI database access module, pairing it with with the CGI.pm module that allows Web pages and forms to be generated and processed easily. These tools provide developers with a solid foundation for creating applications that incorporate database content to create dynamic, up-to-date Web sites.

The book employs a practical learn-by-doing approach that demonstrates development techniques by building complete applications, not just fragmentary pieces. It shows what to do at each step of the way during the process of building live, working examples. Applications are fully explained so you can understand how they work and apply the techniques they illustrate to your own projects.

Like many others, I wish I'd seen this book long ago.
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!
This is an excellent book. I knew my way around Perl and had done a few relatively simple CGIs before being handed a project to build an application that would allow 50 or 60 employees to enter several thousand customer complaints and email them to the right recipients based on the complaint content. I had a three-week deadline.

I bought the book and started patching elements of the example applications together until I had everything 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.
If you work with perl & mysql this book is a must!!
Paul DuBois really has it together!!
A must!!
If you know some Perl and some MySQL, please, DO by
"MySQL and Perl for the Web" by Paul DeBois and figure out
how those fancy web applications out there are made and learn
how to be able to write one.
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....
There are plenty of books about MySQL and PHP in bookstores. Yet, I still prefer Perl as my web page languages, thanks to its powerful regex and the similarity to C grammar (Some functions have exactly the same name and take the same arguments as in C).

For web applications, a backend database is necessary (MySQL). But how to access and operate on these dabatases? Perl comes into scene at this point.

I don't understand why people write so many books on PHP and MySQL, and so few on Perl and MySQL. Up to now, Paul's book is the only one I ever saw to cover both MySQL and Perl's application in web pages.

Paul's method is step by step, and the examples are not trivial ones. And he clearly explained the critical parts of his code. He even wrote some packages which can be used as library.

Before reading his book, I feel curious how the dynamic web pages work. Now, after finishing his book, I can understand how a commercial site such as Amazon works.

Finally, I recommend this book be bought with the other title by Paul - "MySQL". This is the book dedicated to MySQL language. It is a good companion to "MySQL and Perl for the Web".