IoT & Hardware
Reader small image

You're reading from  Raspberry Pi Home Automation with Arduino - Second Edition

Product typeBook
Published inFeb 2015
Publisher
ISBN-139781784399207
Edition1st Edition
Tools
ArduinoRaspberry Pi
Concepts
Home Automation
Right arrow
Author (1)
Andrew K. Dennis
Andrew K. Dennis
author image
Andrew K. Dennis

Andrew K. Dennis is a full stack and cybersecurity architect with over 17 years' experience who currently works for Modus Create in Reston, VA. He holds two undergraduate degrees in software engineering and creative computing and a master's degree in information security. Andy has worked in the US, Canada, and the UK in software engineering, e-learning, data science, and cybersecurity across his career, and has written four books on IoT, the Raspberry Pi, and supercomputing. His interests range from the application of pataphysics in computing to security threat modeling. Andy lives in New England and is an organizer of Security BSides CT.
Read more about Andrew K. Dennis

Right arrow

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 page is locked
Previous Page
Chapter 10 of 16, Page 3
Next Page
You have been reading a chapter from
Raspberry Pi Home Automation with Arduino - Second Edition
Published in: Feb 2015Publisher: ISBN-13: 9781784399207
© 2015 Packt Publishing Limited All Rights Reserved

Author (1)

author image
Andrew K. Dennis

Andrew K. Dennis is a full stack and cybersecurity architect with over 17 years' experience who currently works for Modus Create in Reston, VA. He holds two undergraduate degrees in software engineering and creative computing and a master's degree in information security. Andy has worked in the US, Canada, and the UK in software engineering, e-learning, data science, and cybersecurity across his career, and has written four books on IoT, the Raspberry Pi, and supercomputing. His interests range from the application of pataphysics in computing to security threat modeling. Andy lives in New England and is an organizer of Security BSides CT.
Read more about Andrew K. Dennis

Personalised recommendations for you

Based on your interests and search pattern

Architectural Patterns and Techniques for Developing IoT Solutions

Architectural Patterns and Techniques for Developing IoT Solutions

This book covers all the patterns and considerations that give you both the power and flexibility to build scalable, secure, and performant IoT solutions by combining various patterns in interesting ways. It also lists the benefits of combining IoT with technologies like blockchain, 3D-printing, 5G, Generative AI, quantum computing, and LLMs.

BookSep 2023304 pages
Arduino Data Communications

Arduino Data Communications

Arduino Data Communication focuses on IoT’s Internet aspect, guiding you in setting up your own infrastructure for storing and managing the data collected from sensors. This book goes beyond microcontroller basics, equipping you with the knowledge essential for building real-world projects.

BookNov 2023286 pages5
Arduino IoT Cloud for Developers

Arduino IoT Cloud for Developers

From fundamental principles to advanced techniques, this comprehensive book equips you with the knowledge and skills needed to design and deploy IoT applications seamlessly. Explore cloud integration, best practices, and real-world projects to harness the full potential of IoT application development with the Arduino IoT Cloud.

BookNov 2023402 pages
The Azure IoT Handbook

The Azure IoT Handbook

Building IoT Systems with Azure IoT is a comprehensive introduction for those who are new to the Internet of Things and looking to get up to speed in no time. This book will teach you how to create and develop IoT solutions with intelligent edge-to-cloud technologies in the Azure cloud.

BookDec 2023248 pages