MySQL Articles

The following articles describe how to use several language interfaces to MySQL:

• Using the Ruby MySQL Module
  This article discusses how to use the Ruby MySQL module for writing scripts that access MySQL databases. This module can be used directly; it also forms the basis for the MySQL driver that is included in the Ruby DBI module.
  Article: [HTML] [PDF]
  Example script source code: [ compressed tar file ] [ ZIP file ]
• Using the Ruby DBI Module
  This article discusses how to use the Ruby DBI module for writing database-access scripts. Ruby DBI provides an interface somewhat similar to that provided by the Perl DBI module.
  Article: [HTML] [PDF]
  [HTML, Japanese] (translation of version 1.02 by Kubo Takehiro)
  Example script source code: [ compressed tar file ] [ ZIP file ]
• Writing MySQL Scripts with PHP and PDO
  The PHP Data Objects (PDO) extension provides database-independent access methods for PHP scripts.
  Article: [HTML] [PDF]
  Example script source code: [ compressed tar file ] [ ZIP file ]
• Writing Scripts with PHP's PEAR DB Module
  The PHP Extension and Add-on Repository (PEAR) includes a DB module that provides database-independent access methods for PHP scripts.
  Article: [HTML] [PDF]
• Writing MySQL Scripts with Python DB-API
  The Python DB-API module provides database-independent access methods for Python scripts.
  Article: [HTML] [PDF]
  [HTML, Brazilian Porteguese] (translation of version 1.01 document by Ielton Ferreira Carneiro Pinto)
  Example script source code: [ compressed tar file ] [ ZIP file ]
• Writing JDBC Applications with MySQL
  The Java JDBC interface provides database-independent access methods for Java programs.
  Article: [HTML]
  For book-length coverage of MySQL Connector/J, the MySQL JDBC driver, take a look at MySQL and Java Developer's Guide.
  [Publisher's listing] [Amazon listing]

Other articles:

• Securing Your MySQL Installation
  This article discusses how to make your MySQL installation secure and protect it against unauthorized access.
  Article: [HTML]
• Using MySQL With XML
  This article shows a few simple ways to use MySQL to perform XML-related tasks: Producing XML documents from query results, reading XML documents and extracting the contents for insertion into MySQL, and setting up a web-based XML data feed. The scripts are in Perl, but the basic ideas can be adapted to any language.
  Article: [HTML]
• Running MySQL as a Service Under Windows NT
  Under Windows NT-based systems (NT, 2000, XP), the MySQL server can be run as a service. This articles describes how to install, remove, and control the service.
  Article: [HTML]
• Migrating from Microsoft Access to MySQL
  This article compares Access with MySQL and outlines some strategies for moving your data from Access to MySQL.
  Article: [HTML]
• Migrating from IIS to Apache
  This article discusses some reasons to migrate away from Internet Information Server to Apache, and suggests strategies for implementing such a migration.
  Article: [HTML]