How to properly organize the storage of records change history?

Question

Java

Good evening I'm
interested in how to organize the storage of the history of changes to records in the database, according to the type of what is done here on Habré.
If there is an article on this topic, I will be glad to read it.
I myself have so far realized that it should be one to many, but technically the process is lame
. Maybe I didn’t take something into account

Answer 1

An easy way is to opt out of update and delete.
insert only.
It will also be necessary to add a column with the date, in which the current time will be automatically put down.

Answer 2

See triggers (in DBMS). You can execute commands to insert (INSERT) information into event log tables during DELETE, INSERT, etc.