Re: [sqlite] Different read/write behaviour when using System.Data.SQLite .NET Wrapper and using database encryption through a password leads to data inconsistency

2013-09-05 Thread Brzozowski, Christoph
Joe Mistachkin Sent: Donnerstag, 5. September 2013 08:08 To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] Different read/write behaviour when using System.Data.SQLite .NET Wrapper and using database encryption through a password leads to data inconsistency Brzozow

Re: [sqlite] Different read/write behaviour when using System.Data.SQLite .NET Wrapper and using database encryption through a password leads to data inconsistency

2013-09-04 Thread Joe Mistachkin
Brzozowski, Christoph wrote: > > Our application uses the System.Data.SQLite .NET Wrapper ( version 1.0.66.0 ) > That version was released in April 2010 and is no longer officially supported. > > in a multi user scenario, where multiple users on different machines access the > same database, wh

Re: [sqlite] Different read/write behaviour when using System.Data.SQLite .NET Wrapper and using database encryption through a password leads to data inconsistency

2013-09-04 Thread Eric Minbiole
We ran into a similar issue while working on our own (semi-custom) SQLite encryption mechanisms. In my case, it was caused by the SQLite page cache reading the "File Change Counter" (Header page, offset 24) directly from the ciphertext *before* decrypting the page. (Presumably, this is done for e

[sqlite] Different read/write behaviour when using System.Data.SQLite .NET Wrapper and using database encryption through a password leads to data inconsistency

2013-09-04 Thread Brzozowski, Christoph
Hello, Our application uses the System.Data.SQLite .NET Wrapper ( version 1.0.66.0 ) in a multi user scenario, where multiple users on different machines access the same database, which lies on a network share, or in a single user scenario, where the database lies locally but is accessed simult