PinnedInBetter ProgrammingbyJason Ngan·Jul 14, 20224 Rate Limit Algorithms Every Developer Should KnowA beginner’s guide to implementing rate limitA response icon6A response icon6
InLevel Up CodingbyJason Ngan·May 16, 20235 Must-Know Database Locks for Every DeveloperEssential techniques for data consistency
InLevel Up CodingbyJason Ngan·Apr 6, 2023Read Phenomena You Need to Know Before Learning SQL IsolationKey reasons why we need isolation in SQL
InLevel Up CodingbyJason Ngan·Mar 16, 2023Why is Offset Pagination So SlowDemystify using SQL Explain AnalyzeA response icon1A response icon1
InLevel Up CodingbyJason Ngan·Mar 8, 20232 Database Indexes Every Developer Should KnowClustered vs non-clustered indexes
InLevel Up CodingbyJason Ngan·Feb 27, 2023Database 101: Row-Based vs. Column-Based DatabasesWhat are the differences and why should you know?
InLevel Up CodingbyJason Ngan·Feb 19, 2023How Does SQL Store Data Internally?A brief introduction to SQL data pageA response icon1A response icon1
InLevel Up CodingbyJason Ngan·Feb 7, 20233 Caching Problems Every Developer Should KnowCache penetration, cache breakdown and cache avalanche
InLevel Up CodingbyJason Ngan·Feb 2, 20236 Caching Strategies For System Design InterviewsWhen and how to update your cacheA response icon2A response icon2
InLevel Up CodingbyJason Ngan·Feb 1, 20234 Reasons Why Single-Threaded Redis is So FastDesign choices that have stood the test of time