This version of Bookshelf is designed as single-user, using SQLite as a backend database (.bslf, .bslx, and .bdbf files) to keep it simple and portable.
Multiple users can open a SQLite data file concurrently on a network with read only access, however SQLite is not designed for multi-user read/write access. This may risk corruption.
SQLite can support multiple read-only clients accessing a data file on a network share, if:
- No process writes to the database while it’s being read.
- All access is explicitly read-only.
- The network file system supports stable shared reads (most do).
Future Versions of Bookshelf are planned using a client/server model for multi-user access with PostgreSQL as a back end.
Potential Issues with using SQLite data file on Network Share with Single User Read-Write Access
File Locking: SQLite relies on POSIX or Windows file locking mechanisms to manage concurrency and ensure data integrity.
For more information, see: https://sqlite.org/lockingv3.html#network_filesystems