Ubuntu & Debian Easy Setup

Step 1

Install MonetDB

Create a file /etc/apt/sources.list.d/monetdb.list with the following contents (replacing "suite" with your system's code name which you may be able to get by running the command lsb_release -cs):

deb https://dev.monetdb.org/downloads/deb/ suite monetdb
deb-src https://dev.monetdb.org/downloads/deb/ suite monetdb

Install the MonetDB GPG public key

sudo wget --output-document=/etc/apt/trusted.gpg.d/monetdb.gpg https://www.monetdb.org/downloads/MonetDB-GPG-KEY.gpg

After this, you can use apt to install the MonetDB packages. First run:

sudo apt update

Install MonetDB/SQL, using the command:

sudo apt install monetdb5-sql monetdb-client

Step 2

Hello World!

Verify the correct installation of MonetDB.

Create and start a new farm where you can store different databases.

shell> monetdbd create /path/to/mydbfarm
shell> monetdbd start /path/to/mydbfarm

Create and release a Database (default in maintenance mode)

shell> monetdb create mydb
shell> monetdb release mydb

Connect to the database with the following credentials:

default user: monetdb

default password: monetdb

shell> mclient -u monetdb -d mydb

Perform the first query

sql> SELECT 'hello world';

    | single_value  |
    | hello world   |
    1 tuple

Remember to close the query with semicolon

Terminate the connection with the server

sql> \q

Step 3

Have Fun

Now it's time to discover some more advanced features of MonetDB. Go to see our Introduction to MonetDB in the documentation section to discover, among others:

Searching for more download options?

Have a look at the comprehensive installation guide of MonetDB

View Sources