And in completely different news...

[nonethefewer]

Firefox 3 is ♥.  Today's adoration is for how it remembers what phrase I typed to get which URL.  For example, when I type 'rea', it pulls up the Google Reader URL, and when I type 'read', it brings up my reading page here.  *claps hands*

I had to train it a lot to get that example, though, as I'd spent ages typing in 'rea' and 'read' to get Google Reader.  Fifty million times later, I finally trained it to distinguish between the two URLs.

You know what's fun?  By which I mean to say, fun for me?  Installing SQLite Manager, and watching the phrase/URL counts change.

* Install that addon.
* Go to Tools > SQLite Manager.
* Go to Database > Connect Database.  This is where I go to; yours may be different:
  C:\Documents and Settings\[user name]\Application Data\Mozilla\Firefox\Profiles\[profile folder]\
* In there, open places.sqlite.
* Click on the Execute SQL tab, and type this query in the box:

select h.input, h.use_count, p.url
from moz_inputhistory h
left join moz_places p on p.id = h.place_id

* Filter on whatever you like to get the results you need.  Using my above example, I'd want to see everything where I type in at least 'rea' to get it (covering both 'rea' and 'read'):

select h.input, h.use_count, p.url
from moz_inputhistory h
left join moz_places p on p.id = h.place_id
where h.input like 'rea%'

--

I still don't know why the numbers aren't integers, and why there are sometimes multiple entries for the same URL.  But hey, tinkering!  I like tinkering.  And I love SQL, so, bonus.