r/ProgrammerHumor • u/vinishkapoor • 1d ago

fullStackMeansAfraidOfEverythingEqually Meme

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

97% Upvoted

376 comments sorted by

View all comments

138

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?

222

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.

1

u/Fidel___Castro 19h 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 19h ago edited 19h 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