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                           
@kragen
Copy link
Author

kragen commented May 1, 2015

Aristotle points out that Firefox has a non-sidebar history UI, under History→ Show All History, which actually has the features I was missing (like the ability to see and sort by the time of the most recent visit).

@ap
Copy link

ap commented May 1, 2015

Also I enthusiastically agreed that the sidebar history viewer blows hard, once I remembered that it even exists, which I had forgotten because I never use it, which is because, well, it blows hard.

So this story ends with happy @kragen, hopefully. 😃

@databoose
Copy link

Even 5 years later it's still garbage.

I came here to spit as well. What a shame because the rest of the browser is great.

@nestcx
Copy link

nestcx commented Aug 21, 2020

is there a reason for it being so shockingly unusable? it doesn't just look bad, it is genuinely difficult to use.

@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