stackademic

The leading education platform for anyone with an interest in software development.

Prithwish Nath

Prithwish Nath

Software Engineer

Developer, audiophile, strategy game enthusiast.

Skills & Expertise

Python
TypeScript
Apache Kafka
OpenTelemetry
React
OLAP
Polars
Pandas
vLLM

Articles by Prithwish Nath(18)

Reducing MCP Response Sizes for LLM Context Limits

How to measure per-tool MCP token cost, cut the MCP menu tax, and enforce a hard budget on any MCP server — with under 2% added latency.

Jun 25, 2026artificial intelligence

How To Build Faster Data Pipelines in Python with Apache Arrow.

How to build web data pipelines 2.6x faster and 60% cheaper with Apache Arrow. Cut memory usage and file sizes by half for AI training.

Jun 19, 2026data science

Building a Fault-Tolerant Web Scraping Pipeline with Effect-TS

Effect-TS changed how I think about web data ingestion in TypeScript. Here's a practical guide for building pipelines that handle failure reliably.

Jun 19, 2026typescript

From Google Search to Kafka Event Stream for Many Consumers

How to model SERP changes as Kafka event streams and fan them out to independent consumers.

Jun 19, 2026python

How Far Can DuckDB Go Without a Cloud Warehouse?

No server. No cloud bill. Just DuckDB and 50M rows on a cheap $500 Acer laptop. Here's the honest truth on where local analytics work best.

Jun 18, 2026data science

Build Your Own, Self-Hosted Google Trends Alternative with DuckDB

Step-by-step guide for a Google SERP tracker with Python, Bright Data, and DuckDB. Free alternative to Semrush and Ahrefs.

Jun 18, 2026python

Building a Bun CLI That Turns API Docs Pages Into TypeScript Clients

Build a Bun CLI that scrapes API documentation pages and generates fully typed TypeScript clients—no OpenAPI schema required.

Jun 18, 2026javascript

How to Validate API Responses in Python with Great Expectations (GX Core)

How to validate any API response in Python, quarantine bad batches, and store only clean results in DuckDB.

Jun 18, 2026python

The Case For Adding Observability to Data Extraction with OpenTelemetry

Adding OpenTelemetry and Jaeger to expose hidden retries, latency, and silent failures in production.

Jun 18, 2026devops

Fully Local Data Analytics with dbt Core and DuckDB

How to use dbt’s layered SQL models and DuckDB’s embedded engine to clean, normalize, and transform raw web data into analyst-ready tables.

Jun 18, 2026data science

Also on the network