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
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
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
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
5 matches
Mail list logo
