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?

  • kingofras@lemmy.world
    link
    fedilink
    arrow-up
    15
    arrow-down
    1
    ·
    11 days ago

    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.

      • kingofras@lemmy.world
        link
        fedilink
        arrow-up
        5
        arrow-down
        1
        ·
        11 days ago

        Well they don’t peddle violence directly of course that would be incriminating. They are setting up their instance moderation rules so that burning down the western democracies is encouraged.