Home / Blog
Blog
Code-rich, answer-first technical articles on building cricket analytics with CricketLogic and DuckDB.
·5 min read
Why DuckDB for cricket analytics
Why CricketLogic uses DuckDB as its cricket data warehouse: columnar analytics on millions of ball-by-ball rows, zero server setup, a single portable file, and first-class SQL — compared to pandas, SQLite and hosted APIs.
duckdbarchitectureanalyticsdata-engineering
·7 min read
Computing batting & bowling stats from ball-by-ball data
How CricketLogic derives strike rate, batting average, economy rate and bowling strike rate from raw Cricsheet deliveries — the exact SQL behind the batting_performance and bowling_performance views.
analyticssqlduckdbcricket-stats
·6 min read
Loading Cricsheet YAML into DuckDB
A practical guide to parsing Cricsheet ball-by-ball YAML into normalized DuckDB tables with CricketLogic, including the schema, duplicate detection and how ingestion actually works.
cricsheetduckdbingestionpython