←back to thread

Use DuckDB-WASM to query TB of data in browser

(lil.law.harvard.edu)
227 points mlissner | 1 comments | 31 Oct 25 17:37 UTC | HN request time: 0.234s | source
Show context
mlissner ◴[31 Oct 25 17:37 UTC] No.45774572[source]▶
OK, this is really neat: - S3 is really cheap static storage for files. - DuckDB is a database that uses S3 for its storage. - WASM lets you run binary (non-JS) code in your browser. - DuckDB-Wasm allows you to run a database in your browser.

Put all of that together, and you get a website that queries S3 with no backend at all. Amazing.

replies(4): >>45775637 #>>45775690 #>>45775706 #>>45780371 #
timeflex ◴[31 Oct 25 19:15 UTC] No.45775637[source]▶
S3 might be relatively cheap for storing files, but with bandwidth you could easily be paying $230/mo. If you make it public facing & want to try to use their cloud reporting, metrics, etc. to prevent people for running up your bandwidth, your "really cheap" static hosting could easily cost you more than $500/mo.
replies(3): >>45775880 #>>45777187 #>>45777948 #
simonw ◴[31 Oct 25 23:45 UTC] No.45777948[source]▶
Stick it behind Cloudflare and it should be effectively free.
replies(1): >>45779430 #
1. bigiain ◴[01 Nov 25 05:18 UTC] No.45779430[source]▶
Until it isn't.