Writing

How we solved a classic race condition in a multi-service streaming architecture using a conditional UPSERT for idempotent, ordered writes.

A guide to scalability in system design covering load parameters, performance metrics like latency and throughput, and vertical vs horizontal scaling.

An introduction to system reliability: the difference between faults and failures, and how hardware, software, and human errors cause them.

Explore the world of Retrieval-Augmented Generation (RAG) with Large Language Models (LLMs), Vector Stores, and Langchain. This in-depth guide covers everything you need to know to harness the power of RAG for question-answering, knowledge extraction, and content generation.

List comprehension in Python is a must-know tool for any programmer. Learn how to simplify your code with list comprehension, including advanced techniques like nested and multilevel comprehensions. Enhance your coding efficiency and readability today!

A guide to Python's walrus operator (:=) for writing cleaner, more concise code in loops, conditionals, and list comprehensions.

Solving LeetCode's Combine Two Tables problem with a SQL LEFT JOIN to report person details even when address data is missing.

Solving LeetCode's Employees Earning More Than Their Managers problem using a SQL self join.

Comprehensive SQL notes covering DDL, DML, DCL, table operations, joins, subqueries, and aggregate functions.

A quick guide to setting up GitHub CLI aliases so you can switch between multiple GitHub accounts without re-authenticating each time.

Concise personal notes on JavaScript fundamentals: data types, operators, type coercion, strings, arrays, functions, loops, and objects.

A dynamic programming approach to LeetCode's Unique Paths problem, moving from a naive recursive solution to memoization, with Python code.

A stack-based algorithm for checking balanced parentheses, with a C++ implementation and step-by-step visuals of pushing and popping brackets.