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

Re: [webstorage] deleting a database

From: Ian Hickson <ian@hixie.ch>
Date: Thu, 26 Nov 2009 02:37:26 +0000 (UTC)
To: ATSUSHI TAKAYAMA <taka.atsushi@googlemail.com>
Cc: Joćo Eiras <joaoe@opera.com>, public-webapps@w3.org
Message-ID: <Pine.LNX.4.62.0911260236040.14150@hixie.dreamhostps.com>
On Wed, 25 Nov 2009, ATSUSHI TAKAYAMA wrote:
>
> (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

That seems like an implementation issue.


> 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.

I don't think that such a number would make much sense. Different 
implementations could have radically different space usage for the same 
data. If the database implementation is inefficient, that's an 
implementation issue, not a Web application issue.

-- 
Ian Hickson               U+1047E                )\._.,--....,'``.    fL
http://ln.hixie.ch/       U+263A                /,   _.. \   _\  ;`._ ,.
Things that are impossible just take longer.   `._.-(,_..'--(,_..'`-.;.'
Received on Thursday, 26 November 2009 02:38:00 GMT

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