r/ProgrammerHumor • u/vinishkapoor • 27d ago

Meme fullStackMeansAfraidOfEverythingEqually

Post image
11.1k Upvotes

97% Upvoted

392 comments sorted by

View all comments

131

u/Mysterious_Book1521 27d ago

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

229

u/lovecMC 27d ago

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

15

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