Answer the question
In order to leave comments, you need to log in
How to implement custom action cancellation?
The application is a table with a large number of rows. The user controls the data from this table (deletion, transfer to groups, etc.).
Sometimes it happens that the user made a mistake and deleted the wrong data or transferred the data to the wrong group.
I would like to be able to undo the last action. What is the best way to do this? Create a duplicate table and copy the current data into it and then only do the action? But if there is a lot of data in the table, then this business will be long?
Maybe there are mechanisms for organizing this in the DBMS itself (postgresql)?
I'll describe the details:
You don’t need to store for a long time - two minutes is enough. The table is complex, with a large number of links and with a large number of fields. The search takes place in almost all fields with complex logic. The data is still in the region of 25k, but growth is expected up to 1kk.
Another problem is that this table is used by other tables (foreign key) and the data in these other tables is also deleted when deleted in the main one.
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question