SQLite Forum

SQLite with NFS + cachefilesd
Login
> I suppose that means you have read and understood [SQLite Over a Network, Caveats and Considerations](https://sqlite.org/useovernet.html)

In addition to the three choices listed there, I can suggest a few more possibilities too (although I would expect that these will be more complicated to implement than the three listed in the linked document):

1. Use a virtual table to access remote data. However, some features will not work with virtual tables.

2. Define a VFS which handles the locking properly on the network file system.

3. Define a protocol for database locking properly on the server and implement that, and then implement the VFS which uses that protocol to access the data.