sql query on tags in places.sqlites of firefox
Publié : 15 sept. 2018, 13:27
how to display bookmarks with the same tag labeled 'press_germany' from places.sqlite database?
I use the SQLite Manager extension as well as the DB Browser for SQLite software.
I do not see any table of tags, and I do not know how firefox creates these tags. All that I have found approaching my goal is in the following links:
I tried this query but it shows 0 results:
https://stackoverflow.com/questions/46 ... -structure,
https://superuser.com/questions/515090 ... ces-sqlite
I tried this query but it shows 0 results:
A places.sqlite schema if helpful:https://developer.mozilla.org/en-US/doc ... s/Database
Thanks.
I use the SQLite Manager extension as well as the DB Browser for SQLite software.
I do not see any table of tags, and I do not know how firefox creates these tags. All that I have found approaching my goal is in the following links:
I tried this query but it shows 0 results:
https://stackoverflow.com/questions/46 ... -structure,
https://superuser.com/questions/515090 ... ces-sqlite
I tried this query but it shows 0 results:
Code : Tout sélectionner
SELECT moz_places.url, moz_places.title
FROM moz_places
LEFT OUTER JOIN moz_bookmarks
ON moz_places.id = moz_bookmarks.fk
WHERE moz_bookmarks.title = 'press_germany'Thanks.