> I hadn't really thought about deleting yet (I'm deciding what kind of audit > trail approach to take, whether to mark a record as deleted or actually > delete and copy to some kind of audit log).
I had thought about this many times. Audit trails / data history is something that is done very frequently. It leads to a big amount of boilerplate, especially when complex data (i.e. normalised data across several relations) needs historisation. I wonder if this is something that could be handled by jOOQ - or if this goes too far into implementation-specific stuff. I'd be interested if you could share your experience, once you have decided which approach to take... > But it would round off the > feature, so I think that would be good to include. Done.
