Rishikesh Ranjan — rishikeshranjan.com

// open source & systems

SporeDB

A bioprocess time-series database on Apache Arrow and DuckDB — automatic phase detection, a PromQL-style query language that compiles to DuckDB, and FDA 21 CFR Part 11 audit trails.

Creator2026PythonPyPIApache ArrowDuckDB

Bioprocess data is high-frequency, phase-driven, and heavily regulated — a poor fit for generic time-series tools. SporeDB is a time-series database built for it, on a modern columnar core.

What it does

  • Columnar core. Built on Apache Arrow and DuckDB for fast analytical queries over time-series data.
  • Automatic phase detection. PELT and BOCPD changepoint detection segments a run into its process phases automatically.
  • PromQL-style queries. A familiar query language that compiles down to DuckDB, with InfluxDB and OSIsoft PI connectors.
  • Regulated by design. FDA 21 CFR Part 11 audit trails are built in, not bolted on.