A man with a mission...

Storage Explorer 0.1

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!

Here is the version 0.1 build.

September 2, 2007 | Filed Under Mozilla 

comments

6 Responses to “Storage Explorer 0.1”

  1. Martijn on September 2nd, 2007

    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.

  2. Shawn Wilsher on September 2nd, 2007

    @Martijn

    That’s actually what I plan on doing next with it :)

  3. Nickolay Ponomarev on September 2nd, 2007

    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

  4. Shawn Wilsher on September 3rd, 2007

    @Nickolay

    Created Wiki Page:
    http://wiki.mozilla.org/Storage-Explorer

  5. AndyEd on September 3rd, 2007

    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.

  6. George Rypysc on September 13th, 2007

    @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’