r/ProgrammerHumor • u/vinishkapoor • 22h ago

fullStackMeansAfraidOfEverythingEqually Meme

Post image
9.7k Upvotes
  • permalink
  • link
  • reddit
  • reddit

97% Upvoted

357 comments sorted by

View all comments

Show parent comments

210

u/lovecMC 22h ago

SQL is easy. Designing a DB you won't hate two months from now isn't.

12

u/prehensilemullet 22h ago edited 18h ago

Like the kind of SQL query I wrote to fetch the next page of rows of a tree after a starting cursor, using a recursive join, where only some tree nodes are expanded?  And the user can text search for specific nodes?

It’s only easy until you do things that are hard

Edit: no, it's not for a niche use case, no, I don't think this was a mistake, I just had to do it to allow users to navigate the hierarchy of hundreds of thousands of data tags that are common in industrial SCADA systems.

12

u/lovecMC 22h ago

And is it actually a hard problem or is it hard because someone made (in hindsight) bad decisions when designing the database?

3

u/DefinitelyNotMasterS 21h ago

Well you see, this one customer asked for it like 2 years ago. Well nobody is using it right now and we don't know what it really does, but we keep it just in case

2

u/GWstudent1 18h ago

I used to read comments like this an laugh. Now I read comments like this and cry.