Compiling TolDBD under Linux

Tol requires Database access to make massive data analysis.
The Tol Database Drivers project, Tol-DBD, is the programming interface to get the Database Access.

It consists of three drivers, Tol-PostgreSQL, Tol-MySQL and Tol-ODBC, that to be compiled require the client libraries of the Database you are planing to use.

If you aim to get access to Databases managed by PostgreSQL or MySQL, we encorage you to use the direct access drivers available for those DBRMSs. Under such circumstances either Tol-PostgreSQL or Tol-MySQL has better performance than the more general Tol-ODBC driver.

1. Required packages for Tol-DBD compilation

Depending on which driver you are interested on, these are the packages required:

PostgreSQL

Maybe you have compiled PostgreSQL in your system. In such case you have already available the required library. Otherwise you should install libpq-dev, that contains the headers files and the client access library.

Having apt-get available just type, as root, the next command:

MySQL

The headers and libraries required to compile the Tol-MySQL driver are available under the Downloads section of MySQL Home Page. Just click there, choose your server version, download the file labelled as "Headers and libraries" and install it.

Using the just released Debian Etch or the upcoming Ubuntu Feisty there's only one package available: libmysqlclient15-dev. To proceed type this as root:

ODBC

To compile the Tol-ODBC driver you will need to install the UnixODBC API. Once more, using Debian or Ubuntu, just type the following apt-get command:

2. configure, compile and install

Download and unpack toldbd-1.0.tar.gz:

The configure script offers several command line options to cover each of the three available drivers:

  --enable-odbc           turn on ODBC-client package support
  --enable-mysql          turn on MySQL-client package support
  --enable-postgres       turn on PostgreSQL-client package support

Run configure adding all the --enable-DBRMS you need, or use the common-build script which in fact runs it with all them:

The script ends with a digest of the files found for the given options. If you have installed every packages for every DBRMs and you have run common-build, the digest should looks like this:

  Configuration results:

  Directories where Tol-DBDrivers will be installed: /usr/local/lib

   UnixODBC Support:
     Headers found in system directories
     Library found in system directories

   MySQL Client Support:
     Headers found in system directories
     Library found in system directories

   PostgreSQL Client Support:
     Headers found in system directories
     Library found in system directories

  To build Tol-DBDrivers 1.0 type:
  make
  make install

But if you get an error message it could be a missing component or a misconfiguration. Please don't hesitate to contact us at Tol-Users mailing list, we will be pleased to help you.

If you got the expected output, continue with make:

And finish the installation typing as root, the make install command: