(Russell Dyer) Once you’ve built several MySQL databases, you’ll learn some shortcuts to database design. Many databases are very similar. When creating new databases, developers often build the same basic tables with only slightly different names and some adjustments to columns. Rather than sta

(Stacey Quandt) Open source vendors are often asked how they make money if their software is free. Well, believe it or not, open source and profit are not oxymorons. In fact, several open source vendors are making money, growing in size, revenue, installed base, and influence.

(John David Duncan) The MySQL database server features a distinctive modular architecture. The core “upper level” features of the server, such as the network layer, SQL parser, and query optimizer, are separated from the underlying data storage by a well-defined interface. Most MySQL databases s

(Nicholas Clayton) The author explains how he was able to use VB.NET, PHP, and XML to talk to a troublesome MySQL database. “There may be times when what your client needs and what their web host will give you brings your project to a grinding halt. I have encountered such a problem recently when tr

(Luis Yordano Cruz) This article will demonstrate the power of three-tier development in PHP 5, using PEAR::DB_DataObject for the business logic and Smarty for display logic. I assume that you have some familiarity with HTML, Smarty, PEAR::DB_DataObject, MySQL, and PHP 5.

MySQL AB, developer of the world’s most popular open source database, today announced the general availability of a set of graphical query and administration tools designed to make life easier for MySQL(R) database developers, DBAs and users.

(Mike Hillyer) One of the least commonly used of the MySQL datatypes has to be the SET datatype. The SET datatype is a string type, but is often referred to as a complex type due to the increased complexity involved in implementing them. A SET datatype can hold any number of strings from a predefine

(Robin Schumacher) It’s recently become very hard to be involved in the database industry and not be acquainted with MySQL. Boasting an install base of some five million systems and 35,000 downloads a day, MySQL has come on the database scene in a very dramatic way. The “M” in the open source L

(DMSoft Technologies) The importance and widespread use of the Internet has changed the information-processing world. Many enterprises in the world publish their information on-line as they need to access, process and exchange large amounts of information primarily through the World Wide Web.

(Nils-Erik Frantzell) Open source stacks such as XAMPP from Apache Friends are simplifying open source development by making it easier to write and distribute applications in a stable and standardized environment. Traditionally, AMPP — Apache, MySQL, PHP, and Perl — have all been installed and con