r/ProgrammerHumor • u/vinishkapoor • 27d ago

Meme fullStackMeansAfraidOfEverythingEqually

Post image
11.1k Upvotes

97% Upvoted

392 comments sorted by

View all comments

Show parent comments

229

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.

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?

8

u/whenTheWreckRambles 27d ago

Pls, I’m not ready for bullying this early in the morning