Thread

1. beybol · 1790591768 · focus · HN ↗

   I don't rely on time calculations at the database level. I handle them in the application based on UTC time stored in the database and the user's time zone. This shifts the problem to the application code, where I can control it precisely and make conscious decisions about how to handle specific business requirements, such as when a day ends or how to deal with events across different time zones. It also makes it possible to properly test all cases with unit tests.

   1. wodenokoto · 1790593666 · focus · HN ↗

      So how are you solving the example in the article where they join on timestamps? Read both tables from the DB into the application?

      1. beybol · 1790596226 · focus · HN ↗

         I read raw data (UTC timestamps) from the db and timezone for user profile and calculate it on the fly.

Unofficial Hacker News client; not affiliated with Y Combinator.