MonetDB
Generated on 13 May 2024 from the MonetDB catalog page
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
Package | Version | License |
---|
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.