|
|
|
|
|
|
by profquail
2000 days ago
|
|
|
Another approach to solving this issue is with a temporal database (standardized in SQL:2011); supporting a “valid time” in your query gives your user a consistent view of the database tables even if others are modifying it concurrently. It’s also handy if you want to keep audit records of the database (e.g. so users can see who/when/what changes were made). https://en.wikipedia.org/wiki/SQL:2011 |
|
|