One would assume that clearing all the favicon.ico files out of Firefox 3 would be a simple task.

It isn’t.

Clearing your cache doesn’t work because the icons aren’t stored there. Rather it’s in a SQLite database called places.sqlite in your Firefox profile directory.

There are three ways to clear all favicons.

First method: Create a new Firefox profile. This is very annoying to do because you have to reset all your preferences for the new profile.

Second method: Delete all bookmarks, clear cache, start over. This is equally as annoying if not more.

Third method: Manually empty moz_favicons table from places.sqlite. With a Firefox plugin, this works and doesn’t require you to reset anything else.

(Fourth method: Use Favicon Picker plugin? Nope. This does not clear the cache for favicons all at once. Individual, yes. All at once, no.)

Here’s how to do the SQLite method:

Step 1.

Download the Firefox add-on SQLite Manager and install it.

Step 2.

Launch SQLite Manager by clicking Tools then SQLite Manager, like this:

Step 3.

From within SQLite Manager, click Database (top left) then Connect Database to bring the open dialog up. In the File Name field, type in %APPDATA%\Mozilla\Firefox, like this:

Press enter once.

Above: Open the Profiles folder.

There should be one profile folder present with an "odd" name like aDPa7219.default. Open that one up. When you do, you should see something similar to this:

Above: If you see this, open up places.sqlite.

Step 4.

Right-click the moz_favicons folder on the left and choose Empty Table, like this. DO NOT use "Drop table" as that will delete it entirely. You DO NOT want to do that. Choose to EMPTY it.

Click Yes when asked if you’re sure you want to delete all the records from moz_favicons, like this:

Step 4.

Close the SQLite Manager.

Close Firefox including any other Firefox windows you have open.

Restart Firefox.

All favicons are now cleared. Every single one of them. It’s a beautiful thing.

Final notes

None of your bookmarks will be touched; they will all still be there.

The places.sqlite file will still be at the same size it was before. So if you were expecting the file to get smaller, it won’t. However the favicon cache is cleared and that’s what matters.

Happy browsing, everyone.

Flickr, the ever popular photo sharing service, has had video available for some time but only for Pro (i.e. paid) members. I’ve used it a few times and it’s pretty decent. Granted, they only allow 90-second videos, but for many people that’s just about right.

Recently it was announced that anyone – including the free members – can now upload videos too. The only hitch is that freebie members can’t upload HD. But considering most people don’t do HD video at present, that’s okay.

Being that I’ve actually tried Flickr’s video sharing option myself, this is what I can say about it:

First, the load time is almost always faster compared to other video sharing sites.

Second, the interface is a whole lot cleaner.

Third, the way in which Flickr encodes videos does put emphasis on quality before speed (I personally appreciate this), yet still loads quickly.

Fourth, the Flickr community is above and beyond better than YouTube’s ever could be. And yes, this matters. If you want to be in the company of people more on the adult side, Flickr definitely trounces YouTube in that respect.

Give Flickr video a try, you might like it.