Post AakLV0AVjRwtUImrAW by tek@freeradical.zone
 (DIR) More posts by tek@freeradical.zone
 (DIR) Post #AakCJKC2YWe8WxrLuK by tek@freeradical.zone
       2023-10-14T00:33:02Z
       
       0 likes, 0 repeats
       
       The next API I write is going to store timestamps as the int number of minutes ago, with a minutely from job to update the rows, because curse you, time zones, is why.
       
 (DIR) Post #AakLTZAmcEHhTNEJjk by tek@freeradical.zone
       2023-10-14T02:15:45Z
       
       0 likes, 0 repeats
       
       @sungo Where’s the fun in that?
       
 (DIR) Post #AakLUyc5VwosfFfqsK by pagrus@tears.intherain.club
       2023-10-14T00:34:33.847Z
       
       0 likes, 0 repeats
       
       @tek@freeradical.zone NO GODSNO TIMESTAMPS
       
 (DIR) Post #AakLUzQ4W6nnAH3lmi by pagrus@tears.intherain.club
       2023-10-14T00:35:11.553Z
       
       0 likes, 0 repeats
       
       @tek@freeradical.zone and no autoincrementing integer keys either, just hashes
       
 (DIR) Post #AakLV0AVjRwtUImrAW by tek@freeradical.zone
       2023-10-14T02:16:00Z
       
       0 likes, 0 repeats
       
       @pagrus UUIDs all the way down.
       
 (DIR) Post #Aal151GPEa0rQhpznM by mensrea@freeradical.zone
       2023-10-14T10:01:56Z
       
       0 likes, 0 repeats
       
       @tek no no. what you need to do is store the the utc epoch time in one col and the time zone diff in a second col
       
 (DIR) Post #AalTj4vtoCbr6r8TlQ by tek@freeradical.zone
       2023-10-14T15:22:54Z
       
       0 likes, 0 repeats
       
       @mensrea As a varchar.
       
 (DIR) Post #AalZO3IzGSUNhnIAnQ by mensrea@freeradical.zone
       2023-10-14T16:26:20Z
       
       0 likes, 0 repeats
       
       @tek amateur. it's obviously the place to use blob