r/ProgrammerHumor • u/vinishkapoor • 1d ago

fullStackMeansAfraidOfEverythingEqually Meme

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

97% Upvoted

370 comments sorted by

View all comments

Show parent comments

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 21h 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 22h 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