[sqlite] Read-only main database and ATTACH

2011-01-09 Thread Bill Zissimopoulos
Hello, list: I am looking to understand the implications of using ATTACH with databases with different read-write permissions. I have a scenario where I need to access a large database (approx. 512MB) that resides in a read-only filesystem. There is also a small read-write database with the

Re: [sqlite] Read-only main database and ATTACH

2011-01-09 Thread Simon Slavin
On 9 Jan 2011, at 5:07am, Bill Zissimopoulos wrote: I am wondering then whether there are any particular gotchas related to attaching read-only and read-write databases that I should be aware of. I am looking at one of the following ATTACH scenarios: 1. Open the read-only database as