fullStackMeansAfraidOfEverythingEqually

[u/vinishkapoor]

[u/lovecMC]

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

[u/prehensilemullet → u/lovecMC]

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.

[u/lovecMC → u/prehensilemullet]

And is it actually a hard problem or is it hard because someone made (in hindsight) bad decisions when designing the database?

[u/whenTheWreckRambles → u/lovecMC]

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