Category/database

Database

2 posts

Jun 29, 20211 min read#redis

Cache Aside Pattern

When updating the cache, after updating the database, should you update the cache or delete it? Or perhaps delete the cache first, then update the database—either way, there are certain issues involved.

Jul 29, 20201 min read#hive #mysql

The Self-Cultivation of a SQL Engineer

Since I personally prefer using window functions, I prioritized them in my solutions. Of course, these may not always be the optimal approaches—the answers are for reference only.