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.
My all-time favorite database table was a table named STATE, meant to store all US states. It had 531 rows.
Relatable. 🤣
well, there's confusion, paranoia, agitation and so many others...
Confusion
... Your medical condition
Disorganized
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 :(
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"
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.
How about a date stored as an integer?
Edit: and I'm not taking about a timestamp
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.
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.
My all-time favorite database table was a table named STATE, meant to store all US states. It had 531 rows.
Relatable. 🤣
well, there's confusion, paranoia, agitation and so many others...
Confusion ... Your medical condition Disorganized
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 :(
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"
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.
How about a date stored as an integer?
Edit: and I'm not taking about a timestamp
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.