Viewing profile — hantusk

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 4pixe…

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

yeah, also reminded me of wifi sd-cards: https://hackaday.com/2016/06/30/transcend-wifi-sd-card-is-a-...

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

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

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.

Lego brick in build123d: https://build123d.readthedocs.io/en/latest/tutorial_lego.htm... Gear in build123d: https://github.com/GarryBGoode/gggears

CTEs go a long way towards left to right readability while keeping everything standard SQL.

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

cumin and persian cumin (caraway) is one such example

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…

Since writes to object storage are going to be slow anyway, why not double down on read optimized B-trees rather than write optimized LSM's?

I think https://github.com/uwdata/mosaic is really promising here. See the example https://idl.uw.edu/mosaic/examples/linear-regression.html where the user can recalculate a linear…

Check out build123d, which has a nicer api for cadquery. I draw sketches in svg if the sketch shapes become too unmanagable to express in code

https://rclone.org/ works great

I don't think it was for the technical fit or performance reasons, but more a philosophy about everything starts with data, and graphics are just visualizations anchored to the dat…

I also have written a lot d3, between versions 2 and 7, and the refactoring that has happened meant a lot of examples online that were hard to comprehend were even harder to update…

For a shortcut, Musescore has a plugin called colornotes that does this, installable from the GUI. You can alter the color scheme by editing the .js plugin code: https://github.com…

more specifically it's using the svelte wrapper of three.js called Threlte: https://threlte.xyz/

Check out Descript. It's been awesome when I used it in the past

I liked SQL workbench ( https://news.ycombinator.com/item?id=39537794 ) which has the same core ideas but more usable features at this point (query history, parquet support and cha…

you could consider hosting an empty postgresql database, compile your code as a postgresql foreign data wrapper and expose it as a view. Nothing is more compatible with the postgre…

SQLGlot brands itself as an sql optimizer also: https://github.com/tobymao/sqlglot?tab=readme-ov-file#sql-op... but I haven't tried that aspect of it personally

Simo linked some older papers with this same idea: https://twitter.com/cloneofsimo/status/1765796493955674286