News for hackers. Stuff that matters.

pjot

Re:I've operated petabyte-scale ClickHouse clusters for 5 years on Friday September 11, 2026 @08:20PM (#49667225)
I don’t think it’s necessarily the use case changed but maybe the constraints. Streaming directly to Clickhouse is a great solution. Recent approaches I’ve seen though buffer data as parquet in object storage first, and read data from there. Im not sure if CH would be the preference
Re:Project Blinkenlights on Friday September 11, 2026 @07:01PM (#49666600)
Thought this was the ascii Star Wars in your terminal à la

  telnet towel.blinkenlights.nl
Re:Discovery of a new OpenAI agent message board on Friday September 04, 2026 @03:48PM (#49569365)
1008 pages, wow!
Re:Defrag98: Windows 98 Disk Defragmenter Simulator Online on Saturday August 29, 2026 @10:04PM (#49495028)
It also made a really satisfying “boyoyoyinnng” sound
Re:Defrag98: Windows 98 Disk Defragmenter Simulator Online on Saturday August 29, 2026 @07:36PM (#49494274)
Will need to degauss after this
Re:Nitter project received cease and desist on Tuesday August 25, 2026 @05:22PM (#49440833)
Where do you get this free beer?
I used to love watching the “unlimited” storage counter increase as each second went by
Re:Asynchronous I/O in DuckDB: Work, Thread, Work on Sunday August 16, 2026 @12:49AM (#49317006)
I wonder how this would work in trying to parallelize the worker threads (multiple duckdb instances) coordinating them via Quack.

Ducks all the way down!

Re:Why Large Language Models Fail at Tabular Prediction on Tuesday August 04, 2026 @11:04AM (#49169983)
One step further are those who want to point an llm directly at the data warehouse to get the data needed to run predictions
Re:Systems and Delays on Saturday July 25, 2026 @11:47PM (#49054514)
Re:Alternate Clock Designs and Time Systems on Friday July 10, 2026 @01:22PM (#48862712)
Here’s a different kind of binary clock https://www.hey.earth/posts/binary-clock
Re:1-Click GitHub Token Stealing via a VSCode Bug on Wednesday June 03, 2026 @01:34AM (#48380288)

  > created bunch of fake spam pages and trying to mine crypto
Pages like GitHub pages? We’re repos being created in your account? Curious how you discovered that your tokens were pwned
Re:You Don't Love Systemd Timers Enough on Tuesday June 02, 2026 @12:23PM (#48372377)
After years of using orchestration tools like airflow and dagster so many lightbulbs have just lit up in my head.

I wish documentation for tools would explain their abstractions concepts in terms of its primitives.

Great post, thanks!

  > 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.
Re:NanoTDB – Golang Append-Only Time Series DB on Friday May 15, 2026 @08:49PM (#48155754)
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

Re:Pretty Fish: A better mermaid diagram editor on Wednesday April 15, 2026 @11:20AM (#47780362)
To be fair, pie charts are horrible in general.
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.

I did this but used duckdb as the vector store. Works really well, quite fast too.

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

Re:Using an Engineering Notebook on Wednesday February 11, 2026 @11:47PM (#46985002)
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.
Re:Claude Opus 4.6 on Thursday February 05, 2026 @01:03PM (#46902560)
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
Not sure how you missed it, it’s here: https://fs.blog/about/
“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
Re:Icons in Menus Everywhere – Send Help on Monday December 08, 2025 @11:51PM (#46201346)
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!
Re:Tau² Benchmark: How a Prompt Rewrite Boosted GPT-5-Mini by 22% on Wednesday September 17, 2025 @03:30PM (#45280363)
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

Re:Building a DOOM-like multiplayer shooter in pure SQL on Tuesday September 09, 2025 @02:48PM (#45186750)
Author of the mentioned DuckDB-DOOM here!

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

Re:A Typology of Canadianisms on Wednesday July 09, 2025 @10:47PM (#44516717)
A “fully dressed” poboy in New Orleans is one with all the fixing’s
Ha! I made this. I’m not a robot either :)
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.

Re:Frankenstein's `__init__` on Saturday April 19, 2025 @10:56AM (#43736843)
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.

Older »