HNHacker News
TopNewBestAskShowJobs

jd3

726 karma · joined January 30, 2015

https://dataswamp.org/~john/
submissionscomments
jd3··on Rewrite Bun in Rust has been merged
> You contribute to projects run by others with the understanding that others run the project, is this not the default assumption others have too when contributing to FOSS?

There are certain unspoken rules you don't break out of a of tradition of process and decorum — this decision broke that rule, overturning 5+ years of accrued experience and institutional memory, so I can understand why this might feel like a rugpull which would reasonably upset the average contributor.

These antics are acceptable in a BDFL project where the stakes are low, but try this in an actual major project with thousands of contributors and see how it goes.

I think the best case scenario I can think of is the microsoft typescript js->go conversion, whereas the bun zig->rust is probably the worst case.

jd3··on Maryland citizens hit with $2B power grid upgrade for out-of-state AI
I wrote a multi-page essay about this for our condo association last year. There's lots of complexity and externalities here — Pepco grid modernization, PJM interconnection cap auctions, AI buildouts in NOVA, etc; it's a really complicated issue.
jd3··on The buns in McDonald's Japan's burger photos are all slightly askew
The US app is still laggy (even on the iPhone 17 Pro) and constantly logs you out. My theory is that they set the login timeout to a low number to make it harder to accrue points.
jd3··on GitHub Stacked PRs
We dealt with this headache for 7+ years at my former employer. Thanks so much for this.
jd3··on Tailscale's new macOS home
> ability to stream US TV when abroad (by exiting from my home network)

Should note that Tailscale does not work natively with hdhr for mpeg television streams b/c wireguard doesn't natively support udp multicast/broadcast. Also can't directly port forward b/c hdhr sets a default ttl of 2.

My understanding is that most VPNs in general don't support udp multicast due to operating on the network layer rather than data link, though iirc OpenVPN supports multicast traffic through its virtual TAP (Layer 2) rather than TUN (Layer 3).

Tailscale does create a TUN/TAP virtual network[0], though udp multicast is still not natively supported.

[0]: https://tailscale.com/docs/concepts/tailscale-osi#data-link-...

https://github.com/tailscale/tailscale/issues/1013

https://github.com/tailscale/tailscale/issues/11134

jd3··on 60 Minutes Havana Syndrome report finds U.S. government tested energy weapon
The effects aren't too far off from reports of the maduro raid, though my understanding is that the US just used a standard LRAD
jd3··on Lessons learned shipping 500 units of my first hardware product
I stopped reading when I realized it wasn't a deep dive into the most interesting question I had, which is the technical hardware design process and finding a factory to actually take your design and manufacture it.
jd3··on What's up with all those equals signs anyway?
I discovered X-Face[0] through gmane! Such a blast from the past.

[0]: https://en.wikipedia.org/wiki/X-Face

jd3··on The struggle of resizing windows on macOS Tahoe
I noticed this and modified the .car to just make window corners sharp. It looks a bit jarring, but functionally speaking, it feels like a big improvement.
jd3··on Screenshots from developers: 2002 vs. 2015 (2015)
Thanks, typo; updated.
jd3··on Screenshots from developers: 2002 vs. 2015 (2015)
Dennis Ritchie running Rob Pike's acme editor on Windows back in July 2002.

https://anders.unix.se/images/dmr_screenshot.gif

https://anders.unix.se/2015/10/28/screenshots-from-developer...

jd3··on Asbestosis
My mom's father died in his early 30's while working as an engineer for Mack Trucks in Hagerstown, Maryland in the '50s and '60s and my mom, to this day, attributes his rapid health decline to mesothelioma/industrial asbestos exposure.
jd3··on I only use Google Sheets
We bought a Google Workspace subscription for a building I help manage and I was shocked when I found out that you can't archive emails for discovery/legal purposes unless you buy a more expensive subscription that has access to the "vault."

We already pay nearly $90/mo for 6 seats!

jd3··on Plugin System
Tried using the "Online Media" built-in plugin for a couple of trivial test cases — Youtube and archive.org — the former worked, while the latter failed, so I disabled it and switched back to yt-dlp in

  Settings => Network => Enable youtube-dl => Custom youtube-dl path => "~/.local/bin/"
because I installed yt-dlp globally through uv

  uv tool install yt-dlp
jd3··on I replaced Animal Crossing's dialogue with a live LLM by hacking GameCube memory
https://www.youtube.com/watch?v=7AyEzA5ziE0
jd3··on FFmpeg 8.0 adds Whisper support
took me longer than i'd care to admit to figure out how to install whisper as a user/system package on macOS w/o brew (which pulls in all of llvm@16 during install)

    brew install uv
    uv tool install openai-whisper
    then add ~/.local/bin/ to $PATH
jd3··on The Israeli "art student" mystery (2002)
> What is especially remarkable, however, is how quickly the Fox News report appeared and then vanished. Internet sources say that when someone stumbles upon evidence of a possible conspiracy, such as the ones noted above, most journalists say it’s nothing but trouble to pursue it. Even if leads are developed, editors tend to ignore them. Some make it clear that such leads can hurt the writers professionally. Eyewitness reports regarding the Israeli peddlers from authoritative sources, however, make the story of the Israeli squads impossible to dismiss.

https://www.wrmea.org/2002-may/israeli-trainees-and-mossad-a...

jd3··on Benzene at 200
Was going to make the same comment.

https://i.imgur.com/EGyYmkX.jpg

https://www.nytimes.com/1988/08/16/science/the-benzene-ring-...

jd3··on Twin – A Textmode WINdow Environment
I'm a fan of the tiles/patterns from DESQView/X

https://news.ycombinator.com/item?id=16044021

jd3··on I created Perfect Wiki and reached $250k in annual revenue without investors
When working for my former employer, we rolled our own help center, but after awhile, it was deemed easier and cheaper to just cut it and transfer everything to zendesk.
jd3··on What made the Irish famine so deadly
I'm Irish and this is the correct answer
jd3··on Tailscale is pretty useful
I tried using tailscale to share my hdhomerun prime tuners over the internet, but sadly, it doesn't seem to work due to Tailscale's lack of support for mDNS lookups[0][1]. You can't just forward the port b/c the hdhr device packets have a ttl of 1 hop (and, while you could change the ttl through iptables, that seems like a lot of trouble).

I can open a stream manually through http://192.168.1.189:5004/auto/v600 while connected to tailscale (w/ my apple tv in-home as an exit node) on my laptop outside of the house, but when I open the HDHR/Channels apps, they can't detect the HDHR tuner itself.

Apparently this "just works" with openvpn, so I've been thinking about just switching back to that.

[0]: https://github.com/tailscale/tailscale/issues/1013

[1]: https://old.reddit.com/r/HDHR/comments/z8byns/watching_remot...

jd3··on I still like Sublime Text
sublime still has the lowest latency compared to any other major text editor i've tried
jd3··on Why is it so hard to buy things that work well? (2022)
Many of the best engineers that I have worked with over the years have a discerning constitution which seems to innately allow them to identify high quality software, which is essentially a matter of taste.

The problem is that this disposition is not the norm for a technician, which is why I tend to prefer hiring and training engineers that are artistic, creative, and obsessive.

jd3··on Constraints in Go
https://github.com/stephenafamo/bob supports both CTEs and JSONB in the psql (postgres) dialect

https://bob.stephenafamo.com/docs/query-builder/psql/example...

https://github.com/stephenafamo/bob/blob/main/gen/bobgen-psq...

jd3··on SQL style guide by Simon Holywell
I was not tech lead on that part of the project and did not contribute to any of its initial research/implementation, sadly; I was brought in post-hoc to help with perf issues/cleanup.

To directly answer your question, though, without going into too much detail, there were pci compliance issues with some tables/columns in the mysql db, so if I had to guess, perhaps DMS had the capability to assuage that concern more elegantly than mysql_fdw[0], though the mysql_fwd EXCEPT parameter seems to also do the same thing, so honestly, I have no idea.

    By default, all views and tables existing in a particular database on the MySQL host are imported. Using this option, you can exclude specified foreign tables from the import.[1]
[0]: https://github.com/EnterpriseDB/mysql_fdw

[1]: https://www.enterprisedb.com/docs/mysql_data_adapter/latest/...

jd3··on SQL style guide by Simon Holywell
A week before being laid off last month, I solved a decade+ old open problem at our company which first occurred since Django doesn't natively support CTE's, leading to years of technical debt from the ersatz sql/query plans produced by our fragile queries.

I ended up manually overloading get_extra_restriction on a custom ForeignKey class (we couldn't use FilteredRelation b/c we were still on django 1.11), which ensured that the JOIN ON ... clause limited the tables being joined to their correct partition/schema while being accessed through a view

The view thing is a long story — it was a legacy PAC codebase from the '90s which used 13+ schemas in a mysql db that was then being synced to our postgres db through Amazon DMS. All of the tables on each view contain identical source_schema/CompanyID columns, hence the

    '%(remote_alias)s. "source_schema" = %(fk_alias)s. "source_schema" AND '
    '%(remote_alias)s. "CompanyID" = %(fk_alias)s. "CompanyID"
etc. approach

before/after query plan in depesz: https://imgur.com/a/HQbNSIL

jd3··on Low Cost Mini PCs
Had the same initial thought; the site design is simple and straightforward, but info dense and easy to navigate, similar to craigslist.
jd3··on Zuckerberg claims regret on caving to White House pressure on content
I didn't notice the twitter decline until after musk bought + interceded in the algorithm.

It used to feel much more curated/tailored to my more esoteric interests, but now I get ai slop, race baiting, "breaking news" which is some fake right wing news account, etc. etc.

jd3··on Spice: Fine-grained parallelism with sub-nanosecond overhead in Zig
Yes, I meant to say dropbox
Page 1 of 11Next →