DBD::monetdb - MonetDB Driver for DBI


  use DBI();

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

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


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



  MonetDB (


  To install this module type the following:

    perl Makefile.PL
    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.


  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:

    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


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


  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

  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.

  The Initial Developer of the Original Code is CWI.
  Portions created by CWI are Copyright (C) 1997-2006 CWI.
  All Rights Reserved.