Skip to main content

Client Interfaces

Graphical User Interfaces Graphical database utilities have been around for some time to support click-and-go interactions with a DBMS. They often support multiple database back-ends using a standard communication protocol, e.g. JDBC. MonetDB/JDBC makes such tools work flawlessly with the server and make your experience with MonetDB/SQL even better. Recommended GUIs are Squirrel and DBvisualizer.

APIs The foundation for building applications rest on application programming interfaces. MonetDB comes with a JDBC, ODBC, PHP, Perl, Ruby and Python interface libraries.  JDBC, PHP, Perl, Ruby and Python interfaces are native implementations and do not require installation of the complete MonetDB code base. The Mapi library is the lowest level C-interface to interacting with the server.

This reference manual relies on external documentation for the basics of its  application interfaces, PHP, Perl, Python, and the drivers JDBC and ODBC. Examples are used to illustrate their behavior in the context of MonetDB only. The resource locations identified below may at times proof valuable.

Perl DBI http://www.perl.org/
PHP5 http://www.php.net/
Python http://www.python.org/
Ruby-on-rails http://www.rubyonrails.org/


Business Intelligence MonetDB empowered toolkits can be found in business intelligence warehouse applications. Kettle, Mondrian, Pentaho 

We would like to hear from those missed in this list.