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
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 :))
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
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
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,
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
: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
>
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,
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
Isaac Raway wrote:
Well, putting this together I think I may have settled on a solution for
the
first version of this project:
1) Only a single user will have access to each DB, therefore taking the
most
recent record from any table will always be the right thing to do. This
avoids the
Well, putting this together I think I may have settled on a solution for the
first version of this project:
1) Only a single user will have access to each DB, therefore taking the most
recent record from any table will always be the right thing to do. This
avoids the complexity of conflict
Isaac Raway wrote:
I am looking at a design that will require syncing a disconnected SQLite DB
file on client's machines to a central server. The version of the DB on the
server will also be modified periodically, so there is a chance that new
records will be created in either and also updated.
"Isaac Raway" <[EMAIL PROTECTED]> wrote:
>
> At any rate, anyone have experience syncing SQLite DB files?
>
I have done this on two separate projects.
In the first case, the databases to be synced all had a fixed
set of records (a few hundred thousand rows). New rows were
never added or
I am looking at a design that will require syncing a disconnected SQLite DB
file on client's machines to a central server. The version of the DB on the
server will also be modified periodically, so there is a chance that new
records will be created in either and also updated. Conflicts therefore
14 matches
Mail list logo