Using a Mozilla XULrunner application to edit your Sqlite databases

I have needed a tool to edit/change sqlite database, and have been using this great Firefox extension, but it requires you to load Firefox, which I don't always do while I'm testing Chromium. You can get this great extension here:

Sqlite Manager

So I noticed today, that they also offer a downloadable version which works just with XULrunner on it's own. It's not that surprising as many extensions leverage the power of this component, but it means you can launch this on it's own , which is handy.

So all you do is download the zip file, and make sure you have XULrunner-1.9.1 from your favourite Linux repository and unzip the file where you want, /opt is a good place for most.

Then just add a launcher on your desktop to start the application like this:


/usr/bin/xulrunner-1.9.1 /opt/sqlitemanager/application.ini (or where you unzipped it)

Voila, you have a great utility ready to run.

In the picture above I'm having a look at the cookies I've downloaded while testing Firefox 3.5.2

I also came across this web site while checking out how this fitted together, which gives you a good intro into developing your own XULrunner apps.

Howto create your own XUL applications

Excellent straight forward guide to sqlite

While doing some work on the Firefox sqlite files, I wanted a good guide on how to manipulate the data.

As a O'Reilly on-line Safari library user , I did a search on books that contained any sections on this, and the best one I have found so far is the Appendix contained in the "Android wireless application development" book. This might seem like a strange place, but as Android uses a lot of sqlite, it is not that surprising.

One of the great things about Safari is that you can just download the chapter you are after as a pdf, which is just what I have done.

So, if you need a great , easy to follow guide on the subject, I can certainly recommend this one.