4 ms·

Fast-forward a couple years: now I have scripts that launch sub-tasks more than once a second.

• yellowapple 2y ago
  So use timestamps with sub-second precision, which virtually every SQL database supports (even ones like SQLite that don't have built-in date/time types).
  • selcuka 2y ago
    What about ntpd updates, or multiple scripts running in parallel?
  • ltbarcly3 2y ago
    I don't think you know enough about how databases work to even try to be giving advice. The timestamp generated in a transaction is generally the time the transaction started, which means it is always the same within the same transaction.
    • selcuka 2y ago
      Obviously sub-tasks will not typically be in the same transaction.
    • yellowapple 2y ago
      > I don't think you know enough about how databases work to even try to be giving advice. That's both incorrect and entirely unwarranted.