Just in case anybody else is interessted. I created triggers for my
database that look like:
SELECT CASE
WHEN (SELECT redundance('') !=0)
THEN RAISE (ABORT, 'backup on redudant database was not successfull')
END;
My custom function redundance then executes the statements on the
On Tue, 5 Aug 2008 18:57:10 +0200, you wrote:
>Hi everyone,
>i need to backup a sqlite database on a remote device for
>configuration redundancy purposes. Due to a really slow connection
>between the devices triggering rsync is not the best solution yet.
>Although rsync is efficient it is tr
g sync stuff, SQLite
over streams, etc.
Robert
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Till Steinbach
Sent: Tuesday, August 05, 2008 9:57 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] Realtime backup of database
Hi everyone,
i need to backup a sq
Hi everyone,
i need to backup a sqlite database on a remote device for
configuration redundancy purposes. Due to a really slow connection
between the devices triggering rsync is not the best solution yet.
Although rsync is efficient it is transfering kilobytes of data to see
what it has to
Hi Stephen,
I have a slightly different requirement. Because the second device is
the hot-standby part of my device hosting the database, I must be sure
that the change was successfull. Everything else would lead to
confusion when there is a failover and some data is not yet changed.
I'm just
On Tue, Aug 5, 2008 at 4:36 PM, Till Steinbach
<[EMAIL PROTECTED]> wrote:
> Hi Ingo!
> Although I'm limited to C-Code your code would be really useful for
> me. The triggers will be the same for me. When I have the right
> triggers the most difficult part is done. The idea with the seperate
> table
Hi Ingo!
Although I'm limited to C-Code your code would be really useful for
me. The triggers will be the same for me. When I have the right
triggers the most difficult part is done. The idea with the seperate
table for logging is great. I have no idea yet how to log whole
statements. I'm l
Hello!
I think you need to add callback function for insert operations and are
logging in the function.
Best regards, Alexey.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Till Steinbach wrote:
> I don't get the right idea for my application. Something like
> capturing the querys that update the database and transmit them to the
> remote system would fit the purpose, but that seems to me very
> complicated to teach the database.
>
You could write triggers fo
Hi everyone,
i need to backup a sqlite database on a remote device for
configuration redundancy purposes. Due to a really slow connection
between the devices triggering rsync is not the best solution yet.
Although rsync is efficient it is transfering kilobytes of data to see
what it has to
10 matches
Mail list logo