HSQLDB
default database van libre office base (? .odb files ?)
https://en.wikipedia.org/wiki/HSQLDB
requires JRE , which is annoying
wm : do not use HSQLDB , it is ms access like
SQLLITE
in process db, fast & low in resources
not std in linux , but often installed by apps
install it yourself : sudo apt-get install sqlite3
https://www.sqlitetutorial.net/ (there are a few differences between ANSi sql and sqlite )
mgt via shell tools
- standard with sqlite install
sqlite3 --help
https://www.sqlite.org/cli.html - sqlite-utils
python library
db files
- mimetype : SQLite3 database (application/vnd.sqlite3)
- no file extention, commonly used : .sqlite, .db, .db3 wm : .sqlite