TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

Show HN: Spice.ai – materialize, accelerate, and query SQL data from any source

177 pointsby lukekimabout 1 year ago
Hi HN, We&#x27;re Luke and Phillip, and we&#x27;re building Spice.ai OSS - a lightweight, portable runtime, built in Rust and powered by Apache DataFusion to locally materialize, accelerate, and query data tables sourced from any database, data warehouse or data lake.<p>Phillip and I first introduced Spice on Show HN in September 2021. Since then, we’ve been schooled and humbled in every way building 100TB+ data and ML systems for the <a href="https:&#x2F;&#x2F;spice.ai" rel="nofollow">https:&#x2F;&#x2F;spice.ai</a> cloud platform. Along with our customers, we struggled with getting fast, low-latency, high-concurrency SQL query within a budget, accessing and combining data from many sources, trade-offs between OLTP&#x2F;OLAP compute engines, and managing datasets as code.<p>Today, we’re re-launching Spice, completely rebuilt from the ground up, to directly solve several of the problems we had in accessing data quickly and cost-effectively providing it to applications, dashboards, and machine learning. Spice provides federated SQL query across databases (MySQL, PostgreSQL, etc.), data warehouses (Snowflake, BigQuery, etc.) and data lakes (S3, MinIO, Databricks, etc.) with the ability to materialize remote datasets locally using in-memory Arrow, DuckDB, SQLite, or PostgreSQL. Accelerated engines run in your infrastructure giving you flexibility and control over price and performance.<p>You can read the full announcement blog post at <a href="https:&#x2F;&#x2F;blog.spiceai.org&#x2F;posts&#x2F;2024&#x2F;03&#x2F;28&#x2F;adding-spice-the-next-generation-of-spice.ai-oss&#x2F;" rel="nofollow">https:&#x2F;&#x2F;blog.spiceai.org&#x2F;posts&#x2F;2024&#x2F;03&#x2F;28&#x2F;adding-spice-the-n...</a>.<p>We’d appreciate it if you check Spice out, give us feedback, and if you&#x27;d like to contribute, we&#x27;d love to build with you.<p>Thanks!<p>GitHub: <a href="https:&#x2F;&#x2F;github.com&#x2F;spiceai&#x2F;spiceai">https:&#x2F;&#x2F;github.com&#x2F;spiceai&#x2F;spiceai</a>

19 comments

lmeyerovabout 1 year ago
Any sense of comparison to Dremio, which helped steward the Arrow ecosystem for doing this kind of thing?<p>(The idea is great fwiw, I&#x27;ve been following them one-off for years, and we have to do elements of these things in how we build louie.ai and Graphistry for the GPU equivalent. Real pain point!)
评论 #39857714 未加载
imgdesgenabout 1 year ago
That&#x27;s awesome! I&#x27;ll definitely give it a try if there&#x27;s a suitable scenario.
评论 #39887610 未加载
alex_hirnerabout 1 year ago
Looks great! Is flightsql supported over the wire too, so one could hook it up to grafana? Any plans to support iceberg?
评论 #39857358 未加载
评论 #39857361 未加载
nextworddevabout 1 year ago
Hey guys - how does this compare to cube?
评论 #39860272 未加载
gerenukabout 1 year ago
Interesting one. Any plans for clickhouse data connector?
评论 #39887606 未加载
neeleshsabout 1 year ago
Congratulations. Is this similar to Trino&#x2F;Starburst, Drill?
评论 #39858228 未加载
dvdsglabout 1 year ago
Congrats on the launch! This is exciting. The video demo is awesome: <a href="https:&#x2F;&#x2F;youtu.be&#x2F;AZyrecVWnEs?si=j7JVKhhcUor1_y-f" rel="nofollow">https:&#x2F;&#x2F;youtu.be&#x2F;AZyrecVWnEs?si=j7JVKhhcUor1_y-f</a>
评论 #39854984 未加载
评论 #39864954 未加载
cedroneabout 1 year ago
Congrats Luke &amp; Phillip– exciting day!
prabhatsharmaabout 1 year ago
Do you support subqueries and joins?
评论 #39859452 未加载
leeholimabout 1 year ago
Congratulations on the launch!!
jjustin_lawsonabout 1 year ago
Congrats on the launch team!
dwgrayabout 1 year ago
This looks great - I&#x27;ve been meaning to dig into Rust - seems like a solid choice for you.
watsondocabout 1 year ago
Wow, looks promising
martinmaoabout 1 year ago
This looks awesome!
marooned4about 1 year ago
looks great . Going to try this out
alambabout 1 year ago
So great to see another project built on DataFusion @!
评论 #39859902 未加载
mritchie712about 1 year ago
Very cool!<p>One thing to keep in mind:<p>DuckDB can directly query parquet files (and many other file types[1]), mysql, postgres[0], and SQLite. So if you&#x27;re in need of something like this, DuckDB on it&#x27;s own might work for your use case.<p>0 - <a href="https:&#x2F;&#x2F;duckdb.org&#x2F;docs&#x2F;extensions&#x2F;postgres" rel="nofollow">https:&#x2F;&#x2F;duckdb.org&#x2F;docs&#x2F;extensions&#x2F;postgres</a><p>1 - <a href="https:&#x2F;&#x2F;twitter.com&#x2F;thisritchie&#x2F;status&#x2F;1767922982046015840" rel="nofollow">https:&#x2F;&#x2F;twitter.com&#x2F;thisritchie&#x2F;status&#x2F;1767922982046015840</a>
评论 #39856354 未加载
评论 #39864912 未加载
ignoramousabout 1 year ago
&gt; <i>Today, we&#x27;re re-launching Spice...</i><p><pre><code> Obtaining blockchain and smart-contract data is hard ... Spice makes it easy. </code></pre> <a href="http:&#x2F;&#x2F;web.archive.org&#x2F;web&#x2F;20220414105622&#x2F;https:&#x2F;&#x2F;docs.spice.xyz&#x2F;" rel="nofollow">http:&#x2F;&#x2F;web.archive.org&#x2F;web&#x2F;20220414105622&#x2F;https:&#x2F;&#x2F;docs.spice...</a><p>A slight detour from the company&#x27;s original vision (<a href="https:&#x2F;&#x2F;archive.is&#x2F;88IoQ" rel="nofollow">https:&#x2F;&#x2F;archive.is&#x2F;88IoQ</a>)?
评论 #39857599 未加载
评论 #39858281 未加载
评论 #39864909 未加载
CyberDildonicsabout 1 year ago
There are eight different accounts in this thread &quot;congratulating the launch&quot; with their first comment. Half were created six hours ago right when this was posted.<p><a href="https:&#x2F;&#x2F;news.ycombinator.com&#x2F;user?id=martinmao">https:&#x2F;&#x2F;news.ycombinator.com&#x2F;user?id=martinmao</a> <a href="https:&#x2F;&#x2F;news.ycombinator.com&#x2F;user?id=dwgray">https:&#x2F;&#x2F;news.ycombinator.com&#x2F;user?id=dwgray</a> <a href="https:&#x2F;&#x2F;news.ycombinator.com&#x2F;user?id=dennispan">https:&#x2F;&#x2F;news.ycombinator.com&#x2F;user?id=dennispan</a> <a href="https:&#x2F;&#x2F;news.ycombinator.com&#x2F;user?id=peycke">https:&#x2F;&#x2F;news.ycombinator.com&#x2F;user?id=peycke</a> <a href="https:&#x2F;&#x2F;news.ycombinator.com&#x2F;user?id=watsondoc">https:&#x2F;&#x2F;news.ycombinator.com&#x2F;user?id=watsondoc</a> <a href="https:&#x2F;&#x2F;news.ycombinator.com&#x2F;user?id=leeholim">https:&#x2F;&#x2F;news.ycombinator.com&#x2F;user?id=leeholim</a> <a href="https:&#x2F;&#x2F;news.ycombinator.com&#x2F;user?id=cedrone">https:&#x2F;&#x2F;news.ycombinator.com&#x2F;user?id=cedrone</a> <a href="https:&#x2F;&#x2F;news.ycombinator.com&#x2F;user?id=jjustin_lawson">https:&#x2F;&#x2F;news.ycombinator.com&#x2F;user?id=jjustin_lawson</a>
评论 #39861594 未加载
评论 #39864945 未加载
评论 #39864854 未加载
评论 #39864917 未加载