Smart Cities - SQLite3 database: Difference between revisions
Jump to navigation
Jump to search
| Line 26: | Line 26: | ||
[[File:Screen Shot 2022-06-22 at 5.39.55 am.png | 900px]] | [[File:Screen Shot 2022-06-22 at 5.39.55 am.png | 900px]] | ||
= Creating a database and table in SQLite3 using DB Browser for SQLite = | |||
* Open the '''DB Browser for SQLite''' | |||
[[File:Screen Shot 2023-01-17 at 12.15.04 am.png | 900px]] | |||
* In the main menu, click on '''New Database''' | |||
* Navigate to the user home directory '''/home/pi''' | |||
* Enter the file name '''data.db''' | |||
* Click Save. | |||
[[File:Screen Shot 2023-01-17 at 12.16.35 am.png | 900px]] | |||
* Give the database Table the name '''measurements''' | |||
[[File:Screen Shot 2023-01-17 at 12.20.08 am.png | 900px]] | |||
Revision as of 13:21, 16 January 2023
Introduction
- SQLite3 is a single file database that is easy to install and access.
- It responds to SQL queries.
- Unlike other databases it does not require a database server.
- Because the SQLite3 database exists as a single file on a computer it is easy to copy and backup the database.
- Data kept on the database can be easily shared with students.
Installation of SQLite3 on Raspberry Pi
- In the Terminal enter the command sudo apt install sqlite3
Installing Database Browser software
- In the Terminal enter the command sudo apt install sqlitebrowser
- This will take approximately 30 seconds to install.
- Once the software is installed it will appear in the Raspberry Pi menu under Programming.
- The name of the program is DB Browser for SQLite
- This software gives complete access to the database to view and edit data.
Creating a database and table in SQLite3 using DB Browser for SQLite
- Open the DB Browser for SQLite
- In the main menu, click on New Database
- Navigate to the user home directory /home/pi
- Enter the file name data.db
- Click Save.
- Give the database Table the name measurements
