Transform Mozilla Bookmarks into a list

You have seen that I begin to post “friday links”

It is simple,once you have SqlLite Manager add-on for FF. ( add-on,source)

Just run the following query ( for the last 7 days bookmarks) by selecting “places.sqllite”:

SELECT 
&quot;&lt;p&gt;&lt;a target='_blank' href='&quot; || moz_places.url  || &quot;'&gt;&quot; || moz_bookmarks.title || &quot;&lt;/a&gt;&lt;/p&gt;&quot;

FROM moz_bookmarks Inner JOIN moz_places WHERE moz_bookmarks.fk = moz_places.id AND moz_bookmarks.title != &quot;null&quot; 
and last_visit_date BETWEEN  strftime('%s',date('now','-7 day'))*1000000 and strftime('%s',date('now'))*1000000 
and dateAdded BETWEEN  strftime('%s',date('now','-7 day'))*1000000 and strftime('%s',date('now'))*1000000

(OK,I must know why I multiply by 1000000 – but,hey – it works ….)

Posted

2011-11-28

addons, mozilla, quick and dirty

ignatandrei

Tags:

Comments

One response to “Transform Mozilla Bookmarks into a list”

Andrei Ignat

2011-12-01

SELECT 
"<p><a target='_blank' href='" || moz_places.url  || "' rel='nofollow'>" || moz_bookmarks.title || "</a></p>"	 
FROM moz_bookmarks Inner JOIN moz_places WHERE moz_bookmarks.fk = moz_places.id AND moz_bookmarks.title != "null"
and parent in
( select id from moz_bookmarks 
where  title like '%YOUR FOLDER HERE%'
)

Transform Mozilla Bookmarks into a list

Comments

One response to “Transform Mozilla Bookmarks into a list”

Leave a Reply to Andrei Ignat Cancel reply