How to Use SQLite on Raspberry Pi

Having a database comes in handy in some Raspberry Pi projects. SQLite gives you a lightweight database with Structured Query Language.

Install SQLite

sudo apt-get install sqlite3

Install SQLite Browser (Desktop app).

sudo apt-get install sqlitebrowser

Start Raspberry Pi Desktop and test SQLite Browser.

Python have access to SQLite by importing library.
Start Python environment.

python3

Import SQLite library.

import sqlite3

Exit Python environment.

quit()
OTHER TUTORIALS
High-level Steps: Prepare a Micro SD Card Download Raspbian ImageFlash the SD CardStart Raspberry Pi and Configure Find Raspberry Pi ...
There are a few different types of accessing Raspberry Pi remotely. In this post I'll introduce the following types: SSH ...
When you experimenting with Raspberry Pi, you often wish to go back to a "clean" working state, especially after messing ...
Raspberry Pi itself already has a lot of potential but with Camera, it makes even more interesting. You can easily ...
OpenCV is an Open Source Computer Vision and Machine Learning software library.With a bit of Python programming, you can turn ...
Having a database comes in handy in some Raspberry Pi projects. SQLite gives you a lightweight database with Structured Query ...
LCD Screen is a much more effective way to communicate the current status with a user, compare to beeping sound ...
Although there are few options for wired audio out from Raspberry Pi, a wireless Bluetooth speaker may be useful for ...
Don't you love robotic voice coming out from Raspberry Pi?Pico Text-to-Speech engine will give Raspberry Pi ability to speak without ...
Raspberry Pi Zero has HDMI, Bluetooth and USB for potential Audio Outputs but it is missing PWM audio output compared ...