NAME

DBD::monetdb - MonetDB Driver for DBI

SYNOPSIS

use DBI();

my $dbh = DBI->connect('dbi:monetdb:');

my $sth = $dbh->prepare('SELECT * FROM env'); $sth->execute;
$sth->dump_results;

DESCRIPTION

DBD::monetdb is a Pure Perl client interface for the MonetDB Database Server. It requires MonetDB::CLI (and one of its implementations).

PREREQUISITES

DBI
MonetDB::CLI

MonetDB (http://monetdb.cwi.nl)

INSTALLATION

To install this module type the following:

perl Makefile.PL
make
make test
make install

You need to use the correct make command. That may be nmake or dmake, depending on which development environment you are using.

TESTING

The supplied tests will connect to the database using the DBI environment variables, e.g.:

set DBI_DSN=dbi:monetdb:
set DBI_DSN=dbi:monetdb:host=localhost

Don't specify port and language (if possible). The server should listen on the default ports for sql and mapi.

If the server doesn't accept the default username/password, then set the relevant environment variables, e.g.:

set DBI_USER=test
set DBI_PASS=secret

Make sure libMapi is in your library search path (depending on the MonetDB::CLI implementations in use).

The tests will create tables with the name (or prefix) 'perl_dbd_test' in the current schema.
Check for the unlikly case that this will cause unwanted side effects!

To run the tests, type

make test

If all tests pass, you'll see something like:

t/01base.....ok

t/75mil......ok
All tests successful.
Files=22, Tests=412, 10 wallclock secs ...

It is possible to run individual test scripts, e.g.:

perl -w -Mblib t/02cxn.t

BTW: You can test the ODBC driver when setting the DSN appropriately, e.g.:

set DBI_DSN=dbi:ODBC:driver=MonetDB ODBC Driver

AUTHORS

Martin Kersten <Martin.Kersten@cwi.nlE> implemented the initial Mapi based version of the driver (monet.pm). Arjan Scherpenisse <acscherp@science.uva.nlE> renamed this module to monetdbPP.pm and derived the new MapiLib based version (monetdb.pm). Current maintainer is Steffen Goeldner <sgoeldner@cpan.org>.

COPYRIGHT AND LICENCE

The contents of this file are subject to the MonetDB Public License Version 1.1 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://monetdb.cwi.nl/Legal/MonetDBLicense-1.1.html

Software distributed under the License is distributed on an "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the License for the specific language governing rights and limitations under the License.

The Original Code is the MonetDB Database System.