Depending on your level of expertise with C#, you could create a .NET Windows 
service to run on machine X that contains a WCF service which controls the 
database access. The Y and Z clients would be WCF clients that talk to the WCF 
service on X. They could communicate via http or TCP.

From: 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 back so quickly.

Web programming is not something I am familiar with. My application is desktop 
based mostly written in C#.

However, your suggestion is something I can look deeper into.

James

-----Original Message-----
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On 
Behalf Of Simon Slavin
Sent: 11 January 2018 09:13
To: SQLite mailing list 
<sqlite-users@mailinglists.sqlite.org<mailto: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<mailto:jcole...@gtt-training.com>> 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 appreciate SQLite is not 
> appropriate choice of database for. I hope doing the (SELECT) only from the 
> client will be a workable solution.

Can you set up a web-facing interface to do this ? Do you know web programming ?

It can be done in many langauges. A PHP backend which queries the database and 
makes up a web page with the results is a very common way of doing it. But you 
can use node.js instead.

The idea is that instead of querying the database directly, the remote 
computers pass the query to the host computer.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org<mailto:sqlite-users@mailinglists.sqlite.org>
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users<http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org<mailto:sqlite-users@mailinglists.sqlite.org>
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users<http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to