[Ruud-v-A]

You should not write a CRUD app in 2018. Update and delete are remnants from the times where memory and disk were expensive, and update in place was a necessity. This is no longer the case. Apart from a few very specialised use cases, there is no need any more for update or delete. Record new facts and don’t destroy the older ones.

[mattmanser]

Going to laugh when anyone audits you for GDPR compliance. This is the exact sort of shit the laws are being brought in to prevent.

If a users wants data deleted they want the data DELETED, not kept for a hacker to hoover up in a few years time.

[blattimwind]

Still counts as CRUD. If it helps you sleep at night, consider the "RUD" as "replace, update or delete things from the default-visible set".

[glimmung]

This is not true generally anyway (in most mainstream systems it is much simpler to update or delete when appropriate), but please consider e.g. the GDPR where the ability to delete personal data is mandatory, and the "keep everything forever" mindset is precisely what that legislation is designed to remedy.

[cgdub]

What should I use to write a CR app?

[hodl]

Probably Object Oriented

[vyrotek]

Or you can use features such as Temporal Tables with SQL Server