starrocks

StarRocks is a query engine for asking fast questions of enormous data. If your company sits on billions of rows of sales, clicks, or events, this returns complex reports in under a second, even while new data is still streaming in. It speaks standard SQL over the MySQL protocol, so your existing BI tools connect without changes, and it can query data sitting in a lake (Iceberg, Hudi, Delta) without copying it first. Apache 2.0, a Linux Foundation project, and fully open with no feature gating in the core.

The real differentiator is real-time updates. Most fast analytics engines, like Druid and ClickHouse, are append-only, so updating a row is painful. StarRocks does primary-key upserts and deletes at second-level speed without tanking query performance. The cost shows up in operations. This is a distributed system with separate coordinator and worker nodes that you cluster, scale, monitor, and tune yourself. Running it seriously means having people who know databases, which is exactly the gap CelerData, the company behind it, sells its managed cloud against.

For real-time dashboards and customer-facing analytics, this is a direct substitute for ClickHouse or Druid, and it can replace the serving layer of a Snowflake or BigQuery setup. Solo developers and small teams: powerful, but you probably don't have data at the scale that justifies the ops. Larger teams with real analytics workloads and database talent: this is a genuine open alternative to a five-figure warehouse bill.

The catch is the operational weight. The engine is free and excellent, but a self-hosted distributed database is a commitment, not a weekend install. If you don't have the people to run it, the math that makes it free stops being free.