HNHacker News
TopNewBestAskShowJobs

andrewl

6,676 karma · joined September 20, 2007

submissionscomments
andrewl··on Tell HN: SQLite's lower() only lowercases ASCII letters
I don’t think you can call the developers’ reasons cop outs. The developers have made no commitment to make users happy. The only commitment they make is that the features listed on their site are in the application. They explicitly state the lower() function does not handle Unicode. You can not cop out on a commitment you have not made. And you can not cop out on a commitment somebody arbitrarily assigns you. SQLite is public domain. Ask for your money back if you’re not satisfied with the gift you received.
andrewl··on Cuis: The Modern Smalltalk-80
Alan Kay, one of the lead developers of Smalltalk, said it was also valued for being good for bootstrapping ideas for building systems. He went into that topic starting at 58:50 in this talk:

Alan Kay at OOPSLA 1997 - The computer revolution hasn’t happened yet https://www.youtube.com/watch?v=oKg1hTOQXoY&t=3530s

“To me the most distressing thing that happened to Smalltalk when it came out of Xerox PARC was for many respects and purposes it quit changing. Now I can tell you at Xerox PARC there were four major versions, completely different versions, of the language over about a ten year period. And many dozens and dozens of significant releases within those different versions. And I think one of the things we liked most about Smalltalk was not what it could do but the fact that it was such a good vehicle for bootstrapping the next set of ideas we had about how to do systems building. And that for all intents and purposes when Smalltalk went commercial ceased. Even though there was a book, the famous blue book, that Adele and Dave wrote that had the actual code in it for making Smalltalk interpreters and starting this process oneself, almost nobody took advantage of this. Almost no university took advantage of it, almost no commercial institution took advantage of it. And what they missed was, to me, the deepest thing I would like to communicate to you today, and that is we don’t know how to design systems yet. So let’s not make what we don’t know into a religion for God’s sake. What we need to do is to constantly think and think and think about what’s important. And we have to have our systems let us get to the next levels of abstraction as we come to them. And the thing that I’m most proud of about Smalltalk, pretty much the only thing from my standpoint that I’m proud of, is that it has been so good at getting rid of previous versions of itself until it came out into this world. Now one of the reasons we got involved in doing Smalltalk talk again, for me it was after 16 years of not working on programming languages, a couple of years ago we started this project we called Squeak, which is simply, not an attempt to give the world a free Smalltalk, but an attempt to give the world a bootstrapping mechanism for something much better than Smalltalk. And when you fool around with Squeak please please think of it from that stand...think of how you can obsolete the damn thing by using its own mechanisms for getting the next version of itself.”

andrewl··on Solar panels that plug into your wall
A lot of people in the U.S. are trying to innovate. I think the problem is the fossil fuel industry has been paying government, probably for decades, to implement legal roadblocks at all levels, from individual homes up to states and regions, to non-fossil fuel energy. I think they've also had a hand, at least at the propaganda level, in pushing back on electric vehicles.

Personally, I'd love to see the United States, and the rest of the world, decrease its reliance on oil. We won't get off it in any of our lifetimes, but we should move in that direction. I like diversifying. Any bit helps. Solar in Australia and Arizona. Maybe less so in northern Maine. Wind turbines where there's wind. I personally don't have any aesthetic objection to them. I think they look kind of cool. And certainly better than smokestacks. And so on.

andrewl··on The Beatles have permeated research papers across academic disciplines
I wonder how the Beatles count compares to the count of references to Alice in Wonderland, which I think are especially frequent in papers on physics and mathematics.
andrewl··on Apple caught off guard by AI demand for Mac Mini and Mac Studio
Paul Graham discusses this in his essay The Submarine: https://www.paulgraham.com/submarine.html

As you say, Apple would not be a trillion dollar company without a great product, but you can build something great and also aggressively market it. Nobody is saying they got where they are just with marketing.

andrewl··on Requests to remove DHH impression from Neovim website prompts heated argument
I just now learned of DHH’s views by reading the Github discussion. I think the quote should be removed. But I do not think that, without further information, we should condemn someone for using the quote in the first place. And that is because it’s a big world, and you can’t know everything. And I at least do not investigate someone’s political positions before I quote them. If I read that DHH said "Tests are money in the bank" I might have quoted him here or on some other site. And that’s because I didn’t stop to investigate his positions before quoting him, not because I endorse his positions.

I also am not going to dismiss the work of all the other Neovim contributors and stop using it.

andrewl··on Executable Is a SQLite Database
I like a hierarchy, too. Presumably the underlying engine could be a database but it would at least appear to the user as a tree. But with the option to find files with SQL or a SQL-like language. I would love to be able to find files based on all kinds of metadata that was available for searching with the OS’s file system, and not using any special tools. I’m thinking things like EXIF data, audio file metadata, text file line count, and so on.
andrewl··on Executable Is a SQLite Database
Yes. In this interview Michael Stonebreaker, one of the original developers of PostgreSQL, discusses (among other topics) replacing the file system with a database :

https://www.youtube.com/watch?v=YPObBOwIrHk

andrewl··on 388 years ago, Galileo worked out why human giants can't exist
J. B. S. Haldane discussed this in his essay On Being the Right Size:

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

andrewl··on Folding Paper Globes
The site doesn't give you printouts you can fold into a globe, but it is very informative. You highlight countries, drag them around, and their size adjusts to whatever degree of distortion you'd get for any land mass at the given longitude. So you can, say, highlight Greenland and drag it on top of Brazil and see how they compare. You can highlight and drag countries, US states, Canadian provinces, and Australian states. Hovering over an entity shows you area and population.
andrewl··on A shell colon does nothing. Use it anyway
I think Bash won as Bityard says above, in the sense that COBOL won, which was because it was everywhere (approximately) and then when another system was being built to do something in COBOL’s niche COBOL was the obvious choice. Once it was sufficiently established it won by inertia and absolutely not because it was the better language. Or maybe it was the better language in its time, but it certainly is not now. And note I’m only talking about COBOL’s niche, of mainframe-based processing in the banking, insurance, state and federal payroll and similar areas.
andrewl··on Vint Cerf, “father of the Internet”, is retiring
Quoting from an earlier comment in this discussion:

There's always some nincompoop who brings that up. Al Gore deserves credit for what he did as a senator and vice president. He helped to pass legislation that enabled the NSFNET backbone to grow and to permit commercial traffic to flow on the government-sponsored backbones in the US. Had he not done that, it's pretty likely that the commercial sector would not have seen an opportunity to create a commercial internet that all of us can enjoy, so he does deserve some credit for what he's done.

— Vint Cerf, Tracking the Internet into the 21st Century <https://www.youtube.com/watch?v=Hf0rjtnwC9A>

andrewl··on The vintage beauty of Soviet control rooms (2018)
To me they look oppressive and bleak. They are interesting, to be sure. But I don’t find them beautiful. And aesthetics are subjective, of course. I can well believe others find them beautiful.
andrewl··on Footage Shows Cop Stalking Woman After Surveilling Her with a LPR
The linked article does not say what happened to him, but if you Google his name there are lots of hits. This one says he was fired:

https://www.nbcmiami.com/news/local/monroe-county-deputy-arr...

andrewl··on Reducing tick density along recreational trails in Ottawa, Canada
I think it's that they need humidity or else they dry out. So hot and humid is fine. Hot and arid is what they have a problem with.
andrewl··on Reducing tick density along recreational trails in Ottawa, Canada
Can you give us some more detail on the nematodes, or point us to an article?
andrewl··on How to corrupt an SQLite database file
It’s impressive. To admit fallibility is to be honest. It represents confidence.
andrewl··on How to corrupt an SQLite database file
Your link to the security page is broken because of the capital H in your URL. It should be: https://www.sqlite.org/security.html
andrewl··on How to corrupt an SQLite database file
The January 6, 2022 date at the bottom of the page is not the date the page was last updated. It is the date problem 8.9 (Boundary value error in the secondary journals used by nested transactions) directly above it was fixed. The date at the very bottom of the screen in the middle says the page itself was last updated on 2026-04-13.
andrewl··on Where are all the UK red telephone kiosks?
“They have phones in booths now? Finally! I don’t have to lug this cell phone around.”

Hermes Conrad, Futurama Season 6, Episode 6: Lethal Inspection

andrewl··on Museum of Imaginary Musical Instruments
Then there is the tromboon, created by P.D.Q. Bach, which is a real instrument but should not be.

https://en.wikipedia.org/wiki/P._D._Q._Bach#Tromboon

andrewl··on Math Jokes in Alice in Wonderland
Martin Gardner’s The Annotated Alice explains the subtleties, mathematical and otherwise, of both Alice books in engaging detail. It explained things I never understood, and showed me things I missed (and then explained them). Besides the mathematics there are references to politicians and events of the era, and jokes that would be known only to people at Oxford.
andrewl··on 'Beauty of the Beasts' Review: The Gross and the Grimy
The subhead on the article is: Animals that feed on dead matter perform an important service. Without them, we’d live in a world of putridity and pestilence.
andrewl··on Uncle Bob: It's Over
That was a bizarre performance.
andrewl··on Neanderthals ran 'fat factories' 125k years ago (2025)
This is the first I’ve heard of straight-tusked elephants, which are almost twice the mass of modern day elephants. You’d need a lot of cooperation and coordination to kill one of them.
andrewl··on Archive of BYTE magazine, starting with issue #1 in 1975
Byte was great. For years it was the highlight of my month. And I thought the cover art was amazing. The Smalltalk hot air balloon logo came from the cover of the August 1981 issue, which was devoted entirely to Smalltalk.

Robert Tinney, who painted many of the covers, died in February:

https://news.ycombinator.com/item?id=46982354

andrewl··on Why Japan has such good railways
The population density of Italy 201/km2 is lower then population density of Germany 241/km2, so from point of view of density, Germany should have more high-speed rail than Italy.

That would be if kilometers of rail tracks scaled linearly with population density per unit area. My guess (based on no research at all) is it’s more that there’s a population density tipping point, and after reaching it rail development dramatically increases. I do also think you’re right about the influence of the German car industry.

andrewl··on Why Japan has such good railways
The population density is probably one factor. New Zealand has 5.34 million people in 103,000 square miles. At the other extreme you have Hong Kong with 7.5 million people in 430 square miles. Each mile of track gives service to a much larger percentage of the population in Hong Kong than New Zealand. The same goes for a lot of the United States. The coastal corridors in the United States are population dense, but the interior less so.
andrewl··on Why Japan has such good railways
Yes. You get a lot of bang for your buck as far as the number of people served. Hong Kong is less than half the area of Rhode Island, but the populations are 7.5 million for Hong Kong and 1.1 million for Rhode Island. Small area plus high population density is the situation where trains are most valuable.
andrewl··on A soft robot has no problem moving with no motor and no gears
The fact that a product has not yet been created from a given technology does not mean the technology or the research itself is useless, or will not turn out to be useful in the long term. You can also learn a lot from research or development that does not ultimately work out.
Page 1 of 19Next →