Smallpond – A lightweight data processing framework built on DuckDB and 3FS
54 comments
·February 28, 2025jamesblonde
auxten
Data operations are increasingly happening near the GPU side to boost efficiency—especially for compute-heavy workflows. Talking about Arrow file processing and zero-copy queries on DataFrames, which are becoming crucial for modern data pipelines. I think another option worth considering is chdb, which supports these features and fits well with this shift. (author of chdb here)
orlp
One thing I found peculiar is that for the GraySort benchmark it dispatches to Polars by default to do the actual sorting, not DuckDB: https://github.com/deepseek-ai/smallpond/blob/ed112db42af4d0....
tomnipotent
The function argument defaults to polars, but the actual benchmark code sets duckdb by default.
https://github.com/deepseek-ai/smallpond/blob/ed112db42af4d0...
dcreater
Confused by the example in the repo? What is the use case for this? Is it a replacement for dask, ray etc? (Not a professional swe)
dang
Related ongoing thread:
Understanding Smallpond and 3FS - https://news.ycombinator.com/item?id=43232410
also:
DuckDB goes distributed? DeepSeek's smallpond takes on Big Data - https://news.ycombinator.com/item?id=43206964 (no comments there, but some people have been recommending that article)
rubenvanwyk
May Data Engineering content keep on hitting front page HN!
HackerThemAll
DuckDB itself is cool enough, especially when combined with SQLite and/or PostgreSQL, and now this. Thanks DeepSeek!
dcreater
How is duckdb combined with SQLite? Aren't they alternatives to each other?
fastasucan
What does this do - what is the benefit over DuckDB, Polers etc?
articsputnik
Mehdi just wrote about this. Mainly starting DAGs parallelism using Ray (core) and their filesystem 3FS. See https://mehdio.substack.com/p/duckdb-goes-distributed-deepse....
mritchie712
I don't think you get any really benefits over duckdb unless your data is 10tb+ or you spin up 3FS (which seem challenging).
RyanHamilton
If you want to checkout duckdb try QStudio. It's a free sql client with duckdb integrated: https://www.timestored.com/qstudio/help/duckdb-sql-editor. Disclaimer: I'm the main author.
dcreater
What's with the win95 ui?
maximilianroos
Big fan of QStudio! Thanks for building it!
shipp02
Is the code written by the deepseek model?
I should probably give up on being a software engineer if it is.
cavisne
There is a chinese blogpost from 2019 about 3FS so it predates deepseek [1]. It will be interesting to see the benchmarks but I suspect without 3FS smallpond is not that useful (the bottleneck would move to the networked file system).
None of the big US clouds support Infiniband broadly (Azure & Oracle have some support) so 3FS itself is not very useful to US companies who want to use public clouds.
breadwinner
Give up and become what? Most white collar jobs will be automated in the coming years. You think doctors' jobs are safe?
ezst
Not OP, but, anything that actually physically affects the real world for the better? For instance, large infrastructure engineering and construction projects are not going to run themselves any time soon. The world doesn't revolve around ad and fin tech.
didntknowyou
you can already google the information , the majority of a doctor's value is not in their information but their people and technical skills.
rscho
Well, googling the info is one thing. But today, medicine is still mostly a know-how profession. Residency is there mostly to transmit know-how.
nurettin
If your white collar job consists of simply using software, like copying numbers you see to an excel sheet, maybe. Otherwise they are pretty safe. People have been building tools and automation for thousands of years, yet nobody invented a fully automated cook for your fancy family dinner.
rscho
Yes, doctors are safe. Because they do things. With their hands. That no one else does.
aragonite
> Because they do things. With their hands. That no one else does
That's only true of surgeons :) What if your specialty is nonsurgical (internal medicine, pediatrics, psychiatry, etc)?
mdaniel
Also, a hallucination for 'SELECT mising_field FROM borgus_tuble' is one thing, hallucinating that taking a dose of Cl Na O along with CH3 CO2 H will cure covid is another thing entirely
delfinom
Nope.
Healthcare megacorps are buying up independent practices like crazy. All because doctors can't keep up with the bullshit IT required for insurance, state mandates, etc and that's in addition to the insanity of even renting commercial real estate for an office these days.
These megacorps set quotas and push doctors to nickel and dime like crazy. They sure as shit will spend the money to find robots that can give you a prostate exam with a robot dildo.
risyachka
Why would you assume that?
lvl155
Looking forward to next few years when we can finally abstract away all the back-end techs.
threeseed
We've had this for at least a decade now.
If you use a cloud provider there are managed solutions for data engineering pipelines.
m2f2
Sure, and it's not cheap.
BobbyJo
We ain't even solved garbage collection yet, and you think "back end systems" are going to abstracted away in the next few years?
purplerabbit
Maybe they just mean for the type of projects they care about
BobbyJo
Can't you already just use FaaS and managed persistence?
We are seeing more and more specialized query engines. This is a query engine specialized for training pipelines. It is not general purpose - it is for providing batches of training data at workers. It uses Ray for parallelization. The kind of queries you need are random reads (to implement shuffling across epochs), arrow support (zero copy to Pandas DataFrames), and efficient checkpointing.