Sanjay-M <sm@planage.com> wrote:
I was wondering if this approach could be adopted in developing a Client/Server application with a separate server component accessing the SQLite database (on a separate machine).
If a template / model can be developed i am sure this can be very useful in creating larger multi-user applications even at the cost of some duplication / redundant effort.
I am thinking of situations where we cannot have a web server even on the intranet - more like traditional servers accessed over TCP/IP
Sorry but I can't follow your question. SQLite is a file based RDBMS engine, designed to be accessed locally and not through TCP/IP. If what you need to do is run over a network PostgreSQL will provide you with such feature (plus a lot others). Remember: âSQLite is not a replacement for PostgreSQL [or any other RDBMS]. SQLite is a replacement for fopen().â Regards. Esteban A. Maringolo