Docu review done: Wed 31 Jul 2024 02:39:49 PM CEST

sqlite

Table of Content

Open the file with sqllite direte

$ sqlite3 -column -header ./path/to/sqlitefile

Or, you can first run sqlite without defining the database file and load then the db file

$ sqlite3 -column -header
SQLite version 3.34.1 2021-01-20 14:10:07
Enter ".help" for usage hints.
sqlite>

sqlite> .open ./path/to/sqlitefile

If you have now a look into the loaded databases with by using .database you will see that your newly added one is showing up

sqlite> .databases
main: /home/myawesomeuser/sqlitedbs/path/to/sqlitefile r/w

main indicates that this is the default database

Now lets see what tables are exiting in the database

sqlite> .tables
CHNL     SRV      SRV_FAV  SRV_IP

The rest is standard sql ;)