|All reviews||MySQL: The Complete Reference||Latest reviews||Best sellers ranking|
MySQL: The Complete Reference
Database programming books
December 18, 2003
Week: 2 All time: 40
manuellemos.netMySQL 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.
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.
No comments were submitted yet.