Lemaxoxo

8 ms·

1.
Pub Quiz Flashcards(maxhalford.github.io)
2 points by Lemaxoxo 4mo ago|0 comments
2.
by Lemaxoxo 4mo ago
Right, I get that usecase. You have to crunch numbers that sit somewhere, and store the outputs in the same place. DuckLake is great for that. But where does this DuckDB client-server setup fit in?
3.
by Lemaxoxo 4mo ago
+1 I can't think of many use cases for this and Arrow Flight, other than moving data around.
4.
Lower your warehouse costs via DuckDB transpilation(maxhalford.github.io)
1 points by Lemaxoxo 6mo ago|0 comments
5.
by Lemaxoxo 7mo ago
That's very cool, thanks for sharing. Our of curiosity, did you ever get to run on a Twitter/X stream of political tweets?
6.
by Lemaxoxo 7mo ago
You are correct. To be fair I wasn't focused on comparing the runtimes of both methods. I just wanted to give a baseline and show that the batch approach is more accurate.
7.
by Lemaxoxo 7mo ago
Author here. Thank you very much for the comment. I will take a look. This is a great case of Cunningham's law!
8.
by Lemaxoxo 7mo ago
Author here. Thanks for your comment! Compression algorithms may have been supporting incremental compression for a while. But as some have pointed out, the point of the post is that it is practical and simple to have this available in Pyth
9.
by Lemaxoxo 7mo ago
Ok that makes sense! On my side I can get away with using it through WASM. But your performance needs won't allow that.
10.
by Lemaxoxo 7mo ago
I'm curious because I have a similar use case for a querying frontend. Did you consider using https://github.com/tobymao/sqlglot ? If so, what was missing to justify writing your own parser?
11.
Text classification with Python 3.14's ZSTD module(maxhalford.github.io)
12 points by Lemaxoxo 7mo ago|1 comments
12.
by Lemaxoxo 7mo ago
Hello HN. 5 years ago I posted an article about text classification via data compression. I got helpful and educative comments in response. Now that Python have shipped zstd in 3.14, I thought it would be time to revisit this approach. The
13.
by Lemaxoxo 8mo ago
https://maxhalford.github.io/
14.
by Lemaxoxo 1y ago
Op here. I tried what the font a bit but didn't mention it in the article. I didn't get good results with it. Although it's probably a good idea to ask it for a guess, and feed that to the LLM too.
15.
Do LLMs Identify Fonts?(maxhalford.github.io)
8 points by Lemaxoxo 1y ago|1 comments
16.
by Lemaxoxo 2y ago
Nice! I wrote about something similar for rectangular layouts: https://maxhalford.github.io/blog/dynamic-on-screen-keyboard...
17.
by Lemaxoxo 3y ago
Cheers! Mainly a couple of things: - I don't like to have to put {{ ref('source') }} everywhere. I think the tool should parse dependencies automatically. I wrote more about this here: https://maxhalford.github.io&
18.
Lea: Minimalist Alternative to Dbt(github.com)
13 points by Lemaxoxo 3y ago|4 comments
19.
by Lemaxoxo 3y ago
Hey there HN. lea is a tool we developed over the past year at Carbonfact. Carbonfact is a platform that helps fashion brands decarbonize. We believe in doing this in a data-driven way, and lea is a cornerstone for us.
20.
Answering “Why did the KPI change?” using decomposition(maxhalford.github.io)
2 points by Lemaxoxo 3y ago|0 comments
21.
by Lemaxoxo 3y ago
Hey, great work. Do you think this algorithm would be amenable to be done online? I'm the author of River ( https://riverml.xyz ) where we're looking for good online clustering algorithms.
22.
by Lemaxoxo 4y ago
Thank you so much for this! It's very generous of you to have taken the time.
23.
by Lemaxoxo 4y ago
Thanks, I wasn't aware.
24.
by Lemaxoxo 4y ago
Do you have some data/resources on this? I'm a total snowflake at this, but I'm willing to learn.
25.
by Lemaxoxo 4y ago
That's too bad, I would have expected it to work out of the box. Other than rewriting the query in a different way, I'm not sure I see an easy workaround. Are you still working on this?
26.
by Lemaxoxo 4y ago
Hehe I was wondering if someone would catch that. Rest assured, I know the difference between online and stochastic gradient descent. I admit I used stochastic on Hacker News because I thought it would generate more engagement.
27.
by Lemaxoxo 4y ago
Isn't that the point of common table expressions (CTEs)?
28.
by Lemaxoxo 4y ago
I agree. Databases are going to be here for a long time, and we're barely scratching the surface of making people productive with them. dbt is just the beginning.
29.
by Lemaxoxo 4y ago
I'm watching it, it's really good. Montana makes a great point: you can move data to the models, or move the models to the data. Data is typically larger than models, so it makes sense to go with the latter.
30.
by Lemaxoxo 4y ago
Postgres has excellent support for WITH RECURSIVE, so I see no reason why it wouldn't. However, as I answered elsewhere, you would need to set some stateful stuff up if you don't want the query to start from scratch when you re-ru

More ›