2 ms·
Create an `updated_at` with an on update trigger to set it to NOW(). Your code will never have to explicitly remember to set it. Go further and create an integ
by echelon 4y ago
Create an `updated_at` with an on update trigger to set it to NOW(). Your code will never have to explicitly remember to set it.
Go further and create an integer `version` vector clock that gets set to its value plus one. You can see the edit frequency of individual entities and construct a simple key for cache invalidation.