How to Set Up a Simple Database with mSQL and CGI Interfaces

L. Fini

Arcetri Technical Report No 1/1998
Firenze, February 1998

Abstract

In the following pages we describe a simple database used to maintain a list of the computers and related devices in use at the Osservatorio Astrofisico di Arcetri. The system is based on mSQL (a database engine provided with an SQL interface) and on HTML FORMS which fire CGI procedures on a Web server. Through the interface it is possible to search the database and add/modify data.

The latter operations are protected by a username/password mechanism.

The whole system is an assembling of various Web tools and may be of interest as a template to set up other similar applications.