HN user

jd3

726 karma

https://dataswamp.org/~john/

Posts4
Comments306
View on HN

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.

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

Asbestosis 9 months ago

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.

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!

Plugin System 10 months ago

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

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

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...

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...

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.

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/...

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

Low Cost Mini PCs 2 years ago

Had the same initial thought; the site design is simple and straightforward, but info dense and easy to navigate, similar to craigslist.