Apache: The Definitive Guide, 3rd Edition

Database Manager

The computing world divides into two camps — the sort-of-free camp and the definitely expensive camp. If you are reading this, you probably already use or intend to use Apache and you will therefore be in the sort-of-free camp. This camp offers free software under a variety of licences (see later) plus, in varying degrees, commercial support. Nowadays, all DBMs (database managers) use the SQL model, so a good book on this topic is essential.^[2] Most of the scripting languages now have more or less standardized interfaces to the leading DBMs. When working with a database manager, the programmer often has a choice between using functions in the DBM or the language. For instance, MySQL has powerful date-formatting routines that will return a date and time from the database served up to your taste. This could equally be done in Perl, though at a cost in labor. It is worth exploring the programming language hidden inside a DBM.

These are the significant freeware database managers:

MySQL (http://www.mysql.com)

MySQL is said to be a “lighter weight” DBM. However, we have found it to be very reliable, fast, and easy to use. It follows what one might call the “European” programming style, in which the features most people will want to use are brought to the fore and made easy, while more sophisticated features are accessible if you need them. The “American” style seems to range all the package’s features with equal prominence, so that the user has to be aware of what he does ...