carlopi

2 ปีที่แล้วdiscuss

```sql FROM 'https://raw.githubusercontent.com/hannes/fortytwodotparquet/...' LIMIT 10; ``` (or online: https://shell.duckdb.org/#queries=v0,FROM-'https%3A%2F%2Fraw...)

carlopi

2 ปีที่แล้วdiscuss

Here it is: https://carlopi.github.io/duckdb-wasm-unsigned////#queries=v...

That is, the duckdb-wasm web shell with loaded PSQL extension

carlopi

3 ปีที่แล้วdiscuss

DuckDB-Wasm, with extension enabled. Execute SQL queries within a browser tab, and share the scripts as a link.

carlopi

4 ปีที่แล้วdiscuss

Not sure whether they classify as obscure, but I haven't see cited already:

- Dominator tree (https://en.wikipedia.org/wiki/Dominator_(graph_theory))

- Single-Connected-Components-Graph

- Deterministic data structures (eg. a set that acts deterministic to the fact that addresses might be somehow randomly assigned, very useful for ensuring reproducibility)

Already cited, but it's clearly among the most elegant:

- union-find (!!!!)

and as a bonus one that is easily overlooked:

-std::deque, that when restricted to push_back() or push_front() guarantees not to ever move objects around.

Submissions

Show HN: DuckDB Table Visualizer –> Iceberg

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

comments