News for hackers. Stuff that matters.

Show HN: DuckDB-WASM, execute queries in a browser, and share them as links

https://shell.duckdb.org/#queries=v0,INSTALL-spatial~,LOAD-spatial~,CREATE-TABLE-nyc-AS-SELECT-borough%2C-st_union_agg(geom)-AS-full_geom%2C-st_area(full_geom)-AS-area%2C-st_centroid(full_geom)-AS-centroid%2C-count(*)-AS-count-FROM-st_read(%27https%3A%2F%2Fraw.githubusercontent.com%2Fduckdb%2Fduckdb_spatial%2Fmain%2Ftest%2Fdata%2Fnyc_taxi%2Ftaxi_zones%2Ftaxi_zones.shp%27)-GROUP-BY-borough~,SELECT-borough%2C-area%2C-centroid%3A%3AVARCHAR%2C-count-FROM-nyc

( 2 comments | on HN )
Re:Show HN: DuckDB-WASM, execute queries in a browser, and s... by carlopi on Monday December 18, 2023 @01:41PM (#38686424)
DuckDB-Wasm, with extension enabled. Execute SQL queries within a browser tab, and share the scripts as a link.
Re:Show HN: DuckDB-WASM, execute queries in a browser, and s... by ilovefood on Tuesday December 19, 2023 @05:31PM (#38702796)
Amazing, I was eagerly waiting for this one. Loading extensions in previous DuckDB-WASM releases didn't work seamlessly. Looks like now it's the case :D

ref: https://github.com/duckdb/duckdb-wasm/issues/1542#issuecomme...

Thanks!!