Awesome articles, Gus... dunno how I missed the second one, but I just read it. Really nice job.

My only suggestion to everyone is to NOT audit inserts. The data already lives in the main table. The only thing audit triggers should do is modify changes to the original row... that, of course, includes deletes. The reason I'm so adamant about NOT auditing Inserts is because, depending on the audit method you chose, will a least double the size of your database and in some cases, will increase the size my a factor of 4 (sometimes more for full EAV audit tables).

Of course, maybe you would rather have a 2-4 terabyte database to backup instead a 1 terabyte database 😀