Home / server / Questions / 71871
Accepted
jberryman
Asked: 2009-10-07 10:31:31 +0800 CST

Best system to serve sqlite databases to webservers over a network?

  • 772

I am helping in setting up a web service in which user data will be stored in sqlite databases on a server running perhaps Samba, and one or more web servers will read and write to those databases on the backend. I would like advice as to which network file system to use in an all-linux environment, as well as any other thoughts

samba

4 Answers

  1. from sqlite docs:

    Also, the file locking logic of many network filesystems implementation contains bugs (on both Unix and Windows). If file locking does not work like it should, it might be possible for two or more client programs to modify the same part of the same database at the same time, resulting in database corruption.

    so, be very careful! NFS in particular is well known not to follow POSIX behavior, especially about atomicity.

    • 2
  2. Best Answer

    NFS is probably your best bet. NFS is pretty configurable and will likely prove to be the best tool for the job. If you have any Windows in the mix, CIFS (Samba) is the way to go, but in an all-linux environment, NFS.

    That being said, I agree with Ben S. If the only choice is sqlite (which I hope it isn't), NFS is the way go to. But a real DBMS is a much better choice.

    • 1

  3. I'd suggest a real multi-user database. SQLite is the best choice for single-user apps, not multiple servers.

    • 0

  4. This really is not what sqlite is for. It is possible but a much more robust system (and easier to maintain) would be a simple mysql installation instead of an entire fileserver.

    • 0