3 ms·
Someday we'll have a database that handles this for us. We'll specify whether a particular table should have an audit trail. The system will know about foreign
by ccleve 4y ago
Someday we'll have a database that handles this for us. We'll specify whether a particular table should have an audit trail. The system will know about foreign keys and related tables, and save them as well. Everything will be configurable, of course. Internally, the system will save the relevant data using the write-ahead log. Restoring deleted data will be easy, a simple command. Purging data that should disappear forever will be another command. This is all very possible.
Someday.
I'm embarrassed to admit how many decades I've been waiting for this.