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]
French translation of version 1.06 by Michel Casabianca:
[HTML]
[PDF]
-
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]
Example script source code:
[compressed tar file]
[ZIP file]
French translation of version 1.03 by Michel Casabianca:
[HTML]
[PDF]
-
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]
Example script source code:
[compressed tar file]
[ZIP file]
Brazilian Porteguese translation of version 1.01 by Ielton Ferreira Carneiro Pinto:
[HTML]
French translation of version 1.02 by Michel Casabianca:
[HTML]
[PDF]
-
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]
Document last modified: March 26, 2015
[Kitebird home]