withsoon

Changelog

What's been added and improved.

2026-06-20

Spark Interview Questions, Roadmap, Daily Tips, TOC

  • +Added Apache Spark Interview Questions — DAG, shuffle, AQE, skew, memory tuning, joins, streaming, Delta Lake
  • +Added 6-week Data Engineer Roadmap with localStorage progress tracking
  • +Added Daily Tip widget rotating through 50 curated DE/system design tips
  • +Added sticky Table of Contents on articles (desktop) and collapsible TOC (mobile)
  • +Added Callout components: InterviewTip, CommonMistake, SeniorAnswer, ProductionNote, Warning
  • +Added Related Articles section at end of each article
  • +Added Subscribe form (UI) on homepage and article pages
  • +Added RSS feed at /feed.xml
  • +FAQ JSON-LD schema automatically generated for interview Q&A articles
2026-06-18

SQL Interview Questions, OG Image API, Article UX overhaul

  • +Added SQL Interview Questions — window functions, CTEs, sessionization, deduplication, SCD Type 2
  • +Added OG image generation at /og (edge runtime, dark background, section badge)
  • +Added Reading Progress bar, Back-to-Top button, Copy Code button on all articles
  • +Added Article JSON-LD schema, Twitter/LinkedIn share buttons
  • +Added Mock Interview + Cheat Sheet tabs to Netflix system design
  • +Fixed Kafka Q&A title to be honest about 16/50 published
2026-06-15

P0 Trust Fixes, SEO infrastructure, Netflix routing

  • +Fixed empty subsections: replaced with Coming Soon tiles instead of showing 0 items
  • +Fixed duplicate Claude article in Tech News feed
  • +Added About page, custom 404 page, Footer with GitHub/About links
  • +Added robots.ts, sitemap.ts with dynamic article URLs
  • +Added canonical URLs to all hub pages
  • +Added author byline, suggest-correction link to all articles
  • +Added System Design hub page (/system-design)
  • +Added System Design link to navbar
  • +Fixed Netflix initialTab prop passing (direct URL navigation now works)
  • +Added breadcrumb to Netflix page: Home / System Design / Netflix
2026-06-10

Complete Netflix system design — all tabs

  • +Netflix page: 7 tabs — Architecture, Data Models, Trade-offs, Capacity, Quiz, Mock Interview, Cheat Sheet
  • +Architecture: animated playback flow with 12 steps
  • +Data Models: PostgreSQL schemas for users, subscriptions, profiles, content, watch progress
  • +Capacity: back-of-envelope calculations for storage, bandwidth, and throughput
  • +Trade-offs: 8 production trade-off comparisons with justification
  • +Quiz: 10-question self-assessment with reveal
← Back to home