Re: [sqlite] Can't seem to create DB with unvacuumed data [ for testing ]

2013-10-11 Thread Paul L Daniels 
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 ]

2013-10-11 Thread Drake Wilson 
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 ]

2013-10-11 Thread Paul L Daniels 
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