Re: [sqlite] Opening an in-memory database in two connections, one read-write, one read-only.

On Sat, Apr 27, 2013 at 12:54 AM, Scott Hess wrote: > Someone over here was trying to use a shared-cache in-memory database with > two connections, one a read-write connection for purposes of populating > things, the other a read-only connection for purposes of letting a >

Re: [sqlite] Opening an in-memory database in two connections, one read-write, one read-only.

No comment? Do I need to recast the problem or something? Thanks, scott On Fri, Apr 26, 2013 at 9:54 PM, Scott Hess wrote: > Someone over here was trying to use a shared-cache in-memory database with > two connections, one a read-write connection for purposes of populating >

[sqlite] Opening an in-memory database in two connections, one read-write, one read-only.

Someone over here was trying to use a shared-cache in-memory database with two connections, one a read-write connection for purposes of populating things, the other a read-only connection for purposes of letting a (trusted) user make queries. They were surprised to find out that they could run