MonetDB comes with several programming language interface libraries:
Each interface listed above is a native implementation and does not require an installation of the MonetDB client/server code.
The C ODBC driver and setup library are available as a separate installer.
The C Mapi library is the lowest level C-interface for interacting with the server.
We refer to external documentation for the basics of the language bindings:
Examples provided are used to illustrate their behavior in the context of MonetDB only.
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 receive 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.
For a deeper integration of MonetDB with R, proceed to MonetDB.R - MonetDB to R Connector. For information about the embedded R support in MonetDB, check this blog post.