Re: [sqlite] File locking requirements in Single Process/Multi-Threaded system

2012-02-07 Thread Marc L. Allen
> The methods on the VFS open-file > objectthat do reading and > writing specify both the amount and the offset. There are no seeks. Oh, yeah. :( Sorry. I've even implemented those routines. > The open succeeds. xLock() does not interact with any ot

Re: [sqlite] File locking requirements in Single Process/Multi-Threaded system

2012-02-07 Thread Richard Hipp
> > Marc > > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto: > sqlite-users-boun...@sqlite.org] On Behalf Of Richard Hipp > Sent: Tuesday, February 07, 2012 3:09 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] File

Re: [sqlite] File locking requirements in Single Process/Multi-Threaded system

2012-02-07 Thread Marc L. Allen
Hipp Sent: Tuesday, February 07, 2012 3:09 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] File locking requirements in Single Process/Multi-Threaded system On Tue, Feb 7, 2012 at 2:42 PM, Marc L. Allen wrote: > I'm trying to use sqlite in an embedded, multi-tasking sys

Re: [sqlite] File locking requirements in Single Process/Multi-Threaded system

2012-02-07 Thread Richard Hipp
On Tue, Feb 7, 2012 at 2:42 PM, Marc L. Allen wrote: > I'm trying to use sqlite in an embedded, multi-tasking system with a very > simple file system. Essentially, it doesn't support having a file open > multiple times. That is, only one reader or writer. > > I have studied the code, but I can

[sqlite] File locking requirements in Single Process/Multi-Threaded system

2012-02-07 Thread Marc L. Allen
I'm trying to use sqlite in an embedded, multi-tasking system with a very simple file system. Essentially, it doesn't support having a file open multiple times. That is, only one reader or writer. I have studied the code, but I can't quite tell how sqlite manages the DB files in a single pr