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
