As an alternative to client-server database managers, such as mysql, mariadb, postgresql, etc. , the sqlite embedded database manager is very useful ....
https://en.wikipedia.org/wiki/SQLite sqlite - wikipedia https://sqlite.org sqlite - home page https://sqlite.org/cli.html sqlite - command line interface http://zetcode.com/db/sqlite/ sqlite - zetcode tutorial sqlite is readily available from the debian repositories .... $ apt show sqlite3 $ sudo apt install sqlite3 $ apt policy sqlite3 # create a database and a database table $ sqlite3 /tmp/atest.sql3 sqlite> create table lookup ...> ( ...> id integer , ...> value text ...> ) ; sqlite> sqlite> -- insert some data -- sqlite> sqlite> insert into lookup( id , value ) values( 1 , 'line 1' ) ; sqlite> insert into lookup( id , value ) values( 2 , 'line 2' ) ; sqlite> insert into lookup( id , value ) values( 3 , 'line 3' ) ; sqlite> sqlite> -- turn on column mode and headers -- sqlite> sqlite> .mode columns sqlite> .headers on sqlite> sqlite> -- query the database -- sqlite> sqlite> select id , value from lookup ; id value ---------- ---------- 1 line one 2 line two 3 line tre -- Stanley C. Kitching Human Being Phoenix, Arizona