MacOS Easy Setup


Step 1

Install MonetDB

Homebrew

Install MonetDB from the formula on the Homebrew repository. Homebrew will download the latest released version (along with any dependencies), configure it for your system and build it.

Prerequisites: you need to install Xcode Command Line tools and Homebrew before continuing.

brew install monetdb

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

NB: the previous command uses monetdb and not monetdbd (deamon server)

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