This is rather easily achieved using additional tables and triggers, so whenever you update or delete a row, the old version is written to the additional table.

This is rather easily achieved using additional tables and triggers, so whenever you update or delete a row, the old version is written to the additional table. It requires some work (writing triggers, duplicate table definitions, etc.), but it's not that hard and the result is worth it.