O'Reilly logo

Raspberry Pi Home Automation with Arduino by Andrew K. Dennis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 6. Temperature Storage – Setting up a Database to Store Your Results

In this chapter, we will cover setting up a database on your Raspberry Pi using SQLite. This SQL-based database will be used for storing 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 you to query your database via HTTP requests.

Along with these technologies, we will set up an Apache web server running Python via WSGI —a server-side programming language that we can use to run SQL queries against our database.

Let's get started, our first step will be to install SQLite Version 3.x and set up our temperature database.

SQLite

SQLite Version 3.x is ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required