Re: [sqlite] SQLite database on Dropbox, Google Drive, MS SkyDrive, Ubuntu One or SAMBA share

2013-07-03 Thread Eric Sink
FYI: For a different approach, check out Zumero (http://zumero.com) which synchronizes SQLite changes within the db rather than the whole db as a file. Disclosure: I am a co-founder of Zumero, which is commercial, proprietary, non-open-source, etc. I mention this only because we often descri

Re: [sqlite] SQLite database on Dropbox, Google Drive, MS SkyDrive, Ubuntu One or SAMBA share

2013-07-03 Thread Gerry Snyder
On 6/27/2013 12:38 PM, joe.fis...@tanguaylab.com wrote: Anyone, Does anyone have good or bad experiences using a SQLite database in a shared folder? The 'Dropbox / Drive / SkyDrive / One' I use Dropbox for SQLite files a lot. If I am not careful to be making changes to a file on only o

Re: [sqlite] SQLite database on Dropbox, Google Drive, MS SkyDrive, Ubuntu One or SAMBA share

2013-07-03 Thread Stephen Chrzanowski
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

Re: [sqlite] SQLite database on Dropbox, Google Drive, MS SkyDrive, Ubuntu One or SAMBA share

2013-06-27 Thread Simon Slavin
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." fil

[sqlite] SQLite database on Dropbox, Google Drive, MS SkyDrive, Ubuntu One or SAMBA share

2013-06-27 Thread joe.fis...@tanguaylab.com
Anyone, Does anyone have good or bad experiences using a SQLite database in a shared folder? The 'Dropbox / Drive / SkyDrive / One' are of course a bit different than a SAMBA share because they are copies that get synced versus SAMBA which is the one and only copy. Normally I would just be acc