Getting connected to a database

In this section we will explore various options on how we can get connected to a database server for use throughout the tutorial and beyond. We will review three major options, from the easiest (and most recommended) to the more involved but highly customizable.

Setting up a local database server (Intermediate)

Alternatively you can install and set up a database server to run on your local machine. This offers a very portable solution, but it requires some additional steps to deploy the server. If you decide to go this route, we strongly recommend you use Docker to download and launch a pre-configured database server we have provided as a Docker image.

You can find a step-by-step instructions on setting up a local database server using Docker in our Setting Up a Local Database Server tutorial!

Setting up a database server on another machine (Advanced)

Finally, you might want to set up a database server on dedicated server hardware. Properly setting up and maintaing a database server can require significant IT expertise and infrastructure, depending on the desired scale. If you are interested in pursuing this option, you can find useful configuration information at our MySQL Docker image project.

What’s next?

Once you have decided on your database server option and acquired access credentials, you are ready to move onto setting up DataJoint library in Python or MATLAB! Pick your favorite language for step-by-step instruction on installing and setting up DataJoint library.