0
If a database is edited before daylight savings time ends (time rolls back), would that corrupt the database?
Earlier today, I saw on Lemmy that comments made within the last hour since DST were now in the negatives since time had rolled back. If a database uses time like this for search operations, would that interfere with them? Could it corrupt the database?
Comments
This is poor Lemmy programming, has nothing do with DST. You’ll often see if you’re posting a comment it will say “in 3 seconds”, meaning in the future. It’s because of how the frontend calculates the relative time based on a db timestamp against the local clock of your computer… which are beginner programmer mistakes from the late 90’s.
Slightly off topic below.
The 2 blokes programming this are not very good and since they are now beginning to peddle violence inciting garbage they can stuff their monthly donation too.
It depends on the database. But it’s common practice to store values in UTC, which doesn’t have DST, and only display in the user’s timezone. What you saw was probaby only a bug on the front end, but not database corruption.
Or just Unix (epoch) time.
https://en.wikipedia.org/wiki/Unix_time
There can be problems with leap seconds using UTC (or leap hours eventually)
https://en.wikipedia.org/wiki/Leap_second
They decided to stop doing leap seconds.
Until they decide to reverse it, or until they make a different change.
Just use Epoch time for backend and calculations, and use local time for displaying to the user (or UTC for debugging systems that span time zones)
Sign in to comment. Sign in