Quote:
Originally Posted by darrenlee
Correct me if I'm wrong.I don't think accessing calibre library from different OS will cause any trouble,since sqlite database file is cross-platform. The chance is that accessing the same calibre library from different machines/users simultaneously will cause errors due to writing-lock on db file.
|
As far as I peeked in the metadata.db (?) file, the major problem between unix and windows is the directory-separator: / v.s. \. By head, I see it in the book-table, the location of the file. I bet if Calibre can coop with using / as dirseparator on msWindows and \ as dirseparator at unix, then the database shold have no problems.
The case of the characters should be no problem, since Calibre has created the files in the first place and all used filesystems are at least case-aware.
Multiple access of the single database can be a problem for nas-storage, however my first goal is to move the entire tree from linux to mswindows.
For nas-storage, I'd say Calibre should be able to handle read-only databases, also nice for databases stored on cd/dvd-s. The nas-storage can use locking to give the first calibre write access, subsequent calibres only get read-only access.
In the end, my (qnap 419) nas comes with mysql installed. Using that can be a goal for future developments. (this might need a new thread...)