I wish strictly INSERT-only tables were a standard SQL feature. It would be so v... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		donatj on June 28, 2023 \| parent \| context \| favorite \| on: Fintech engineering mistakes (2022) I wish strictly INSERT-only tables were a standard SQL feature. It would be so very useful.

lixtra on June 28, 2023 [–]

What’s the advantage of INSERT-only table over having a normal table and all normal users only have INSERT privilege on that table?

As admin I can still recreate the whole insert table with modified data, etc.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact