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
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
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: