HNHacker News
TopNewBestAskShowJobs

eskaytwo

119 karma · joined April 22, 2016

submissionscomments
eskaytwo··on pg_clickhouse v0.10: Subquery pushdown and 1000x faster TPC-H queries
Yeah. There's some solid work in there, but it reads like an LLM without a review pass.

This paragraph has an awkward rhythm:

> Getting more into the nitty-gritty, we also closed a subsecond-precision loss when inserting timestamps over HTTP (#300), and to top it all off, a broader static-analysis pass over the codebase turned up and fixed a handful of other latent bugs (#313); these hadn't showed up in the field, but were worth closing before they could.

Even just asking Claude to apply Strunk and White makes it much easier to read:

> We also fixed a loss of subsecond precision in timestamps inserted over HTTP (#300). A static-analysis pass over the codebase turned up several other latent bugs (#313); none had surfaced in the field, but we fixed them anyway.

And its diagnosis of why the original is tricky shows an LLM is more than capable of improving readability given a couple of review passes:

> Three things make it awkward, and they pile up:

> 1. Two bits of throat-clearing. "Getting more into the nitty-gritty" and "to top it all off" both just say here comes the next thing. Neither tells you anything. Back to back, they read as filler.

> 2. Mixed tone. "Nitty-gritty" and "to top it all off" are chatty; "subsecond-precision loss" and "static-analysis pass" are dry and technical. The sentence keeps switching voice.

> 3. Too much in one sentence. Two unrelated fixes joined by a semicolon, plus a clause hanging off the second one, plus the trailing "before they could." By the end, you've lost track of what "they could" was about — the thing it points back to is thirty words behind you.

It's a shame when solid technical work gets obscured by the poor SNR of default LLM output, when clarity is only a few iterations away.

eskaytwo··on How Passive Radar Works
Much more covert, and civilian infrastructure also less likely to be blown up.
eskaytwo··on How Passive Radar Works
With their movement you might get some strange SAR like effects. Computationally complex but could add another dimension over a static tower.
eskaytwo··on Agentic Software Engineering Book
This was done in the analogue age https://en.wikipedia.org/wiki/I_Am_Sitting_in_a_Room
eskaytwo··on Show HN: NanoClaw – “Clawdbot” in 500 lines of TS with Apple container isolation
Thanks! Was hoping someone would do something more sane like this.

Openclaw is very useful, but like you I share the sentiment of it being terrifying, even before you introduce the social network aspect.

My Mac mini is currently literally switched off for this very reason.

eskaytwo··on Meditation as Wakeful Relaxation: Unclenching Smooth Muscle
Meditation has many techniques. Similar to how people have many different motivations and programs when they have a regular gym practice. Strength is different to agility is different to flexibility.
eskaytwo··on Meditation as Wakeful Relaxation: Unclenching Smooth Muscle
MCTB or Dhamma overground might have been a less confronting link to share :)
eskaytwo··on Meditation as Wakeful Relaxation: Unclenching Smooth Muscle
In more formal traditions the focus on breath (or similar) is to develop concentration/samatha/samadhi. The focus on sensations is the insight/vipassana component, and often this is where the tension bubbles up to the surface. Keeping calm (equanimous) during this process can indeed be non-trivial!

It sounds like you have come to a practice very similar to a lot of the Burmese traditions of insight meditation, which is quite fascinating.

eskaytwo··on Meditation as Wakeful Relaxation: Unclenching Smooth Muscle
I think they’re just focussing on the Samatha concentration aspect?
eskaytwo··on The best way to use text embeddings portably is with Parquet and Polars
There’s some nice plugins too, some are finance related: https://github.com/ddotta/awesome-polars
eskaytwo··on Anyone can push updates to the doge.gov website
It’s also important to consider the upcoming tax cuts. Don’t assume the efficiency savings are to return $50.50 to your back pocket.
eskaytwo··on Ingrid Daubechies awarded National Medal of Science
Not every problem needs a CNN thrown at it.
eskaytwo··on Time-Series Anomaly Detection: A Decade Review
Thanks for the pointer. Augurs looks really promising. If the matrix profile method was included it would be a nice alternative to the numba jit methods that are commonplace.
eskaytwo··on Time-Series Anomaly Detection: A Decade Review
It does convolution of each sub sequence across the series length, and then shows the distance of the closest match. This can detect both outliers (long distance from closest match) as well as repeated patterns (short distance).
eskaytwo··on Time-Series Anomaly Detection: A Decade Review
I don’t think it’s the same people.
eskaytwo··on VMware is now part of Broadcom
They deliberately kept them at arms length to protect the brand value
eskaytwo··on An asteroid will occult Betelgeuse on December 12th
for checking this sort of stuff, Stellarium is amazing open-source doftware.
eskaytwo··on Writerside – a new technical writing environment from JetBrains
If this could generate Confluence that would overlap well for a lot of JetBrains IDE users
eskaytwo··on Recent adventures in performance optimization with Rust
DuckDB can also operate on Polars data frames, and return the results to Polars data frames.
eskaytwo··on Recent adventures in performance optimization with Rust
Pandas is ok for numerical, but Polars (rust-based) is absolutely the way to go for big datasets. The article is fascinating if you're a Python developer and you need to stray off the path of things Polars can do.
eskaytwo··on CHART: Completely Hackable Amateur Radio Telescope
There’s also the Kraken project https://www.krakenrf.com/
eskaytwo··on Grave flaws in BGP Error handling
Operators could have raised this with vendors to fix.
eskaytwo··on Improving sleep
It doesn’t. Some of the Swiss waters are very good. My baseline for coffee is quality single origin Geisha, and good Swiss water is better than most espresso places.
eskaytwo··on Dot_ix: Interactive GraphViz Dot Graphs
Are you doing the edge splines and Bézier curves from graphviz?
eskaytwo··on How my children (n=2) acquired absolute pitch
It seems more cognitive than due to physical effects in the ear. Adam Neely had a good YouTube video on it https://youtu.be/QRaACa1Mrd4
eskaytwo··on JupyterLab 4.0
In the sense of an evolving notebook that’s used eg like for reports. It would be good to be able to version control this. The output doesn’t need to be saved, but the code itself would be valuable - and then can pull from version control and run.
eskaytwo··on JupyterLab 4.0
What’s the current best-practice workflow for using with git? I see jupytext discussed in the comments but this saves the .py exported file. Is there a good clean method for storing tbe .ipynb files into git? It maybe is easier without the cell outputs?
eskaytwo··on Evernote to raise prices for Personal and Professional accounts
+1 obsidian is great and all mmd so easy to migrate off if ever need to
eskaytwo··on America’s bad bet on expanding legal sports gambling
The tradie’s laptop
eskaytwo··on DDoS detection and remediation with Akvorado and Flowspec
This is really nice! Have you looked at using stream processors such as ksql for the ddos detection?
Page 1 of 3Next →