database

Since version 5, MySQL comes with built-in support for master-master replication, solving the problem that can happen with self-generated keys. In former MySQL versions, the problem with master-master replication was that conflicts arose immediately if node A and node B both inserted an auto-incrementing key on the same table.

Simple howto with user-defined function for optimizing MySQL database tables with PHP

In this article you'll learn how to create database-enabled Ajax requests using PHP and MySQL. We begin by creating the front-end HTML and JavaScript files used to make requests to the server-side. The requested server-side is a PHP file which bridges the gap between Ajax and a PHP object that connects to a MySQL database and returns results as an XML response to the Ajax engine. To cover this functionality you'll learn about the concepts from a high level overview rather than focusing on each and every line of code. The complete source code for this sample can be downloaded and is necessary to create a working sample on your personal server.

Howto documenting the procedure for installing amavisnewsql to manage spam settings and quarantine through squirrelmail. It's assumes you have postfix/amavisd-new already configured to manage spam and clamav. This squirrelmail plugin allows individual mail accounts to manage white/blacklists, spam thresholds and quarantined emails.. on a per mail account level!

Interactive SQL tutorial, learn about: SQL Server, Oracle, MySQL, DB2, Mimer, PostgreSQL, SQLite and Access.