SQLite database for sensor data in Raspberry Pi - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is SQLite and why is it suitable for storing sensor data on a Raspberry Pi?

SQLite is a lightweight, file-based database engine. It is suitable for Raspberry Pi because it requires no server setup, uses minimal resources, and stores data locally, making it ideal for small sensor data projects.

beginner

Which Python module is commonly used to interact with SQLite databases on Raspberry Pi?

The 'sqlite3' module is commonly used in Python to create, read, update, and delete data in SQLite databases on Raspberry Pi.

beginner

What is the purpose of the SQL command 'CREATE TABLE' in the context of sensor data?

'CREATE TABLE' defines a new table structure in the database to store sensor readings, specifying columns like timestamp, sensor type, and value.

beginner

Why should sensor data entries include a timestamp?

Timestamps record when each sensor reading was taken, allowing tracking of data over time and analysis of trends or events.

beginner

How do you insert a new sensor reading into an SQLite database using Python?

Use a SQL 'INSERT INTO' statement with parameters in Python's sqlite3 module, then commit the transaction to save the data.

Which command creates a new table in an SQLite database?

A INSERT INTO

B SELECT

C CREATE TABLE

D UPDATE

'CREATE TABLE' is used to define a new table structure in the database.

What Python module do you use to work with SQLite on Raspberry Pi?

A os

B pandas

C math

D sqlite3

The 'sqlite3' module provides functions to interact with SQLite databases.

Why is it important to include a timestamp with sensor data?

A To increase database size

B To know when the data was recorded

C To make data unreadable

D To slow down data insertion

Timestamps help track when each sensor reading was taken.

Which SQL command adds new data to a table?

A INSERT INTO

B CREATE TABLE

C DELETE

D DROP TABLE

'INSERT INTO' adds new rows of data to a table.

What is a key advantage of SQLite on Raspberry Pi for sensor data?

A No need for a separate database server

B Requires internet connection

C Only works with large data sets

D Needs complex setup

SQLite stores data in a file and does not require a separate server.

Explain how to set up an SQLite database on Raspberry Pi to store sensor data.

Think about the steps from Python code to saving data.

Describe why SQLite is a good choice for logging sensor data on a Raspberry Pi.

Consider resource use and simplicity.