On Sat, 12 Oct 2013 22:15:21 -0400 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. Aaah, many thanks for that. Tree-from-the-forest clarity event. Curious that it doesn't seem to occur on the iOS SMS database file in the same way. Now time to get back to work on the Undark. Regards, Paul. -- Computer Repairs for Charters towers - http://ctpc.biz A.B.N. 19 500 721 806 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
