HNHacker News
TopNewBestAskShowJobs

wenc

9,715 karma · joined December 22, 2016

submissionscomments
wenc··on Many Small Queries Are Efficient in SQLite
For analytic queries, yes, a single SQL query often beats many small ones. The query optimizer is allowed to see more opportunities to optimize and avoid unnecessary work.

Most SQLite queries however, are not analytic queries. They're more like record retrievals.

So hitting a SQLite table with 200 "queries" is similar hitting a webserver with 200 "GET" commands.

In terms of ergonomics, SQLite feels more like a application file-format with a SQL interface. (though it is an embedded relational database)

https://www.sqlite.org/appfileformat.html

wenc··on Gas Town Decoded
I'm not entitled to your time of course, but would you mind describing how?

All I know is beads is supposed to help me retain memory from one session to the next. But I'm finding myself having to curate it like a git repo (and I already have a git repo). Also it's quite tied to github, which I cannot use at work. I want to use it but I feel I need to see how others use it to understand how to tailor it for my workflow.

wenc··on That viral Reddit post about food delivery apps was an AI scam
I took a course on critical thinking once which taught me to at least pause and ask questions when I read something sensationalist.

I’ve learned that when my impulse is to say “It sounds like something X would do,” it often leads me down very wrong paths.

Just because the vibes point in that direction often doesn’t mean it’s the truth.

This is exactly how misinformation starts and real people pay the price for generations. Just look at the MSG (monosodium glutamate) untruth that has hurt many Chinese restaurants and Chinese Americans over the years. Misinformation is not victimless.

wenc··on Why many Asian megacities are miserable places
I live in NYC. That sounds more like NYC.

Most mega cities in Asia Pacific at least have newer infrastructure and social norms that make them less miserable.

NYC is miserable in some ways (crumbling infrastructure, broken social norms especially post COVID) and not in others (creativity, passion).

Some days I feel the latter makes up for the former. But the former is still bad.

wenc··on Why many Asian megacities are miserable places
Curious, what does that have to with the article?
wenc··on 'Life being stressful is not an illness' – GPs on mental health over-diagnosis
Not Doordash, but I often ask my Lyft drivers.

Like for anything in life, it depends on the market you're in, and where you are situated on the acumen distribution (low acumen drivers don't make a lot, while high acumen ones do). Narrative thinking likes cherry picking the worst cases and then representing those stories as normal. But reality is always a bit more complicated.

Many Lyft drivers are immigrants, either between jobs, or are doing it full time. I don't directly ask them how much they make, but I tell them in my homeland of Canada, if you're on welfare and disability, you make CAD$x and it's good enough money for a single person. Most Lyft drivers are like: "that's way, way less than what I make doing this." (some tell me they make US$3-4k/month, working 6 day weeks. This might sound like too little, but realize that not all COL is the same, and for an immigrant, this is a great gig with optionality -- you can always turn off the app).

Then you might say, oh, they're blind to the depreciation hit their cars are taking. But good, high acumen, Lyft drivers often drive second-hand Priuses which depreciate slowly and have great mileage, and they track expenses like a hawk. If you go to the Lyft subreddit, good drivers know all the tricks -- optimize for high yield windows, avoid dead miles, avoid blind quests, and the cap hours deliberately. It's the ones with less acumen that drive a new car with low MPG on financing, and don't optimize.

So don't generalize and catastrophize (catastrophizing amplifies depression -- in cognitive behavioral therapy, they teach you to guard against that). Just stop it. Everything in life is a distribution.

I'm not saying driving a Lyft is aspirational, but for some immigrants who are doing it to support their family, it's a less-bad option than many others.

I even had a few drivers pushing me to get married (I'm single) because they said, once they get home from a day of driving, they get to go back to family. "It's less lonely," they tell me. In some ways they're happier than I am, even though I make nominally more than them.

wenc··on Functional Quadtrees
That is a cool visualization of a quad tree. I use quadtrees in geospatial applications (to partition lat longs) but this is the time I’ve seen it used to render a photo.

Quad trees are abstract until you see what they look like. It’s a clever method to partition 2D points.

(Kd trees are even better)

wenc··on High-income job losses are cooling housing demand
I lived in downtown Montreal and it could just be me but the housing stock was not of the highest quality compared to most other places in Canada. Montreal as a whole feels rundown (I say this as a former Montrealer who’s lived in many places since). Cheap rent though.
wenc··on Iowa City made its buses free. Traffic cleared, and so did the air
This is one of those NYTimes "solutions journalism" pieces meant to celebrate the program rather than truly analyze it.

You can pick free, or scalable, or financially sustainable (and without sustainability, a political shift will kill it), but you cannot have all three at once. The minute you push on one, second-order effects pop up somewhere else.

It is a classic wicked problem: solving it literally changes the problem.

Big-city transit has an equilibrium point, and it is incredibly stable. Every serious transit city in the world ends up in the same place: charge fares, subsidize low-income riders, and fund the basic system with taxes.

That equilibrium is stable for a reason. Every major city that tries free transit at scale will eventually snap back to it, because it is the only configuration that does not implode under feedback loops. It keeps demand reasonable, service reliable, and the politics tolerable.

wenc··on Apple to focus on 'quality and underlying performance' with iOS 27 next year
I just downloaded Google Keyboard (Gboard) and tried typing "thumbs up". It still screws it up.

Not sure if it's better that the iOS keyboard.

wenc··on Apple to focus on 'quality and underlying performance' with iOS 27 next year
I thought it was just iOS not being responsive enough to my thumb-typing speed.

But this was very validating to watch.

I love my iPhone but hate the iOS typing experience. It's so bad that I bought an external foldable Bluetooth keyboard that I keep in my bag just so that I could type longer emails.

I miss my BlackBerry keyboard.

wenc··on Why I love my Boox Palma e-reader
I have a Kindle, multiple iPads and an iPhone.

I only read on my iPad and iPhone because they are on-hand almost anywhere I am.

To me, the e-reading discussion is the same as the notetaking software discussion -- people obsess over the best form factor, but really most of the benefit comes from "just doing it" and keeping at it.

Most people gear up but they never end up doing it (reading continuous or taking notes).

wenc··on Life After Work
Which ones?

If you’re thinking Scandinavian countries they are mixed economies. Most successful economies today are mixed economies.

wenc··on The future of Python web services looks GIL-free
Globals are not commonly used except in retrofit cases of legacy code or in beginner code.

I haven’t seen or used a global more than once in my 20 years of writing Python.

wenc··on US falls out of 10 most powerful passports list for first time in 20 yrs
This is it. Counting countries with visa-free access to passports seems like vanity metric -- there are many countries that I will never visit in my life.

Freedom to work/live and consular access in places where people want to be is way more important.

wenc··on How America got hooked on ultraprocessed foods
Those are the larger format stores in France. In the US they are called Fred Meyer, Meijer, etc.
wenc··on How America got hooked on ultraprocessed foods
As a Canadian living in the US, I’d say your sentiment depends on where you live and what you’re willing to pay.

In the Seattle area there are overpriced grocery stores like PCC and Met Market that sell healthy food at a premium.

There is also Whole Foods.

Even normal grocery stores like Safeway and Kroger have a ton of healthy foods — you just have to read the label.

The one thing you have to know if that American grocery stores are giant — they carry way more SKUs than the average European grocery store. It’s on the shopper to find what they want. It’s usually there.

wenc··on DoorDash and Waymo launch autonomous delivery service in Phoenix
Outside of big cities in Japan, car ownership is quite high (usually 2 cars per household).
wenc··on How Kyoto, Japan Became the Loveliest Tourist-Trap
> In the US, it's common to go out to eat because the reputation and wages of labor for food service have been crushed, but in Japan, asking another human to pour your beers and make you food and then clean up in an izakaya carries an appropriate cost.

Hmm, unless I'm not getting your point, this seems at variance with the lived experience of most East and Southeast Asians. (I've lived all over the world, mostly in Asia Pacific and North America)

America has relatively high labor cost (plus tax and tips, you're looking at at least $20/meal/person post-covid) and eating out is expensive and it is actually not that common to eat out -- at least not at a sit down restaurant. For most Americans, eating out is maybe a once or twice a week affair.

In most of Asia (including Japan) eating out is relatively cheap and most can afford to do it daily (many young people in Asia don't cook). I don't know if anyone goes to Japan to eat $200 teppanyaki or that izakayas are a daily affair, but most meals in Japan cost under US$10. An udon is under $5, and a gyudon (beef, soup, rice) at Yoshinoya costs under $5. No tax or tip -- you pay sticker price.

wenc··on Fewer H-1B visas did not mean more employment for natives (2017)
Canada has great homegrown software talent (mostly out of schools like UWaterloo and UToronto). They usually come to the US on TN visas, not H-1B.

Canada has given the US so many great people: Brian Kernighan, Alfred Aho, Rob Pike, Ken Iverson, James Gosling, Rasmus Lerdorf, Matei Zaharia, Geoffrey Hinton, Ilya Sutskever, Andrej Karpathy, John Chambers, Robert Gentleman...

wenc··on Terence Tao: The role of small organizations in society has shrunk significantly
This is the classic tradeoff. (it's similar to the bias variance tradeoff, or fox and hedgehog analogy)

Monolithic systems are scalable and efficient when well-governed, but brittle under errors or bad leadership (e.g. China closing its ports in the 14th century had centuries-long repercussions).

Distributed systems are less efficient but more resilient to errors and poor governance.

It’s not always one or the other though. American founding fathers found a right set of tradeoffs in designing checks and balances (like separation of powers) and federalism structures that harden the system against bad governance (though this is under strain today).

wenc··on Claude can sometimes prove it
> “if it typechecks, you’re done” nature of proofs.

This resonates with me.

Software engineering is more art than math -- you have to deal with corner cases, exceptions, human interactions. So much of code encodes culture, preferences, storytelling, etc. It's kind of a "procedural epistemology". You are codifying -- without correctness -- the behaviors that you know.

Pure Math doesn't work like that -- it is more declarative and is built on a structure of correct statements. (numerical math is a different animal -- it's closer to engineering -- but proofs are pure math). It's way more limited and restrictive and rigorous than imperative code.

It's like writing in Haskell. If it compiles in Haskell, the result might not be useful in real life, but there's a degree of consistency that languages like Python cannot enforce.

But even Haskell for practical reasons only aims at consistency rather than correctness. Proof assistants like Lean and Coq go all the way in Curry-Howard correspondence.

wenc··on Claude can sometimes prove it
> Anyone who has used AI tools has seen cases where the first 80% of a project came together like a bolt of lightning, but the last 20% is next to impossible for the AI to accomplish

Offtopic: doing the inverse works better.

If you rely on AI to write 80% of your code, you end up with code you don't understand, so the last 20% is really difficult. You can't even guide the AI correctly at that point.

I actually do the opposite. I write 80% of my code, have an LLM read it, and it helps me iterate faster on the last 20% (which are mostly tedious things like unit tests, corner cases, optimizations, etc). This works surprisingly well because now the AI has a structure to start from, and it's only doing incremental code completion. As a human, I'm also not that great at detecting corner cases -- this is where an LLM really helps because it has seen patterns I've never seen.

In fact, I use coding agents to combine multiple sources of information (not just code) like design docs, LaTeX, etc. and I ask the LLM to detect if the code actually implements the math in the LaTeX correctly. Claude actually does a pretty decent job at that.

wenc··on On Charlie Kirk and Saving Civil Society
For me

Twitter: anger

Instagram: vanity

Facebook: pride

Of those, I hate anger the most so I am off twitter, even though it’s still a great place to overhear the latest in the business, geopolitics and tech zeitgeist. You literally hear about things before anyone else. But I decided that life is too short to be angry all the time.

I like instagram because it’s entertaining (and am of the age where I can ignore influencer antics). This is not true of younger folks for whom instagram is a mimetic model (there’s so much bad advice on it — especially on how to be a man or a woman today). As an older person, I want to tell young people: don’t get relationship advice off instagram. They’re so shallow and make you so entitled — “if your guy doesn’t do this, you’re too good for him” is pretty toxic.

Facebook used to be this political rage bait place but everyone’s left so I’m still hanging around with my geezer friends in their 40s. It’s become a place to share travel photos and pictures of kids.

Tiktok: I’m too old for Tiktok but I hear young people use it for news.

Google: I still use Google but young people are now increasingly abandoning Google and search on ChatGPT.

wenc··on Apple Watch Ultra 3
I also live in Seattle, and have to dig my Orca card out of my wallet every time. I can't even tap my wallet because there are multiple NFC cards in there.

I tell myself, eh first world problems. But agreed that it's also a Seattle Process problem.

For a city with so many tech companies, the city itself isn't very technological.

wenc··on Apple Watch Ultra 3
Also Express Transit.

If you live in a city that supports it like NYC or Toronto, just tap your wrist (no unlock) on transit and you’re in.

wenc··on ReMarkable Paper Pro Move
I work in more applied fields. When I’m doing a long derivation, I draw figures and arrows and my notes spill over from my current view into a larger view.

I find the page concept limiting (for me). I scrawl something but I need an infinite canvas to relate multiple ideas (my mind doesn’t work so linearly). That’s when refresh rate matters a lot.

Also matters when skimming. Eink displays are not conducive to skimming over many pages. That problem is solved on LED displays and paper, but not epaper.

wenc··on ReMarkable Paper Pro Move
Only if you type.

Oddly, no one gets offended if you scribble with your Apple Pencil. It looks like you're taking notes.

wenc··on ReMarkable Paper Pro Move
> On an iPad, at any moment there could be a toast from Signal, or Discord, or Messenger, or whatever. There's a web browser full of infinite content on Reddit and YouTube. I can go on a plane and have a physical book in front of me but it's no match for the allure of the internet if there's Wi-Fi. The reMarkable is one of the only devices out there that fixes the distraction aspect, and THAT is the single biggest thing between me and achieving things.

Don't install any of these apps, and use a Shortcut (described somewhere else on this page). It's really not that hard -- I've done it. Then stick a paper-like sheet on it.

And voila, your iPad is now a better ReMarkable. The Apple Pencil is more amazing than most pens, the resolution and refresh rate on a Retina Display is unmatched.

The key to not getting tired on a tablet is responsiveness -- something no eInk device achieves. I regularly do math derivations on Freeform for hours without being distracted.

I realized after trying a bunch of expensive distraction-free devices over the years that for me, none of them were worth it.

wenc··on ReMarkable Paper Pro Move
I’m not sold on e-ink devices being a creation device. The refresh rate is too slow and the resolution is too low.

I realized there was already a device that was perfect for note taking on an infinite canvas.

I use an iPad and Apple Pencil (bought refurb on backmarket.com) with paper like surface [1] I install nothing in it except Apple Freeform. (No distractions)

High refresh rate, Retina display, excellent pen pressure, and fast chip. Cheaper than RM2 if bought refurb.

[1] https://a.co/d/dHLwPp1

← PreviousPage 3 of 34Next →