CP363 : Tools and Facilities

All publicly available PC labs on campus can be used by you for your course work. You will be provided with space and database access on the department server hopper for use in your projects.


Tools

Database Management Software (DBMS)

Connecting to MySQL - DBMS

Database Connections with Programming Languages

Connecting with Python
Using SSH Tunnelling (required)
Other Languages

Database

MySQL
MySQL is an SQL compatible database server. The department has a MySQL server on hopper, which you will be using in your project. You will be given logins and database schemas on this server.

Database Interface

HeidiSQL
HeidiSQL is a useful and reliable tool designed for web developers using the popular MySQL server, Microsoft SQL databases and PostgreSQL. It enables you to browse and edit data, create and edit tables, views, procedures, triggers and scheduled events. Also, you can export structure and data either to SQL file, clipboard or to other servers. HeidiSQL is available in the public computer labs and can be downloaded for home use as well. (Requires Windows or a Windows emulator.)

Tutorials on these products will be held as necessary throughout the course.