Re: [sqlite] Announcement of Copy - A cross platform syncing app, that uses SQLite as its backend

2013-03-02 Thread dd
>>The integrity check just takes too long so we don't. pragma quick_check; doesn't take much tme. http://www.sqlite.org/pragma.html#pragma_quick_check On Sun, Mar 3, 2013 at 8:00 AM, Jason Dictos wrote: > >> . > > > > Thanks for the details. What programming

Re: [sqlite] Announcement of Copy - A cross platform syncing app, that uses SQLite as its backend

2013-03-02 Thread Jason Dictos
>> . > > Thanks for the details. What programming language do you use? (Dropbox > uses Python.) > C++ >> Early on we figured out quite quickly not leverage the read/write >> locking models of SQLite > > Do you use WAL mode? > I played with it early on but I didn't know how stable the

Re: [sqlite] Announcement of Copy - A cross platform syncing app, that uses SQLite as its backend

2013-03-01 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/03/13 12:27, Jason Dictos wrote: > Overall SQLite has been the perfect solution to our situation. Thanks for the details. What programming language do you use? (Dropbox uses Python.) > Early on we figured out quite quickly not leverage the

Re: [sqlite] Announcement of Copy - A cross platform syncing app, that uses SQLite as its backend

2013-03-01 Thread Jason Dictos
Overall SQLite has been the perfect solution to our situation. We needed some relation but nothing too heavy weight to store our meta data about files and shares. Early on we figured out quite quickly not leverage the read/write locking models of SQLite (SQLITE_BUSY hell) but instead use a

Re: [sqlite] Announcement of Copy - A cross platform syncing app, that uses SQLite as its backend

2013-03-01 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/03/13 09:56, Jason Dictos wrote: > This app we wrote couldn't have happened without SQLite, I would be interested in hearing about the experience with SQLite, especially anything relevant to other developers. One of your competitors is Dropbox

[sqlite] Announcement of Copy - A cross platform syncing app, that uses SQLite as its backend

2013-03-01 Thread Jason Dictos
Hi All, I just wanted to let you all in on a deal we are offering to everyone on this mailing list, regarding Copy a new syncing app we have deployed here at barracuda networks (www.copy.com). This app we wrote couldn't have happened without SQLite, both on