3 ms·
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 wi
by rsync 5y ago
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 ...
- NoNotTheDuo 5y agoAnd ideally there is a created time stamp and a last updated time stamp.
- BenjiWiebe 5y ago(at least in my cases) Ideally nothing ever gets updated, there's just a newer version of the row.
- BatteryMountain 5y agoSame. 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.