-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 02/20/2011 04:55 PM, Stef Mientki wrote: > still want to see if a simple client/server setup would solve my current > problems
There is no such thing as "simple" client/server. You have to worry about issues like authentication and authorization. You have to deal with naming. You have to think about APIs being synchronous or asynchronous. You have to worry about state and if state is maintained across connections or dropped. You have to worry about new error codes that couldn't occur before. You have to deal with race conditions and latency. Sweeping all this under the rug will appear simple until you do real deployments and start painfully encountering and addressing the issues. That is why networked databases are not simple. If the data is not valuable then all that doesn't matter. > (and I realize that I'm a great optimist) Indeed :-) You should look closely at what it is you actually need. If you want a close match to the Python object model then use MongoDB. If you want to use SQL then use Postfix. If you want a stronger binding to SQLite and the ability to operate with and without a network then consider using SQLite virtual tables with the backend talking over the network or locally as needed. If you need lots of processes on the network to access data quickly then consider memcached. If you eventually intend to go for Amazon or Google cloud deployments then look at what they provide to run locally. If transactions and ACID matter then carefully research what meets your needs and deploying using as much redundancy and backup as appropriate. If you can't make your mind up, write a server that provides your data REST style and make the clients use HTTP. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk1hvnkACgkQmOOfHg372QSFZACfbWZXHwD3+q9xfmfIVAZr9ITO yHAAn1s3y6w6FV0pW0VPAL1cTfoscB96 =Id/K -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
