Good CTE, Bad CTE
The planner treats CTEs very differently depending on how you write them. Here's what happens under the hood, version by version, through PostgreSQL 18.
The latest blog posts to take off on Hacker News. 5,961 posts.
The planner treats CTEs very differently depending on how you write them. Here's what happens under the hood, version by version, through PostgreSQL 18.
The demo scene has a peculiar view on copyright . It roughly boils down to a system of effort - effort in ideas, effort in craft - where the scene polices itself and punishes sceners that steal outright from other sceners. Theft from the outside world, however, is often taken lightly - especially when it comes to…
How VHDL preserves determinism In this post, I would like to talk about VHDL’s crown jewel: how it preserves determinism in a concurrent language. Here is a figure of how it works:
After a team member summoned Copilot to correct a typo in a PR of mine, Copilot edited my PR description to include and ad for itself and Raycast .
A regression in external display support on Apple Silicon M4/M5 generation chips prevents full HiDPI modes on 4K monitors, limiting users to either blurry non-HiDPI or reduced workspace HiDPI.
I've been vibe-coding a lot lately. Like, a lot a lot
Edit April 2, 2026: I've been getting inbound interest from researchers wanting to run their own queries. The MCP integration I use for my own research lets you analyze live mobile telemetry continuously collected from real devices in the wild, directly from Claude. To access it reach out at
The open web with AIs is turning into a dark forest.
This may have some legs
The right arrow key on my Macbook Pro keyboard stopped working the other day. I say “stopped working”, but technically it works too well now, it is being pressed constantly, which makes the laptop pretty unusable.
News flash: C++26 is done! 🎉 On Saturday, the ISO C++ committee completed technical work on C++26 in (partly) sunny London Croydon, UK. We resolved the remaining international comments on the C++26…
A very primitive version of recovery.
The morning of April 12, 1981, 20 years to the day after Yuri Gagarin became the first person in space, the Space Shuttle thundered into the...
As you may know, on Glade Art we tend to take anti-bot measures very seriously; it is one of our topmost priorities to protect our fellow users from having t...
What if I told you SQL could play chess? No JavaScript, no frameworks - just pure SQL rendering a full chess board in your browser.
Popular images of the Jovian moon Io’s famed Steeple Mountain turn out to be misinformed. How the Inquisitive team figured that out, and what Steeple Mountain really looks like!
Nitrile and latex gloves that scientists wear while they are measuring microplastics may lead to a potential overestimation of the tiny pollutants, according to a University of Michigan study.
ESP32-S31 delivers comprehensive multi-protocol connectivity, rich multimedia interfaces, and hardware-accelerated security for next-generation IoT applications.
Every dataframe library ships with hundreds of operations. pandas alone has over 200 methods on a DataFrame. Is pivot different from melt? Is apply different from map? What about transform, agg, applymap, pipe? Some of these seem like the same operation wearing different hats. Others seem genuinely distinct. Without a…
How TurboQuant compresses the KV cache without losing accuracy, and what that could mean for memory stocks
how to hide juicy data in plain sight
Paper packaging offers a number of advantages over its plastic counterparts: It has a high recycling rate, lower CO₂ emissions, and lower disposal costs. However, it cannot yet be sealed without adhesives or layers of plastic—a disadvantage for manufacturing and recycling processes. In the PAPURE project, four…
How the KV cache gives every AI conversation a physical weight in silicon, and what happens when the memory runs out.
In my last post, I showed you to use FireWire on a Raspberry Pi with a PCI Express IEEE 1394 adapter. Now I'll show you how I'm using a new FireWire HAT and a PiSugar3 Plus battery to make a portable MRU, or 'Memory Recording Unit', to replace tape in older FireWire/i.Link/DV cameras. The alternative is an old used…
Every wall, floor, barrel, and imp is a div — DOOM rendered entirely in CSS. Using 3D transforms, CSS math functions, @property, clip-path, anchor positioning, and SVG filters to build a fully playable 3D first-person shooter in the browser without Canvas or WebGL.
AI eval mistakes and the data science practices that fix them.
A personal blog, by a programmer and IT expert. Essays, Articles, Guides, and Recipes. As well as Code, Quotes, and Links.
TruffleRuby started as my internship project at Oracle Labs in early 2013. It is an implementation of the Ruby programming language on the JVM, using the Graal dynamic compiler and the Truffle AST interpreter framework . TruffleRuby can achieve peak performance well beyond that possible in JRuby at the same time as…
I’ve taken agency in the treatment of my bone cancer (osteosarcoma in the T5 vertebrae of the upper spine). After I ran out of standard-of-care treatment options and there were no trials available for…