Smart Cities - SQLite3 database: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 13: | Line 13: | ||
= Installing Database Browser software = | = Installing Database Browser software = | ||
* In the Terminal enter the command '''sudo apt | * In the Terminal enter the command '''sudo apt install sqlitebrowser''' | ||
[[File:Screen Shot 2022-06-20 at 9.15.04 pm.png | 900px]] | [[File:Screen Shot 2022-06-20 at 9.15.04 pm.png | 900px]] | ||
| Line 19: | Line 19: | ||
* This will take approximately 30 seconds to install. | * This will take approximately 30 seconds to install. | ||
[[File:Screen Shot | [[File:Screen Shot 2023-01-17 at 12.11.41 am.png | 900px]] | ||
* Once the software is installed it will appear in the Raspberry Pi menu under Programming. | * Once the software is installed it will appear in the Raspberry Pi menu under Programming. | ||
Revision as of 13:12, 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.
