[dgb23]

To add:

If you want to do CRUD but without the headaches of U and D you can do this:

https://en.wikipedia.org/wiki/Bitemporal_modeling

It may seem scary at first and requires more thought, but the benefits are very real, even if the history is not exposed to users in any way.

[drekipus]

My company is in the process of retroactively making our crud "ledger" into a bitemporal one.

We're all pretty keen for it. Looks great!