Export Awesomebar history in Firefox

Question

Is there any way to export the history information from the Firefox address bar into a file?

I have been searching for docs online, but cannot find a solution.

Thanks!

Answer 1

This post shows how to clear the SQLite database of contents. You should be able to execute some show tables, select * to get the content.

Answer 2

The bookmark data is going to be located in %appdata%\Mozilla\Firefox\Profiles[randomcharacters].default\places.sqlite (or whatever your profile is instead of default). The moz_places table should be what you're interested in. SQLiteSpy works for taking a peek at it, though another program might have more robust options for extracting and exporting the data in the way you want. Though if you can't find one, you could just use a programming interface like System.Data.SQLite to extract the data.