Install SQLite3 for the light use of the database.
“SQLite3” refers the version 3. “SQLite” calls the legacy version 2. The old package sqlite is not available in Bullseye (you don't need it).

Install

# apt install sqlite3 libsqlite3-dev

No configuration is required.
SQLite3 is a file-based database. Unlike large-scale DBMS, backup/restore is very easy.

Full backup: copy sqlite file
Restore: replace sqlite file

Interface for PHP / Ruby

Like MariaDB, PHP and Ruby need interfaces. Python3 has SQLite3 interface by default.

# apt install php-sqlite3 ruby-sqlite3

Update History

2021-08-22

Correct some sentences
Add explanation for the weird package missing error