hantusk
Joined 13 years ago
Karma
242
Submissions
113
Member since
Mar 12
Recent submissions
Comment · 2 months ago
Check out https://hub.steampipe.io/, available as sqlite/postgtesql extensions
Comment · 2 months ago
It is implemented here as DuckDB extension: https://github.com/ila/openivm/
Comment · 3 months ago
Check out mosaic from uwdata which works on top of Observable plot
Or plotly-resampler which works on top of plotly and uses the rust package tsdownsample to aggregate on the 4pixels per pixel shown level (to make antialias work)
the grammar of graphics approach really is a great abstraction, and I'd love to see xy work in that direction
Comment · 3 months ago
Check out https://github.com/ila/openivm which implements a very large scope of aggregations as incremental operations in an SQL-to-SQL compiler, and extension for duckdb that automatically maintains a materialized view
Comment · 5 months ago
yeah, also reminded me of wifi sd-cards: https://hackaday.com/2016/06/30/transcend-wifi-sd-card-is-a-...
Comment · 7 months ago
I can recommend Pixi for this. https://pixi.prefix.dev/latest/
pixi init && pixi add wget
And youre ready to go, everything confined to the venv within the directory
Comment · 9 months ago
Good opportunities arise for those who stick their neck out. Here's some inspiration for what to blog about: https://simonwillison.net/2022/Nov/6/what-to-blog-about/
It seems he started his blog in 2003: https://simonwillison.net/2003/Jun/12/oneYearOfBlogging/
Comment · 10 months ago
you're joking because of the other frontpage story with Gemini 3 hallucinating hacker news 10 years in the future, but still lets keep the hallucinations to that page.
Comment · 11 months ago
Lego brick in build123d: https://build123d.readthedocs.io/en/latest/tutorial_lego.htm...
Gear in build123d: https://github.com/GarryBGoode/gggears
Comment · 1 year ago
CTEs go a long way towards left to right readability while keeping everything standard SQL.
Comment · 1 year ago
Reading CSV into a duckdb table will give you that, along with a table for the errors and reason for error: https://duckdb.org/docs/stable/data/csv/reading_faulty_csv_f...
Could definitely be done as a small little bash script
Comment · 1 year ago
cumin and persian cumin (caraway) is one such example
Comment · 1 year ago
I agree. So many disparate solutions. The streaming sql primitives are by themselves good enough (e.g. `tumble`, `hop` or `session` windows), but the infrastructural components are always rough in real life use cases.
crossing fingers for solutions like `https://github.com/feldera/feldera` to be wrapped in a nice database, `https://materialize.com/` to solve their memory issues, or `https://clickhouse.com/docs/en/materialized-view` to solve reliable streaming consumption.
Various streaming processing frameworks often have domain specific languages with a lot of limitations of how to express aggregations and transformations.