Based on Debian 11 "Bullseye" environment.


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).


# 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


  • Correct some sentences
  • Add explanation for the weird package missing error