Senario: TWS is running as the read-only-web-application server. Web clients search & read-only. Local Clients may be updating the same SQLite db with ODBC (they are NOT using the web app). (this is tested, and works fine)
I have a SQLite.exe commandline backup script to copy everything to text files, and it can be scheduled to run un-attended. Question: Am I flirting with some kind of data-concurrency problems ? The reason for the question is that I tried to backup to a ODBC client; too clumsy and slow. The TWS/Tcl application could do the backup on the server; but thats too much coding. Any thoughts ?