是否可以拥有远程sqlite数据库 [英] Is it possible to have a remote sqlite database

问题描述

你能在服务器上远程存储一个sqlite数据库吗?我正在构建一个 iphone 应用程序，所有教程似乎都将 sqlite 数据库存储在 iphone 本身上...

Can you store an sqlite database remotely on a server? I am building an iphone app and all the tutorials seem to store the sqlite database on the iphone itself...

推荐答案

这是不可取的，因为您很快就会遇到并发问题.在这种情况下，我会使用传统的 RDMS，例如 MySQL 或 PostegreSQL.

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 有一个有用的页面解释何时使用它.它说:

SQLite has a useful page explaining when to use it. It says:

如果你有很多客户端程序通过一个公共数据库访问网络，您应该考虑使用客户端/服务器数据库引擎代替SQLite.

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.

这篇关于是否可以拥有远程sqlite数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！