carlopi

6 ms·

1.
Show HN: DuckDB Table Visualizer –> Iceberg(duckdb.org)
2 points by carlopi 9mo ago|0 comments
2.
by carlopi 2y ago
```sql FROM ' https://raw.githubusercontent.com/hannes/fortytwodotparquet/... ' LIMIT 10; ``` (or online: https://shell.duckdb.org/#queries=v0,FROM-'https%3A%2F%2Fraw... )
3.
by carlopi 3y ago
Here it is: https://carlopi.github.io/duckdb-wasm-unsigned////#queries=v... That is, the duckdb-wasm web shell with loaded PSQL extension
4.
Show HN: DuckDB-WASM, execute queries in a browser, and share them as links(shell.duckdb.org)
8 points by carlopi 3y ago|2 comments
5.
by carlopi 3y ago
DuckDB-Wasm, with extension enabled. Execute SQL queries within a browser tab, and share the scripts as a link.
6.
by carlopi 3y ago
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 (passing t
7.
by carlopi 3y ago
Thanks, cool read, I took a couple of ideas, will see where we land.
8.
by carlopi 3y ago
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 GitHub workflows results (say how many times job X passed)
9.
by carlopi 3y ago
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 DuckDB-weekend project!
10.
by carlopi 4y ago
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 struct
11.
by carlopi 5y ago
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 be internal (as in no visibility from outside) + no indirect
12.
by carlopi 5y ago
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 about partial evaluation or super-compilation).
13.
by carlopi 5y ago
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 the if is safe. This is an example of
14.
by carlopi 5y ago
Devirtualization is always plenty of fun + has lots of potential. Added to the list of article to read.
15.
by carlopi 5y ago
Congrats, later will check & take inspiration!
16.
by carlopi 5y ago
> My respect to the entire team. Same!
17.
by carlopi 5y ago
Yes, I wanted to be more nuanced but oversimplified. Thanks for mentioning this!
18.
by carlopi 5y ago
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 merged or forked while entering or exiting SCCs, this allows
19.
by carlopi 5y ago
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 some implicit assumptions on the kind of legalizati
20.
by carlopi 5y ago
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), but it's already in line with other optimizations, ta
21.
by carlopi 5y ago
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 downloading big payloads). Both factors plays a role
22.
by carlopi 5y ago
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 uses information on what memory ranges are read-only).
23.
by carlopi 5y ago
Hi, author of the post here, I am not familiar with this concept, do you have any pointers?
24.
by carlopi 5y ago
Hi, I wrote the article, and I am somehow to blame for PartialExecuter, looking forward to any feedback and questions!
25.
Show HN: Cheerp 2.7, C++ to JavaScript/WASM, PartialExecuter, Exceptions(leaningtech.com)
1 points by carlopi 5y ago|1 comments
26.
by carlopi 5y ago
Pure JS unrolling + bit manipulations lead to roughly 40% speed up, using this function: function add() { var i = 0, d0 = 0.0, d1 = 0.0, d2=0.0, d3=0.0; for (i = 0|0; i < N; i = ((i|0)+(4|0))|0) { d0 = a[i^0] + b[i^0]
27.
by carlopi 5y ago
Author here, questions are welcome!
28.
by carlopi 6y ago
Do you have any single example where Rust+WebAssembly are 100x (or even 10x) faster than JavaScript? I did got to the page you linked, but also there is no actual "proof".
29.
by carlopi 6y ago
I am highly skeptical of any claim that anything can be 10x-100x faster that JavaScript. Do you have any concrete example where a similar program coded in (decently written) JS is that slower? I work on a compiler from C++ to JavaScript &am
30.
Show HN: C++ function+classes compiled to JavaScript. Open and go to dev console(leaningtech.com)
1 points by carlopi 6y ago|0 comments

More ›