PHP Classes

Title: MySQL: The Complete Reference

Recommend this page to a friend!

  Latest classes All reviews   MySQL: The Complete Reference   Latest classes Latest reviews   Best sellers ranking Best sellers ranking  

Title

MySQL: The Complete Reference

Category

Database programming books

Author

Vikram Vaswani

Publisher

McGraw-Hill Osborne

Release date

December 18, 2003

ISBN

0072224770

Sales ranking

Week: Not ranked All time: 40

Reviews

March 22, 2004
  Post a comment Post a comment   See comments See comments   Find where to Buy Now Find where to Buy Now  
MySQL: The Complete Reference reviewed by
Picture of Manuel Lemos
Manuel Lemos
manuellemos.net
MySQL and PHP are two Open Source products that have been holding hands since their early days. PHP always has been a very popular Web programming language because it is free and dedicated to Web development.

On the other hand, most PHP applications require a capable database engine. Since MySQL is capable enough and is also free, it became a perfect partner database application, which explains why it is so popular in the PHP world.

Along with Linux and Apache, MySQL completes the set of main components that comprise the popular quartet of free Web development applications frequently used together that is often known as LAMP: Linux, Apache, MySQL and PHP.

Despite previously lacking some of the powerful features that are usually available in high-end database server products, MySQL became increasingly popular over time. However, MySQL has evolved to implement many of the features that used to be lacking.

"MySQL: The Complete Reference" is an up to date book that covers MySQL features exhaustively, including the latest enhancements introduced in the recent releases.

The book is divided in four parts of several chapters each: installation, usage, administration and development.

The installation part provides an introduction to MySQL sub-systems and their components before explaining how to install and configure MySQL on Windows or Unix/Linux like platforms either from readily available binaries of from the source code distribution.

The usage part mostly covers access to databases using SQL. It has special chapters about newer features like sub-queries and transaction support.

The administration part covers all aspects of DBA interest, including configuration, security, user access control, maintenance tasks, data backup and recovery, performance tuning and database server replication.

The development part cover aspects of the MySQL APIs and how to use them to access MySQL databases from programs developed in C, Perl and PHP.

{buttons}Overall this is a very complete reference book, of interest to different types of users of MySQL databases from database application developers to database administrators. The fact that it covers features introduced in MySQL 4 and more recent versions like ACID transactions, referential integrity, query result caching and sub-queries, makes it an excellent choice for people looking for an up to date MySQL book.

Overall this is a very complete reference book, of interest to different types of users of MySQL databases from database application developers to database administrators. The fact that it covers features introduced in MySQL 4 and more recent versions like ACID transactions, referential integrity, query result caching and sub-queries, makes it an excellent choice for people looking for an up to date MySQL book.
  Post a comment Post a comment   See comments See comments   Find where to Buy Now Find where to Buy Now  

Comments

No comments were submitted yet.

Post a comment