RE: [sqlite] synchronising two databases

[Richard Boyd]

Thanks,

I'll look into something like that. I think there must be a neat way of
doing this synchronisation besides actually copying files, but this method
should get me started.

I'll keep you posted if I come up with any other method.

Regards,
Richard.

-Original Message-
From: Andrew Piskorski [mailto:[EMAIL PROTECTED]
Sent: 13 December 2004 14:24
To: [EMAIL PROTECTED]
Subject: Re: [sqlite] synchronising two databases


On Mon, Dec 13, 2004 at 02:00:05PM -, Richard Boyd wrote:

> My question is this: Is it possible for me to copy across the database
file
> and then append it to the end of the locally held database thus
> synchronizing the two? Is there a better way to do this synchronization?

If both databases are shut down, presumably you could use rsync to
blindly synchronize the two at the binary level.  Conceivably you
could even integrate something like librsync into SQLite and thus do
the rsync operation while the database is locked, with no other
activity going on.

  http://librsync.sourceforge.net/

(This is all speculation on my part though, I have tried nothing of
the sort.  And of course, there might already be some better way to do
it in SQLite.)

--
Andrew Piskorski <[EMAIL PROTECTED]>
http://www.piskorski.com/
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.801 / Virus Database: 544 - Release Date: 24/11/04

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.813 / Virus Database: 553 - Release Date: 13/12/04

[sqlite] synchronising two databases

[Richard Boyd]

Hi all,

I have an application where I need to access a database remotely (using
TCP/IP). I had thought of just calling sqlite commands (possibly using RPC)
and getting database data returned. However, as I will only periodically
access the remote database, I need to effectively keep a copy of the
database locally for offline number crunching.

My question is this: Is it possible for me to copy across the database file
and then append it to the end of the locally held database thus
synchronizing the two? Is there a better way to do this synchronization?

Many thanks in advance,
Richard


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.801 / Virus Database: 544 - Release Date: 24/11/04