Gilles Ganault wrote: > I wanted to check if someone had > recently written a similar solution so that SQLite can be used as a > light, no-brainer DB server?
The problem is that the moment you have a network accessible service you have to deal with administration. Things like authentication, security, log files etc. Then you have to specify a protocol of some sort and as you update it over time have to deal with client and server versioning. Some people have made networkable variants of SQLite and you'll have all these issues with them. At that point you may as well use MySQL, Postgres or plain ODBC and not worry about the backend. > SQLite is such a pleasure to use in single-mode that it's too bad it > can't be used for moderate use, ie. to share data among 3-4 clients. Just to be clear SQLite can trivially handle that sort of workload. It just can't be done reliably using a network share due to bugs in the protocols and implementations of network file sharing. If you are looking for an alternative then I'd suggest couchdb. It is designed for replication from the ground up and you get offline mode for free. It is document oriented rather than relation oriented like SQL but for many that is an advantage :-) Roger _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
