Our great sponsors
-
spiceai
A unified SQL query interface and portable runtime to locally materialize, accelerate, and query datasets from any database, data warehouse, or data lake.
-
datafusion-federation
Allow DataFusion to resolve queries across remote query engines while pushing down as much compute as possible down.
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
We also have a Grafana plugin we'll continue to improve to make it super easy to connect to Grafana, and Spice has a metrics endpoint and example Grafana dashboard for monitoring itself https://github.com/spiceai/spiceai/blob/trunk/monitoring/gra...
There is an effort within DataFusion to support pushing down joins across tables from the same remote provider that we will likely contribute to as well: https://github.com/datafusion-contrib/datafusion-federation
I'm not too familiar with https://cube.dev/ - but my initial impression is they are focused more on providing APIs backed by SQL. They have a SQL API that emulates the PostgreSQL wire protocol, whereas Spice implements Arrow and Flight SQL natively. Their pre-aggregations are a similar concept to Spice's data accelerators. It also looks like they have their own query language, whereas Spice is native SQL as well.
Related posts
- MQL – Client and Server to query your DB in natural language
- Show HN: Delphi – Build customer-facing AI data apps (that work)
- Need to reduce costs - which service to use?
- Anyone with experience moving to Cube.dev + Metabase/Superset from Looker ?
- GigaOm Sonar Report Reviews Semantic Layer and Metric Store Vendors