SQLite temperature logging on a Raspberry Pi

Recently I’ve written tutorials about database programming and CGI programming on a Raspberry Pi. I wanted to write a tutorial that builds on the ideas in earlier posts, so I built a temperature logging system that stores data in an SQLite database, and displays the contents of the database graphically in a web page.

I built a temperature logging system using a Raspberry Pi and a DS18B20 connected to the GPIO pins. I wrote a web script to query the database and display the temperature as a graph. The web UI also displays minimum, maximum and average temperatures. Follow this link to see how I built the Raspberry Pi temperature logger.

Here’s a screenshot of the web UI:

Raspberry Pi web UI

Raspberry Pi web UI for SQLite temperature logging system.

I’ve also written an article about getting a Raspberry Pi web server on-line. ¬†This is a brief guide to making a Raspberry Pi web site visible on line.

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s