sqlite database
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
Reply to: