Chapter 4. Temperature Storage – Setting Up a Database to Store Your Results
In the next few chapters, the Raspberry Pi will act as a central control device to read data from our Arduino devices, control DC motors, and send e-mails. In this chapter, we will cover setting up a database on the Raspberry Pi using SQLite.
This SQL database will be a place to store the results from the temperature readings that we captured in the previous chapter. We will also look at HyperText Structured Query Language (HTSQL), a language that allows us to query our database via HTTP requests.
Along with these technologies, we will set up a Python script that grabs the temperature reading from the Arduino and writes it to the database. This script will be run periodically via a cron job.
For this chapter, you will need the following:
The Raspberry Pi you set up
Optionally, a monitor, keyboard, and mouse plugged into your Raspberry Pi if you don't plan to connect over SSH
The Arduino thermostat you built in the previous...
