Databases

This page is under construction...

In this lesson, we give a brief introduction to the techniques needed to create websites that interact with databases. The server for this course uses the HSQLDB open source database engine. The (dbquery QUERY) command is used to send requests to the database. It returns results either as strings or as lists of lists (which can be processed using the table commmand).

The language we use to communicate with the database is called SQL. The particular version of SQL we use here is described in the HSQLDB syntax documentation. I won't expect you to become expert in SQL, but I will have you use some standard SQL queries..

Here are the programs we developed