Thread: Change Data Capture
Hello, Is there a plan to integrate Change Data Capture into the database engine itself? The "normal" way to track data changes are by doing triggers and (shadow) tables, but that involves mundane work (plumbing) that the database engine (presumably) could do better and more effecient. Best Regards Jan Johansson
On 11/22/10, Jan Johansson <jan.johansson.mr@gmail.com> wrote: > Is there a plan to integrate Change Data Capture into the database > engine itself? Probably not until the following SQL standard feature is applied to PostgreSQL: http://petereisentraut.blogspot.com/2010/05/system-versioned-tables.html -- Regards, Richard Broersma Jr. Visit the Los Angeles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug
On Mon, Nov 22, 2010 at 3:23 AM, Jan Johansson <jan.johansson.mr@gmail.com> wrote: > Is there a plan to integrate Change Data Capture into the database > engine itself? > The "normal" way to track data changes are by doing triggers and > (shadow) tables, but that involves mundane work (plumbing) that the > database engine (presumably) could do better and more effecient. Some more pointers: * http://archives.postgresql.org/pgsql-general/2010-06/msg01295.php * http://www.postgresql.org/docs/current/static/contrib-spi.html#AEN124746 Josh