Search

Lessons (13)

  • Views, Triggers & Stored Procedures

    Interview answers for views, materialized views, triggers and stored procedures. Covers PDF questions 20, 24 and 27-30 …

  • Transactions, Indexes & Concurrency

    Interview answers for triggers, ACID, clustered indexes, deadlock/livelock and RAID. Covers PDF questions 8-11 and 18 …

  • Serverless Architecture

    … Functions as a Service, event triggers, cold starts, pay-per-use pricing, managed backends, and the patterns and …

  • Releases, Observability and Production Safety

    … immutable artifacts, reversible migrations and a measured rollback trigger. Correlate logs, metrics and traces with request IDs; alert …

  • Debug Latency Like an Investigator

    … Restart helps briefly Warm cache, leak, churn, periodic trigger. Safe response sequence 1. Record window, route/tenant/region …

  • How Browsers Render a Page

    … Use defer or async . - Changing geometry triggers expensive layout; transform and opacity are cheap. - Batch DOM reads and …

  • React Hooks in Practice

    … a box that doesn't trigger renders jsx function SearchBox() { const inputRef = useRef(null); // 1. reference a DOM …

  • REST vs GraphQL vs gRPC

    … problem: listing 50 users and their posts can trigger 1 query for users + 50 queries for posts. Fix …

  • ConfigMaps, Secrets & Storage

    … put a hash of the config in a pod annotation, so changing the config triggers a rolling restart …

  • DSA Interview Patterns Cheat Sheet

    … Keyword triggers, a decision flowchart, complexity tables and a step-by-step interview routine. The big idea There …

  • Scaling & Health Probes

    … scale consumers on Kafka lag triggers: - type: kafka metadata: bootstrapServers: kafka:9092 consumerGroup: email-service topic: shop.orders …

  • Choosing an Architecture

    … customer rules Contract design and stability Serverless Functions triggered by events, managed services Spiky workloads, event processing, zero …

  • Data in Microservices: Sagas & the Outbox Pattern

    … Each one updates a single service's database and triggers the next step. If a step fails, the …