Re: [sqlite] Can't seem to create DB with unvacuumed data [ for testing ]
On Fri, 11 Oct 2013 23:15:24 -0500 Drake Wilson wrote: > Quoth Paul L Daniels , on 2013-10-12 > 13:57:00 +1000: > > I've tried the pragma autovacuum=0 and journalling set to none to > > no avail. Every time I exit from the command line SQlite3 tool I > > find that the data I explicitly deleted has genuinely been removed. > > > > Any suggestions? > > PRAGMA secure_delete=0 ? That did it nicely, many thanks for that. -- 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
Re: [sqlite] Can't seem to create DB with unvacuumed data [ for testing ]
Quoth Paul L Daniels , on 2013-10-12 13:57:00 +1000: > I've tried the pragma autovacuum=0 and journalling set to none to no > avail. Every time I exit from the command line SQlite3 tool I find > that the data I explicitly deleted has genuinely been removed. > > Any suggestions? PRAGMA secure_delete=0 ? ---> Drake Wilson ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Can't seem to create DB with unvacuumed data [ for testing ]
I'm trying to create a sqlite3 db with unvacuumed data in it so I can verify the functionality of my SQLite deleted data recovery tool "Undark", but would you believe, other than the iPhone databases that I've pulled from my phones I cannot seem to create a DB that has persistent deleted rows in it. I've tried the pragma autovacuum=0 and journalling set to none to no avail. Every time I exit from the command line SQlite3 tool I find that the data I explicitly deleted has genuinely been removed. Any suggestions? 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