About Schedule Software

Software installation

MySQL

In this class we will use MySQL Community Edition as our Database Management System (DBMS) (note: you do not have to create an Oracle account, click the link that says, "No thanks, just start my download"). Follow the instructions on the linked page to install a local copy of MySQL on your computer. We will also access an installation on a Dartmouth server.

MySQL Workbench

Most of the time you will interact with the MySQL DBMS through MySQL Workbench. You should install this on your local machine (note: you do not have to create an Oracle account, click the link that says, "No thanks, just start my download"). Follow instructions on the linked page to install a local copy of MySQL Workbench.

NOTE: you may see a warning that says, "Warning "Incompatible/nonstandard server version or connection protocol detected". You should be able to disregard this warning. Your database is newer than MySQL Workbench.

Connect to database

Once you've installed MySQL and MySQL Workbench, connect to your local database server from the MySQL Workbench home screen by first clicking on the plus next to "MySQL Connections" and entering the required connection information as shown here.

Optional: Node.js

I will use Node.js to create a RESTful web API. Install Node on your local machine if you'd like to create your own. Alternatively, you can use another service such as Flask.