HTML5 Database administration / introspection?

Question

I'm playing around with html client side storage and wanted to know if there are any facilities for introspection of the database - is there an equivalent of sqlite ".tables" or ".schema" ?

Also, I'm not seeing my tables show up in AppData\Local\Apple Computer\Safari\LocalStorage . Is there another place tables are stored?

Answer 1

This is browser specific.

For Safari, you need Safari 4 -- they have a inspection tool(Figure 2-11) for that purpose.

Answer 2

Safari stores the tables in "AppData\Local\Apple Computer\Safari\Databases".

First Databases.db is an sqlite3 database with 2 tables.

Origins tracks what site created the database and maximum storage for that database.

Databases tracks the specific databases and their folder, common and file name

I use sqlite3 command line tool or sometimes SQLite Administrator. Any sqlite3 app will do.

Your database will be in a subfolder like http_exeample_com_0\00000000003.db

Answer 3

select * from sqlite_master;

That table has columns for type ('table' or 'index'), name, tbl_name, sql (the equivalent of what .schema outputs)