Re: [sqlite] SQLite reading old data

2012-05-24 Thread Fabrizio Steiner
.@sqlite.org] Im Auftrag von Fabrizio Steiner > Gesendet: Freitag, 16. Dezember 2011 15:49 > An: General Discussion of SQLite Database > Betreff: Re: [sqlite] SQLite reading old data > > Yeah, I see the same two solutions. The first solution would also ensure > currently encrypte

Re: [sqlite] SQLite reading old data

2011-12-16 Thread Fabrizio Steiner
1 15:27 > An: 'General Discussion of SQLite Database' > Betreff: Re: [sqlite] SQLite reading old data > > I think the only solutions would be: 1) SQLIte changes so that it does not > use > a direct file read/write for the change counter. 2) Have the page-level > encryptor s

Re: [sqlite] SQLite reading old data

2011-12-16 Thread Michael Stephenson
: Thursday, December 15, 2011 3:00 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQLite reading old data The answers to your questions : 1)Yes I'm still using System.Data.SQLite but without any key. 2)No I don't use WAL. 3)Running only one thread didn't bring up

Re: [sqlite] SQLite reading old data

2011-12-15 Thread Fabrizio Steiner
he header? I've found no documentation about implementing the crypting api. Kind Regards Fabrizio > -Ursprüngliche Nachricht- > Von: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] Im Auftrag von Michael Stephenson > Gesendet: Donnerstag, 15. Dez

Re: [sqlite] SQLite reading old data

2011-12-15 Thread Michael Stephenson
Discussion of SQLite Database Subject: Re: [sqlite] SQLite reading old data I think the following observation, which I made in the meantime, may be very interesting. Which also gives a hint to a problem with SQLite in combination with the encryption of System.Data.SQLite. I tried the same test wi

Re: [sqlite] SQLite reading old data

2011-12-15 Thread Fabrizio Steiner
> Von: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] Im Auftrag von Igor Tandetnik > Gesendet: Donnerstag, 15. Dezember 2011 14:26 > An: sqlite-users@sqlite.org > Betreff: Re: [sqlite] SQLite reading old data > > Fabrizio Steiner wrote: > >

Re: [sqlite] SQLite reading old data

2011-12-15 Thread Igor Tandetnik
Fabrizio Steiner wrote: > I'm currently facing a problem with the System.Data.SQLite ADO.NET Provider. > I'm using stamps (simple integer column) on the rows > in order to detect if another user has altered the same datarow during the > time the first user started the edit and when he > invoked

[sqlite] SQLite reading old data

2011-12-15 Thread Fabrizio Steiner
Hello I'm currently facing a problem with the System.Data.SQLite ADO.NET Provider. I'm using stamps (simple integer column) on the rows in order to detect if another user has altered the same datarow during the time the first user started the edit and when he invoked the save. Every update incr