Re: [sqlite] SQLite Application Server Concurrency

2018-01-13 Thread Dinu
James, You don't need to go all the length to creating a sqlite proxy RPC as has been suggested. Your service could implement one thing only - a lock to the database file (external to the SQLite locking mechanism, of course). So it only needs to serialize concurrency; the client does the RPC (via

Re: [sqlite] SQLite Application Server Concurrency

2018-01-11 Thread James Colehan
] On Behalf Of R Smith Sent: 11 January 2018 10:45 To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] SQLite Application Server Concurrency On 2018/01/11 11:06 AM, James Colehan wrote: > Hi, > > I am looking for some advice on using SQLite for my given situation. > > My

Re: [sqlite] SQLite Application Server Concurrency

2018-01-11 Thread Lee Gray
: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of James Colehan Sent: Thursday, January 11, 2018 3:21 AM To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Subject: Re: [sqlite] SQLite Application Server Concurrency Hi Simon, Thanks for getting b

Re: [sqlite] SQLite Application Server Concurrency

2018-01-11 Thread John Found
I have several such applications, running in industrial environment. I always use a TCP server on 'X' and TCP client on 'Y' with some simple, specialized http-like protocol on top. All this can be implemented very easy, especially if you don't need a top performance and millions of clients.

Re: [sqlite] SQLite Application Server Concurrency

2018-01-11 Thread R Smith
On 2018/01/11 11:06 AM, James Colehan wrote: Hi, I am looking for some advice on using SQLite for my given situation. My system involves a windows network. On PC 'X', I have an SQLite database with a process that handles amendment's to the database ie INSERTS, DELETES and UPDATES. Also, on

Re: [sqlite] SQLite Application Server Concurrency

2018-01-11 Thread James Colehan
...@mailinglists.sqlite.org] On Behalf Of Simon Slavin Sent: 11 January 2018 09:13 To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Subject: Re: [sqlite] SQLite Application Server Concurrency On 11 Jan 2018, at 9:06am, James Colehan <jcole...@gtt-training.com> wrote:

Re: [sqlite] SQLite Application Server Concurrency

2018-01-11 Thread Simon Slavin
On 11 Jan 2018, at 9:06am, James Colehan wrote: > My concern is that I have a requirement to query the database on PC 'X' from > other PC's. Basically, performing (SELECT) statements from stations 'Y' and > 'Z'. This creates a client/server situation that I