Is it possible to have a remote sqlite database
Can you store an sqlite database remotely on a server? I am building an iphone app and all the 开发者_Python百科tutorials seem to store the sqlite database on the iphone itself...
That is not advisable, as you will quickly run into concurrency problems. I would use a traditional RDMS such as MySQL or PostegreSQL in such a case.
SQLite has a useful page explaining when to use it. It says:
If you have many client programs accessing a common database over a network, you should consider using a client/server database engine instead of SQLite.
I agree with Matthew Flaschen, but if you really want to, you can connect to a sqlite db throuth an ssh tunnel. If multiple clients prefer mysql postgresql.
精彩评论