开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜