(Roger Stringer) Setting up an affiliate system on your website can be very lucrative. While there are a lot of details involved, it need not be overly complicated. This article walks you through the steps of creating and setting up a basic affiliate system.

(Alan Beaulieus) Learn how queries are executed by the MySQL server, and then take a closer look at the select statement and how its parts interact. (pdf)

(Ian Gilfillan) As most of you will know, the big news recently in the MySQL world, besides the launch of the long-awaited MySQL 5, involves Oracle. Oracle has done two things that will catch the attention of MySQL users. First was the purchase of Finnish company Innobase OY, who develop the code fo

The PostgreSQL development community has released version 8.1 of the open source database introducing new advanced features and performance improvements for what is claimed to be the most advanced open source database management system.

(Alex Woodie) Large companies that previously would not consider the open-source MySQL database due to its lack of high-end features needed to run enterprise applications may want to take a fresh look at the data platform. Last week the Swedish company announced MySQL version 5.0, which adds critica

(Ben Reichelt) When open source software is mentioned, one of the first thoughts that comes to mind is the LAMP stack (Linux, Apache, MySQL, and PHP/Perl/Python). While these products are not generally associated with Windows development, at least one of them is certainly well suited for Windows dev

(Falko Timme) This document describes how to install a Proftpd server that uses virtual users from a MySQL database instead of real system users. This is much more performant and allows to have thousands of ftp users on a single machine. In addition to that I will show the use of quota with this set

(Mike Hillyer) We currently use Oracle 8i to house a database that stores around 10 million rows a day. We currently store the most current 7 days, partitioned by day. We have 15 tables and of those 15 tables 2 main tables are accessed the most. One of these tables has 44 columns — data types r

(John Berns) For years, the mysql library has been the standard for PHP development and a lot of great apps have been built running PHP and mysql. Now, with PHP5 there is a new database extension called mysqli that stands for “MySQL Improved.”

(Alan Radding) Maybe you can view it as some sort of perverse testament to the robustness of today’s open-application environment, but application development and deployment has gotten very complicated. There are too many message protocols, data formats, component types, services and such for develo