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. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
