Hacker News: nickpeterson

New comment by nickpeterson in "The perils of UUID primary keys in SQLite"

nickpeterson — Sat, 06 Jun 2026 04:49:22 +0000

They just mean you catch incorrect joins more easily because there is usually no overlap in keys between unrelated tables. Using int, you’re usually going to have some shared values between two unrelated tables.

New comment by nickpeterson in "SQLite is all you need for durable workflows"

nickpeterson — Sat, 30 May 2026 12:54:05 +0000

A lot of oltp databases have modeling conventions for making read only reporting tables. Do tabular dbs have an inverse for transaction heavy data, that later gets batched to a read optimized structure? I kind of think most databases (even oltp workloads) really are read dominated. I feel like DuckDB is really close to working as the ‘main db’ for such systems, but my lack of knowledge for how to handle quick mutations bothers me. It feels like some form of temporal data modeling would solve it but I don’t know.

New comment by nickpeterson in "Scientists “bottle the sun” with a liquid battery that stores solar energy"

nickpeterson — Sun, 17 May 2026 20:01:40 +0000

I think I saw an apple A16 takes about 8 watts, which would be about a square foot of solar panel. So assuming we keep making progress it doesn’t seem insane to me that a laptop where the back of the lcd is a solar panel would be enough?

New comment by nickpeterson in "New statue in London, attributed to Banksy, of a suited man, blinded by a flag"

nickpeterson — Mon, 04 May 2026 16:26:16 +0000

I always knew returning void was a bad idea

New comment by nickpeterson in "Dad brains: How fatherhood rewires the male mind"

nickpeterson — Sun, 19 Apr 2026 05:42:39 +0000

Structure in this context is probably ‘routine’, though how that plays into a male vs female role is anyone’s guess.

New comment by nickpeterson in "I ported Mac OS X to the Nintendo Wii"

nickpeterson — Wed, 08 Apr 2026 17:53:11 +0000

The one that really bugs me is the Apple TV. It would be a great little box to use for terminals/thin client style work and there are a ton of old cheap ones. Having a $50 dollar used box that was low power and could run OSX would be great.

New comment by nickpeterson in "US and Iran agree to provisional ceasefire"

nickpeterson — Wed, 08 Apr 2026 00:39:19 +0000

If the USA walks away and lets every other country pay a new fee to Iran… That would be interesting…

New comment by nickpeterson in "Dataframe 1.0.0.0"

nickpeterson — Mon, 23 Mar 2026 18:08:26 +0000

risky, it feels like there is a chance you'll still need an extra .0 to cover something unexpected.

New comment by nickpeterson in "AirPods Max 2"

nickpeterson — Mon, 16 Mar 2026 22:54:49 +0000

The weight is sign of reliability

-Boris the bullet dodger

New comment by nickpeterson in "Pentagon Gives Anthropic an Ultimatum"

nickpeterson — Wed, 25 Feb 2026 01:23:46 +0000

I guess I better send the pentagon a right to be forgotten request.

New comment by nickpeterson in "Descent, ported to the web"

nickpeterson — Sat, 14 Feb 2026 23:20:37 +0000

Whoa, I just remembered playing forsaken multiplayer at sleepover when I was a kid. Thanks for reminding me!

New comment by nickpeterson in "Oxide raises $200M Series C"

nickpeterson — Wed, 11 Feb 2026 00:11:04 +0000

I’m sure it wouldn’t be profitable for them, but I feel like having some vendor sell a ‘reference machine’ that they know could run the core OS well would be a good in between. Someone like Framework selling a workstation looking desktop in a specific reference config couldn’t be too bad. Feels like just enough to get a community started. Most tasks really don’t need bleeding edge hardware anymore, the thing could go years without hardware changes.

New comment by nickpeterson in "Show HN: Comet MCP – Give Claude Code a browser that can click"

nickpeterson — Wed, 07 Jan 2026 14:43:16 +0000

Anyone know of any good articles around having claude code build playwright test suites for a given website and parameters?

New comment by nickpeterson in "Synadia response to Jepsen test of NATS 2.12.1"

nickpeterson — Mon, 05 Jan 2026 18:49:12 +0000

It's good to see their response. I feel like between the issues with CNCF being talked about on the Oxide and friends podcast, and this recent Jepson report, nats tends to get a decent amount of negative coverage.

Which is a shame, since I do think it's a great tool.

New comment by nickpeterson in "Sega Channel: VGHF Recovers over 100 Sega Channel ROMs (and More)"

nickpeterson — Wed, 17 Dec 2025 04:31:04 +0000

I’m pretty sure it was people playing sega channel games.

New comment by nickpeterson in "Sega Channel: VGHF Recovers over 100 Sega Channel ROMs (and More)"

nickpeterson — Tue, 16 Dec 2025 17:35:49 +0000

And now blockbuster is out of business, thanks a lot empressplay.

New comment by nickpeterson in "Jepsen: NATS 2.12.1"

nickpeterson — Mon, 15 Dec 2025 13:31:15 +0000

He Vanished!? Find him you fools!

New comment by nickpeterson in "GNU recutils: Plain text database"

nickpeterson — Sun, 14 Dec 2025 23:17:22 +0000

It’s turtles all the way down.

New comment by nickpeterson in "Elevated errors across many models"

nickpeterson — Sun, 14 Dec 2025 23:07:14 +0000

The one time you desperately need to ask Claude and it isn’t working…

New comment by nickpeterson in "Apple has locked my Apple ID, and I have no recourse. A plea for help"

nickpeterson — Sat, 13 Dec 2025 19:00:31 +0000

That’s part of where the margins come from.