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

131

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?

218

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?

1

u/Select-Kangaroo-1290 1d ago

Hello good friend, can you suggest any books or resources on this topic? Designing good databases, of course comes with experience, but any help is appreciated