Re: [sqlite] External advisory locking ...

2006-05-20 Thread John Stanton
Mike, if you are going to implement a lock server, why not finish the job and include Sqlite in the server, then you will not have a problem. JS Mike Ashmore wrote: Hello all, I'm working on a system in which I'm using SQLite to open a number of database files and to perform operations on

Re: [sqlite] External advisory locking ...

2006-05-19 Thread Mike Ashmore
Alas, it's nowhere near so simple. There will be other processes that *can* be writing the file at the same time, so we still need an advisory locking mechanism. In case you were wondering, we're trying to implement row-level access control (using views and triggering write operations

Re: [sqlite] External advisory locking ...

2006-05-19 Thread drh
Mike Ashmore <[EMAIL PROTECTED]> wrote: > Hello all, > I'm working on a system in which I'm using SQLite to open a number of > database files and to perform operations on aggregate views of those > files. > > The problem I've got is, some of the files I want SQLite to open and > SELECT

Re: [sqlite] External advisory locking ...

2006-05-19 Thread Nuno Lucas
On 5/19/06, Mike Ashmore <[EMAIL PROTECTED]> wrote: [...] Since locking will require me to invoke (slow) IPC mechanisms, I don't want to send any more lock messages off to my lock server than absolutely necessary; any suggestions on how I should approach that? Try to look at the os_win.c file

[sqlite] External advisory locking ...

2006-05-19 Thread Mike Ashmore
Hello all, I'm working on a system in which I'm using SQLite to open a number of database files and to perform operations on aggregate views of those files. The problem I've got is, some of the files I want SQLite to open and SELECT from, I can only acquire read access to. And the