Re: [sqlite] SQLite database sync

2010-10-07 Thread Alexander Spence
Of David Haymond Sent: Wednesday, October 06, 2010 7:30 AM To: sqlite-users@sqlite.org Subject: [sqlite] SQLite database sync Hi SQLite users, I am completely new to SQLite (and SQL in general), and I am currently working on an iPhone app that uses the embedded SQLite engine to cache offline data

Re: [sqlite] SQLite database sync

2010-10-07 Thread Petite Abeille
On Oct 7, 2010, at 9:35 PM, Nicolas Williams wrote: > A general tool for hands-off bi-di synchronization of arbitrary DBs is > not really feasible, not in a way that would satisfy most users. Perhaps we should ask the author of diffkit [1] to solve that hairy problem for the rest of us :))

Re: [sqlite] SQLite database sync

2010-10-07 Thread Nicolas Williams
On Thu, Oct 07, 2010 at 09:09:19PM +0200, Petite Abeille wrote: > On Oct 6, 2010, at 5:50 PM, David Haymond wrote: > > If I copy, I don't want to transfer EVERY record to the server each time I > > sync, because that would be a waste of bandwidth. What is the best way to > > copy only those

Re: [sqlite] SQLite database sync

2010-10-07 Thread Petite Abeille
On Oct 6, 2010, at 5:50 PM, David Haymond wrote: > If I copy, I don't want to transfer EVERY record to the server each time I > sync, because that would be a waste of bandwidth. What is the best way to > copy only those records that have changed to the server? Perhaps you could simply rsync

Re: [sqlite] SQLite database sync

2010-10-06 Thread Simon Slavin
On 6 Oct 2010, at 4:50pm, David Haymond wrote: > If I copy, I don't want to transfer EVERY record to the server each time I > sync, because that would be a waste of bandwidth. What is the best way to > copy only those records that have changed to the server? Make a new column for each table,

Re: [sqlite] SQLite database sync

2010-10-06 Thread Gerry Snyder
cords that have changed to the server? > > David > > -Original Message- > From: Simon Slavin > Sent: Wednesday, October 06, 2010 7:18 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] SQLite database sync > > > On 6 Oct 2010, at 1:29p

Re: [sqlite] SQLite database sync

2010-10-06 Thread David Haymond
:18 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQLite database sync On 6 Oct 2010, at 1:29pm, David Haymond wrote: > I am completely new to SQLite (and SQL in general), and I am currently > working on an iPhone app that uses the embedded SQLite engine to cache >

Re: [sqlite] SQLite database sync

2010-10-06 Thread Simon Slavin
On 6 Oct 2010, at 1:29pm, David Haymond wrote: > I am completely new to SQLite (and SQL in general), and I am currently > working on an iPhone app that uses the embedded SQLite engine to cache > offline data. What is the best way to implement synchronization capabilities > (change tracking,

[sqlite] SQLite database sync

2010-10-06 Thread David Haymond
Hi SQLite users, I am completely new to SQLite (and SQL in general), and I am currently working on an iPhone app that uses the embedded SQLite engine to cache offline data. What is the best way to implement synchronization capabilities (change tracking, state tracking, etc.) in a separate