How database indexing works, with Postgres examples
B-trees in plain English, reading EXPLAIN ANALYZE, composite, partial and covering indexes, what indexes cost, and adding them to a live Postgres table safely.
Building for 100,000 students at once
37 articles
B-trees in plain English, reading EXPLAIN ANALYZE, composite, partial and covering indexes, what indexes cost, and adding them to a live Postgres table safely.
How PostgreSQL streaming replication works, synchronous vs asynchronous commits, routing reads in Django, handling replication lag, and replicas for failover.
How to turn an uploaded lecture into encrypted HLS: probing, encoding a ladder with FFmpeg, queue-driven workers, CPU vs GPU vs spot capacity, retries and what one lecture really costs.
How players choose between renditions, what hls.js and dash.js do by default, and how to design a bitrate ladder that keeps lectures playing on patchy mobile networks.
HLS and MPEG-DASH compared: playlists vs manifests, iPhone and Android support, encryption and DRM, low latency, and how CMAF lets one set of segments serve both formats.
Sub-second WebRTC or CDN-scale HLS? Latency budgets for live classes, SFUs, Low-Latency HLS, RTMP vs SRT ingest, the cost of a 5,000-student class and a hybrid design.
Why one CDN is a single point of failure on exam and launch days, how DNS, player-side and content-steering failover compare, and what must match across CDNs.
Move slow work off the request path: queues vs brokers vs streams, Celery in Django, retries and idempotency, dead letters, separate queues, and when Kafka is worth it.
What monitoring and observability each answer, how logs, metrics and traces fit together with OpenTelemetry, and how to set SLOs and error budgets around student journeys.
Set recovery time and recovery point objectives per system, choose between backup and restore, pilot light, warm standby and active/active, apply 3-2-1 backups and run drills.
Deploy during a live class without anyone noticing: rolling, blue-green and canary compared, draining connections and WebSockets, feature flags and exam-day deploy freezes.
Change a live Postgres schema without locking students out: expand and contract, lock timeouts, concurrent indexes, NOT VALID constraints, batched backfills, safe Django migrations.
Upclass for institutes
Your courses, live classes and tests in your own branded app, with piracy protection on every lecture. Plans start at ₹1,999/month.