Hacker News: pjothttps://news.ycombinator.com/user?id=pjotHacker News RSShttps://hnrss.org/hnrss v2.1.1Mon, 25 May 2026 00:45:22 +0000<![CDATA[New comment by pjot in "Ebola Outbreak Now Third Largest Recorded and "Spreading Rapidly""]]>

  > The Chinese are a decade ahead of the west when it comes to building cars.
Is this true? From years of watching Top Gear any Chinese car that was tested was laughably bad.

]]>Sat, 23 May 2026 17:47:26 +0000https://news.ycombinator.com/item?id=48249601pjothttps://news.ycombinator.com/item?id=48249601https://news.ycombinator.com/item?id=48249601<![CDATA[New comment by pjot in "NanoTDB – Golang Append-Only Time Series DB"]]>DuckDB has indexes. One specifically for highly selective point lookups. The structure is called an adaptive radix tree. The workloads you’re describing are sort of duckdb’s bread and butter (even the parquet stuff it’ll handle out of the box)

https://duckdb.org/2022/07/27/art-storage

]]>Sat, 16 May 2026 00:49:13 +0000https://news.ycombinator.com/item?id=48155754pjothttps://news.ycombinator.com/item?id=48155754https://news.ycombinator.com/item?id=48155754<![CDATA[New comment by pjot in "Pretty Fish: A better mermaid diagram editor"]]>To be fair, pie charts are horrible in general.

]]>Wed, 15 Apr 2026 15:20:08 +0000https://news.ycombinator.com/item?id=47780362pjothttps://news.ycombinator.com/item?id=47780362https://news.ycombinator.com/item?id=47780362<![CDATA[New comment by pjot in "Show HN: Hacker News archive (47M+ items, 11.6GB) as Parquet, updated every 5m"]]>Re-reading your comment :) Yes, my demo has just a simple loop when loading the embeddings.

I was replying more towards the latency you mentioned. Because duckdb runs on device, you save yourself the additional round trip network time when comparing similarities.

]]>Thu, 19 Mar 2026 02:56:34 +0000https://news.ycombinator.com/item?id=47434336pjothttps://news.ycombinator.com/item?id=47434336https://news.ycombinator.com/item?id=47434336<![CDATA[New comment by pjot in "Show HN: Hacker News archive (47M+ items, 11.6GB) as Parquet, updated every 5m"]]>I did this but used duckdb as the vector store. Works really well, quite fast too.

https://github.com/patricktrainer/duckdb-embedding-search

]]>Thu, 19 Mar 2026 01:51:24 +0000https://news.ycombinator.com/item?id=47433791pjothttps://news.ycombinator.com/item?id=47433791https://news.ycombinator.com/item?id=47433791<![CDATA[New comment by pjot in "Using an engineering notebook"]]>For me, it helps to slow down my thoughts and aides deep work. I draw diagrams, connect blurbs with arrows, and “link” to other page numbers.

]]>Thu, 12 Feb 2026 04:47:53 +0000https://news.ycombinator.com/item?id=46985002pjothttps://news.ycombinator.com/item?id=46985002https://news.ycombinator.com/item?id=46985002<![CDATA[New comment by pjot in "Claude Opus 4.6"]]>Claude Code release notes:

  > Version 2.1.32:
     • Claude Opus 4.6 is now available!
     • Added research preview agent teams feature for multi-agent collaboration (token-intensive feature, requires setting
     CLAUDE_CODE_EXPERIMENTAL_AGENT_TEAMS=1)
     • Claude now automatically records and recalls memories as it works
     • Added "Summarize from here" to the message selector, allowing partial conversation summarization.
     • Skills defined in .claude/skills/ within additional directories (--add-dir) are now loaded automatically.
     • Fixed @ file completion showing incorrect relative paths when running from a subdirectory
     • Updated --resume to re-use --agent value specified in previous conversation by default.
     • Fixed: Bash tool no longer throws "Bad substitution" errors when heredocs contain JavaScript template literals like ${index + 1}, which
     previously interrupted tool execution
     • Skill character budget now scales with context window (2% of context), so users with larger context windows can see more skill descriptions
     without truncation
     • Fixed Thai/Lao spacing vowels (สระ า, ำ) not rendering correctly in the input field
     • VSCode: Fixed slash commands incorrectly being executed when pressing Enter with preceding text in the input field
     • VSCode: Added spinner when loading past conversations list

]]>Thu, 05 Feb 2026 18:03:16 +0000https://news.ycombinator.com/item?id=46902560pjothttps://news.ycombinator.com/item?id=46902560https://news.ycombinator.com/item?id=46902560<![CDATA[New comment by pjot in "Mental Models (2018)"]]>Not sure how you missed it, it’s here: https://fs.blog/about/

]]>Sat, 24 Jan 2026 21:31:34 +0000https://news.ycombinator.com/item?id=46747898pjothttps://news.ycombinator.com/item?id=46747898https://news.ycombinator.com/item?id=46747898<![CDATA[New comment by pjot in "If you care about security you might want to move the iPhone Camera app"]]>“Hover” seems to be causing some confusion. It’s more of a “shallow” press. Like the opposite of “pressing into” when 3D Touch was a thing

]]>Mon, 29 Dec 2025 01:16:31 +0000https://news.ycombinator.com/item?id=46416296pjothttps://news.ycombinator.com/item?id=46416296https://news.ycombinator.com/item?id=46416296<![CDATA[New comment by pjot in "Icons in Menus Everywhere – Send Help"]]>Similar is the save icon, though for a different reason. It conveys its function well, but one first needs to know what a floppy disk even is!

]]>Tue, 09 Dec 2025 04:51:27 +0000https://news.ycombinator.com/item?id=46201346pjothttps://news.ycombinator.com/item?id=46201346https://news.ycombinator.com/item?id=46201346<![CDATA[New comment by pjot in "Tau² benchmark: How a prompt rewrite boosted GPT-5-mini by 22%"]]>I’ve found myself writing code intending to write prompts for writing better code.

Soon enough Im sure we’ll start to see programming languages that are geared towards interacting with llms

]]>Wed, 17 Sep 2025 19:30:20 +0000https://news.ycombinator.com/item?id=45280363pjothttps://news.ycombinator.com/item?id=45280363https://news.ycombinator.com/item?id=45280363<![CDATA[New comment by pjot in "Building a DOOM-like multiplayer shooter in pure SQL"]]>Author of the mentioned DuckDB-DOOM here!

This is awesome - multiplayer is a great addition. Really like the cone in the mini-map too

]]>Tue, 09 Sep 2025 18:48:48 +0000https://news.ycombinator.com/item?id=45186750pjothttps://news.ycombinator.com/item?id=45186750https://news.ycombinator.com/item?id=45186750<![CDATA[New comment by pjot in "A Typology of Canadianisms"]]>A “fully dressed” poboy in New Orleans is one with all the fixing’s

]]>Thu, 10 Jul 2025 02:47:27 +0000https://news.ycombinator.com/item?id=44516717pjothttps://news.ycombinator.com/item?id=44516717https://news.ycombinator.com/item?id=44516717<![CDATA[New comment by pjot in "Abusing DuckDB-WASM by making SQL draw 3D graphics (Sort Of)"]]>Ha! I made this. I’m not a robot either :)

]]>Tue, 22 Apr 2025 15:58:55 +0000https://news.ycombinator.com/item?id=43763650pjothttps://news.ycombinator.com/item?id=43763650https://news.ycombinator.com/item?id=43763650<![CDATA[New comment by pjot in "Abusing DuckDB-WASM by making SQL draw 3D graphics (Sort Of)"]]>Author here, wild to see this at the top of HN!

You can play it here: https://patricktrainer.github.io/duckdb-doom/

Pressing “L” enables (very) verbose logging in the dev console and prints much of the sql being executed.

]]>Tue, 22 Apr 2025 15:54:31 +0000https://news.ycombinator.com/item?id=43763603pjothttps://news.ycombinator.com/item?id=43763603https://news.ycombinator.com/item?id=43763603<![CDATA[New comment by pjot in "Frankenstein's `__init__`"]]>Rather than juggling your parent’s __init__ on another thread, it’s usually clearer to:

1. Keep all of your object–initialization in the main thread (i.e. call super().__init__() synchronously).

2. Defer any ZMQ socket creation that you actually use in the background thread into the thread itself.

]]>Sat, 19 Apr 2025 14:56:25 +0000https://news.ycombinator.com/item?id=43736843pjothttps://news.ycombinator.com/item?id=43736843https://news.ycombinator.com/item?id=43736843<![CDATA[New comment by pjot in "Are people bad at their jobs or are the jobs just bad?"]]>This compounds with each _team_ modeling the work in jira/excel too!

]]>Wed, 02 Apr 2025 23:40:18 +0000https://news.ycombinator.com/item?id=43563097pjothttps://news.ycombinator.com/item?id=43563097https://news.ycombinator.com/item?id=43563097<![CDATA[New comment by pjot in "My 16-month theanine self-experiment"]]>Through the arm, I believe, is still the way it’s performed today!

]]>Sun, 09 Mar 2025 20:26:19 +0000https://news.ycombinator.com/item?id=43313391pjothttps://news.ycombinator.com/item?id=43313391https://news.ycombinator.com/item?id=43313391<![CDATA[New comment by pjot in "Sam Bankman-Fried thrown into solitary over Tucker Carlson interview: report"]]>I don’t know, I feel like there is much more room for positive incentives than negative. Prisons put people on a pretty level playing field.

Like, the well behaved could be served pork chops and peas instead of slop and mush.

]]>Sat, 08 Mar 2025 18:40:28 +0000https://news.ycombinator.com/item?id=43302372pjothttps://news.ycombinator.com/item?id=43302372https://news.ycombinator.com/item?id=43302372<![CDATA[New comment by pjot in "Sam Bankman-Fried thrown into solitary over Tucker Carlson interview: report"]]>Maybe leading with a stick instead of a carrot isn’t the right approach?

]]>Sat, 08 Mar 2025 18:04:27 +0000https://news.ycombinator.com/item?id=43302071pjothttps://news.ycombinator.com/item?id=43302071https://news.ycombinator.com/item?id=43302071