Skip to main content

Language bindings

MonetDB comes with JDBC and ODBC drivers and PHP, Perl, Ruby and Python programming interface libraries. The JDBC, PHP, Perl, Ruby, Python and Node.js interfaces are native implementations and do not require installation of the MonetDB client/server code. The ODBC driver and setup library are available as a separate installer. The Mapi library is the lowest level C-interface to interacting with the server.

We rely on external documentation for the basics of the language bindings provided: PHP, Perl, Python, and the JDBC and ODBC APIs. Examples provided are used to illustrate their behavior in the context of MonetDB only.

JDBC docs.oracle.com/javase/8/docs/technotes/guides/jdbc/
ODBC docs.microsoft.com/en-us/sql/odbc/reference/odbc-programmer-s-reference
Python Database API v2.0 www.python.org/dev/peps/pep-0249
R www.r-project.org
JavaScript Node.js nodejs.org
Ruby/Rails rubyonrails.org
Perl DBI www.perl.org
PHP Data Objects (PDO) www.php.net/manual/en/book.pdo.php

Notes: The programming interface is based on a client-server architecture, where the client program connects to a server using a TCP/IP connection to exchange commands and receives answers. The underlying protocol uses plain UTF-8 data for ease of use and debugging. This leads to publicly visible information exchanged over a network, which may be undesirable. Therefore, a private and secure channel can be set up with the Secure Socket Layer functionality.

In addition, a deeper integration of MonetDB with R is available on the website of the MonetDB.R connector. If you are looking for information about the embedded R support in MonetDB, follow check this blog post.

More information about using MonetDB on Node.js you can find here.