Weblog entry #264 for simonw

Firefox 3 - sqlite a mistake?
Posted by simonw on Thu 10 Jul 2008 at 12:40
Tags: ,
Aside from complaining others complained too much about Firefox 3...

I was somewhat surprised to see that the search plugins in FF3 are now also in a sqlite database (you can use a technology too much - is a database really appropriate here? Write rarely, read often, small XML files?).

Now I need to figure out how to import my Opensearch XML file into Sqlite (or how to host my custom search engine nicely just to import one search engine). Previously I could just copy the XML file into the relevant directory, and restart Firefox.

I need to import this because my home directory is on NFS, and something glitched, and my old profile then found itself incapable of using the disk as a cache (recreating the "Cache" directory didn't help here).

I'm think Firefox's decision to use sqlite was a mistake or possibly just poorly executed, that may have made it impractical in almost all set ups where user home directories are mounted (CIFS or NFS), which is a lot of corporate environments. Certainly they need to think about recovery and locking with sqlite more, blowing away, or manually recovering a profile backup every time something goes wrong is going to be exceedingly tedious - guess I can write a wrapper script for Firefox to do it for me but this isn't the Tao of software route.

I've abandoned trying to persuade it to use a local disk for Cache at the moment - which ought to help performance slightly - although hopefully most of the Cache is in buffer cache most of the time. Possibly local caching here is actually slower than using the local Squid proxy, but in that path through the code it renders the alt text before fetching the graphics (yuk). No doubt some obscure rendering parameter may help here.

Epiphany looks suddenly so attractive, and is so much faster on GNOME.

 

Comments on this Entry

Posted by ajt (204.193.xx.xx) on Thu 10 Jul 2008 at 15:07
[ Send Message | View Weblogs ]

SQLite is actually a nice little database it's written in c and is very fast, ideal to embed into another application. There is even a nice Perl front end to it and presumably other language bindings. Is it a mistake? I don't know but it is a decent little transactional database.

--
"It's Not Magic, It's Work"
Adam

[ Parent | Reply to this comment ]

Posted by Steve (82.41.xx.xx) on Sat 12 Jul 2008 at 12:26
[ Send Message | View Steve's Scratchpad | View Weblogs ]

Agreed. It makes parsing your history, and bookmarks, an awful lot easier too.

Steve

[ Parent | Reply to this comment ]

Posted by emeitner (216.170.xx.xx) on Mon 14 Jul 2008 at 04:34
[ Send Message | View emeitner's Scratchpad | View Weblogs ]
Yes. And thankfully the Mozilla devs plan on using it again to get rid of the hideous Mork format{shudder} used in Thunderbird address books. Ever tried to parse one of those?(If not, here is a good read: http://www.jwz.org/hacks/mork.pl )

[ Parent | Reply to this comment ]

Posted by simonw (89.16.xx.xx) on Tue 15 Jul 2008 at 18:54
[ Send Message | View Weblogs ]
Surely that is comparing it to the Firefox 2 mess which was a mangled html kind of thing (and mork for history).

Had they just switched to XML or YAML or any format you could just have written a one line Perl import without thinking you wouldn't care, and they could just read and write it as a simple file....

[ Parent | Reply to this comment ]

Posted by Anonymous (200.42.xx.xx) on Tue 15 Jul 2008 at 18:42
I think it's really helpful using a SQL database, just look at the bookmark tagging incorporated in FF3. But FF3 should allow changing to another SQL database, instead of using the sqlite that comes hardwired.

[ Parent | Reply to this comment ]

User Login

Username:

Password:

[ Advanced Login ]

Register Account

Quick Site Search