Digital Garden
A collection of my notes, thoughts, and writings. These are public notes directly synced from my Obsidian vault on GitHub.
Back-of-the-Envelope Estimation
Practice sheet for capacity math in SD interviews. Built after the URL Shortener mock (2026-07-20) where a 10× error appeared twice — once in records/year, once left stale in storage after the input w
Back-of-Envelope Estimation
Capacity math is step 2 of every HLD ([[SD Interview Framework & Pitfalls]]). Point isn't a precise number — it's justifying architecture. "Writes fit on one Postgres box" vs "writes need sharding + a
Go Channels
What: make(chan T) — capacity 0; every send blocks until a receiver is ready and vice versa. It's a synchronization point, not a queue. Syntax/Signature: ch := make(chan int); send ch <- v; receive v
Go Concurrency Patterns
What: A fixed set of N goroutines consuming from a shared jobs channel — bounds concurrency and memory regardless of input size. Syntax/Signature: jobs chan In + results chan Out + sync.WaitGroup (or
Go Context & Cancellation
What: The standard mechanism for propagating cancellation, deadlines, and request-scoped values down a call tree. Cooperative: work stops only where code checks ctx.Done(). Syntax/Signature: ctx, canc
Go Data Structure Internals
What: An array [N]T is a fixed-size value (copied on assignment). A slice is a 3-word header {ptr T, len, cap int} viewing a backing array — copying a slice copies the header, aliasing the data. Synta
Go Embedding & Dependency Injection
What: Placing a type name (not a named field) inside a struct or interface promotes its methods/fields to the outer type. Composition, not inheritance — there is no virtual dispatch back to the outer
Go Error Handling
What: Wrapping preserves an error chain while adding context; Is walks the chain comparing to a target value, As walks it looking for a target type, Join (1.20+) aggregates multiple errors into a tree
Go Goroutine Leaks
What: A goroutine blocked forever (channel op, lock, or infinite loop) with no termination path. Each leak pins its stack and everything reachable from it; leaks accumulate in servers until OOM. Synta
Go Goroutines & Scheduling
What: A goroutine is a runtime-managed, cheaply-created unit of execution (2 KB initial stack, grows/shrinks dynamically) multiplexed onto OS threads by Go's scheduler. Syntax/Signature: go f(args) —
Go Interface Internals
What: A type satisfies an interface if its method set contains every method of the interface — no implements keyword, checked structurally at compile time at the point of conversion/assignment. Syntax
Go Race Conditions & Memory Model
What: A data race = two goroutines access the same memory location concurrently, at least one is a write, with no synchronization edge between them. Go declares racy programs to have undefined behavio
Go Receivers & Control Flow
What: func (t T) M() operates on a copy; func (t T) M() on the original. Choice affects mutation, copy cost, method sets, and interface satisfaction. Syntax/Signature: Method set rule: T → value-recei
Go Sync Primitives
What: Mutual exclusion locks. RWMutex allows unlimited concurrent readers or one writer. Syntax/Signature: mu.Lock()/Unlock(); rw.RLock()/RUnlock(); both have TryLock (1.18, rarely appropriate). Zero
Go Type Assertions & Generics
What: Runtime extraction of the concrete type (or a narrower interface) from an interface value. Syntax/Signature: v, ok := i.(T) (comma-ok, safe) · v := i.(T) (panics on mismatch) · switch v := i.(ty
Go Zero Values, Enums & Options Pattern
What: Every Go value is initialized: numeric 0, "", false, nil for pointers/slices/maps/chans/funcs/interfaces. Idiomatic APIs make the zero value immediately usable. Syntax/Signature: var mu sync.Mut
MongoDB
The canonical document database — see [[SQL vs NoSQL]] for the general decision framework this fits into. This page is MongoDB-specific mechanics: the document model, replica sets, sharding, and the a
Postgres Internals
MVCC and isolation levels are covered in [[SQL Transactions & ACID]]; EXPLAIN/indexing in [[SQL Indexes & Query Performance]]. This page is Postgres-specific physical internals — how MVCC is actually
Python asyncio
Single-threaded concurrency via cooperative multitasking — one thread, one event loop, many coroutines. Best for I/O-bound work (HTTP, DB, file reads). For when to reach for asyncio over threading/mul
FastAPI
Modern async Python web framework, built on Starlette (ASGI) + [[Pydantic]]. Auto-generates OpenAPI docs from type hints — the schema isn't written separately from the code, it's derived from it. pyth
Python: Identity, Mutability & Memory
== checks value equality; is checks identity — whether two names point to the exact same object in memory. python a = [1, 2, 3] b = [1, 2, 3] a == b # True — same value a is b # False — different
Pydantic
Data validation using Python type hints as the schema — the standard validation layer under FastAPI. Pydantic v2 (current) is Rust-backed internally — roughly 5-50x faster than v1's pure-Python valida
Python Concurrency: GIL, Threading, Multiprocessing, Asyncio
The Global Interpreter Lock (GIL) allows only one thread to execute Python bytecode at a time, even on a multi-core machine — this single fact is why Python's concurrency story has three genuinely dif
Python Decorators
A decorator is a function that takes another function as an argument, adds behavior around it, and returns a new (usually wrapped) function — without permanently modifying the original function's sour
Python Generators & Iterators
A list computes and stores every value in memory upfront. A generator yields values lazily, one at a time, only when asked — using O(1) memory regardless of how many values it will eventually produce.
Python Gotchas Cheat Sheet
Fast last-minute-review reference. Full explanations for the non-obvious ones live on their dedicated pages — this is the recall table, not the teaching material. Gotcha Rule Full page ---------
Python Logging
Python's built-in logging module is the production standard. print() in production code has no severity levels, no structured output, and can't be selectively disabled without editing source — logging
Python OOP & Data Model
- Encapsulation — bundling data and methods together, hiding internal state so nothing outside the class depends on it directly. In Python this is achieved mostly by convention, not enforcement: prefi
Python: Scoping & Closures
Python resolves a name by searching these scopes in order: Local → Enclosing → Global → Built-in. python x = "global" def outer(): x = "enclosing" def inner(): x = "local" prin
Redis — See Caching & Redis
Redis content lives in [[Caching & Redis]] (System Design/Concepts/Caching & Redis.md) — written first as a Wave 0 fundamentals page since Redis is referenced across many HLD/LLD problems, not filed s
SQL Aggregates & GROUP BY
sql SELECT COUNT(), COUNT(column), COUNT(DISTINCT col), SUM(salary), AVG(salary), MIN(salary), MAX(salary) FROM employees; COUNT() counts every row including NULLs; COUNT(column) skips NULLs in that c
SQL Basics & Query Fundamentals
sql SELECT name AS employeename, salary 12 AS annualsalary FROM employees; SELECT FROM employees WHERE department = 'Engineering' AND salary 80000; SELECT FROM employees WHERE salary BETWEEN 50000
SQL Classic Interview Problems
The recurring problem shapes that show up across DataLemur, LeetCode SQL 50, and real fintech/product interviews (Razorpay, PhonePe, Juspay-style rounds). Each pattern below is worth being able to wri
SQL Constraints & Schema DDL
Category Stands for Commands Purpose ------------ DDL Data Definition Language CREATE, ALTER, DROP, TRUNCATE Defines/changes schema DML Data Manipulation Language INSERT, UPDATE, DELETE M
SQL Indexes & Query Performance
A separate data structure (usually a B-tree) storing column values plus pointers back to the actual table rows — trading write overhead and storage space for read speed. sql CREATE INDEX idxordersuser
SQL JOINs
INNER JOIN LEFT JOIN RIGHT JOIN FULL OUTER JOIN A ∩ B A (+ B if match) B (+ A if match) A ∪ B sql -- INNER — only matched rows in both tables SELECT u.
SQL Pivoting
Transform row data into columns (pivot) or columns into rows (unpivot). Standard SQL has no native PIVOT — CASE WHEN inside an aggregate is the portable answer. Input (long format): one row per (user,
SQL Security & Injection Defense
Every senior backend screen asks about SQL injection defense — a genuinely must-know topic, not trivia. python query = f"SELECT FROM users WHERE id = '{userinput}'" If userinput = "' OR '1'='1": sql
SQL String & Date Functions
sql SELECT LENGTH('hello'); -- 5 SELECT UPPER('hello'), LOWER('HELLO'); SELECT TRIM(' hello '); -- 'hello' SELECT SUBSTRING('hello world', 7, 5); -- 'world' (
SQL Style & Best Practices
Writing a correct query and writing a query that reads as senior-level are different skills — this page is the second one. sql -- Good: uppercase keywords, descriptive lowercase aliases, aligned colum
SQL Subqueries & CTEs
sql -- Scalar — returns a single value SELECT name, salary FROM employees WHERE salary (SELECT AVG(salary) FROM employees); -- Multi-row — use with IN / ANY / ALL SELECT name, salary FROM employees W
SQL Transactions & ACID
sql BEGIN; UPDATE accounts SET balance = balance - 500 WHERE id = 1; UPDATE accounts SET balance = balance + 500 WHERE id = 2; COMMIT; -- or ROLLBACK to undo everything since BEGIN -- Savepoints
SQL UNION & Set Operations
Combine results from multiple SELECT statements — all must have the same column count with compatible types. sql -- UNION — deduplicates (sort/hash under the hood — real cost on large sets) SELECT cit
SQL Views, Procedures & Triggers
Server-side database objects that wrap queries or logic. Common interview territory even where production usage varies by team/philosophy. A stored SELECT — no data of its own, re-runs the underlying
SQL Window Functions
Compute a value per row using rows around it — without collapsing rows the way GROUP BY does. This is the single most-tested "senior-level" SQL topic. sql functionname() OVER ( PARTITION BY col
HTML & CSS Fundamentals
Using tags that convey meaning (<nav, <article, <header, <button) instead of generic <div/<span for everything. Why it matters beyond style: screen readers and other assistive tech rely on semantic ta
JS Closures & Async
A function that retains access to its enclosing scope's variables even after that outer function has returned. javascript function makeCounter() { let count = 0; // private — inaccessibl
JS Core Language & Data Types
8 types: Number, BigInt, String, Boolean, Null, Undefined, Symbol (primitives) + Object (reference). javascript typeof null // "object" — a famous, unfixable-for-compatibility JS bug; null is
JS DOM & Events
Nodes include everything (comments, text, elements) — navigated via childNodes, firstChild, nextSibling. Elements are HTML tags only — navigated via children, firstElementChild, nextElementSibling. In
JS Machine Coding Patterns
The recurring "implement this from scratch" set — expect at least one of these in any JS machine-coding round. Debounce: run only after the trigger has paused for delay ms — good for search-input, res
JS Prototype & OOP
Every object has an internal [[Prototype]] link to another object. Accessing a missing property walks up this chain until found or null is reached. javascript const animal = { breathes: true }; const
React Hooks Deep-Dive
jsx const [count, setCount] = useState(0); setCount(prev = prev + 1); // functional form — required when the new state depends on the old State updates are asynchronous/batched — reading count immed
React Machine-Coding (Frontend System Design)
"Design the frontend for X" rounds — 30-45 min, focused on architecture and data flow, not pixel-level design. 1. Clarify requirements (5 min) — functional scope + non-functional (scale, performance,
React Patterns & State Management
jsx // Controlled — React state IS the source of truth for the value const [val, setVal] = useState(''); <input value={val} onChange={e = setVal(e.target.value)} / // Uncontrolled — the DOM itself own
React Performance & Reconciliation
React maintains a virtual (in-memory) representation of the UI tree; on a state change, it builds a new virtual tree and diffs it against the previous one, applying only the minimal real-DOM mutations
API Design Principles
Tested in system design rounds, backend interviews, and "design this endpoint" questions. Constraint What it means ------ Stateless Server holds no client session; every request carries all conte
API Gateway
A single entry point that sits in front of a microservices backend, so clients talk to one address instead of knowing about (and coupling to) every individual service's location. It's a specialized re
Blob & Object Storage
Storage for large, unstructured binary data (images, videos, file uploads, backups) — deliberately not a database. Flat namespace of key → blob (bucket + object key), not rows/tables. S3, GCS, Azure B
CAP Theorem & Consistency Models
A distributed system, during a network partition, can only guarantee two of three: - Consistency — every read returns the most recent write - Availability — every request gets a (non-error) response -
CDN (Content Delivery Network)
A geographically distributed network of edge servers that cache content physically close to users, cutting network latency by avoiding a round trip to the origin server for every request. It's a rever
Caching & Redis
Caching appears in virtually every system design interview. Redis is the default distributed cache. Master both the concept and the trade-offs. - DB reads are 1–10ms. Cache reads are 0.1ms. - Reduces
Communication Protocols (HTTP Polling, Long Polling, WebSockets, SSE, gRPC)
"How does the client get real-time updates?" is really "what's the trade-off between connection overhead, latency, and infrastructure complexity you're willing to accept?" Every chat/notification/live
Consistent Hashing
Markers: ⭐ MUST KNOW — core answer, asked directly. 🎯 FOCUS — high-value senior-loop follow-up. 💡 GOOD TO KNOW — depth/impressor, recognize + one-liner is enough. - Naive approach: server = hash(key
Core Vocabulary & Quality Pillars
Every HLD interview scores you against these four qualities, implicitly or explicitly. Naming which one you're prioritizing — and why — is the difference between a design that "just happens" and one t
Database Replication & Sharding
Copy the same data onto multiple nodes. Master-slave (primary-replica): writes go to the primary, reads distributed across replicas — increases read throughput and gives a failover target if the prima
LLD Interview Approach
Typically a 1–2 hour session: design a class structure, then implement it (usually in Python or Java). Common at companies with a dedicated machine-coding round (CRED, BrowserStack, Razorpay, Flipkart
Latency vs Throughput
Low Latency High Throughput --------- Goal Fast single request Maximum requests/sec, individual delay less critical Technique Caching, in-memory state, fewer network hops Batching, queuing, p
Load Balancing
Distributes incoming requests across multiple servers — prevents any single instance from being overloaded, enables adding/removing capacity without downtime, and is the mechanism that makes horizonta
Merkle Trees
Two replicas are supposed to hold the same data (see [[Database Replication & Sharding]], [[Distributed Key-Value Store]]) but may have silently drifted apart — a missed write, a dropped hint, a bug.
Message Queues & Kafka
Message queues decouple producers from consumers, enabling async processing and absorbing traffic spikes. Kafka is the dominant distributed event-streaming platform — it shows up in notification, feed
OOD Design Patterns
Five patterns cover the large majority of LLD interview extensibility follow-ups. Recognize which one fits before the interviewer asks — naming it unprompted in the design phase is the signal. Use whe
Proxies (Forward vs Reverse)
Sits in front of clients, hides client identity from the server. Common uses: corporate networks, VPNs, content filtering, and some client-side caching. mermaid flowchart LR Client -- FP[Forward P
SD Interview Framework & Pitfalls
Applies to every HLD problem in this KB — see each problem page for it applied end-to-end. 1. Clarify requirements — functional (what it does, explicitly cut what it doesn't) + non-functional (scale,
SOLID Principles
Principle One line Example --------- S — Single Responsibility One class, one reason to change OrderProcessor doesn't also send emails — that's a NotificationService's job O — Open/Closed Ope
SQL vs NoSQL
Not "which is better" — it's "what does the access pattern actually need." Every HLD problem's data-model section should justify this choice against the specific read/write pattern, not a general pref
Service Discovery & Health Checks
In a horizontally-scaled system, instances come and go constantly — autoscaling, deploys, crashes. Clients and load balancers need to know, at any moment, which instances are actually alive. Each inst
Single Point of Failure
Any component whose failure takes down the whole system. Load balancers, coordinators, and service-discovery nodes are common SPOFs precisely because their job is centralizing routing decisions — the
Design Ad-Click Aggregation (Stream Processing)
Design a system that ingests a massive stream of ad-click events and aggregates them (clicks per ad per minute, for billing and reporting) accurately, at high throughput, in near-real-time. This is th
Design a Unique ID Generator in Distributed Systems
Design a service that generates unique IDs at scale, across multiple servers, with no single point of coordination on the hot path. This looks trivial (AUTOINCREMENT works on one database) until the s
Design a Distributed Job Scheduler
Design a system that schedules and executes jobs (cron-style recurring tasks, or one-off delayed jobs) reliably across a fleet of worker machines. The defining challenge is exactly-once-ish execution
Design a Distributed Key-Value Store
Design a Dynamo/Cassandra-style distributed key-value store: put(key, value) and get(key), horizontally scalable, surviving node failures without downtime. This is the problem that makes CAP theorem c
Design a Distributed Message Queue (Kafka-style)
Design the message queue infrastructure itself — not a system that uses Kafka (that's every other problem in this KB touching [[Message Queues & Kafka]]), but Kafka-the-system: how partitions, replica
Design Dropbox (File Storage & Sync)
Design a file storage and sync service: upload files, sync them across a user's devices, handle edits efficiently. The defining challenge isn't storage (that's [[Blob & Object Storage]] again) — it's
Design Google Docs (Collaborative Editor)
Design a real-time collaborative document editor: multiple users typing in the same document simultaneously, with everyone converging on the same final content, without an explicit merge step. This is
Design a News Feed (Twitter/X Timeline)
Design a social feed: users post short updates, follow other users, and see a reverse-chronological (or ranked) timeline of posts from people they follow. This is one of the most-asked HLD problems be
Design a Notification System
Design a system that sends push, email, and SMS notifications triggered by backend events (order placed, message received, price drop) to potentially millions of users. The class-design version of cha
Design a Payment System
Design a system that processes payments between users/merchants — charge a card, move money, record the result — reliably enough that money is never lost, never duplicated, and always accounted for, e
Design Typeahead / Search Autocomplete
Design the suggestion dropdown that appears as a user types into a search box (Google-style): given a prefix, return the top-K most likely completions, fast enough to update on every keystroke. The de
Design Uber / Ride-Sharing (Geospatial + Real-Time Matching)
Design a ride-sharing system: riders request trips, get matched to a nearby available driver in near-real-time, track the driver's position live, and get dynamic pricing under supply/demand pressure.
Design a Web Crawler
Design a system that systematically downloads web pages, extracts links, and crawls those links recursively, at the scale of the entire web (billions of pages). The defining challenges are not downloa
Design WhatsApp (Chat System)
Design a real-time 1-1 and group messaging system: message delivery whether the recipient is online or not, delivery/read receipts, presence, and media sharing. The defining challenge isn't storage (t
Design YouTube / Netflix (Video Streaming)
Design a video platform: upload, process, and stream video at global scale with adaptive quality. The defining challenge isn't storage (that's [[Blob & Object Storage]]) or even streaming itself — it'
Design a Board Game (Tic-Tac-Toe, generalized)
Tic-Tac-Toe itself is trivial; the interview value is in generalizing win detection so it doesn't hardcode "3 in a row on a 3x3 board" — a candidate who writes 8 explicit if checks for the 8 winning l
Design an Elevator System
Harder than Parking Lot because the core challenge isn't matching (spot to vehicle) but scheduling under a moving state — which elevator should answer which call, and in what order should a single ele
Design an LRU Cache
The single most common LLD warm-up because the "obvious" solution (a dict) doesn't give O(1) eviction, and the correct solution (hash map + doubly linked list) is a specific, well-known composition of
Design a Notification System (LLD)
This is the class-design version: model notification channels (email, SMS, push), user preferences per channel, and the fan-out to multiple channels for one event — as clean, extensible objects. The d
Design a Parking Lot
A classic LLD warm-up because it forces the fundamentals without much domain complexity: multiple entity types (vehicles, spots, tickets), a matching/allocation rule, and an obvious extensibility foll
Design a Rate Limiter (LLD)
The [[Rate Limiter]] HLD page covers the distributed systems version — Redis, atomicity across gateway instances, fail-open/closed at scale. This page is the class-design version asked in a machine-co
Design Splitwise (Expense Sharing & Debt Simplification)
Two distinct sub-problems disguised as one: (1) modeling an expense split (equal, exact, percentage), and (2) debt simplification — given a tangle of who-owes-whom, compute the minimum number of trans
Design a Vending Machine
The canonical State pattern problem. The naive solution — a pile of booleans (hasmoney, itemselected, isdispensing) with if chains checking combinations — allows invalid states to exist in principle (
Design a URL Shortener
--- A URL shortener takes a long URL like https://www.example.com/products/electronics/laptop?ref=campaign2026&utmsource=twitter and produces a short one like https://short.ly/aB3xY9z. Anyone who open
Design a Rate Limiter
A rate limiter caps how many requests a client (user, API key, IP, or service) can make in a given time window, rejecting the rest. Every public API needs one — it's the difference between a bad actor
Interview KB — Master Index
Standalone interview-prep knowledge base — every page here cross-links only to other pages inside this KB, nothing external. One deep page per problem, one small focused page per concept/sub-topic. Al
Redis
Redis is an open-source in-memory data structure store, usable as: - Database - Cache - Message broker - Streaming engine It provides data structures out of the box: - hash, list, set, sorted set, bit
Defining Nonfunctional Requirements
DDIA 2nd edition — Chapter 2 notes. (Complete — only book Summary left, skippable) Sections covered: Functional vs Nonfunctional ✅ · Case Study: Home Timelines ✅ (Representing Users/Posts/Follows ✅ ·
DDIA Interview Map
How to read Designing Data-Intensive Applications as HLD/System-Design interview fuel — not as a textbook to finish. Maps each chapter to the interview lever it unlocks, the design problem to pair it
Trade-Offs in Data Systems Architecture
DDIA 2nd edition — Chapter 1 notes. (Complete — only book Summary left, skippable) Sections covered: Operational vs Analytical ✅ · Characterizing Txn/Analytics ✅ · Data Warehousing ✅ · Systems of Rec
SD Theory Curriculum
Structured theory foundation before tackling design problems. Track section completion here. Related: [[synthesis/Job Switch Hub]] [[synthesis/Coach Hub]] [[System Design/System Design Basics]] ---
Arrays & Hashing
- Need O(1) lookup (does X exist? how many times?) - Reducing O(N²) brute force to O(N) by trading space for time - Grouping elements by a shared property (anagrams, frequencies) - Finding relationshi
Linked Lists
- Problem involves pointer manipulation (reversal, merging, cycle) - O(1) space constraint — no converting to array - Relative ordering of nodes matters, or need to process end-to-beginning Signal phr
Trees
- Hierarchical data, parent-child relationships - Path, depth, LCA, validation problems - DFS → path/property problems, BST operations - BFS → level-by-level, shortest path to leaf, right/left view Si
Heap & Priority Queue
- "Top K", "Kth largest/smallest", "K most frequent" - Need to repeatedly get min or max efficiently - Merging multiple sorted streams - Median in a dynamic stream - Minimize total cost by always comb
Backtracking
- Problem asks for all combinations / permutations / subsets - Constraint satisfaction (N-Queens, Sudoku, Word Search) - Brute force with pruning — explore then undo (backtrack) invalid paths Signal p
Greedy Algorithms
- Problem asks for min/max and locally optimal choice leads to globally optimal result - No need to revisit past choices (contrast: DP considers all options) - Sort first, then scan linearly with a si
Math & Geometry
- Large number operations (overflow, modular arithmetic) - Prime number problems - Grid transformations: rotate, spiral, zero-out - GCD, LCM, factorial digit counting Signal phrases: "count primes", "
Coach Hub
LLM-maintained. Updated after every retro or scorecard. Read by /coach to get current week state without scanning Private/ for the right weekly file. --- currentweek: W06 / Sprint S2 (Jun 29–Jul 5, 20
Constraints
Rules enforced by DB engine on column/row data. Violations rejected at write time. Way better than app-level checks — DB never lies. Constraint What it enforces ------------------------------ NOT
DDL, DML, DCL, TCL
SQL statements grouped by purpose. Interview-classic — "is TRUNCATE DDL or DML?" Category Stands for Commands What it does ---------------------------------------------- DDL Data Definition Lan
SQL Security
Privileges + injection prevention. Interview must-know — every senior screen asks about SQLi defense. User input concatenated into a query, attacker breaks out of the literal and runs arbitrary SQL. V
Views, Procedures, Triggers
Server-side database objects that wrap queries or logic. Interview territory; production usage varies by team. Stored SELECT statement, behaves like a virtual table. No data of its own — re-runs under
SQL Aggregates & GROUP BY
sql SELECT COUNT() AS totalrows, -- count all rows including NULLs COUNT(column) AS nonnullcount, -- count non-NULL values only COUNT(DISTINCT col) AS uniquecoun
SQL Basics
sql -- All columns SELECT FROM employees; -- Specific columns SELECT name, salary FROM employees; -- With alias SELECT name AS employeename, salary 12 AS annualsalary FROM employees; -- Computed col
Writing Clean SQL
sql -- ✅ Good: uppercase keywords, lowercase identifiers, aligned columns SELECT u.name, u.email, COUNT(o.id) AS ordercount, SUM(o.total) AS totalspent FROM users u JOIN orders o ON u.id = o.
SQL Indexes & Performance
Separate data structure (usually B-tree) that stores column values + pointers to table rows. Trades write overhead + storage for read speed. sql -- Create index CREATE INDEX idxordersuserid ON orders(
SQL JOINs
INNER JOIN LEFT JOIN RIGHT JOIN FULL OUTER JOIN A ∩ B A (+ B if match) B (+ A if match) A ∪ B [AABB] [AAB ] [ ABB] [AA
SQL Pivoting
Transform row data into columns (pivot) or column data into rows (unpivot). SQL has no native PIVOT in standard SQL — use CASE WHEN. --- Input: long format — one row per (user, metric) userid metric
SQL String & Date Functions
sql -- Length SELECT LENGTH('hello'); -- 5 SELECT CHARLENGTH('hello'); -- 5 (alias) -- Case SELECT UPPER('hello'); -- HELLO SELECT LOWER('HELLO'); -- hello -- Trim
SQL Subqueries & CTEs
sql -- Employees earning above average SELECT name, salary FROM employees WHERE salary (SELECT AVG(salary) FROM employees); -- Salary difference from company average SELECT name, salary, salary - (
SQL Transactions & ACID
sql BEGIN; -- or START TRANSACTION UPDATE accounts SET balance = balance - 500 WHERE id = 1; UPDATE accounts SET balance = balance + 500 WHERE id = 2; COMMIT; -- make changes permanent -- On error
SQL UNION & Set Operations
Combine results from multiple SELECT statements. All SELECTs must have the same number of columns with compatible data types. --- sql -- All cities from customers AND suppliers (deduped) SELECT city F
SQL Window Functions
Compute a value per row using rows around it — without collapsing rows like GROUP BY does. sql functionname() OVER ( PARTITION BY col -- reset window per group (optional) ORDER BY col -- r
LLM Fundamentals — Transformer Stack to AI Systems
Source: [[raw/20 Most Important AI Concepts Explained in Just 20 Minute]] Full stack: from raw text → tokens → vectors → transformer → LLM → training → inference → systems. --- Layers of connected neu
Real Interview SD Questions — 10+ Companies
Source: [[raw/Every System Design Question I Was Asked in Real Interviews at 10+ Companies]] Author: Senior Backend Engineer at Canva. 15+ companies, 10+ SD rounds documented. Key insight: "Design Twi
SQL Topics
Topic Notes --------------------------- ------------------------------------------------------
Senior SD Mindset — L7 Lessons
Source: [[raw/The Day a Google L7 Engineer Tore My System Design to Shreds]] The gap between mid-level and staff-level system design isn't more patterns — it's understanding the physics behind the pat
Frontend System Design
Tested in: Full-stack and senior FE interviews at CRED, Razorpay, Flipkart, Meesho. Format: "Design the frontend for X" — 30-45 min. Focus on architecture, not pixel design. --- 1. Clarify requirement
SQL for Interviews
Tested at: Razorpay, PhonePe, Juspay, Zepto, most fintech/product companies. Round format: 2-3 queries in 30-45 min. Medium complexity expected. --- sql -- Logical execution order (not written order):
API Design Principles
Tested in: System Design rounds, backend interviews, "design this endpoint" questions. --- Constraint What it means ------ Stateless Server holds no client session. Every request carries all cont
Docker & Kubernetes
Conceptual reference only — not tested as a coding round. Know these for verbal questions and SD discussions. --- Containerization — package app + dependencies into an isolated, portable unit. Same co
Low Level Design (LLD) & Machine Coding
Round format: 1-2 hr coding session. Design a class structure + implement it in Python. Tested at: CRED, BrowserStack, Razorpay, Flipkart, Meesho. --- 1. Clarify (5 min) - Who are the users? What a
Design Google Docs (Collaborative Editor)
The hardest SD problem. Core challenge: multiple users editing same document simultaneously without conflicts. --- Functional: - Multiple users edit same document in real-time - All users see each oth
Design Twitter Feed (Social Media Feed)
Scale: 300M DAU, 500M tweets/day, 28B feed reads/day. Read-heavy (read:write ≈ 100:1). --- Functional: - Post tweet (text, images, links) - Follow / unfollow users - View home timeline (tweets from fo
Design WhatsApp (Chat System)
Scale: 2B users, 100B messages/day, 65B messages/day (pre-2022). --- Functional: - 1-1 messaging - Group messaging (up to 1024 members) - Message delivery status (sent ✓, delivered ✓✓, read ✓✓ blue) -
Design YouTube / Netflix
Scale: 500hr video uploaded/minute (YouTube). 200M+ daily active users (Netflix). --- Functional: - Upload video - Stream video (adaptive bitrate) - Search videos - Recommendations (out of scope unles
AWS CloudWatch
AWS's observability platform. Collects metrics, logs, traces, and events from all AWS services. Core for production monitoring and the MLA-C01 exam. --- Component What it is Analogy --------------
AWS RDS
Managed relational database service. Handles provisioning, patching, backups, and failover. Supports PostgreSQL, MySQL, MariaDB, Oracle, SQL Server, and Aurora. --- Concept Description ------------
AWS SQS & SNS
SQS = managed message queue (point-to-point). SNS = managed pub/sub (fan-out). Used together for reliable async decoupling. --- Standard Queue FIFO Queue --------------------- Ordering Best-effo
Merge Intervals
Used for problems involving overlapping ranges (time slots, events, schedules). 10-15% of array problems fall here. Identify this pattern when: - Input is a list of [start, end] pairs - Problem asks t
Bit Manipulation
Fast integer operations using binary representation. Small topic, high payoff — problems are easy once you know the tricks. --- python a & b # AND — both bits 1 a b # OR — either bit 1 a ^ b
Prefix Sum
Pre-compute cumulative sums to answer range-sum queries in O(1) instead of O(n). Identify this pattern when: - "Sum of elements between index i and j" - "Subarray sum equals K" - "Count subarrays with
TypeScript
Typed superset of JavaScript. Catches errors at compile time. Standard for Next.js, React, Node.js in 2026. Your portfolio (vectorbuilds.dev) is TypeScript + Next.js. bash npx tsc --init # create
Go Context
context.Context is the standard way to carry deadlines, cancellations, and request-scoped values across API boundaries and goroutines. Every production Go service uses it. Pass ctx as the first parame
Go HTTP Server
net/http ships a production-ready HTTP server in the standard library. No framework needed for most services. --- go package main import ( "fmt" "net/http" ) func main() { http.HandleFunc(
Go Testing
Go ships a testing package with everything you need. No external framework required for basic tests. testify is the standard third-party addition. bash go test ./... # run all tests go te
Python asyncio
Single-threaded concurrency via cooperative multitasking. One thread, one event loop, many coroutines. Best for I/O-bound tasks: HTTP, DB, file reads. --- python import asyncio async def fetch(url: st
FastAPI
Modern async Python web framework. Standard choice for AI/ML APIs and backend services. Built on Starlette (ASGI) + Pydantic. Auto-generates OpenAPI docs. bash pip install fastapi uvicorn[standard] uv
Pydantic
Data validation library using Python type hints. Standard in FastAPI and LangChain. v2 (current) is Rust-backed — 5-50x faster than v1. bash pip install pydantic # v2 by default --- python from pyda
Caching & Redis
Caching appears in virtually every system design interview. Redis is the default distributed cache. Master both the concept and the tradeoffs. --- - DB reads are 1-10ms. Cache reads are 0.1ms. - Reduc
Consistent Hashing
[!success] Status: COMPLETED Full depth covered. Below is marked so you know what to drill vs what's bonus. [!info] How to read the markers - ⭐ MUST KNOW — core answer, will be asked directly. Dril
Message Queues & Kafka
Message queues decouple producers from consumers, enabling async processing and absorbing traffic spikes. Kafka is the dominant distributed event streaming platform. Appears in notification, feed, Ube
Wiki Index
Updated 2026-05-16 125 pages Added 3 missing DSA Techniques entries (Arrays & Hashing, Greedy, Math & Geometry); fixed section counts; renamed DSA Techniques files with numeric prefixes LLM: read th
Concurrency Deep Dive
Cross-language synthesis: Go goroutines ↔ Python async/threading ↔ distributed concurrency patterns. Most engineers know one — knowing all three is a rare interview differentiator. --- Single-threaded
Interview Prep Hub
Aggregated technical templates + behavioral stories for interview prep. LLM: update when new patterns added, SD problems completed, or behavioral stories refined. Plan window: May 11 → Nov 11, 2026.
Job Switch Hub
Goal: 50+ LPA offer Plan window: May 11 → Nov 11, 2026 (26 weeks) Current week: see [[Coach/projectcurrentweek]] LLM: update this page when DSA progress changes, SD problems completed, applications
LLM & AI Stack
Cross-domain synthesis: LangChain + MCP + RAG patterns + AWS AI services. Primary moat for targeting AI companies. LLM: update when new AI/ML content ingested or work experience notes added. --- Appli
Tech Stack Overview
How to position skills in interviews and on resume. LLM: update when new skills added, certs achieved, or projects shipped. --- Python (Expert) ─────────────── 5 years, production RAG/LLM systems Go (
Go Enums
Go has no built-in enum keyword. The idiomatic alternative is a typed constant group combined with iota — a compile-time counter that auto-increments within a const block. The result behaves like an e
Go Generics
Generics (introduced in Go 1.18) let you write functions and types that work across multiple types without duplicating code. The key idea: type parameters — placeholders for concrete types supplied at
Go Proverbs
A collection of wise, pithy design principles from Rob Pike — one of Go's creators. Presented at Gopherfest 2015, they capture the philosophy behind idiomatic Go. Similar in spirit to the Zen of Pytho
Go HTTP Clients
Go's standard library ships a production-ready HTTP client in net/http — no third-party dependency needed. This note covers the full lifecycle: making requests, working with JSON, understanding URLs a
Go Mutexes
A mutex (mutual exclusion lock) protects shared data from concurrent access. While channels communicate data between goroutines, a mutex guards data that multiple goroutines read or write directly. Fr
AWS Lambda
- Serverless compute — run code without provisioning or managing servers - Event-driven — executes in response to triggers (S3, API Gateway, Kinesis, DynamoDB Streams, SNS, SQS, etc.) - FaaS (Function
Go Channels & Goroutines
Go's concurrency model is built on two primitives: goroutines (lightweight threads managed by the Go runtime) and channels (typed, thread-safe pipes for goroutines to communicate through). The philoso
Go Control Flow
Go's control flow for conditionals is intentionally minimal: if/else for branching and switch as a cleaner alternative to long if-else chains. No parentheses around conditions, braces always required.
Go Error Handling
Go handles errors as values, not exceptions. There's no try/catch — instead, functions return an error as the last return value, and callers check it explicitly. This makes error paths visible, forces
Go Functions
Functions are first-class citizens in Go — they can be assigned to variables, passed as arguments, and returned from other functions. Types come after variable names. Go natively supports multiple ret
Go Quiz & Coding Challenges
How to use: Go section by section. For "What's the output?" — reason through it before expanding. For coding challenges — write the solution first, then verify. --- go package main import "fmt" var x
Go Interfaces
An interface defines a set of method signatures. Any type that implements all those methods automatically satisfies the interface — no explicit implements declaration needed. This is called structural
Go Loops
Go has exactly one looping construct: for. It replaces C's for, while, and do-while. No parentheses around the loop header, braces always required. This keeps the language minimal without sacrificing
Go Maps
A map is Go's built-in hash map — an unordered collection of key-value pairs with O(1) average lookup, insert, and delete. Keys must be a comparable type (anything you can use == on). Maps are referen
Go Packages & Modules
Go code is organized into packages (a directory of .go files that share a package declaration) and modules (a collection of related packages defined by a go.mod file). Every file belongs to a package.
Go Pointers
A pointer holds the memory address of a value rather than the value itself. Pointers let you share and mutate data across function boundaries without copying it. Go pointers are simpler than C pointer
Go Slices
A slice is Go's dynamically-sized, flexible view into an array. Unlike arrays (fixed size, part of the type), slices can grow and shrink. They are the standard way to work with ordered collections in
Go Structs
A struct is Go's primary way to group related data. It's equivalent to a class without inheritance — you get data fields and methods attached to the type. Go favours composition over inheritance throu
Go Variables & Types
Go is statically typed — every variable has a type fixed at compile time. The compiler catches type mismatches before the program runs. Types are written after the variable name (opposite to C/Java).
AWS VPC
--- - Virtual Private Cloud — your own isolated private network within AWS - Spans all AZs in a region (regional resource) - You control: IP ranges, subnets, route tables, gateways, security rules - A
Two Pointers
--- - Sorted array or string — find a pair satisfying a condition - In-place element removal or rearrangement - Comparing elements from both ends simultaneously - Avoid O(n²) brute force on array pair
Stacks
Pre-requisite: [[Stack & Queue]] — covers Stack/Queue data structure, operations, Python implementation --- - Need to track the most recent element seen (last-in, first-out) - Matching/validation — br
Data Engineering Fundamentals
Type Definition Examples -------------------------- Structured Organized in a defined schema DB tables, CSV, Excel spreadsheets Semi-Structured Some structure via tags/hierarchies JSON, XML,
AWS EC2
--- Concept Definition Example --------- Scalability Ability to handle increased load by adding resources — either vertically (bigger instance) or horizontally (more instances) Upgrading from t
AWS S3
Pre-requisite: [[Data Engineering Fundamentals]] — covers Data Types, Data Lake vs Warehouse, ETL, Data Formats --- - Simple Storage Service — object storage service by AWS - Infinitely scalable, high
Design a URL shortener
Design a URL shortener like bit.ly --- 1. Given a long URL → generate a unique short URL 2. Given a short URL → redirect to original long URL 3. Link Analytics — click count per short URL 4. Optional:
Trapping Rain Water — Two Pointer Visual
--- idx: 0 1 2 3 4 5 height: 4 2 0 3 2 5 5 █ 4 █ █ 3 █ █ █ 2 █
Python String Functions for DSA
Quick reference for string operations commonly used in LeetCode / interview problems. --- python s = "Hello World" s.lower() # "hello world" s.upper() # "HELLO WORLD" s.swapcase() #
IAM
- Global service — IAM is not region-specific - Root account is created by default — never share it, never use it for daily tasks - Users are people within your organization and can be grouped - Group
AI & ML Topics
Area Notes ------------- LLM Fundamentals [[LLM Fundamentals]] — transformer stack, training, inference, AI systems LangChain [[Langchain]] MCP [[MCP]] --- - [x] Transformer architecture (a
MCP — Model Context Protocol
Model Context Protocol (MCP) is an open standard by Anthropic that defines how applications expose tools, resources, and prompts to LLMs in a unified way. Think of MCP as USB-C for AI — one standard
AWS Topics
Notes will be added here as AWS topics are studied (MLA-C01 exam track, 12-week plan) Resource Type Cost Use --------------------
Big O & Complexity
Big-O Name Speed Example ----------------------------- O(1) Constant Best Array index lookup O(log n) Logarithmic Great Binary search O(n) Linear Good Single loop through array O(n
Sliding Window
Answer YES to all 3 → use Sliding Window: 1. Input is an Array or String? 2. Problem asks for a Subarray or Substring? 3. Looking for Longest / Shortest / Max Sum / specific count? --- Is window size
Binary Search
Use Binary Search when: 1. Input is sorted (array, range, search space) 2. Problem asks for a specific value, or min/max that satisfies a condition 3. Brute force is O(N) or O(N²) — binary search brin
Tries (Prefix Trees)
- Problem involves prefix matching, autocomplete, word search - Multiple strings need to be searched efficiently - Brute force would be O(N × M) — Trie brings prefix lookups to O(M) --- python class T
Graphs
- Input is a network, grid, or dependency structure - Problem asks for connectivity, shortest path, cycles, ordering - Keywords: nodes, edges, neighbors, connected components, path --- python graph =
Dynamic Programming
- "Count the number of ways to..." - "Minimum/maximum cost/steps to reach..." - "Can you achieve X?" (often boolean DP) - Overlapping subproblems + optimal substructure = DP Greedy vs DP: If past choi
DSA Topics
Type Notes ------------- Complexity [[Big O & Complexity]] Sorting [[Sorting Algorithms]] Data Structures [[Stack & Queue]] · [[Linked List]] · [[Trees & BST]] · [[Hash Map]] · [[Trie]] Te
Hash Map
Maps keys to values using a hash function. Python's dict is a production-ready hashmap. Operation Average Worst --------------------------- Get O(1) O(n) Set O(1) O(n) Delete O(1) O(n)
Linked List
Linear data structure where elements are linked via references — not stored contiguously in memory. Feature Array Linked List ----------------------------- Access by index O(1) O(n) Insert/De
Sorting Algorithms
Algorithm Time (avg) Time (worst) Space Stable Use When ------------------------------------------------------------ Bubble Sort O(n²) O(n²) O(1) Yes Never (educational only) Insertion S
Stack & Queue
Last In, First Out. All operations O(1). Operation Big O Description ------------------------------- push O(1) Add to top pop O(1) Remove and return top peek O(1) View top without remov
Trees & BST
- Hierarchical structure: root → children → leaves - Each node has at most one parent, any number of children - Binary Tree: each node has at most 2 children (left, right) - BST: left child < parent <
Trie (Prefix Tree)
Tree-like structure for storing strings character by character. Optimised for prefix operations. Operation Time ----------------- Insert O(m) where m = word length Search O(m) Prefix check
FrontEnd Topics
Area Notes ------------- JavaScript Core [[JavaScript]] JavaScript DOM [[JavaScript DOM Notes]] JS Interview Patterns [[JavaScript Function Code Examples for Interviews]] JS Interview Ques
Interview Question
Area Topics ------------ -------------------------
JavaScript DOM Notes
Every HTML tag is an object. Nested tags are "children" of the enclosing tag. - Nodes vs. Elements: - Nodes: Include everything (Comments, Text, Elements). Accessed via childNodes, firstChild, nextS
JavaScript Function Code Examples for Interviews
Quick ref: [[Debounce]] · [[Throttle]] · [[Flatten]] · [[Promise Polyfills]] · [[Currying]] · [[Array Polyfills]] · [[Deep Clone]] · [[DOM Functions]] - A debounce function is a higher-order function
JavaScript Interview Questions
Q: What are JavaScript's data types? 8 types — 7 primitives + 1 object type. Primitives: Number, BigInt, String, Boolean, Null, Undefined, Symbol Reference: Object (includes Array, Function, Date,
JavaScript
8 types: Number, BigInt, String, Boolean, Null, Undefined, Symbol, Object javascript typeof "abc" // "string" typeof 42 // "number" typeof null // "object" ← JS bug, null is N
React Learning
Main reference: [[React]]
React
- Library (not framework) — only controls the root node you give it - Virtual DOM — React diffs a virtual copy of the DOM and applies minimal real DOM updates - JSX — HTML-like syntax transpiled to Re
Webdriver IO Learning
- Introduction to WebdriverIO - Setting up the Environment - Basic WebdriverIO Test - Q&A - What is WebdriverIO? - WebdriverIO is a custom implementation for selenium's W3C webdriver API. It is writ
Go Basics
go package main import "fmt" func main() { fmt.Println("Hello, world!") } Every Go program starts in package main. Execution begins in func main(). --- Every Go program is made of packages. By conven
Go Topics
Area Notes ----------------------- ------------------------- Basics [[Basics]] Variables & Types [[Variables & Types]]
Decorators
Decorators are one of Python's most powerful features. They allow you to modify or enhance the behavior of functions or methods without permanently modifying their source code. They are heavily used i
Object Oriented Programming
Code that's easy for humans to understand is called "clean code". Any fool can write code that a computer can understand. Good programmers write code that humans can understand. -- Mart
Python Programming
- First-class function: A function that is treated like any other value - Higher-order function: A function that accepts another function as an argument or returns a function - Pure Function: For same
Logging
Video ref: https://www.youtube.com/watch?v=pxuXaaT1u3k Python's built-in logging module is the standard for production logging. Avoid using print() in production — it has no severity levels, no format
Python Interview Questions
Q: What is the difference between is and ==? == checks value equality. is checks identity — whether both variables point to the same object in memory. python a = [1, 2, 3] b = [1, 2, 3] a == b # Tr
Python Topics
Area Notes ------------- Language Core [[Python Programming]] · [[Decorators]] · [[Object Oriented Programming]] Libraries [[Logging]] Interview Prep [[Python Interview Questions]] --- - [x
API Gateway
Design an API Gateway that acts as the single entry point for all client requests to a microservices backend. --- - Route requests to appropriate backend services - Authentication & Authorization - Ra
ML Feature Store
Design a Feature Store — a centralised repository for storing, sharing, and serving ML features for training and inference. --- Direct relevance: Crest Data ML thresholding engine — KPI features need
Notification System
Design a scalable notification system that sends push, email, and SMS notifications to millions of users. --- - Support push (mobile), email, SMS channels - Send notifications based on events (order p
RAG & LLM System
Design a Retrieval-Augmented Generation (RAG) system — an LLM-powered Q&A that grounds answers in a private knowledge base. --- Direct relevance: AWS Bedrock LLM chat application at HCLTech. The Flas
Rate Limiter
Design a rate limiter that restricts the number of requests a user/service can make in a given time window. --- - Allow N requests per user per time window (e.g., 100 req/min) - Return HTTP 429 (Too M
Uber & Ride Sharing (Maps/Geospatial)
Design a ride-sharing system like Uber — real-time driver tracking, matching, routing. --- ⭐ Direct relevance: HCLTech geospatial engine — 250+ concurrent drivers, WebSocket tracking, sub-second late
Langchain
Source: DeepLearning.AI — LangChain for LLM App Dev Code: [[L1-Modelpromptparser.py]] Raw OpenAI API LangChain --------------------------
Basics
- Distributes incoming requests amongst multiple servers to optimise resource utilisation - Why it is needed? - Distributes requests so no single server is overloaded → high availability - Reduces r
System Design Basics
Page Type ------ [[System Design Basics]] Fundamentals [[API Design Principles]] REST, pagination, versioning, status codes [[Low Level Design]] SOLID, machine coding problems [[Docker and
20 Most Important AI Concepts Explained in Just 20 Minute
Glad you’re here again. Nonmembers click here Welcome back to another story. If you’ve ever tried to learn AI, you probably felt this at least once… “What the hell is actually going on?” So many te
CLAUDE
Schema for LLM wiki maintenance. Obsidian is the IDE; Claude is the programmer; this vault is the codebase. Obsidian personal knowledge base ("second brain") backed by Git. Not software project — no b
Crack System Design Interviews with This One Database Cheat Sheet
Six databases. One decision framework. Zero fumbling when the interviewer asks “which database would you use here?” Most system design interviews don’t fail on algorithms. They fail on the moment the
Data Structure & Algorithms
Big-O Name Description
Design a Key Value Store
Drawing 2026-06-13 23.28.17.excalidraw
==⚠ Switch to EXCALIDRAW VIEW in the MORE OPTIONS menu of this document. ⚠== You can decompress Drawing data with the command palette: 'Decompress current Excalidraw file'. For more info check in plu
Drawings_Redis
==⚠ Switch to EXCALIDRAW VIEW in the MORE OPTIONS menu of this document. ⚠== You can decompress Drawing data with the command palette: 'Decompress current Excalidraw file'. For more info check in plu
DSA-Visualizer
==⚠ Switch to EXCALIDRAW VIEW in the MORE OPTIONS menu of this document. ⚠== You can decompress Drawing data with the command palette: 'Decompress current Excalidraw file'. For more info check in plu
Every System Design Question I Was Asked in Real Interviews at 10+ Companies
(Non-Medium members can READ the full article for FREE: here) I’ve interviewed at more than 15 companies across multiple countries, including Canva, Grab, Foodpanda, and Agoda, as well as companies in
README
Hands-on companion to [[../RedisRedis notes]]. Goal: understand Redis internals by building a minimal clone. You write the code — this is the list of concepts to go through per stage. Scope disciplin
README
Immutable source layer. LLM reads but never modifies files here. - Web-clipped articles (via Obsidian Web Clipper → markdown) - PDFs converted to markdown - Podcast/video notes (raw transcript or pers
Redis Architecture Deep Dive: What I Learned Building High-Performance Systems
When I first started using Redis, I thought it was just a fast key-value store — a simple cache to put in front of my database. Then I built a real-time leaderboard system handling millions of updates
System Design Notes Arpit Bhayani
- SD is extremely practical and there is a structured way to tackle the situations. - Take Baby Steps, no matter what! 1. Understand the problem statement - Without having a through understanding of
System_design_notes.excalidraw
==⚠ Switch to EXCALIDRAW VIEW in the MORE OPTIONS menu of this document. ⚠== You can decompress Drawing data with the command palette: 'Decompress current Excalidraw file'. For more info check in plu
The Day a Google L7 Engineer Tore My System Design to Shreds
If you are not medium member read here for free @ Cloud With Azeem , @ Azeem Teli , #expocomputing I walked into the interview room with the quiet confidence of someone who had “beaten” t
URL Shortener Architecture.excalidraw
==⚠ Switch to EXCALIDRAW VIEW in the MORE OPTIONS menu of this document. ⚠== You can decompress Drawing data with the command palette: 'Decompress current Excalidraw file'. For more info check in plu
Wiki Operation Log
Append-only. Each entry format: ## [YYYY-MM-DD] action description Parse last 5 entries: grep "^## \[" log.md tail -5 Actions: init ingest query lint synthesis update --- Go (3 new): Context, H
xoraus/CrackingTheSQLInterview: DBMS Concepts, SQL Queries & Schema Design for your Interviews.
SQL (Structured Query Language) is the standard for managing and manipulating relational data. It includes commands for querying, updating, and defining database structures. This guide is divided into