4d ago · 33 min read · Github Main- https://github.com/NishikantaRay/InsightTrack Passmark - https://github.com/NishikantaRay/InsightTrack/tree/main/appsv2/passmark-tests InsightTrack — 17 pages, dual-database architectu
NSSNilesh and 4 more commented
Apr 23 · 12 min read · Athletic performance data contains patterns. Some patterns reflect natural improvement through training. Others represent statistical outliers that warrant investigation. My thesis explored a fundamen
Join discussion
Apr 17 · 8 min read · This is not a lab benchmark. It is an engineering gut-check: same query, different machines, different storage. The numbers are messy, the comparisons are unfair, and yet they are surprisingly useful.
Join discussion
Apr 15 · 5 min read · I did not want a heavy data platform. I wanted a stack that was simple enough to ship quickly, cheap enough to run, and flexible enough to grow later. Character Design I tend to choose practical tool
Join discussion
Mar 23 · 13 min read · When I came across Jonathan Neo's Kimball dimensional model walkthrough on the dbt blog, I knew I had to build something with it. Around the same time, Daniel Beach's Data Engineering Podcast kept men
Join discussion
Feb 17 · 5 min read · HHS recently published a Medicaid Provider Spending dataset covering Jan 2018 - Dec 2024. https://opendata.hhs.gov/datasets/medicaid-provider-spending/ It’s available as a 10GB CSV or 3GB Parquet file. Peek into the Parquet % brew install duckdb % du...
Join discussionFeb 3 · 17 min read · So last Monday, my PM mentioned me at Whatsapp group around 9 AM and ask for some analysis sounds familiar, right? Then He drops around 120MB excel file. one hundred twenty megabytes. I should've known better. I tried opening it in Excel. That spinni...
Join discussionFeb 2 · 11 min read · Exploring JSON in DuckDB with the openFDA Animal & Veterinary Adverse Events API A practical, end‑to‑end walkthrough using the DuckDB CLI with JSON When working with Modern data, JSON is everywhere — APIs, logs, manifests, telemetry, and data feeds. ...
Join discussion
Jan 27 · 8 min read · What if you could run full SQL queries, including JOINs, aggregations, and even remote Parquet file reads, directly inside a Cloudflare Worker? No database server, no connection pool, no cold-start latency from external services. Just DuckDB, compile...
Join discussion
Jan 26 · 6 min read · Project Summary This project explores the Sakila DVD rental database using SQL, DuckDB, Python, and Evidence. The goal is to understand the data and find patterns in movies, customers, and revenue. The data is loaded from a SQLite database into DuckD...
Join discussion
