Query optimization with SQLite and Redis caching

We can't be waiting around for five seconds for a database to respond. When we are young we believe the SQL execution engine will handle everything and make sure we get our results on time. Sadly, this is not the case, at least in my experience. I'll walk through the evolution of one SQL query,…