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. In addition such solution allows to avoid complex settings with web servers, back-front ends etc. The server and the client are built in the desktop application and the communication is transparent for the users. On Thu, 11 Jan 2018 09:06:32 +0000 James Colehan <jcole...@gtt-training.com> 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 PC 'X' I have some other processes running that are > requesting data (SELECT) form the database. I have the Journal Mode set to > WAL. This all appears to work fine. > > 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. > > At the moment I have not encountered any problems. However, my concern is > that this maybe just luck and there is a potential of locking issues or > database corruption. > > Any thoughts would be appreciated. > > Regards, > > James > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -- http://fresh.flatassembler.net http://asm32.info John Found <johnfo...@asm32.info> _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
