Introduction to Computing and Caching in SQL

There’s a pretty common saying:

“There are only two hard things in computer science: cache invalidation and naming things.”

—Phil Karlton

Cache problems in SQL

It’s time that we see how to address the cache problems in SQL. Creating a set of values for caching is, of course, really easy, as it usually boils down to writing a SQL query.