Tip: How to quickly transform Firefox/Iceweasel/Icecat bookmarks to Org file

Tip: How to quickly transform Firefox/Iceweasel/Icecat bookmarks to Org file

[Jean Louis]

As Firefox and derived browsers store bookmarks in the file
`places.sqlite' one may access the file with `sqlite3' utility and use
SQL query to get a list of all bookmarks and transform them into Org
file.

1. Locate your `places.sqlite' file on your system, it must be in your
   Firefox profile. As I am using Hyperbola GNU/Linux-libre it is in
   `~/.hyperbola/iceweasel/uxp/PROFILE-NAME-HERE/places.sqlite'

2. Use the `sqlite3' command and the script below to export to
   `captured.org'

$ sqlite3 ~/.hyperbola/iceweasel-uxp/co46wr2o.default/places.sqlite "SELECT moz_places.title, moz_places.url FROM moz_places, moz_bookmarks WHERE moz_places.id = moz_bookmarks.fk AND moz_places.title IS NOT NULL;" | gawk -F \| '{ print "* " $1 "\n\n[["$2"]["$1"]]\n"}' > captured.org

That is very handy as it produces a file like below:

* linux - Can I spy on an X-session if I am logged in as root? - Server Fault

[[https://serverfault.com/questions/268518/can-i-spy-on-an-x-session-if-i-am-logged-in-as-root][linux - Can I spy on an X-session if I am logged in as root? - Server Fault]]

* Howto: Remote the native X server (i.e. the ":0" X display) using VNC [Archive] - Ubuntu Forums

[[https://ubuntuforums.org/archive/index.php/t-279069.html][Howto: Remote the native X server (i.e. the ":0" X display) using VNC [Archive] - Ubuntu Forums]]

* Tensor tympani muscle - Wikipedia

[[https://en.wikipedia.org/wiki/Tensor_tympani_muscle#Voluntary_control][Tensor tympani muscle - Wikipedia]]

* Logo and Natural Language

[[https://el.media.mit.edu/logo-foundation/what_is_logo/logo_and_natural_language.html][Logo and Natural Language]]