Based on Debian 10 "Buster" environment.

SQLite3

Install SQLite3 for the light use of the database.
“SQLite3” refers the version 3. “SQLite” calls the legacy version 2. Here we install only version 3.

Install

# apt install sqlite3​​​​​ libsqlite3-dev

No configuration required.
SQLite3 is a file-based database. Unlike large scale DBMS, full backup is just copying the file, delete database can be done by deleting the file.

libsqlite3-dev is not a must, but you'll need them when you work with Ruby on Rails.


Interface for PHP / Ruby

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

# apt install php-sqlite3 ruby-sqlite3