MySQL (4.x+)

MySQL is a fast database that runs on numerous platforms. It is one of the most popular free databases available.

Given the transactional nature of GNUe, we recommend using MySQL 4.x+ with transaction support compiled in.

Not all features of GNUe are usable under MySQL, such as auto-populating fields with serials/sequences and query-by-detail.

To utilize MySQL within GNUe, you must use one of the following python drivers:

MySQLdb

Mysql-python, written by Andy Dustman, supports MySQL 3.22, 3.23, and 4.x.

Home Page: http://sourceforge.net/projects/mysql-python

Supported Platforms:

Connection Properties

The following properties can be specified in your connections.conf file:

Examples

The following is an example of a connection.conf entry:

 [myconn]
 provider=mysql          # Use the MySQLdb adapter
 host=localhost          # The hostname/IP of the MySQL host
 dbname=mydb             # The name of the MySQL database

Notes

  1. Transactions are supported if MySQL is compiled with proper transactional support (3.x series does NOT do this by default!).
  2. Windows installer available at http://www.cs.fhm.edu/~ifw00065/ .
  3. Other than that, the driver is fully functional with no known serious problems.

If you get an error while connecting to the server which looks like this: (1193, "Unknown system variable 'NAMES'") please set the connection parameter 'version=4'.


GNUe Home

Developer Tools