Re: [sqlite] System.Data.SQLite and pooling problem

2012-04-29 Thread Joe Mistachkin
Greg Carter wrote: > > This way it's impossible for the pool to return an invalid handle. With > these changes our application runs without problems with pooling on. > Yeah, I noticed several potential race conditions when I looked at the connection pool code. However, that being said, I'm st

Re: [sqlite] System.Data.SQLite and pooling problem

2012-04-29 Thread Greg Carter
On 27 April 2012 11:39, Larry Brasfield wrote: > > When you use a collection of native code from managed code, and when that > native code has cleanup to do, defined by its own conventions rather than > the conventions established for the managed code system, you cannot count > on garbage collect

Re: [sqlite] the xRead method in sqlite3_io_methods

2012-04-29 Thread BaiYang
Here is the changed version a made for it: http://baiy.cn/tmp/sqlite.zip . Search "by BaiYang - add piRealAmt" to go through all changes I have made. With these simple changes, I could for example, write a simple VFS shim that implement data encryption by only adding decrypt algorithm for xRead,