TIL Archive
By Pradyumna Chippigiri
Older short notes. Newer writing and study notes live on the
blogs
page.
AI
Data Engineering
DevOps
Frontend
Python
SQL
System Design
AI
RAG re-ranking in two-stage retrieval
Best LLM & Transformer Visualizations
Andrej Karpathy MicroGPT Visualized
llms.txt endpoint
Blown away by amazon q + mermaid
Data Engineering
Bronze, Silver, Gold layers in data engineering
DevOps
p50, p95, p99 Latencies
SLI vs SLO vs SLA
DORA metrics
Frontend
Loading images faster
Converting images to WebP using coding agents
Python
Understanding pyproject.toml, setuptools, .whl, and .tar.gz
What __init__.py does in Python packages
append vs extend vs + for lists
*args and **kwargs in Python
Dataclass in Python
uv vs pip
Unique Features of OrderedDict in Python
SQL
EXPLAIN vs EXPLAIN ANALYZE
CTEs in SQL
Finding rows with same value
SQL is null vs = null
System Design
Local SSD (NVMe) vs Network SSD (Block Storage)
Time-series delta encoding
RLE Run Length Encoding
Pull vs Push CDN
Best resource for understanding OAuth 2.0
2-random cache eviction