Skip to Content
Raspberry Pi 3 Cookbook for Python Programmers - Third Edition
book

Raspberry Pi 3 Cookbook for Python Programmers - Third Edition

by Steven Lawrence Fernandes, Tim Cox
April 2018
Beginner content levelBeginner
552 pages
13h 58m
English
Packt Publishing
Content preview from Raspberry Pi 3 Cookbook for Python Programmers - Third Edition

Capturing data in an SQLite database

Databases are a perfect way to store lots of structured data while maintaining the ability to access and search for specific data. Structured Query Language (SQL) is a standardized set of commands to update and query databases. For this example, we will use SQLite (a lightweight, self-contained implementation of an SQL database system).

In this chapter, we will gather raw data from our ADC (or local data source) and build our own database. We can then use a Python library called sqlite3 to add data to a database and then query it:

 ## Timestamp 0:Light 1:Temperature 2:External 3:Potentiometer 0 2015-06-16 21:30:51 225 212 122 216 1 2015-06-16 21:30:52 225 212 148 216 2 2015-06-16 21:30:53 225 212 113 216 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Raspberry Pi for Python Programmers Cookbook - Second Edition

Raspberry Pi for Python Programmers Cookbook - Second Edition

Tim Cox

Publisher Resources

ISBN: 9781788629874Supplemental Content