I have one application that deals with a few tens of megabytes of data. Dropbox tries to sync the file with an open-shared connection, and any changes seem to want to UL the whole file again, not to mention the hammering of the journal/wal file. So what I've done is open the file in exclusive mode, and when the program closes, it releases the handle and DB happily syncs the file. This particular application only allows one instance of itself running.
If you're doing 100% reads, or at least, have one machine that handles writing to the database, you can pretty much ignore the following. As stated, DropBox will allow different computers to access the files on their own. The PROBLEM comes in when changes are detected on multiple machines at the same time. You start getting a bunch of copied files with the name "Conflict" appended, with the hostname of the offending machine. This does count towards your DB usage. In other words, if computer 1 has the file open and makes no changes, computer 2 decides to make a lot of changes, computer 1 won't see that change until the application is stopped, DB syncs the file, and then the application is restarted. At this point, no conflict file shows up. However, if both computer 1 and computer 2 start making changes at the same time, you'll start getting conflicted files. On Thu, Jun 27, 2013 at 3:55 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 27 Jun 2013, at 8:38pm, joe.fis...@tanguaylab.com wrote: > > > I use LibreOffice files in shared space and I have never had a problem. > > Do you have just one user with the file open at a time, or are there times > when two or more users are accessing the same database ? > > > I believe the "~lock." files work well. > > Dropbox apparently doesn't sync files that are locked -- which is a good > thing. > > Would SQLite DB files work the same way? > > Dropbox lets everyone edit their own copy of the file. As long as it gets > a chance to sync the copies once one person has edited one, it’s fine. If > two people both edit their own copy at the same time Dropbox will make you > choose which copy 'wins'. This is not a criticism of dropbox: all systems > which sync entire files work that way. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
