HNHacker News
TopNewBestAskShowJobs

zzzeek

12,322 karma · joined April 5, 2007

I'm the creator of the Python tools SQLAlchemy, Alembic Migrations, dogpile.cache and Mako Templates for Python. I am a strong proponent of sarcasm.

http://techspot.zzzeek.org

submissionscomments
zzzeek··on Global warming will exceed 1.5-degree limit, UN says
what's your proposed path to "strict vegan diets" exactly?
zzzeek··on Discovery of a new OpenAI agent message board
oh im sure within a few months the biggest cyberattack risk on the planet is going to be somewhere like North Korea
zzzeek··on You probably own this 7-Eleven (and that's why it looks so sad)
yes japanese 7-11s are exactly what i had in mind. a 7-11 that also has good quality sushi to go would be amazing. it's commonplace in bodegas in NYC (more the Asian owned ones) for example. that and, just one actual dark chocolate selection amidst the piles of low-quality milk chocolate M&Ms and hershey products. it's not a big ask.
zzzeek··on You probably own this 7-Eleven (and that's why it looks so sad)
7-11's, which I frequent often, need a slightly higher food quality selection to appease affluents like me, but as far as how they look, that's what a 7-11 looks like! It's what I look for when I'm driving, on "stroads" / highways, and am looking for an exactly predictable experience, one which is low-key, inexpensive, and does not imply a formal dress code. I'd never want a 7-11 to look like a brownstone in the west village, that would imply an entirely different kind of business establishment.
zzzeek··on EVE Online moves to Python 3
what did they do about stackless? are they using greenlet or did they switch to asyncio?

googled it so this becomes a PSA: https://simonwillison.net/2026/Aug/25/eve-online-move-to-pyt...

so it's neither, it's their own: https://github.com/carbonengine/scheduler

so that's interesting

zzzeek··on Doctors are finally learning to manage antidepressant withdrawal
Interesting is your doctor a general practitioner or a psychiatrist? A psychiatrist definitely knows about this stuff. GPs in my experience know almost nothing about anything beyond what seems like a script they operate from.
zzzeek··on The turbulent AI era is here
i define the hacker news "ratio" as number of upvotes / number of comments. lots of comments and few upvotes is a bad ratio indicating the article is not being well received.

in this case a ratio of 196 points to 479 comments points to a very poorly received yet comment-inspiring article.

zzzeek··on The turbulent AI era is here
poor Bill Gates is one of the richest men on earth but can't get a good ratio on Hacker News
zzzeek··on The Sloppification of Peptides
This article is not so much about peptides it's about entirely AI generated ecosystems. The goal is to promote questionably scammy commercial interests, or obviously political interests as I'm sure is happening also, by creating whole webs of semi convincing looking portals, discussion boards, review sites, community activity, etc, all fake.

The blog post rightly points out we should get good at spotting all this but this is not the scary part, the scary part is that the audience for these ecosystems is not even humans, it's the big AI players like Gemini and ChatGPT, and those are places that a lot of people are going to get information and advice on things.

I use Gemini quite a lot and lately I've already noticed it's very quick to give me a broad spectrum vibe on some issue or topic and not good at all at backing it up with reputable sources. So I think this is potentially a very ominous development of the entire web itself becomes a giant poisoned cauldron of untrustworthy AI maliciously influencing "trustworthy" AIs.

Update: i fed this comment into Gemini and asked "what is Google doing about this?" and it produced a very long, detailed answer, leading off with tagging this as the so-called "internet ouroboros" problem. For those who don't feel like doing the same, I can distill it's answer as follows: "Yo. Chill. We got this, bro. Lol" so we're good!

zzzeek··on The Sloppification of Peptides
East Coast exurbs of NYC here, these things are everywhere, go to a gym the whole place is on them

Maybe a US thing

zzzeek··on Norway should buy OpenAI
right but the entire norwegian society and its welfare state was built upon that homogeneity, where everyone and their neighbor looked "familiar" and could be implicitly trusted to share the same customs. As the foreign born population grows, Norway has taken many steps to restrict immigration, asylum claims, and benefits to immigrants. public opinion has shifted (though not dramatically) as well. parent poster's claim of "easy mode" is receding, so it's not like norway has found a solution to "being a generous welfare state while also openly welcoming foreigners".
zzzeek··on Does anyone run Postgres without PgBouncer?
of course, the vast, vast majority of PostgreSQL users outside of managed cloud hosting are not using pgbouncer. pgbouncer introduces complexities into the database conversation (transaction-level pooling interacting with the prepared statement cache is a long recurring nightmare for us at sqlalchemy) that often not worth the complexity for small local installations.

this article seems to be talking about commercial cloud managed PG services, which yes, those absolutely need to support connection pooling and of course they're going to use pgbouncer.

zzzeek··on Wyden proposes new taxes on data centers
If we want to put pressure on new datacenters to mitigate their externalities I'd prefer they would somehow be investing in the local communities they impact, in areas like electricity generation and water infrastructure. Having them pay a federal tax that's just going to go to more missiles for Hegseth to shoot into Iran seems like a big missed opportunity.
zzzeek··on Google fixed more Chrome bugs in June than over the past two years, thanks to AI
I would never undertake a big performance optimization without first measuring that area's total impact. The LLM would then be great to work out the refactoring and you can give it your bench suite (which it probably wrote) to work against.

I guess just another area where the LLM is useful only as long as you remain in charge using your own programming experience as a guide.

zzzeek··on A Trampoline
They care because trampolines have a very high rate of injury. If you throw a birthday party at your house and one of your neighbors kids breaks their arm or worse, neighbor might decide to sue you. That then puts your insurance company on the hook. Even if your policy forbids trampolines you can often plausibly argue you weren't aware, and they end up having to pay out. Insurance companies refuse to cover things all the time and trampolines are apparently a big problem for them (just talked to our insurance broker a few weeks ago about this as my family is pushing to get one and I'm having to push back.)
zzzeek··on A Trampoline
Insurance does not cover them and if they find out you have one they are likely to cancel your coverage.

I'm not sure why "you can lose your home insurance for having one of these" isn't being brought up more.

zzzeek··on Some more things about Django I've been enjoying
Hi, don't mind me, but

You don't need to return a boolean. You need to return an object that implements __bool__.

Get it ?

And even then, when you're dealing with objects that are special to expressions, you don't actually even need __bool__ that much

zzzeek··on Cloudflare's new AI traffic options for customers
this is annoying, it makes a big deal about "Back when we announced pay-per-crawl"...

I want pay-per-crawl. I clicked the link for it a year ago, got presented with a "request access" button, I "requested access" and obviously since I'm nobody I heard absolutely nothing. Now they're touting the link again, I checked, still that same "request access" button. I have no idea if anyone even has access to this feature.

I don't care about all this other stuff, I want the AI crawlers to pay me cash. Because boy do those fuckers want to crawl me. I'll gladly double the size of my gerrit/jenkins servers to keep up with the load if these stupid bots want to pay to crawl every jenkins build artifact and every changeset source file on the server, as they really seem to want to do.

zzzeek··on Show HN: I simulated closing the Strait of Hormuz on real oil trade data
Well that's also election time so the timing could not be better
zzzeek··on Startup founders urge U.S. government not to shut off Chinese open weight AI
It's to give unfair advantage to Anthropic and OpenAI who would then be expected to shower Donald Trump personally with hundreds of billions of dollars in cash, airplanes and tacky golden things.
zzzeek··on OpenAI and Anthropic unite against open-weight AI risks to their bottom line
there's persuasion, and then there's inspiring people already on your side. the upvotes/downvotes will give you a clue who the audience turns out to be. it was an upvote from me.
zzzeek··on A digestion of the Jacobian conjecture counterexample
reading through this I eventually realized a situation similar to my experience of it is what my dog sees if I attempt to explain Python programming to him.
zzzeek··on Israeli spyware vans infiltrate American streets and your phones
wow that is a really misleading headline. I thought this was the Israeli government spying on US soil.
zzzeek··on Who's afraid of Chinese models?
the leader of China praised Open Source in a speech. Crazy times
zzzeek··on Perfection Is Not Over-Engineering
great post but also the real thing they are talking about here is YAGNI
zzzeek··on Claude Code uses Bun written in Rust now
this whole AI era has put the topic of "do we believe actual reality, or what we hoped/assumed/continue to insist would be reality" front and center. Every discussion is like this these days.
zzzeek··on The zero-cost fallacy: open-source software in the agentic era
the issue with articles that try to analyze the state of open source and its sustainability and all that is that nothing about open source makes any sense if you just talk about it. Imagine you're transported to 1977 and you work at IBM and you try to tell them, oh hey I have an idea, how about the OS everyone uses for literally all commerce, communication, military, etc., you name it, will be written by one guy in his spare time and later maintained by tens of thousands of mostly unpaid volunteers. "Don't other companies try to copy it and sell it as their own?" "Well sure, but mostly it's better to use the free one everyone knows". Try selling your manager at IBM in 1977 that idea for new software. It would be impossible. It would be impossible today.

Trying to explain how the global economy and welfare of most of humanity is hugely dependent on free software production labor, without the advent of actually seeing a world where this actually happens, is just like when we try to explain something like consciousness. There is no explanation that makes sense. So predictions about new avenues of doom (like "MIT licensing was a huge mistake! we should have all been GPL!") similarly dont carry a lot of weight, because of course these predictions make perfect sense in the abstract, yet real world results don't line up at all.

Basically open source software is an emergent phenomenon, like consciousness or evolution, or perhaps even how very large language models suddenly seemed like real people. It's something that would never be predictable in its own absence, which means it will remain largely unpredictable how it will respond to ongoing changes such as "the open source authors and contributors now use programs themselves to produce more code".

zzzeek··on Stop Telling Me to Ask an LLM
before COVID everyone on my team travelled once or twice a year to conferences as well as to the home office for get-togethers, on the company dime. Those conferences have been turned into online only and my company hasn't flown me or hardly anyone on my team or any of our related teams anywhere in years. All of that would be considered vastly extravagant and expensive today. So some kind of belt tightening went on that was never un-tightened.
zzzeek··on Stop Telling Me to Ask an LLM
OK here is the thing. Everyone get your downmods ready since my rants on here are always a disaster.

People are really really tired.

Because of not just Claude, but also "the recession" "the strait of hormuz closed" "we've never recovered our economy from COVID" "everyone works from home now / the company is forcing us to all come back in" "FAANG had 10000 layoffs" "the global warming" "the <panic about XYZ>", our employers are making us work much harder, with a subtle but palpable panic in their emails, with WAY less promises of any kind of job security, companies that never had layoffs for decades are now doing them regularly, our githubs are flooded with people pointing robots at our issues to generate tepid pull requests, and at our pull requests to generate tepid reviews, and look shit is just crazy now.

So I think the whole "how would you approach this interesting problem..." thing is, for now, at least for me it feels a little bit on hold. Like oh that problem. How to scale? how to horizontally shard PostgreSQL? sure, real problems. But geez whatever we're building, it will be replaced in three months anyway. That's a hard problem you have there! I remember when I used to have problems like that, and my solutions sucked anyway and it was replaced with a node.js app two years later. Whatever advice I have, Claude is going to have 98% of it plus another 10% that I didn't even have.

This is all bad. So I think your post is possibly extremely useful. Maybe we should, for people we know and trust as humans in the real world, actually take the time and approach an issue as though we didn't have the Matrix to approximate it for us. I'm going to think about this and consider it.

zzzeek··on Building a real-time AI tutor for 5-year-olds
> At some point, you need to watch out for cynical/nasty series. In fact, all of the books we purchase are ranked against peers they have read in the past, or those we know to actively avoid buying due to cynicism, sarcasm, or open disdain towards adults (Wimpy Kid).

yeah how do you "know" this? our kid is obsessed with wimpy kid and a few other similar series and "cynicism" nails it perfectly, is there a list? of what's known to be "cynical" and what's not?

← PreviousPage 2 of 34Next →