I just resolved Bug 394108, which means Storage Explorer 0.1 is complete!
There are still several features I want to add such as database properties and data viewing, but right now it offers basic query execution. If you want to help, you can file bugs and/or submit patches!
6 replies on “Storage Explorer 0.1”
Just tried Storage Explorer on a recent Minefield nightly build (2007090205 Minefield/3.0a8pre).
It would be nice when the tables inside a database would be listed too. Now I should have a look at http://developer.mozilla.org/en/docs/Places:Design to find out what tables are inside.
Then one can also list the columns inside the table.
In the end one could right click on a table to retrieve all rows from it.
But this is only 0.1, so I guess we can expect more features in the future.
Or perhaps that goes beyond the features of this tool.
@Martijn
That’s actually what I plan on doing next with it :)
For the reference – links for developers. A project page on MDC or somewhere should be started too.
http://svn.mozilla.org/projects/mozStorage-explorer/trunk/
https://bugzilla.mozilla.org/buglist.cgi?query_format=advanced&product=Other+Applications&component=mozStorage+Explorer&resolution=—&chfieldto=Now
https://bugzilla.mozilla.org/enter_bug.cgi?product=Other%20Applications&component=mozStorage%20Explorer
@Nickolay
Created Wiki Page:
http://wiki.mozilla.org/Storage-Explorer
The Places ERD is at:
http://dietrich.ganx4.com/mozilla/places-erd.png
(Submitted as comment to http://surfmind.com/muzings/?p=120#comments)
I tried using Storage Explorer to pull data from Places, touching history, bookmarks, and favicons. Worked great.
Everything except moz_history_visits where session IDs & link visits are stored.
@AndyEd – There seems to be a typo in that ERD. The table is “moz_historyvisits” (no second underscore) – at least on my current install, Firefox 3.0a8pre.
Query to show the user table names in a given database:
SELECT name FROM sqlite_master
WHERE type=’table’