Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .