Qore MySQL Module

The Qore MySQL Module requires Qore 0.7.1 and MySQL 3.3 or newer headers and libraries to build.

With MySQL 4.1+ you can get transaction support and the module will use the more efficient prepared statement interface.

The driver supports the following features (depending on the MySQL client library version):
* is thread-safe
* stored procedure execution with binding and retrieving values (5 and newer)
* transaction management is supported (4.1 and newer)
* transparent character encoding conversion is supported if necessary

The driver's name is "mysql" and the Datasource type constant is SQL::DSMySQL
ex: $db = new Datasource(DSMySQL);
ex: $db = new Datasource("mysql");

The mysql module is stable and has been extensively tested.

Documentation: docs/mysql-module-doc.html

test/example script: test/db-test.q

BUILD AND INSTALL

If your mysql installation is in a non-standard location, set the MYSQL_DIR environment variable to the location of the installation before running configure.

Note that you have to use g++ 4.0.* on Darwin to link with newer versions of the MySQL libraries

configure
make
sudo make install

The configure script will find out where your qore module directory is found and set this for the install directory.

BUILD FROM SVN

reconf.sh
configure
make
sudo make install

Qore is a multithreaded, embeddable, db-integrated, weakly-typed, object-oriented programming language with XML, JSON & Perl5-regex support, run-time language extensions through modules, suitable for interface development, application scripting, etc.

What is new in this release:

• This version fixes a regression bug introduced in the last release which made numeric values with a fractional component be returned as integers.

What is new in version 2.0:

• This version adds major new features when built against Qore 0.8.6+, including support for the prepared statement API (the SQLStatement class) and the new DBI option API, support for the new arbitrary-numeric data type added in Qore 0.8.6, and the ability to set server-side timezone rules in the client to ensure proper date/time support when communicating with a DB server in a different timezone.

What is new in version 1.0.8:

• The module has been updated to Qore 0.8.0 APIs to support Datasource::execRaw() and DatasourcePool::execRaw() as well as to use Qore's new date/time APIs.

Requirements:

• Qore Programming Language
• MySQL Community Edition