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