11
Replacing a 3 GB SQLite database with a 10 MB FST (finite state transducer) binary
(til.andrew-quinn.me)
A general programming discussion community.
And I find this extends to a more general principle of just pushing through solving a problem in order to understand it. Then once you've done that work, you can find a much better solution. It's easy to get stuck in an analysis paralysis loop where you try to come up with the perfect solution up front, but it's rarely possible to do for something you're doing for the first time. Doing a 'dumb' thing like making a giant mysql db that gets you to a working result is the right way to go about it.