How to keep track user changes in database

  Kiến thức lập trình

So i am in the middle of creating a website. Currently my database sits in PgAdmin and i use postgreSQL. My backend is python oriented (Flask) and the fronted is a mix of AJAX and JS.
Now i came across a step that needs tracking of changes. So i have lets say a row in a table, the row is displayed in the frontend and the user lets say changes the second column and submits the results. The data is parsed and sent to the backend which is sent to the DB.
Is there any other way to keep track of lets say the date of the change (and extra the stuff the user changed) than to either create a new table or keep track of the changes in a private .txt file?
Thank you in advance.

Just a plain question, I am leaning towards the .txt option more and more.

New contributor

Viktor Denac is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

1

LEAVE A COMMENT