Smart Cities - SQLite3 database: Difference between revisions

From Sensors in Schools
Jump to navigation Jump to search
(Created page with "= 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'''")
 
No edit summary
Line 8: Line 8:
= Installation of SQLite3 on Raspberry Pi =
= Installation of SQLite3 on Raspberry Pi =
* In the Terminal enter the command '''sudo apt install sqlite3'''
* In the Terminal enter the command '''sudo apt install sqlite3'''
[[File:Screen Shot 2023-01-16 at 11.58.37 pm.png | 900px]]

Revision as of 13:07, 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