Postgres Extensions Video Presentation at OpenSQL Camp 2008 by Kelly McDonald

Postgres Extensions - Kelly McDonald

Kelly implemented reporting and history-tracking extensions in Postgres. It keeps track of any changes to the system. This has been valuable in letting clients know what happened to their data, where bugs were happening in the system and generally saving our butts. The reporting system takes changes made in a attribute style table structure and arranges them in a standard table type structure for reporting. Kelly will explain why this system was built and how, including limitations of Postgres that had to be accommodated, and an introduction to writing Postgres extensions in C.