Understanding Redis Cache Types and Common Disasters
Redis is a common in-memory database. Reproducing scenarios to explain cache types, trade-offs, and common failures: penetration, breakdown, and avalanche.
Redis is a common in-memory database. Reproducing scenarios to explain cache types, trade-offs, and common failures: penetration, breakdown, and avalanche.
N+1 database query problem, its causes, and solutions: denormalization, DB-level joins ($lookup/JOIN), batch queries with assembly, and ORM/ODM eager loading.
Communicate with databases via SQL can lead to development efficiency and security issues. Usually we choose a suitable ORM for better development experience.
Interacting with RDB through SQL, SQL Builder, and ORM. Understanding their differences helps us make better choices for project needs.
The right type of database depends on the nature of that data. Understanding core concepts such as transactions, ACID, and normalization is essential.