Database Reference
In-Depth Information
Fast capturing of database changes
Some obvious things to code in C are logging, or auditing triggers, which get called at
each
INSERT
,
UPDATE
, or
DELETE
to a table. We have not set aside enough space
in this topic to explain everything needed for C triggers, but interested reader could
look up the source code for the
skytools
package where you can find more than
one way to write triggers in C.
The highly optimized C source for the two main triggers,
logtriga
and
logutriga
,
includes everything you need to capture these changes to a table and even detecting
table structure changes while the code is running.
skytools
.