NOWWORKINGON

sqlite-utils 3.28

CLI tool and Python utility functions for manipulating SQLite databases
https://sqlite-utils.datasette.io/en/stable/

pip install sqlite-utils

usage

– list all tables
sqlite-utils tables /home/ward/gPodder/Database
[{“table”: “podcast”},
{“table”: “episode”},
{“table”: “version”}]

sqlite-utils tables /home/ward/gPodder/Database –csv
table
podcast
episode
version
(first row is header)

– default is json :
sqlite-utils query /home/ward/gPodder/Database “select * from episode” > /mnt/temp/gpoder-epsjson.json
xed /mnt/temp/gpoder-eps

–
sqlite-utils query /home/ward/gPodder/Database “select * from episode” –tsv > /mnt/temp/gpoder-eps.tsv
xed /mnt/temp/gpoder-eps.tsv