HNHacker News
TopNewBestAskShowJobs

durkie

1,529 karma · joined December 20, 2011

materials scientist / fruit picker / industrial automation / lost somewhere

riding every road at https://wandrer.earth co-founder http://www.concrete-jungle.org co-founder https://www.comingle.io (NSFW)

submissionscomments
durkie··on Do we just want slaves?
https://www.urbandictionary.com/define.php?term=Goomba+falla... Maybe
durkie··on HPV vaccine cuts risk of dying from cervical cancer before 30
Why does that seem important? The “in mice” one makes sense (such results might not be the same in humans), but is there a reason to think that results achieved here in England couldn’t happen elsewhere?
durkie··on Decades of Effort Restore Steelhead and Salmon Passage on Alameda Creek
They may have requested to be anonymous
durkie··on US healthcare marketplaces shared citizenship and race data with ad tech giants
i believe it is self-declared.
durkie··on A case study in PDF forensics: The Epstein PDFs
It’s a common thing for speakers of Singaporean English to end sentences with la/leh. But no idea if that’s what’s going on here.
durkie··on France Aiming to Replace Zoom, Google Meet, Microsoft Teams, etc.
i have questions about this! is there a way to get in touch with you?
durkie··on I extracted the safety filters from Apple Intelligence models
Seriously. I feel like “performative” gets applied to anything imperfect. They’ll never stop 100% of murders, so these laws against it are just performative…
durkie··on An Indoor Beehive in My Bedroom Wall
There are bee diseases that are so serious (American foulbrood) that if your hive gets it then the dept of agriculture will come out and not leave until you burn the affected hives. It is super infectious and can cause massive commercial damage if allowed to spread.
durkie··on OpenPlanetData – Free Daily Planet OSM PBF and GOL Indexed Snapshots
Wow this is my first time hearing about the Geodesk format. It seems super useful...I do a ton of OSM data processing, and I can't really do anything with it until it's loaded in to PostGIS, so this would save a ton of time/storage space over that.
durkie··on RFK Jr.: HHS moves to restore public trust in vaccines
From the way you described it, it sounds like there were openings and Biden appointed folks to fill those openings.

How is this different from any president filling any vacancy? By nature of the vacancy being filled, a future president won’t be able to fill it.

durkie··on Spaced repetition systems have gotten way better
I was looking to use this with the iOS Books app, but I can’t share text to your app from there (but something like safari works). Any idea why?
durkie··on Past, present, and future of Sorbet type syntax
Same! I reach for crystal when I need something that is going to perform faster than ruby, but man I get my hand slapped constantly when writing it.
durkie··on Why does Switzerland have so many bunkers?
This is mentioned in the John McPhee book referenced elsewhere in the thread, because there is actually an answer: when the cantons stopped fighting and Switzerland/Helvetica Confederation was formed, the Swiss finance/banking system developed to handle all the money being brought in by those folks acting as mercenaries and being paid to fight other people’s wars.
durkie··on Serving Vector Tiles, Fast
another option that would have been interesting to see here is serving PostGIS GeoJSON export -> tippecanoe encode. Tippecanoe is super fast, parallelizes well and built solely for generating vector tile data (with lots of configurable options that PostGIS lacks)
durkie··on Why Ruby on Rails still matters
https://www.todayintabs.com
durkie··on The Myth of Bananaland
What is amazing to me is that this post references an "epidemic of slipping on banana peels", was posted within a day of a wonderful (33 minute long!) video about the history of slipping on banana peels, and neither references the other! https://www.youtube.com/watch?v=p8W5GCnqT_M
durkie··on OpenStreetMap's New Vector Tiles
Yes, they could. You can attach whatever metadata you want to a vector tile feature.
durkie··on OpenStreetMap's New Vector Tiles
Something like https://github.com/maptiler/tileserver-gl can serve raster tiles from a vector tile dataset
durkie··on Biological Miracle – Wood Frog
A great book about how animals survive super cold winters is "Winter World" by Bernd Heinrich.

Bernd is a super fascinating biologist who really dives deep in to things. At one point in the book I think he was talking about chipmunks surviving winter, and it goes really fun on the first principles. Something like: "chipmunks have a surface area of X m^2, and need to maintain an internal temperature of Y˚C. If the outside temperature is -40˚C they therefore they need to consume Z calories per hour just to maintain body temperature. Their favorite food are pine nuts from the white pine tree. The pine nuts each have B calories, so the chipmunk will need to eat D of them per hour. How many nuts can a chipmunk fit in its mouth? Well I found a dead one and shoved pine nuts in to its mouth until I couldn't fit anymore, and managed to get 17 in there. That means..."

durkie··on Automattic–WP Engine Term Sheet
But the software is called WordPress. How else should they say that they can host WordPress on their site without referring to it?

This feels like if you were to go after someone advertising themselves as a "Honda repair shop".

The sibling comment of "The WordPress Theme Portal" makes more sense as it might imply "The (Official) WordPress Theme Portal"

durkie··on 18,000 Miles Later, an American Woman Has Cycled the World
I think it’s an ambiguity in how the GP worded it. Since it’s a solo record, they could have also written it: “that record requires no drafting”
durkie··on I mapped almost every USA traffic death in the 21st century
But you're saying the speed limit (being too high or low) makes the road dangerous. Aren't the people driving their cars too fast making the road dangerous?
durkie··on I mapped almost every USA traffic death in the 21st century
How does setting a speed limit "too low" make a road more dangerous?
durkie··on Portugal over 90% renewable electricity in May and June
What's the reality check? It sounds like your result basically agrees with the link title.
durkie··on Tour de France: How professional cycling teams eat and cook on the road
reminds me of an anecdote from Le Ride (https://en.wikipedia.org/wiki/Le_Ride ) that talks about in one of the early Tours de France, a rider was disqualified because he broke his crank, hobbled to a nearby town, found the blacksmith, and the rider welded his own crank back together, but the blacksmith's son operated the bellows and this was seen as too much external assistance.
durkie··on Things to avoid in Ruby
My guess is that they're referring to how Rails will instantiate full objects for ActiveRecord database requests and this is often not what you want, because we often just want a single or a few attributes from the model.

So if you had a model Activity, and you wanted to get the names of some of them, the slower/higher memory approach would be something like:

Activity.where("id < 100").map(&:name)

This pulls results from the database, instantiates each as Activity objects, then iterates through each to get its name. You can see in the logs that it grabs the entire object:

Activity Load (133.7ms) SELECT "activities".* FROM "activities" WHERE (id < 100)

.pluck instead grabs just the field you're looking for without instantiating the entire object. So the better way to grab the list of activity names would be like:

Activity.where("id < 100").pluck(:name)

And you can see from the logs that it makes a more narrow query:

(3.8ms) SELECT "activities"."name" FROM "activities" WHERE (id < 100)

durkie··on Making a Postgres query 1k times faster
Not at all surprised that Laurenz Albe played a key role in figuring this out -- I've learned so much about postgres from his Stack Overflow answers over the years.
durkie··on Roll-to-roll fabricated perovskite solar cells under ambient room conditions
What material though? Nanosolar was also doing CIGS roll-to-roll cells, and that didn't work out too well for them.
durkie··on Why Has Figma Reinvented the Wheel with PostgreSQL?
Crunchy data (which can run on AWS/Azure/GCP) supports Citus: https://www.crunchydata.com/blog/announcing-citus-support-fo...
durkie··on JetZero: Ultra-efficient blended wing body jet
also the site is "protected" by dmca.com
Page 1 of 14Next →