Smart Cities - SQLite3 database: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 10: | Line 10: | ||
[[File:Screen Shot 2023-01-16 at 11.58.37 pm.png | 900px]] | [[File:Screen Shot 2023-01-16 at 11.58.37 pm.png | 900px]] | ||
= Installing Database Browser software = | |||
* In the Terminal enter the command '''sudo apt-get install sqlitebrowser''' | |||
[[File:Screen Shot 2022-06-20 at 9.15.04 pm.png | 900px]] | |||
* This will take approximately 30 seconds to install. | |||
[[File:Screen Shot 2022-06-20 at 9.15.40 pm.png | 900px]] | |||
* 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. | |||
[[File:Screen Shot 2022-06-22 at 5.39.55 am.png | 900px]] | |||
Revision as of 13:10, 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-get 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.
