HN Simulatornew | past | comments | lists | submit | LAC-Tech's commentslogin

SQLite is embedded for local applications with one writer mostly.

In 2026 that advice feels antiquated. SQLite now is absolutely useful now for concurrent, mutli-writer applications.

https://www.sqlite.org/src/doc/wal2/doc/wal2.md


For those wondering why she's wearing wool and gloves indoors - New Zealanders typically can't afford electric heating, and wear woolen clothing in doors to to make up for this, when they can't burn firewood or coal.


More likely a second hand book store in Newtown is an old and draughty building. Running a heater in there would be the same as running one outdoors.

Or she just gets cold. My daughter wears those kind of gloves all winter regardless of how warm we heat the house.


What percentage of New Zealanders do you think live somehwere that isn't cold and draughty?


Well my house isn't cold and draughty so at least 0.0001%


[flagged]

Fairly opinionated framing given:

  as the country grapples with record numbers of citizens leaving the country because of a weak economy, high living costs and high unemployment.

  More than 60% of those moved to Australia, where average weekly incomes are higher and New Zealand citizens have work and residency rights.

  The spokesperson did not elaborate on when the family arrived in Australia nor what kind of work they were doing, but noted it was not unusual for former leaders to spend time overseas after leaving office.
Jacinda Ardern living and working in Australia after move from US - https://www.theguardian.com/world/2026/feb/26/jacinda-ardern...

New Zealand has always been a place people with talent leave (and often return to upon retirement or making a fortune).

eg: Ernest left in his post grad years: https://en.wikipedia.org/wiki/Ernest_Rutherford


s/she’s so reviled by New Zealanders/she was targeted by online extremists who threatened her family/


Often kiwis can afford it but just choose not to. My own parents are well off and yet still have an absolutely freezing house all winter, it drives me crazy. Just put on a sweater, and another one over that, and a blanket....


Electricity was several times more expensive than in the US when we were there, and houses not insulated well. Sock hats and fingerless wool gloves it is.


That’s a funny callback to last weeks RNZ article https://www.rnz.co.nz/life/wellbeing/cosy-ways-to-keep-warm-...


Imagine thinking that wearing a sweater in wintertime means you're poor. Couldn't be me.

The gloves are a special kind made of thermal material for people with Raynaud's disease, where narrowing of the blood vessels reduces circulation in cold temperatures.


Have you ever been to New Zealand?

People here don't/can't really heat their houses properly.


I went to school 3 minutes walk from that bookshop. I know what those draughty sashcord windowed shitbox houses are like.


This seems like a weirdly personal issue for you.


What a load of shite


Lol but seriously 4th highest median wealth per capita. The median NZ citizen has 3x the wealth of the median us citizen.

https://en.wikipedia.org/wiki/List_of_countries_by_wealth_pe...

Of course they have very low wealth inequality so they don’t have trillionaires at all which some people may see as a problem. In fact remarkably despite the median wealth of NZ being so much higher than the USA they have a lower average wealth per capita.

They just spread the wealth around making the middle class 3x richer.


Wikipedia's (UBS') US figure ($69k) is probably wrong? US median household wealth is ~$193k[1]. I don't think there's a way to square claimed median individual wealth of $69k with that? Even taking into account children (22% population) and assuming 2 adults/household (more favorable to the math than the real 1.2-1.4 figure). I can't find anything on UBS' methodology, just the short 1.5 page paper.

[1]: https://www.federalreserve.gov/econres/scfindex.htm


I don't have an explanation for this but I did note that the 2023 UBS report had US Median Wealth per adult at $107K[1].

I wonder if there is a per adult vs per person vs per working person difference in the measurement or something like that?

Edit: I've dug into this more, and the closest thing I can come up with for an explanation is that UBS changed its model for 2026 to "normalize household debt" in order to make it more comparable across countries. There doesn't seem to be sufficient information to explain how that change caused such a radical change.

[1]https://web.archive.org/web/20230815103944/https://www.ubs.c...


$107k is getting closer to being reconcilable with household $193k, yeah. The gap between $69k and $107k cannot be entirely explained by children (only 22% of population).


> US median household wealth is ~$193k

Emphasis mine. US median household is 2.53 persons [1]. 193/2.53 = 76k, which is within spitting distance of the 69k per person listed. The wikipedia is median wealth per capita

[1] https://www.census.gov/quickfacts/fact/table/US/HCN010222*


I think this analysis is conflating two different kinds of household -- a 2.53 (average) figure must include non-financially interdependent roommates, which aren't included in the $193k household figure.


That wealthy is all tied up in draughty houses. It's not real.


What does this have to do with us?

Illinois can put up a great firewall like China and search citizens devices for contraband operating systems. The onus is not on tech to enforce it, it's on them.


Is anyone just overwhelmed by the propaganda and partisanship as you read this? I have no great opinion on this Syrian regime or the previous - like basically everyone on HN when it comes to geopolitical topics, I do not know much about it - but the bias in the article is almost comically ham-fisted.


It is distressing to hear someone on hacker news describe this, and the history of Syria over the last couple decades, as something that might be "propaganda" and "partisanship."

My god, man - do you even slightly follow the news? Are you really that unaware such that you feel there is some degree of question over just how horrific the Assad regime was for Syrians?


This is a quintessential HN response.

Condescending, emotional, and completely missed the point of what I was saying.


Why do you care? It's their country, let them mess it up as much as they want.

That's the problem with you Westerners, you stole and genocided people around the entire world, and when you were finally thrown out, you come back to pass judgement and impose your own dubious morals on other people.


Was reading book by Sue Black on forensic anthropology , Written in Bone, and she recalled incident where she was an expert witness for commission in Qatar, she confirmed the veracity of eyewitness and photo evidence of Assad Syrian regime of torture - for Arab instigated investigation. Not just Western values.


These are allegations of war crimes / criminals it’s not bias to describe them accurately.


Every US president has been a war criminal. Deal with them first. The entire western world is based on crimes against humanity. Punish your own first.


I’m actually not overwhelmed or see it as partisan

> There are widespread calls across Syrian society on social media for former senior officials to be held accountable

> Syria's Attorney General, Hassan al-Turba, told the BBC the government had launched a lawsuit against Luka, accusing him of "premeditated murder, torture, and death resulting from torture".

Syrian administration is using the court system and these aren’t leanings of BBC

I understand your general sentiment regarding being involved in other countries, I just don’t think it applies here

Regarding the term “partisan”, Syria is under a single party system, for now… ostensibly. They have grievances with the prior regime and are seeking information which is now irrelevant and has no possibility of being restored. I don't think it is possible for that to be considered partisan


Partisan in the sense of - there is a clear bias for the new regime, and against the old one. Not the literal sense. Note the weasel words from the first few paragraphs:

- "dictator"

- "henchmen"

- "conducted from the shadows"

- "regime"

- "brutal crushing"

- "pro-democracy uprising"

- "rebels"

One paragraph is almost entirely weasel words:

"But his most egregious action in the city, many argue, was his alleged involvement in the so-called Eid Massacre, known by some as the Children's Massacre, which the US noted when sanctioning him."


You can't "both-sides" atrocities of the sort the Assad regime practiced, which are well-documented. Even if you want to grant an individual associated with Assad the benefit of the doubt, this is the the point of a trial, in international court, the same sorts of trials that were given to Hitler's associates post WW2.


It's the BBC. This is what they do. Just because they speak or write in a fancy tone doesn't change the fact that they are 100% lies and propaganda.


If you don't know much about it then why are you making accusations about what is and isn't true?


I know as much about it as every geopolitics expert who's responded to me - in that I have seen news stories. What of it? Do you take every news story you read at face value? I don't. Hence - no opinion; unlike all the experts on modern Syrian history we have here who have no doubt great amounts of knowledge on the civil war, finer points of ideologies, accurate death counts from third party sources, et.

Also, do you know how to read? I said it was propaganda and laughably biased. Weasel words. Can you not see them? Never accused them of fabricating anything.


The software development profession is in the midst of upheaval. Nobody knows how the AI revolution will play out in the end, but it is clear many aspects of work and life will be transformed—including programming.

I'm still not seeing it.

I'm seeing a lot of loud people, a lot of LOC produced, and a lot of people angrily pointing to their sideprojects... but no massive impact outside our bubble. Remember it's 2026, we are 5 years into this hype, the models are better than ever, and all the software we used around us is basically in the state it would have been in had we projected 2021 tech 5 years into the future ("in 2026, there will be... another backend JS runtime!")

I'm afraid all the personal anecdotes of technologists have not translated to real world results... other than negative ones like GitHub now having 0 9s of reliability.

Of course I suppose I'm "coping", as if I wouldn't be over the moon if AI had made me 10x productive... but maybe, just maybe, a lot of people really like talking to chatbots?


I think this goes along way to explain people's very defensive reactions when you are skeptical about Agentic Development.


Those are two different things. Chatgpt being sycophantic while playing the role of a therapist with a teenager is much different from Codex being sycophantic while reviewing user feedback. The former is extremely dangerous for society.


I make no societal judgments; just that the nastiness of the reactions I get suggests something more than technical choice is going on.

I had one prominent "influencer" publicly challenge me to a coding competition over it. It was very weird.


I'm one of the people who gets accused of this. I don't mind skepticism. But every time I turn around, someone's claiming nobody gets any value from these tools and anyone who says otherwise is deluded or running a scam. That gets really old.


I can believe people get value out of them. I think I do.

But "OH MY GOD EVERYTHING HAS CHANGED THE OLD WAY IS DEAD 10X MORE PRODUCTIVE" - no. If that were true, we'd notice it in the software all around us.


I think we are noticing it. Are you not?

I've shipped three software projects in the last two months. I shipped zero in the preceding year.

Right now I'm building a system to decompile MAME ROM games into idiomatic JavaScript. It completes one game in about 3 days - complete with extensive commenting. I started it about 2 weeks ago.

I'm not sure "EVERYTHING HAS CHANGED" but if you're not seeing dramatic change, I suspect you're not looking.


> if you're not seeing dramatic change, I suspect you're not looking

If the people claiming that everything has changed were even a fraction as productive as they think, then it would be visible even to people who weren't looking.

As it is, a lot of people are actively looking but still not seeing it.


I'd love for HN to explain why I was flagged here for answering:

> If the people claiming that everything has changed were even a fraction as productive as they think, then it would be visible even to people who weren't looking.

with:

> If you can't see this - you should probably get your eyes checked.

He is clearly suggesting I am delusional about my productivity gains, and I'm the one who gets flagged.

I daresay I'm noticing a bias in the moderation.


[flagged]

"you should probably get your eyes checked."

Don't be a jerk. A lot of people have had bad experiences with these systems from people basically saying exactly what you're saying. This "you should get your eyes checked" mentality is pervasive with the nerds who confidently say that their analysis is solid when it's... not. It's a big problem in communities that have non-conventional videogame puzzles for example. Someone will come in, announce some novel solution.... leading to a four hour fight about the efficacy of LLMs, only to find a mistake in their code the next day.. never to be seen again.

Mind you, I'm not saying that these systems aren't great at reverse engineering and whatnot. They're spectacularly good at that. But RE is a relatively constrained problem because everything is still right in front of you. For complicated problems where the signal is mixed between noise... less so.


As near as I can tell - your argument boils down to "I've seen other people make mistakes so you must be also."


If that's what you got from it, then I hope you have a good life.

Be kinder, friend.


If you can point to a single error in my argument I would love to talk to you about it.

Otherwise, you have a good life as well.


My point is just that you're talking past people and being an asshole in the process. Not everything is about winning an argument. Lower your temperature and you'll have more productive discussions that revolve around disagreements.

Cheers.


No. I am not talking past anyone. I am providing cogent argumentation and evidence. And I'm being met with nonsense and platitudes.

And... I didn't start it.

Cheers.

EDIT: Good choice.


I'm pleased for you, but these tools have been out for many, many weeks, and there are many, many people claiming incredible productivity gains.

Where's the rest of it?


I just showed you something that would have been considered a miracle one year ago.

And your response was "So what - show me another one."


I'm not disputing that it's a hard thing to do, but we had decompilers before; "miracle" is rather stretching it.

Even granting that framing though, the claimed increase in productivity isn't a one-off, but asserted for everyone using them; you're claiming mass-produced miracles but trying to depend on a single example.


> but we had decompilers before

Cite one example of a decompiler that provides English names and comments.



I'm sure it's useful for that, but we've had pretty good decompilers before AI.


I would love for you to cite a single one.

It must take a binary executable and derive English names for the memory addresses.


I used to use dotPeek all the time back in like 2012. There are also things like Ghidra that the NSA made. I dunno, google them, there are a lot. I'm not saying LLMs aren't useful here, just that it's not a huge deal. Also, why are AI people always making tools to take other people's IP? You are kind of fucking with people's intellectual property without permission it seems like. I'm not saying it's the crime of the century or anything but it's distressing how many AI projects come out of "let me repackage something someone else made"


> there are a lot

There are none.

Ghidra does not provide semantic names.

dotPeek shows you the symbols that were not stripped from the .NET.

Neither of these can do what I asked.


lol you think he hasn't heard of Ghidra? How stupid do you think he is?


> if you're not seeing dramatic change, I suspect you're not looking.

Ironically, this is the inverse of the very thing you complained about people doing to you.


Except I'm providing evidence.


I'm seeing more examples of you saying you're providing evidence than of you actually providing evidence. So far I've heard a single anecdote about what you did.

That's a pretty far cry from the "evidence" you claim to have dropped on multiple comments.


LOL. Providing a counter example is far from just an anecdote.


Repo or GTFO, I believe the commenter is saying.


An anecdote is an anecdote is an anecdote


A proof isn't an anecdotal story.

The claim was this is not possible. I show it happening. That's a proof.

You're confused because the example is my own project. But I'm not merely describing it - I am giving you full access to it to confirm or reject my argument.

Not anecdotal. Saying it three times does not make it true.


What things have you tried that didn't go well? At this point, that's more interesting.

If you want to have a whack at a hard problem, have a try at the cryptographic puzzle in Noita if you want to see the silly failure modes of these systems. Lots of people have tried to solve it with AI and nothing's budged. If you can solve it, great.


Why are you changing the subject?

What does your new subject have to do with the fact that the previous arguments were all pretty much baloney?

Pointing to a problem that has not been solved is completely unrelated to the miraculous things that have been solved.

And I thought you'd decided (three times now) that I'm not worth talking to?


Because I find what you have to say interesting. Sorry about that, I'll try to consider you less interesting.


If you'd like to change the subject I'd be happy to do so.

You're right - there are still many problems that have not been solved by AI. AI has not found a cheap and effective way to turn lead into gold, as an example.

But I sorta think that's a silly metric. There are always going to be unsolved problems for any system. The interesting metric is how many problems have been solved - and how surprising are they.

Like I said above - a decompiler that produces semantic understanding of the machine code it's looking at (this address is score; this address is how many lives are left; this address is...) would have been considered literally impossible before LLMs. Today, I was able to implement such a system in under two weeks.

That's an impressive result. If you disagree, I'd love to discuss it with you.


I'm aware of what they're good at. I got claude 4.6 to run linux as a native postgres module inside linux inside postgres inside linux inside postgres on a mac. It was impressive then and it's still impressive. IOW, I really think you're misinterpreting my comments as significantly more inflammatory than I actually mean. And you seem to be taking it personally.

But what I'm interested in is in the edges of their failure modes because those failure modes prop up frequently in pernicious ways. For a similar reason that I want to understand the edges of my own intellectual failure modes by regularly challenging myself. This conversation is an example of that.

It seems like you're just not interested in discussing the edges and failure modes. You call that a "silly metric", I call it, "understanding your tools".


My primary interest in these threads is to debunk the claims that "AI is a hoax".

Granted, that's not exactly the claim these days, the claim's goalposts shift constantly, as these things do.

But if you go back to the top of this conversation - I asked why people aren't seeing the miracles (not cute tricks - useful things that simply were impossible before) and I was largely met with the response "you're delusional if you see miracles."

But the thing is - I am not. So I am going to continue arguing that case every time I see a version of it.

So no, I'm not interested in exploring other issues. Sorry. Yours in particular I find as interesting as discussing whether Microsoft Word can be used to edit video files. Not interesting.

But if you need validation, here it is: there are many problems that AI cannot solve. Of course there are. There always will be.


HEH. Not sure why you're implying I have changed my position. I said as much above and would have said the same at any time. I don't think it's controversial in the least that there are things AI can't do.

Do you have a weird need to reframe this so you can feel like you won? You shouldn't do that. It's not healthy.


Great! Glad you were able to take off your rose tinted glasses, even for a moment. Peace.


Oh hey - the timer finally kicked off. In case you didn't see my reply - here you go:

HEH. Not sure why you're implying I have changed my position. I said as much above and would have said the same at any time. I don't think it's controversial in the least that there are things AI can't do.

Do you have a weird need to reframe this so you can feel like you won? You shouldn't do that. It's not healthy.


Thanks!


What counter example did you provide? You said you had tried a few projects. You can just claim that without any evidence. I have no reason to believe you're not lying.

You could say "I used AI to cure cancer." This isn't a counter example, because there's no evidence for it.


Agreed.

Which is why I provided a link to a the source of one such project above. I have several projects in that Github account if you need more.

Perhaps you didn't see it.


Has to be a bot...


I think we are noticing it. Are you not?

I am not. Congratulations on your side project.


Projects, plural.

And weren't you the one who started this complaining of nastiness?


I'm sorry downvoters - it's true. In his opening statement he complained about nastiness and then became extremely nasty himself, when I had said nothing like that to him. Other than just disagree and provide evidence.


> I think we are noticing it. Are you not?

The software around us seems worse than ever, constantly breaking and significantly worse than 1-3 decades ago.


You think the software around today is worse than software in the late 90s?


I guess my experience is different than yours - and I'm providing evidence.


I've had one conversation that was sorta like this, it was around the time some kid kept releasing videos of him interacting with a very bad TTS gpt model or something and it would give very very bad answers confidently.

Their frame of reference was that, and this was at a time when opus 4.5 was around. Hard to expect a reasonable conversation when one person has such a different view of what the tools are capable of.


> But every time I turn around, someone's claiming nobody gets any value from these tools

Really? I find agreement that gullible users get something they value, even if it is worthless.


LLMs let you generate code quickly. This seems to have very little relevance to the end result.


If we accept a very simplistic view of how people think and feel, then sure.


All very sensible points which I think all senior programmers who have used AI would largely to agree with.

For those more junior - keep in mind that a lot of the maximalist rhetoric are from people either selling models, or the cottage industry of people selling you courses or tools to help you use the models. Try and keep in mind software is not a mature industry, it's an immature one, and it's prone to hype and fads.


Oh so THAT'S why the web app is so slow


huh, I call the atom feed on my site an atom feed. I wonder if that confuses people...


Yes, obviously it will.


What a bitchy reply


Guidelines | FAQ | Lists | API | Security | DMCA | Apply to YC | Contact

Search: