HNHacker News
TopNewBestAskShowJobs

Erwin

2,405 karma · joined April 10, 2008

@ andreasen . org
submissionscomments
Erwin··on French scientist's photo of ‘distant star’ was chorizo
Speaking for the food producers of Earth and the Solar System, I object to calling whatever material this extra-solar planet is made of "chorizo". If some expedition were to be made to this planet and return a thousand years later with a 10,000 km long sausage (nicely preserved due to the vacuum I suppose), it should not be be able to confuse the consumers by selling it under a brand name connected with Earth sausages, regardless of how tasty it might be. That would just play right into the hands of whatever corporation was able to furnish the first expedition to leave the solar system.
Erwin··on PostgreSQL 14 Internals Book
If you want more, here's another site with similar focus: http://www.interdb.jp/pg/index.html
Erwin··on Germany: Crypto held for more than a year will not get taxed
Interesting to compare that to what happens across the border in Denmark, where crypto is treated as speculation: EVERY individual sale you make has the profit taxed as personal income (calculated as FIFO and so up to ~52%) but the losses have deduction taxed separately at about 26%.

Thus you can end the year with 0 net profit, but a huge tax bill!

Erwin··on The Game: A continually-run D&D campaign, since 1982
There are roleplaying systems that do embrace the complexity (and well beyond CPRG).

Here's an "attack table" for one specific weapon in Rolemaster: you roll a 1-100, add and subtract a whole lot of offensive and defensive bonuses and end up with a result like "15DK" -- 15 hit points of damage and a severity D critical hit on the K (Crushing) table. The broadsword can give both Crushing and Slashing criticals. That again has 20 random outcomes such as "Strike lower level; tear tendons. Foe is at -25%. +3 hits. Foe is stunned and unable to parry next round"

https://i.stack.imgur.com/SPCmu.png

Erwin··on New(ish) command line tools
I like that idea of converting metadata to text, so you can do text operations on it that you are already familiar with, and then apply the changes back.

If your problem can be solved by just regexps, there's a "rename" tool installed by Perl I've used for decades. E.g.

    rename -n 's/JPEG$/jpg/' *JPEG
Will apply the substitution for JPEG at end of the filename to just jpg. The -n will run without renaming so you can see what it intends to do.
Erwin··on Korn Meets KoRN
One of the earliest UNIX legend stories I remember being told was this one about a Korn-like shell being announced in Windows, with Korn himself asking some pointed questions about compatibility: https://wiki.c2.com/?KornShellStory

(Remember those crazy days of MS Windows claiming POSIX compatibility so it could win some government bid?)

Erwin··on Spotify and Google Announce User Choice Billing
Spotify is public and you can see most of their numbers -- the Cost of Revenue for 2021 was 7 billion EUR on 9.6 in revenue. The cost is said to be mostly the royalties though it would include paying the many millions to some podcasters.

The ad-supported users outnumbers premium users (236 million to 180 million) but bring in only 1/6th the revenue. So that's a factor depressing the payout per stream.

https://investors.spotify.com/financials/press-release-detai...

Erwin··on Predicting Best Picture winners using coughs and sneezes
A good candidate for https://improbable.com/ig/winners/#ig2021 ?

The 2021 Biology winner was:

> Susanne Schötz, Robert Eklund, and Joost van de Weijer, for analyzing variations in purring, chirping, chattering, trilling, tweedling, murmuring, meowing, moaning, squeaking, hissing, yowling, howling, growling, and other modes of cat–human communication.

Erwin··on Python built-ins worth learning (2019)
You can now get the first item by abusing the walrus operator, e.g. `any((z := x) for x in [3,5,7] if x % 3)` -- afterwards, z have retained the first assignment for which `x % 3` was true.
Erwin··on Bugs in Hello World
The file objects in the library can operate as unbuffered, line-buffered or fully (i.e. block) buffered. When your stdout is connected to a terminal, it is line-buffered and flushes on newline. But when you redirect to a file, it becomes block buffered.
Erwin··on The CSV Virtual Table
Another cool thing about sqlite is that the virtual tables seen here can be extended through your own custom code.

You can then run SQL queries that in the end call your own data functions to generate data. I had a project where I had several diverse data files (each with its own set of functions to iterate over, but no useful querying) where wrapping each data file with a SQL Virtual table allowed med to use SQL to join them up and query them.

Here's a 2014 article where the author exposes redis as a virtual table within your sqlite code using this mechanism: https://charlesleifer.com/blog/extending-sqlite-with-python/

Postgres has some support for this (you run your SQL code but it really talks to some other service, or another postgres database) through foreign data wrappers. There's some Python library to also make adding that easy.

Interestingly a few projects do it in reverse: you are talking the postgres protocol (using library, psql client) to your database server, but it's not postgres but something else entirely (CockroachDB does this).

I like the idea of the entire world being just SQL, but you have to be careful with those wrappers and expose any indexing you might have, otherwise it's lots of expensive table scans.

Erwin··on Yerka bike uses frame as lock
"1 bike stolen every 4 minutes" is an understatement; for Denmark alone 2020 had 40,000 reported thefts which is one every 13 minutes, down from a staggering 115,000 in 1995 (one every 4.5 minutes).
Erwin··on Why the West is reluctant to deny Russian banks access to SWIFT
I love how this widely quoted term originated on reddit. You can get something named after you after as a layman, like Fermat's Last Theorem, just best avoid coming up with it on a reddit account with an obscene name!
Erwin··on Psygnosis (Wipeout, Lemmings etc.) co-founder Ian Hetherington has died
I just started playing the Shadow of the Beast soundtrack on Spotify -- Allister Brimble was quite prolific with several hundred games scored.

It's interesting to compare the Amiga 500 with its 640x256 resolution and 4096 colors driven by a 68K processor with 68k transistors (coincidence?) and my current 4K screen driven by a 3080ti card and 28.3 billion transistors. Certainly the computing and graphics power has increased greatly, but not so the music output.

Erwin··on I tried 30 mustards this summer
It's done widely enough that Maille themselves sell a "Dijonnaise" : Dijon mustard + mayonnaise.
Erwin··on Index bloat reduced in PostgreSQL v14
Is it a HSTORE column with GIN index? The default "FASTUPDATE=ON" option will delay updates to the index until vacuum time, but if you don't vacuum soon enough suddenly it can decide it should sequentially scan instead of reading through the delayed updates.

This is behaviour I've seen on 9.x on the Aurora variant; for that the solution was to use the FASTUPDATE=OFF index storage option. You can see the delayed tuples by using "pgstatginindex" function.

Using some of the extra options of EXPLAIN (ANALYZE, BUFFERS, COSTS) might give more hints.

If not HSTORE/GIN, then it could be that the analyzer, after some auto-analyze of the table things that what you are asking for will match a significant number of the rows in the table. So there's no point in random seeking through an index because it thinks it needs to read e.g. 50% of the table anyway, so it might just as well not use the index.

Erwin··on Tesla Announces a Humanoid Robot “Tesla Bot”
This announcement is going to cause a lot of headaches for recruiters -- "no, not THAT kind of android!"
Erwin··on Richard Bartle releases his classic “Designing Virtual Worlds” book for free
The test as I created it (that site uses a copy of the questions, those were written by Brandon Downey) asked 30 question evenly spread pitting e.g. Explorer against Socializer, so you ended up with a score that said e.g. you prefer Explorer 100% against any other.

Back when the test was relevant (around 2000?) there was lots of multiplayer games (MUDs) and so you could enter what MUDs you were playing after you got your score -- it was interesting to see the averages for each aspect matching up with type of MUD (e.g. PVE versus PVP versus purely social/RP).

I also tried to match the results against a volunteered MBTI: http://mud-dev.zer7.com/2001/8/20412/#post20412

Erwin··on Show HN: Neural-hash-collider – Find target hash collisions for NeuralHash
Here in Denmark a 15-year old girl and boy was filmed while having sex, and the video spread around among teenagers, apparently mostly through Facebook Messenger.

In 2018, the police indicted 1000 of them (tracking them down with Facebook's help). Legal results were a child-porn law judgement for 334 of them, and simpler penalties for 400.

The child-porn judgement was mostly suspended sentences, but it precludes working with children (as a teacher or even sports trainer if children under 15yo are involved) for between 10 and 20 years.

If there was a system that would have caught it sooner, prior to sharing, the spread would be minimized. The police took 3 years to form a plan to indict the 1000+ people.

Erwin··on Apple Has Opened the Backdoor to Increased Surveillance and Censorship
For many years, anti-virus vendors were able to do that. Why haven't those vendors been already co-opted by governments (Kaspersky on the Russian side, Microsoft in the USA side) into scanning for illegal, copyrighted or secret material and reporting on it?

Even open source products like ClamAV rely on a opaque database of virus strings.

Erwin··on THW: Germany′s army of volunteers for disaster relief
Several of the well-known Danish brand companies have a significant part of them owned by a foundation. Novo (infamous for high insulin prices in US!) has 28% of it owned by a foundation, with assets of $65B. Similar with Mærsk, Lundbeck, Carlsberg, LEGO and even the window-maker Velux: https://da.wikipedia.org/wiki/Liste_over_danske_fonde_efter_...
Erwin··on Classified Challenger tank specs leaked online for videogame
Not WWII, but how about tanks, helicopters versus Samurais? https://www.youtube.com/watch?v=An3t39SGSUE
Erwin··on The Well-Tempered Traveler
Well, the standard temperature unit is Celsius, so Fahrenheit is rare and used just by a few obscure countries: https://en.wikipedia.org/wiki/Fahrenheit#Usage -- and USA.

You are more likely to be in a country that has banned anti-personnel land mines than one using Fahrenheit.

Erwin··on The unreasonable effectiveness of just showing up everyday
In addition to Twenty and Food Lab already recommended, I'll mention Niki Segnit's books: Lateral Cooking and the Flavor Thesaurus. Lateral connects "adjacent" dishes -- you know of dish X, but Y is almost the same but from another food culture but everyone agrees on these basic things with just these slight pivots.

The Flavor Thesaurus does the same for ingredients -- you want to do something with figs, what dishes have figs in them, what complements them? The books cover the Western world, and Niki is the most witty writer among the dozens of culinary books I have.

Outside of that I like the "Perfect" columns by Felicity Cloak in the Guardian. Felicity takes a well-known dish and analyses all the differences in recipes, e.g. 6 cookbook authors have 6 different takes on coq au vin, what works best and how do they end up differently to each other? Like on Serious Eats, there's always well-spirited discussion.

Erwin··on Audacity fork creator steps down. Claims his life is in danger
He seems to live in Germany, near Heidelberg (as the German federal police, BKA, of Heidelberg are investigating). The town has a large university, and used to have one of the largest US Military presences in Germany though I think they've all withdrawn now.
Erwin··on WD My Book users wake up to find their data deleted
curl has a handy --resolve option for telling it how to resolve certain names. Useful when you want to connect to something that thinks it's foo.bar.com and send the right tls/host, but DNS doesn't have it correct yet
Erwin··on Rival weightlifter speaks out on transgender Hubbard's Olympic place
Current UK situation seems to be that being "Gender Critical" is a protected belief, based on the ruling case of a case where a tax expert lost her job for tweeting about how men cannot just change into women: https://en.wikipedia.org/wiki/Maya_Forstater_v_Centre_for_Gl...
Erwin··on CaribouLite: Turn any 40-pin Raspberry-Pi into a Tx/Rx 6GHz SDR
What's special about these frequencies to exclude them? 2398.5-2400 MHz and 2483.5-2485 MHz

Unless that was meant to be 2483.5-2495 which is something called "Globalstar".

Erwin··on Facebook will start putting ads in Oculus Quest apps
I've used my Quest 2 more in the last month, than the Rift S in the 2 years I've had it. With the Q2 there are no cables to get in the way, and I can put it on and play Beat Saber instantly - no steamvr to fiddle with. It's a more realistic Wii Sports at this point, but a fun purchase.
Erwin··on Telnet Mapscii.me
I'm amazed at that sending mouse movement and buttons over telnet works. I guess there's some xterm extensions that allow that now?
← PreviousPage 2 of 25Next →