article

I quickly learned that writing one giant query with a bunch of joins or even bunch of Python helper functions could get me stuck. My transformation functions weren’t flexible enough, or my joins were too complicated to answer the endless variety of questions thrown my way while keeping the numbers correct.

Instead, the easiest way to be fast, nimble, and answer all the unexpected questions was to prepare a giant table or dataframe and limit myself to it. As long as I understood the table’s contents, it was harder to make mistakes. I could group by and aggregate on the fly with confidence.

The main reason we don’t create more affordances, however, is pure egocentrism. When we just say whatever pops into our heads, we may think we’re making craggy, climbable conversational rock walls, when in fact we’re creating completely frictionless surfaces. For example, I’m thrilled to tell you about the 126 escape rooms I’ve done, but my love for paying people $35 to lock me in a room blinds me to the fact that you probably do not give a hoot. I may even think I’m being generous by asking about your experiences with escape rooms, when my supposed giving is really just selfishness with a question mark at the end (“Enough of me talking about stuff I like. Time for you to talk about stuff I like!”).

Calorie intake, protein intake, and training volume are by far the most important factors determining your body composition and degree of swole-ness. Add in training intensity and specificity, and you’ve got the major factors determining strength as well.

Everything else is just details. And it’s not that details don’t matter; it’s just that unless you’re an elite-level athlete trying to eek out an extra percentage of performance, they don’t matter very much. In a complex, redundant system, details generally get lost in the noise, and end up having at most a trivial effect.

I wanted to explore the malicious, confusing, and deceitful things that occur after signing up for digital services, as well as how design can nudge us to forget about a free trial or accidentally sign up for things that we didn’t intend to.

Dark patterns are often most egregious with subscriptions and free trials, especially when attempting to cancel, so I focused on those.

Though it makes me feel like a grandmother on her deathbed to admit it, I remember the days when the internet was vast, when there seemed to be more places to go than anyone could ever visit and infinite things to read. What you saw was not determined by some highly protected coded algorithm that lives somewhere in the cloud. You could just go out and find it.

The tech industry is abuzz about a new standard for social networking that is more open, more user-centric, and potentially more powerful than Twitter and Facebook. But we’ve been here before.

Free chapter from the eBook Shareware Heroes. Plus the website is amazing.

Could the idea that ice cream is metabolically protective be true? It would be pretty bonkers. Still, there are at least a few points in its favor. For one, ice cream’s glycemic index, a measure of how rapidly a food boosts blood sugar, is lower than that of brown rice. “There’s this perception that ice cream is unhealthy, but it’s got fat, it’s got protein, it’s got vitamins. It’s better for you than bread,” Mozaffarian said. “Given how horrible the American diet is, it’s very possible that if somebody eats ice cream and eats less starch … it could actually protect against diabetes.”

In Silicon Valley, the user’s experience has become subordinate to the company’s stock price. Google, Amazon, Meta, and other tech companies have monetized confusion, constantly testing how much they can interfere with and manipulate users. And instead of trying to meaningfully innovate and improve the useful services they provide, these companies have instead chased short-term fads or attempted to totally overhaul their businesses in a desperate attempt to win the favor of Wall Street investors.

The Avalanches – Since I Left You is missing off this list… But that can almost be forgiven.

In this article, I’ll focus on the delicate interplay between many of the forces that act on a bicycle and its parts when riding. We’ll witness how forces applied through tires make a bicycle accelerate, brake, and turn, and we’ll also investigate how the wheels and the frame handle those different forces without breaking.

I’m sorry to break it to anyone who has trouble keeping their car out of a bike lane (or off a concrete barrier), but it’s not the bike lane’s fault you’re a shitty driver. If you hit something stationary, that’s your fault. Pay attention to the fucking road while you’re driving. It’s not too much to ask when other people’s lives are literally at stake.

Neuroscience suggests that loneliness doesn’t necessarily result from a lack of opportunity to meet others or a fear of social interactions. Instead, circuits in our brain and changes in our behavior can trap us in a catch-22 situation: While we desire connection with others, we view them as unreliable, judgmental and unfriendly. Consequently, we keep our distance, consciously or unconsciously spurning potential opportunities for connections.

Why do so many people have an immediate, intuitive grasp of this highly abstract concept—“subjective age,” it’s called—when randomly presented with it? It’s bizarre, if you think about it. Certainly most of us don’t believe ourselves to be shorter or taller than we actually are. We don’t think of ourselves as having smaller ears or longer noses or curlier hair. Most of us also know where our bodies are in space, what physiologists call “proprioception.”

Yet we seem to have an awfully rough go of locating ourselves in time. A friend, nearing 60, recently told me that whenever he looks in the mirror, he’s not so much unhappy with his appearance as startled by it—“as if there’s been some sort of error” were his exact words.

…That means electric bicycles, which have become a much lower impact solution than cars, are booming in many Amish communities.

It’s a lot quicker to jump on your bike and go into town than it is to bring your horse into the barn, harness it to the buggy, and go. It’s a lot quicker and you travel faster too.