Re: [sqlite] Actually delete deleted rows from databasefile

Dan wrote: >> I tried two more inserts into the table, but the "two" string is still >> visible in the >> database file, the file instead grows. What is the rule for reusing a >> deleted block >> (if it is so)? > > I guess it depends on the size of the new records inserted how space is >

Re: [sqlite] Actually delete deleted rows from databasefile

On May 8, 2008, at 2:22 PM, Roar Bjørgum Rotvik wrote: > Hi, > > I see that when I perform a "delete from ..." to delete a row in > the database, the actual > data still remains in the database file. > > Creates a test database and insert some values: > # sqlite3 test.db > SQLite version 3.3.6

[sqlite] Actually delete deleted rows from databasefile

Hi, I see that when I perform a "delete from ..." to delete a row in the database, the actual data still remains in the database file. Creates a test database and insert some values: # sqlite3 test.db SQLite version 3.3.6 Enter ".help" for instructions sqlite> create table foo (a integer, b