Smart Cities - SQLite3 database

From Sensors in Schools
Revision as of 13:10, 16 January 2023 by EdmondLascaris (talk | contribs)
Jump to navigation Jump to search

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.

Retrieved from "http://www.waterwaysinwhittlesea.org/index.php?title=Smart_Cities_-_SQLite3_database&oldid=5416"