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.