this post was submitted on 16 Oct 2024
192 points (91.4% liked)
Technology
60080 readers
3354 users here now
This is a most excellent place for technology news and articles.
Our Rules
- Follow the lemmy.world rules.
- Only tech related content.
- Be excellent to each another!
- Mod approved content bots can post up to 10 articles per day.
- Threads asking for personal tech support may be deleted.
- Politics threads may be removed.
- No memes allowed as posts, OK to post as comments.
- Only approved bots from the list below, to ask if your bot can be added please contact us.
- Check for duplicates before posting, duplicates may be removed
Approved Bots
founded 2 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
Ew. Just store UTC timestamps and do optional translation on the client using whatever the client sets up for their timezone. It's not hard...
Oh believe me, I would change some things about that database if I could. Alas, I'm just the analyst building data models from it.
(To be fair, it's otherwise easy to work with and for most use-cases, it doesn't matter since they're aggregated per month anyway, so I just load the last month's data on the 2nd of each month. I definitely have worse patients to operate on.)