Skip to content

zie [[linux-personal-db-mgt#SQLLITE]]

sqlite databases on lapwm

  • gPodder
  • adb android tool
  • tor bookmarks
  • zotero : /mnt/data/PKS/zotero/

wm

hh.sqlite

there are MUCH more sqlite db

TODO alle aanwezige sqlite databases oplijsten : [[find command|find]] op mimetype

path/to/dir/ => “/mnt/data/SYS/scripts/scripts.bash/1 find-locate/”
application/vnd.sqlite3

find   "/mnt/data/SYS/scripts/scripts.bash/1 find-locate/" -type f -exec sh -c '
    case $( file -bi "$1" ) in (*/x-shellscript*) exit 0; esac
    exit 1' sh {} \; -print

query tor db

query (for example) the titles and URLs :

sqlite3  /the/path/to/your/TorBrowser.app/TorBrowser/Data/Browser/profile.default/places.sqlite   "select moz_bookmarks.title, moz_places.url from moz_bookmarks, moz_places where moz_bookmarks.fk = moz_places.id;"