Skip to content

Instantly share code, notes, and snippets.

@kragen
Created April 27, 2015 22:36
Show Gist options
  • Save kragen/87a6fb68f88d7f08567b to your computer and use it in GitHub Desktop.
Save kragen/87a6fb68f88d7f08567b to your computer and use it in GitHub Desktop.

Fuck. Firefox's history UI is so fucking bad that this is actually fucking better:

: user@debian:~; sqlite3 places.sqlite 
SQLite version 3.7.13 2012-06-11 02:05:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .mode column
sqlite> select title, url, visit_count, datetime(last_visit_date/1000000, 'unixepoch') from moz_places order by last_visit_date desc limit 100;

Disable or remove Add-ons | Firefox Help  https://support.mozilla.org/en-US/kb/disable-or-remove-add-ons  1            2015-04-27 22:27:25                           
uninstall firefox extension - Buscar con  https://www.google.com.ar/search?q=uninstall+firefox+extension  1            2015-04-27 22:27:18                           
                                          https://www.google.com/search?q=uninstall+firefox+extension&ie  1            2015-04-27 22:27:18                           
syl20bnr/spacemacs                        https://github.com/syl20bnr/spacemacs                           1            2015-04-27 22:23:38                           
spacemacs - Buscar con Google             https://www.google.com.ar/search?q=spacemacs&ie=utf-8&oe=utf-8  1            2015-04-27 22:23:25                           
                                          https://www.google.com/search?q=spacemacs&ie=utf-8&oe=utf-8     1            2015-04-27 22:23:25                           
accessing history in a firefox addon - S  https://stackoverflow.com/questions/12901076/accessing-history  2            2015-04-27 22:21:09                           
@vxhare
Copy link

vxhare commented Sep 27, 2020

its terrible

@timwis
Copy link

timwis commented Dec 6, 2020

Literally googled "firefox history sucks" out of frustration and this was the top result.

@fidaay
Copy link

fidaay commented Jun 7, 2021

Literally googled "firefox history sucks" out of frustration and this was the top result.

I googled this too, the solution I've found: "Better History" an addon for Firefox

@Tachytaenius
Copy link

Literally googled "firefox history sucks" out of frustration and this was the top result.

Ikr, it's so validating isn't it

@fidaay
Copy link

fidaay commented Sep 20, 2021

@Thespikedballofdoom
Copy link

Got here by the same means everyone is. Utterly fucking useless history section. Firefox always fucking sucks. Never fixes anything that actually helps people. Maybe this will help someone: http://www.nirsoft.net/utils/mozilla_history_view.html

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment