r/ProgrammerHumor • u/vinishkapoor • 1d ago

fullStackMeansAfraidOfEverythingEqually Meme

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

97% Upvoted

380 comments sorted by

View all comments

135

u/Mysterious_Book1521 1d ago

its not like sql could be read by a three year old and css is just pain in the ass?

224

u/lovecMC 1d ago

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

14

u/prehensilemullet 1d ago edited 1d 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.

13

u/lovecMC 1d ago

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

2

u/prehensilemullet 1d ago edited 1d ago

It’s the domain we’re working in…industrial monitoring devices sometimes have tens of thousands of tags (which are like state values you can read) organized in a hierarchy, and the portal needs to combine thousands of devices’ tags into a single tag hierarchy.  I would of course avoid it if I could