up vote 1 down vote favorite
share [g+] share [fb]

Used DropBox for this purpose for a while, but now it refuses to sync an sqlite database which is open using a shared lock. Are there any good alternatives?

Tried Live Mesh, Sugar Sync, PowerFolder, GoodSync and SpiderOak. SpiderOak looked most promising, but for some reason doesn't synchronize at all. Thanks!

link|improve this question
feedback

1 Answer

up vote 1 down vote accepted

Read lock is used specifically to prevent this. If an app has a lock on a file, it explicitly wants to prevent other programs from accessing the file, probably because it is right now modifying it. (Unless of course the app itself is faulty and just lazily keeps a lock on its files even though it is not using them. In that case: use a different app)

Hence, no app in its right mind would try to read read-locked files.

link|improve this answer
But this is a read lock, not write lock! I can overwrite the file in Explorer without any problem. – Alex Jenter Mar 14 '10 at 14:15
And unfortunately I can't use another app, because I'm the author of it. But closing the connection to SQlite didn't solve the issue, for some reason the CloseHandle function which SQLite calls doesn't always release the lock obtained by CreateFile. – Alex Jenter Mar 14 '10 at 14:16
Ask how to do that on stackoverflow then. If you lock a file, you explicitly prevent other programs from accessing it. – Paperflyer Mar 15 '10 at 0:14
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.