• PizzaMan@lemm.ee
    link
    fedilink
    arrow-up
    29
    ·
    edit-2
    11 months ago

    At work, I am currently dealing with a table that has no primary key, no foreign key, duplicate (almost) serial numbers, booleans stored as strings, and so on. It’s a nightmare of a table.

    Entity framework is acting like I’m on meth for using such a table.

      • psud@aussie.zone
        link
        fedilink
        arrow-up
        3
        ·
        11 months ago

        I have been trying to get people in my area to make their new table generically named, since it’s going to be the only table that can map a date range to a different date range, but I’m on holidays now, and they can’t imagine anything other than their little project needing this table, so it’s going to be named for this one project, and it’s columns will be named for the specific data they’ll hold :(

    • (╯°□°)╯︵ ┻━┻@programming.dev
      link
      fedilink
      English
      arrow-up
      20
      ·
      11 months ago

      I’ve been there and you know what’s worse about it? When you fix it only you or a handful of people notice the astronomical labor you did.

      “It worked before why did you change it? You are just doing busywork”

      • PizzaMan@lemm.ee
        link
        fedilink
        arrow-up
        11
        ·
        11 months ago

        Yeah. Luckily the work I am doing is to fix some really bad work that the entire company has been complaining about. So once it’s fixed it will hopefully be a little bit more recognition than that. Plus my boss is pretty level headed.

        But who fucking knows? There is always the likelihood that people will say things along those lines. And it ain’t my job to fight them on that.

      • PizzaMan@lemm.ee
        link
        fedilink
        arrow-up
        11
        ·
        edit-2
        11 months ago

        No, we have worse. Dates sometimes stored as strings, sometimes as datetimes, and sometimes as integers. There is no consistency, logic, or forethought to the schema.

        It’s rough.