We demonstrated a simple method to write data to a database and to then be able to read it via our web browser. This combination of technologies leads us to all sorts of interesting possibilities. We could expand the SQLite3 database to hold more information on each of the rooms we plan to store data about, or we could expand our Python program to check whether the data being written to it is in the format we expect. We could also store humidity data.

HTSQL provides a variety of ways to write interesting queries that we can use in our web browser to check out our temperature readings. One of the benefits of HTSQL is that we can save these queries as bookmarks in our browser and use them whenever needed.

Hopefully, this chapter has generated interest in you to learn more about Python, HTSQL, and SQLite so that you can expand your home thermostat project further.

Next, we will look at setting up a parcel delivery detection device. We will be using the combination of the Arduino Uno and...