W3C home > Mailing lists > Public > public-webapps@w3.org > October to December 2009

Re: [webstorage] deleting a database

From: ATSUSHI TAKAYAMA <taka.atsushi@googlemail.com>
Date: Wed, 25 Nov 2009 21:32:43 -0500
Message-ID: <9cef076f0911251832t4d6ef08frd120ebcac3c718bf@mail.gmail.com>
To: Joćo Eiras <joaoe@opera.com>
Cc: Ian Hickson <ian@hixie.ch>, public-webapps@w3.org
(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 GMT

This archive was generated by hypermail 2.3.1 : Tuesday, 26 March 2013 18:49:35 GMT