← Back to home
Comparison · Infra & APIs

FoReco vs Windmill

A side-by-side editorial comparison of FoReco and Windmill — release velocity, themes, recent moves, and the top alternatives to consider.

FoReco vs Windmill: at a glance

FeatureFoRecoWindmill
SectorInfra & APIsInfra & APIs
Velocity score0.08.8
Sparks · 30d01
Top themesforecasting, hierarchical-reconciliation, time-series, s3-classesworkflow orchestration, dbt, open core, ai sessions
Last editorial update53m ago1d ago
WebsiteVisit →Visit →

What is FoReco?

Forecast reconciliation with a real object model, five years after it started returning bare matrices.

FoReco reconciles hierarchical forecasts across cross-sectional, temporal, and cross-temporal frameworks, and now covers both point and probabilistic reconciliation. The 1.3.0 release gave every reconciliation function a shared foreco S3 class carrying framework, function, forecast type, and reconciliation metadata, which replaced the loose attribute-and-helper pattern the package had used since 1.0.0. The follow-up 1.3.1 turned the same attention on the API's edges: strict argument validation with errors that name the expected and supplied values, and a help index pruned down to user-facing functions only.

Read the full FoReco trajectory →

What is Windmill?

Windmill gave away the warehouse connectors and now runs dbt natively — the trial is the strategy.

Two lines are moving at once. The platform line made dbt projects a first-class runtime, unified the deployment target on workspace lineage, opened Compare & Deploy to arbitrary target workspaces, and moved BigQuery and Snowflake out from behind the Enterprise license. The AI line took sessions to beta on by default and has been adding controls around them since — file attachments, visible web-search sources, artifact version history, and now a read-only plan mode that refuses anything that writes or deploys until you approve a plan.

Read the full Windmill trajectory →

FoReco vs Windmill: editorial side-by-side

F
FoReco
INFRA · APIS
0.0

Forecast reconciliation with a real object model, five years after it started returning bare matrices.

◆ Current state

FoReco reconciles hierarchical forecasts across cross-sectional, temporal, and cross-temporal frameworks, and now covers both point and probabilistic reconciliation. The 1.3.0 release gave every reconciliation function a shared foreco S3 class carrying framework, function, forecast type, and reconciliation metadata, which replaced the loose attribute-and-helper pattern the package had used since 1.0.0. The follow-up 1.3.1 turned the same attention on the API's edges: strict argument validation with errors that name the expected and supplied values, and a help index pruned down to user-facing functions only.

◆ Where it's heading

The package is completing a reversal it started in 1.0.0. That release simplified outputs to plain matrices and pushed metadata into attributes reachable via recoinfo(); 1.3.0 removed recoinfo() outright and put the structure back as a class with components(), summary(), and plot() methods. The direction is toward being infrastructure rather than a function library — the class is exported through new_foreco_class() and a sibling package has already adopted it. Method coverage has meanwhile broadened from optimal combination into non-negative algorithms, bounded reconciliation, and Gaussian and sample-based probabilistic variants.

◆ Prediction

The soft-deprecated res2matrix() is flagged for removal, so a subsequent release should finish that cleanup; with the class now exported, expect more methods to hang off foreco objects rather than more top-level functions.

W
Windmill
INFRA · APIS
8.8

Windmill gave away the warehouse connectors and now runs dbt natively — the trial is the strategy.

◆ Current state

Two lines are moving at once. The platform line made dbt projects a first-class runtime, unified the deployment target on workspace lineage, opened Compare & Deploy to arbitrary target workspaces, and moved BigQuery and Snowflake out from behind the Enterprise license. The AI line took sessions to beta on by default and has been adding controls around them since — file attachments, visible web-search sources, artifact version history, and now a read-only plan mode that refuses anything that writes or deploys until you approve a plan.

◆ Where it's heading

Windmill is positioning as the place a data team's existing work already runs rather than a system to be ported to: an unmodified dbt project drops in, its models become addressable assets with ref() lineage, and the warehouse languages needed to reach them are no longer paywalled. In parallel, the AI session work is maturing from capability to governance — the recent additions are all about reviewability and constraint, not raw autonomy. The deployment changes point the same way, collapsing configurable targets into a single derived answer.

◆ Prediction

Expect the plan-and-approve posture to spread beyond session chats into the durable AI surfaces, and more warehouse-adjacent runtimes to follow dbt into the first-class treatment; Oracle and MS SQL remain the obvious Enterprise holdouts to watch.

Alternatives to FoReco and Windmill

Other Infra & APIs products tracked by Sparkpulse, ranked by recent ship velocity. Each card links to a full editorial trajectory and lets you pivot into a head-to-head comparison with either FoReco or Windmill.

See all FoReco alternatives → · See all Windmill alternatives →

Recent activity from FoReco and Windmill

Latest ship moves from both products, interleaved chronologically. ⚡ = editorial spark.

  1. 5d agoWindmillPlan mode for AI sessions
  2. 8d agoWindmillNested filter groups and dotted paths in trigger filters
  3. 9d agoWindmillVersion history for AI session artifacts
  4. 18d agoWindmillRun dbt projects as a first-class Windmill runtime
  5. 20d agoWindmillOne deployment target, derived from the workspace lineage
  6. 20d agoWindmillCompare & Deploy into any workspace
  7. 1mo agoFoRecoStrict argument validation and a pruned help index
  8. 1mo agoFoRecoEvery reconciliation function now returns a shared foreco object
  9. 3mo agoFoRecoBootstrap functions gain xreg; simulate() argument bug fixed
  10. 5mo agoFoRecoGaussian and sample-based probabilistic reconciliation added
  11. 1y agoFoRecoBounded reconciliation and an oracle shrunk covariance estimator
  12. 1y agoFoRecoBreaking rename: cs, te and ct prefixes across all functions

Frequently asked questions

What is the difference between FoReco and Windmill?

They serve adjacent needs but don't currently overlap on shipped themes. Windmill is currently shipping more aggressively (velocity 8.8 vs 0.0), with 1 editorial sparks in the last 30 days against 0. See the at-a-glance table above for a side-by-side breakdown of velocity, recent sparks, and editorial themes.

Is FoReco better than Windmill?

Sparkpulse doesn't pick a winner — we score release velocity, not feature parity. Windmill is currently shipping more aggressively (velocity 8.8 vs 0.0), with 1 editorial sparks in the last 30 days against 0. For your specific use case, the alternatives sections above list other Infra & APIs products to evaluate alongside.

What are the best alternatives to FoReco?

Top FoReco alternatives in Infra & APIs are ranked by recent ship velocity. Browse the "FoReco alternatives" section above for the current picks, or visit /alternatives/foreco for the full list with editorial commentary on each.

What are the best alternatives to Windmill?

Top Windmill alternatives in Infra & APIs are ranked by recent ship velocity. Browse the "Windmill alternatives" section above for the current picks, or visit /alternatives/windmill for the full list with editorial commentary on each.