Skimming through the bullet points, it seems that a lot of that advice would be applicable to any storage engine. Storing too much data and not expiring it would seem to be just as much as a problem for flat files.

I would argue that it’s much harder to meet SQLite’s performance and stability targets with a home grown storage system than it would be to learn how to use SQLite effectively.