I have a few thousand bookmarks in Firefox, many of which are tagged with
project_ tags. I use these to bookmark material for future reference on subjects which I want read more about at some future date…
It turns out I’ve now got rather a lot of these project tags, and between them many hundreds of bookmarks. The bookmarks sit there, accumulating, waiting to fulfill their destiny and provide me with sweet, sweet knowledge.
To encourage myself to make some decisions about which are worth pursuing I wanted to get a list of these various project tags, together with a count of how many bookmarks I have saved for each.
Firefox stores bookmarks in a SQLite database called
places.sqlite which can be perused with any SQLite capable database manager. I used the SQLite Manager add-on because it does exactly what I needed.
Find tags by pattern
Count bookmarks for a given tag
Find tags and count by pattern
After a few attempts I managed to combine these two into the final query that gives me the numbers I wanted: