Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Data Audit History
There have been several times when I needed to ensure that we could understand the changes of data overtime. This is inline with the idea of never deleting data; however, in keeping a full audit history you can more deeply understand user behaviors. Or, if you need to have data retention for legal issues, this is also a pattern that could make sense.
Data Store Identifiers: GUID
Over ten years ago now, I moved from auto-increment integers to GUID’s; and I have never looked back. There are a number of reasons why I feel that it is much easier for computers systems and humans to use GUID’s to identify tuples; check it out!