On Sat, Oct 12, 2013 at 10:15 PM, Richard Hipp <d...@sqlite.org> wrote:
> > > > On Sat, Oct 12, 2013 at 10:06 PM, Paul L Daniels > <pldani...@pldaniels.com>wrote: > >> >> Intact record, before removal; >> 81 16 86 30 05 1D 47 81 65 52 45 4D 4F 56 45 4D ...0..G.eREMOVEM >> >> Removed using sqlite3 cli [ Ubuntu 13.04 ], secure_delete = 0; >> 00 00 00 9A 05 1D 47 81 65 52 45 4D 4F 56 45 4D ......G.eREMOVEM >> > > It inserted a "freelist" record. 2-byte offset to the next block of > freespace (in this case zero since it is the last free block on the chain) > followed by a 2-byte size for this block (154 bytes in this case). So even > with secure_delete=OFF, the first four bytes of a deleted record are often > overwritten. > The use of these 2-byte values is why the maximum page size in SQLite is 65536, btw. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users