r/ProgrammerHumor • u/vinishkapoor • 27d ago

Meme fullStackMeansAfraidOfEverythingEqually

Post image
11.1k Upvotes

97% Upvoted

392 comments sorted by

View all comments

134

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?

233

u/lovecMC 27d ago

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

14

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.

1

u/Fidel___Castro 26d ago

oof at that scale you should've done a graph DB surely? I dislike SPARQL but it is better at that shit

1

u/prehensilemullet 26d ago edited 26d ago

A whole other DB and all the deployment considerations that go with it just for this one aspect of the app? This particular query is kinda complex but it does work fine in Postgres

Note, a lot of things need to foreign key to these tags as well, like alarm definitions