Open source
Apache Superset
Bug fixes and improvements to the open source BI platform I use every day at work: dashboards, database engines, SQL parsing, the MCP server and the Italian translation.
- Python
- TypeScript
- React
- SQLAlchemy
I'm Francesco Castaldi, a computer engineer in Italy. Here I collect the projects I'm proudest of and write about tech, personal finance and cycling.
36 pull requests merged upstream, 21 open, across 17 projects.
Open source
Bug fixes and improvements to the open source BI platform I use every day at work: dashboards, database engines, SQL parsing, the MCP server and the Italian translation.

Apps & tools
Five custom visualization plugins for Superset 6: a hierarchical table with rollups, a calendar cross filter, a bar chart with benchmarks, a heatmap with totals and a KPI comparison card.
Apps & tools
A rule based SQL linter that parses queries into a syntax tree, flags common performance antipatterns and suggests rewrites, from a web app, a CLI or a GitHub Action.

University
A stochastic SIR epidemic on a finite population, modelled as a discrete time Markov chain, simulated with Monte Carlo and compared with its deterministic limit.