I call this my “rule of three” - I wait until I’ve seen “something” three times before deciding on an abstraction. Two isn’t enough to get an idea of all the potential angles, and if you don’t touch it a third time, it’s probably not important enough to warrant the effort and risk of a refactor
Funniest for me is Starship Mine, for several reasons.
Wuff… I’m no expert, but this looks like the materialized path pattern, which expressly sacrifices write perf for lookup perf. I’ve used it in the past for managing, say, an e-commerce site product category taxonomy - something that isn’t going to change very often, but liable to get hammered with reads.
I can’t say what might improve this without more research, but I can tell you that this type of pattern isn’t supposed to be performant on write.
Sorry, I’m still watching the opening sequence of motion picture, I’ll let you know what I think when it’s done.
/snark
But for real, I feel like the last season of Picard was finally a chance to see the TNG TV characters in action in a TNG movie.