Viewing profile — carlopi

DuckDB Table Visualizer demo, showcasing 'Iceberg on the Browser' demo ( https://duckdb.org/2025/12/16/iceberg-in-the-browser )

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

Here it is: https://carlopi.github.io/duckdb-wasm-unsigned////#queries=v... That is, the duckdb-wasm web shell with loaded PSQL extension

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

Btw, it's already happening: Go to https://shell.duckdb.org , and type FROM ' https://hacker-news.firebaseio.com/v0/item/37663308.json '; Querying hacker news, from a browser tab (…

Thanks, cool read, I took a couple of ideas, will see where we land.

I'd say find an angle that adds value for you (ideally both since you want the answer AND you can benefit from learning) random ideas can be: * C++: extension to interface with Git…

I just discovered Hacker News offers a JSON API, ducking awesome, if only there was a nice tool to crunch data as JSON files... I think I have just found out yet another great Duck…

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-Component…

I have to double check this, but the approach should be theoretically sound since we are quite strict with what functions are considered to have known call-sites: Function has to b…

I am not completely sure of what "classical" partial evaluation is, but probably yes, this is somehow a special case of it. I have now quite some material to read (see other links …

Take this other example: https://gcc.godbolt.org/z/nebP68Tx8 Here by playing HumanCompiler it should be possible to prove that the if condition never evaluates to true, so removing…

Devirtualization is always plenty of fun + has lots of potential. Added to the list of article to read.

Congrats, later will check & take inspiration!

> My respect to the entire team. Same!

Yes, I wanted to be more nuanced but oversimplified. Thanks for mentioning this!

The step forward that I believe worked well here is that given some actual paths (and since they are simply a sequence of Instruction, they can be fed to an interpreter) they are m…

PartialExecuter happens at the LLVM's IR level, and in theory it's fully generic. Then has been only partially tested outside the Cheerp-pipeline, so I would expect it to rely on s…

Thanks a lot! I also believe it would be cool to upstream this, we will have to sit down and do some planning. Compilation time could improve (I was actually working on this today)…

WebAssembly implies static linking (malloc / printf & all are part of the shipped module) and code size matters since it directly influence users (since there might be delays in do…

A subset of this could possibly be applied at the wasm-opt level, but consider that at the LLVM's IR level there is more information to be leveraged (in particular PartialExecuter …

Hi, author of the post here, I am not familiar with this concept, do you have any pointers?

Hi, I wrote the article, and I am somehow to blame for PartialExecuter, looking forward to any feedback and questions!