[rsync]

I have no particular expertise with modern databases and it has been decades since I did any work as a DBA.

However, I cannot imagine creating table entries without a datestamp. No matter what else you are doing, or what you index by, I would want YYYY-MM-DD_HH-MM-SS in every row.

Maybe I'm just weird that way ...

[BatteryMountain]

Same. Every entity always gets a created column at the minimum, that way when we query later we can order by created to see the last few days worth of data first. Can't do that if you don't know when something was created.

[NoNotTheDuo]

And ideally there is a created time stamp and a last updated time stamp.

[BenjiWiebe]

(at least in my cases) Ideally nothing ever gets updated, there's just a newer version of the row.