Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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!

share|improve this question

1 Answer 1

up vote 2 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.

share|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. –  bastibe Mar 15 '10 at 0:14

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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