How to delete duplicates in the bookmarks of Firefox 32

August 13, 2015

sqlite3 ~/.mozilla/firefox/hcptd00g.default-1397806778756/places.sqlite

sqlite> delete from moz_bookmarks where id not in (select min(id) from moz_bookmarks where fk is not null group by fk) and fk is not null

moz_bookmarks has a fk field which is a foreign key to moz_places table.

moz_places holds the URLs.

Previous: How to setup Lisp development in Windows Next: PDF to images without Adobe Acrobat or anything