Book Image

Raspberry Pi Home Automation with Arduino - Second Edition

By : Andrew K. Dennis
Book Image

Raspberry Pi Home Automation with Arduino - Second Edition

By: Andrew K. Dennis

Overview of this book

Table of Contents (16 chapters)
Raspberry Pi Home Automation with Arduino Second Edition
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
4
Temperature Storage – Setting Up a Database to Store Your Results
Index

SQLite


SQLite 3.x is the latest version of the SQLite series of database technologies. Written in the C programming language, SQLite is a relational database management system that has continued to support more SQL standards as it progressed through several versions.

This means that many of the features you may be familiar with within SQL are available to use when creating a SQLite database.

SQLite has many uses, which include creating databases to embed in applications such as web browsers, or creating lightweight databases for embedded systems running on hardware such as the Raspberry Pi. It is also practical for small projects that do not require a very complex and maintenance-heavy RDMS, such as Oracle or MS SQL, and for those looking for a free and easy solution to store data.

Note

You can read more about the technology and the latest features it supports at http://www.sqlite.org/.

Installing SQLite Version 3.x

We will now walk through the process of installing SQLite on our Raspberry Pi...