MonetDB

MonetDB provides an SQL compliant database interface, supporting the common SQL features such as keys, joins, views, triggers, stored procedures, and user authentications and data access control. In addition, it also supports full-ACID support for concurrent transactions; high scale-up performance, scale-out using distributed merge tables; SQL:1999 ROLLUP, CUBE and GROUPING SETS; SQL:2003 merge statements; SQL:2011 window functions; User Defined Functions in SQL, C/C++, Python and R; and seamless integration with a plethora of programming languages.

Software Included

Creating an App using the Control Panel

Click the Deploy to DigitalOcean button to create a Droplet based on this 1-Click App. If you aren’t logged in, this link will prompt you to log in with your DigitalOcean account.

Creating an App using the API

In addition to creating a Droplet from the MonetDB 1-Click App using the control panel, you can also use the DigitalOcean API. As an example, to create a 4GB MonetDB Droplet in the SFO2 region, you can use the following curl command. You need to either save your API access token) to an environment variable or substitute it in the command below.

curl -X POST -H 'Content-Type: application/json' \
         -H 'Authorization: Bearer '$TOKEN'' -d \
        '{"name":"choose_a_name","region":"sfo2","size":"s-2vcpu-4gb","image": "monetdbsolutions-monetdb"}' \
        "https://api.digitalocean.com/v2/droplets"

Getting Started After Deploying MonetDB

When Droplet is up and running the default setup is:

• UFW firewall allow only SSH (port 22, rate limited), HTTP (port 80), and HTTPS (port 443).

• dbfarm is initialized under /var/monetdb5/dbfarm

• monetdbd is bound to local interface, and listens on default port 50000. Note that UFW

  does not allow port 50000 by default.

You can allow more ports(e.g. 50000) by configuring UFW.

Visit monedtbd documentation for more information

on how to customize monetdbd.