every note, in one binder ✎

Developer interview notes & guides — Page 8

Focused explanations and longer guides, with worked scenarios, common mistakes and interview exercises across every chapter.

read ✓Spring Boot · hard

Spring Startup Checks and Readiness

How Spring Boot liveness and readiness probes work on Kubernetes, what belongs in each health group, and how to warm up and shut down gracefully.

~6 min readread →
read ✓Spring Boot · mid

Spring Transaction Duration and Remote Calls

Why long @Transactional methods exhaust the Hikari pool and hold locks, and how to keep remote calls, files and email outside the transaction.

~7 min readread →
read ✓SQL & PostgreSQL · easy

SQL Aggregation and Result Grain

Why joining two one-to-many tables before SUM inflates totals, and how to aggregate each child table at its own grain before you combine them.

~6 min readread →
read ✓SQL & PostgreSQL · mid

SQL Exists for Relationship Checks

Use EXISTS when you're asking whether a related row exists: no duplicate rows, NULL-safe NOT EXISTS, and semi or anti joins in PostgreSQL plans.

~6 min readread →
read ✓SQL & PostgreSQL · easy

SQL Joins and Unexpected Row Multiplication

Predict how many rows a SQL join returns: duplicate lookup keys multiply rows, inner joins drop unmatched ones, and both can hide in one count.

~6 min readread →
read ✓SQL & PostgreSQL · mid

SQL Keyset Pagination and Stable Ordering

Why OFFSET pages get slow and drift, and how keyset pagination with a unique tiebreaker and a row comparison stays fast at any depth.

~6 min readread →
read ✓SQL & PostgreSQL · hard

PostgreSQL MVCC, Old Versions and Vacuum

How PostgreSQL UPDATE writes a new row version, why dead tuples pile up, what VACUUM reclaims, and how one idle transaction stops cleanup.

~7 min readread →
read ✓SQL & PostgreSQL · easy

SQL Null and Three-Valued Logic

NULL makes comparisons unknown, not false. See how that drops rows from WHERE, empties NOT IN and slips past CHECK constraints.

~6 min readread →
read ✓SQL & PostgreSQL · mid

PostgreSQL Row Locks and Concurrent Updates

Watch two PostgreSQL sessions lose an update, then fix it with an atomic UPDATE or FOR UPDATE, and see what NOWAIT and SKIP LOCKED do.

~7 min readread →
read ✓System Design · mid

System Design IDs and Ordering Requirements

Snowflake IDs, UUIDv4 and UUIDv7 compared with runnable code: collision odds, 4,096 IDs per millisecond, and why clock skew breaks ordering.

~7 min readread →
read ✓System Design · mid

System Design Partitioning and Hot Keys

Choosing a partition key, why hash mod N moves 91% of keys when you add a node, how consistent hashing fixes it, and how to split a hot key.

~8 min readread →
read ✓System Design · mid

System Design Rate Limiting and Fairness

Fixed window, sliding window and token bucket limiters run on the same burst, plus who to limit, enforcing across gateways and 429 responses.

~7 min readread →
read ✓TypeScript · mid

TypeScript Conditional Types and Distribution

How T extends U ? X : Y picks a type, why it splits unions apart member by member, and how wrapping both sides in brackets turns that off.

~6 min readread →
read ✓TypeScript · easy

TypeScript Discriminated Unions for UI State

Replace isLoading, error and data flags with one status union so impossible UI states stop compiling and each branch sees only its own fields.

~6 min readread →
esc