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...