hantusk
No user record in our sample, but hantusk has activity below (stories or comments). Likely we have partial data — the full bulk-load will fill profiles in.
No user record in our sample, but hantusk has activity below (stories or comments). Likely we have partial data — the full bulk-load will fill profiles in.
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 started his blog in 2003:…
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 definitely be done as a small little bash…
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 always rough in real life use cases.…
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 regression based on their selection.…
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 data points (or a functionally derived…
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. I feel like its more stable now…
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:…
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 charts) - if you hadn't seen it maybe some…
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 postgres wire protocol than postgresql itself…
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
Digging into the low rank structure of the gradients, instead of the weights seems like a promising direction for training from scratch with less memory requirements:…
Not affiliated, but happy modal.com user, which has very fast cold starts for the few demos i run with them.
That's not true for postgres scanning: https://duckdb.org/2022/09/30/postgres-scanner.html So i would think we'd see similar speedups for sqlite even without copying any data