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.