Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Raspberry Pi Home Automation with Arduino - Second Edition

You're reading from   Raspberry Pi Home Automation with Arduino - Second Edition Unleash the power of the most popular microboards to build convenient, useful, and fun home automation projects

Arrow left icon
Product type Paperback
Published in Feb 2015
Publisher
ISBN-13 9781784399207
Length 148 pages
Edition 2nd Edition
Tools
Arrow right icon
Author (1):
Arrow left icon
Andrew K. Dennis Andrew K. Dennis
Author Profile Icon Andrew K. Dennis
Andrew K. Dennis
Arrow right icon
View More author details
Toc

Table of Contents (11) Chapters Close

Preface 1. An Introduction to the Raspberry Pi, Arduino, and Home Automation FREE CHAPTER 2. Getting Started – Setting Up Your Raspberry Pi and Arduino 3. Central Air and Heating Thermostat 4. Temperature Storage – Setting Up a Database to Store Your Results 5. Parcel Delivery Detector 6. Curtain Automation – Open and Close the Curtains Based on the Ambient Light 7. Water/Damp Detection – Check for Damp/Flooding in Sheds and Basements 8. Wrapping Up A. References 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...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Banner background image