Re: [webstorage] deleting a database

(Re-sending because I accidentally replied personally...)

> Deleting all the data in the database (i.e. dropping all the tables)

SQLite 3 does not vacuum the database file when you drop a table.
http://www.sqlite.org/lang_droptable.html

If you repeat create and drop tables, you will hit the database file
size limit after possibly a long time. If this occurred only on a
client side (i.e. not in the test environment), web developers
wouldn't know that an error is occurring.

Therefore, it would be nice to have a method to tell how much size the
database is using.

A. Takayama

Received on Thursday, 26 November 2009 03:40:21 UTC