The other day while working I realized how annoying it can be to debug some mozStorage issues. Enter mozStorage Explorer. It’s a simple little addon I wrote that lets you run queries on databases found in your profile. Right now that’s all it does, but in the future I plan to let it browse data too (as soon as I figure how out how to list all the tables in a database).
I’ve tossed it up here for those of you who want to play with it. Suggestions welcome!
8 replies on “mozStorage Explorer”
> n the future I plan to let it browse data too (as soon as I
> figure how out how to list all the tables in a database).
Hi Shawn
This might help:
How do I list all tables/indices contained in an SQLite database?
http://www.sqlite.org/faq.html#q7
Cheers
Rich
There’s already a Storage Inspector with browsing capability on amo, actually.
– Chris
Do you know the storage inspector extension?
https://addons.mozilla.org/de/firefox/addon/3072
It lists all *.sqlite files in your profile and browse the data in there. There’s no way to manipulate it, however.
Hmm, xpi link is 404 for me.
I assume you mean http://files.shawnwilsher.com/2007/8/19/mozStorage-explorer.xpi ? not http://shawnwilsher.com/archives/files.shawnwilsher.com/2007/8/19/mozStorage-explorer.xpi
Have you tried the storage inspector extension. I find it very useful. The only problem I have with it, is that it can’t show the columns if a table has no data.
Link fixed – that’s what I get for doing a late night post :/
@comment 2, 3, and 6 – The current version of storage inspector (0.5) didn’t allow installation on Firefox 3.0a7pre and although it nicely displays all table contents, you can’t enter adhoc SQL queries, unlike (moz)Storage Explorer.