Re:Appropriate Uses for SQLite
by TimWolla on Monday February 12, 2018 @07:42AM
(#16358224)
It doesn't say "require". Possibly they are selecting the same information over and over again, instead of passing it along the different functions, because it is fast enough.
[ Parent
| on HN ]
Even so, querying data once and reusing it is usually the more maintainable option and probably means less code, too. It is not only about performance.
(And just to be clear, for my use cases, I have been very happy with SQLite's performance.)
This requires an information architecture and these days those seem to be harder to come by. I think we may be favoring velocity over Stop and Think time a bit too much.
(If you’re thinking, “no dummy, just use caching” then I regret to inform you that cache invalidation and eviction without an info architecture are as hard if not harder. And caching bugs make you look like a clown in front of your bosses. Because the whack-a-mole process never looks professional)