HNHacker News
TopNewBestAskShowJobs

gerbler

287 karma · joined September 27, 2019

submissionscomments
gerbler··on Against SQL
There's already a subquery in there. I'm saying this can still be done with one subquery, just in a different place and it returns the desired results.
gerbler··on Against SQL
This example seemed wrong to me as well. You can have a subquery, or CTE that returns as many fields as you want and can join on the manager key
gerbler··on The UK’s pursuit of the perfect pitch changed football
This level of specialization in grass-growing would be a good theme for a mockumentary (like Best in Show)
gerbler··on Mary Catherine Bateson: Systems Thinker
I really like Sterman's book. I think the top comment really nailed the challenge with this approach - it's very difficult to identify the components of a system.

I used this modeling approach quite a bit for a few years - my struggle was trying to quantify casual relationships. This is non-trivial (in so many different fields), which makes it really hard to have a reliable System Dynamics model.

gerbler··on Google Workspace for everyone
It's also a paid service with many customers, so likely to last a long time.
gerbler··on J. Kenji López-Alt is Seattle’s reluctant powerful food influencer
I love his food lab book, and overall he seems like such a nice person. The book is a bit dense, but it has such great info that really helps deepen your cooking skills.
gerbler··on Ad tech firms test ways to connect Google’s FLoC to other data
> However, it is likely that the same FLoC IDs or range of IDs will be associated with someone.

This seems all quite speculative. In the first paragraph they describe FLoc IDs as changing constantly - why would they assume new IDs are not being generated, and groups are not constantly being mixed?

gerbler··on Heavier passengers on planes mean new safety limits for airlines
I do think the passenger should be weighed with their bags.

Ultimately the total mass of the person and their belongings is what is being lifted into the air. If there is a dignified way to weigh both, I think that would be fairest.

gerbler··on A Lifetime of Systems Thinking
Have you come across Business Dynamics by John Sterman? It's essentially Meadows approach applied to the business environment, including thinking about general organizational structure.
gerbler··on Heroic rat retiring from detecting land mines
Hmm, I "adopted" one for a couple of years and I would get regular updates - once they passed training, once they were active etc. I think it was every month or two.
gerbler··on PostGIS at 20, the Beginning
Thank you Paul!

I co-built a small company on GeoDjango (Django + PostGIS) and it was a real pleasure to be able to have such a well-working piece of technology in a very fragmented and messy space.

It's a real gem in the world of geospatial data.

gerbler··on In Thailand, traditional cannabis cuisine is back on the menu
I remember this being discussed in a documentary a long time ago (I can't remember the name). A few other points suggested in documentary:

* Hemp/Marijuana was a popular source of fiber and competed with cotton. Cotton requires fertilizer and pesticides (marijuana does not), so the petrochemical industry were keen to squash it as a competitor. Interestingly they claimed it was temporarily legalized during WW2 to allow for rope production.

* Marijuana was also associated with sexual activity (and with both Mexicans & African-Americans). Another reason to portray it as a substance that was immoral.

gerbler··on I Called Off My Wedding. The Internet Will Never Forget
That is a fine photo of an egg
gerbler··on Google is testing its new ad targeting tech in millions of browsers
I'm really missing why FLoC is a bad thing.

Isn't bundling users into buckets good for individual privacy? In theory if the bucket is too small you are identifiable, but my understanding is that the entire premise of this approach is to ensure that is not the case.

gerbler··on Bitcoin as a Battery
It's more like "embodied energy" than battery
gerbler··on The Irish Woman Who Shot Mussolini
More accurate to say she was Anglo-Irish, as she was born in Ireland.

> This is part of Ireland's attempt to cobble together some sort of anti fascist history as nationalism rises due to the displacement levels of immigration seeing numbers greater than the historical plantations of her kind ...

Who is creating this narrative? And what do you mean by "Ireland's attempt"?

gerbler··on Kill the Alarm Clock (2017)
Why do you assume I have not done this? (I have)

My main point about this article is that it's not considering why we are roped into an alarm clock culture - it's not because we want to be woken up this way, it's because sometimes it's an economic necessity.

gerbler··on Kill the Alarm Clock (2017)
Yeah, fair. But perhaps higher minimum wages, and no zero hour contacts? Better worker protections?

If economic survival requires depletion of your sleep (which is so important), it's highlighting an imbalance in the overall system.

gerbler··on Kill the Alarm Clock (2017)
I don't disagree with the premise, but there is an enormous luxury in having this option.

If you work two low-paid jobs, you are time poor. My partner used to work three jobs at one point in her life, getting up at 5am, and finishing at 11pm. An alarm clock is needed due to sleep deprivation.

Perhaps a different framing is "kill low-wage jobs"? I'm being facetious but alarm clocks are not inherently bad, low-wages and long hours are.

gerbler··on Tips for a Better Life
If very high-skilled work is needed and/or specialized tools (replacing a front-door, plumbing a gas-line), I agree, it's hard to match a skilled professional.

In my experience, the vast majority of household diy/repair does not require that level of skill. It can also be hard to find a really skilled person that cares about your home as much as you.

For me, I tend towards fixing/making everything myself unless it requires high-skill or specialized tools.

gerbler··on Tips for a Better Life
I completely agree. I've found these are generally challenging tasks that pull you into a flow state, and when doing them with family, contribute to a great sense of accomplishment.
gerbler··on New bike chain claims to be faster, more durable
I have a Gates Carbon drive too. It's extremely convenient, but my understanding is that it's lower efficiency compared to a well-mantained chain. Due to the practical challenges of maintaining a steel chain, I think Gates does well and it's a great commuter option.
gerbler··on Ditch Excel and Use Julia Data Frames
Thanks for explaining!

I've used R for a lot of data-visualization (and become familiar with the idiosyncrasies of many packages) so it's nice to know that it's compatible.

gerbler··on Ditch Excel and Use Julia Data Frames
What is the benefit of using Julia over R?
gerbler··on A crop of startups are trying to make for-profit local news work
I'd love to see variations of this succeed.

I've been a reader and subscriber to a small Dublin (Ireland) newspaper for the last year or so [0]. It has a staff of ~5 and is mostly funded through subscribers (there's some small ads). I enjoy the experience of getting an interesting monthly paper and it's definitely true that it helps me understand what my local elected officials are doing.

Another interesting example in Ireland is Noteworthy which is journalism that is crowdfunded per story [1]

0: https://dublininquirer.com/

2: https://www.noteworthy.ie/

gerbler··on Brave Browser Passes 20M Monthly Active Users and 7M Daily Active Users
I use Brave exclusively on mobile (so do 5 other people I know, with various levels of tech literacy).

It's fast and blocks ads - that's quite a draw.

gerbler··on Background Features in Google Meet, Powered by Web ML
Sometimes people may not be comfortable sharing their backgrounds, and may not have convenient alternatives. For example, if you have a bed in the background it can be awkward and you might want to blur that out.
gerbler··on NYC’s new digital subway map
It's crazy that this was done pro-bono. Perhaps this is why there are a lot of performance issues?
gerbler··on Reading too much political news is bad for your well-being
I did this too. I gave up reading the news about four months ago. I'm much happier and sleep much better. I found I was constantly reaching for something like the guardian to kill time (including if I woke up at night).

I wanted to still read something current so I subscribed to the New Yorker and love their long articles.

gerbler··on How to put machine learning models into production
There's a great paper from Google about this "Machine Learning: The High Interest Credit Card of Technical Debt" [0] which discusses why you should use a framework to deploy ML models (the authors are involved in developing TFX).

In my experience, spending time explaining results to the business is also a very time consuming element of deploying a model too.

0:https://research.google/pubs/pub43146/

← PreviousPage 2 of 3Next →