this post was submitted on 29 Nov 2023
1226 points (99.2% liked)

Programmer Humor

19564 readers
923 users here now

Welcome to Programmer Humor!

This is a place where you can post jokes, memes, humor, etc. related to programming!

For sharing awful code theres also Programming Horror.

Rules

founded 1 year ago
MODERATORS
 
you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 29 points 11 months ago* (last edited 11 months ago) (9 children)

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.

[–] [email protected] 11 points 11 months ago* (last edited 11 months ago) (1 children)

How about a date stored as an integer?

Edit: and I'm not taking about a timestamp

[–] [email protected] 11 points 11 months ago* (last edited 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.

load more comments (7 replies)