phillip-spice
Joined 5 years ago
Karma
4
Submissions
5
Member since
Sep 7
Co-founder of Spice AI https://github.com/spiceai/spiceai
View on Hacker NewsRecent submissions
Comment · 2 years ago
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.
Comment · 2 years ago
Thanks Andrew! I'm looking forward to contributing back to DataFusion as well.
Comment · 2 years ago
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
Comment · 2 years ago
DuckDB is an in-process DB similar to SQLite - so every application in your stack would need to embed it. Spice is a binary that has Flight SQL and HTTP query endpoints - so multiple applications can connect to it from any language.