I'm trying to create an unique auto increment index field that is re-generated on both inserts and updates. I need it so that a client can send a server an integer and get back all outdated (created or updated) records. Something that would allow:
Insert Record A (Record A 'touched' set to '1') Insert Record B (Record B 'touched' set to '2') Update Record A (Record A 'touched' set to '3') Update Record B (Record B 'touched' set to '4')
I'm using both Postgresql and Sqlite (production and development) and would ideally like a solution that will work under both. What is the best way to add something like this?