HTSQL

Hyper Text Structured Query Language (HTSQL) is a technology that allows us to write queries on the fly for our database and execute them via a URL. Developed by Clark Evans and Kirill Simonov of Prometheus Research, HTSQL is built upon the Python programming language and provides an HTTP-based query language that is translated into SQL. This allows us to write complex queries via the web browser, and allows queries to be embedded in client-side AJAX code without the need to write server-side applications.

Unlike SQL and server-side programming languages such as Java, a database with an HTSQL server running on it can be accessed via JavaScript or a web browser, such as Midori. The benefit of using this technology is that it cuts down on the amount of server-side code we have to write, and also provides us with a simpler syntax than SQL to query a database.

You might remember that we wrote the following SQL query to return the values in our Temperature table:

SELECT * FROM Temperature...