Smart Cities - SQLite3 database

From Sensors in Schools
Revision as of 13:07, 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