The only scalable delete in Postgres is DROP TABLE
Large DELETEs add work instead of reclaiming it. Structure your database so deletion becomes DROP TABLE or TRUNCATE.
The latest blog posts to take off on Hacker News. 1,421 posts.
Large DELETEs add work instead of reclaiming it. Structure your database so deletion becomes DROP TABLE or TRUNCATE.
From the Zed Blog: Agents turned the conversation into the real source of our software. DeltaDB is the version control built for it.
We benchmarked Claude Fable 5 on 200 real-world coding tasks for the Agent Security League.
Once I wrote users.select { |u| u.admin? }.map(&:email) and realized I’d written Lisp.
Meet North Mini Code, Cohere's first open-source agentic coding model: a 30B MoE that codes strongly on minimal hardware.
A case against measuring AI-assisted engineering by code volume and other vanity metrics instead of outcomes.
In this blog post, I will share the adventures I had creating my own LLM, from (almost) scratch, trained only on old texts. I made my own base-training and fine-tuning scripts, data processing pipelines and custom datasets. ("almost from scratch" means I did use existing programming languages and libraries, I didn't…
An overview of DiffusionGemma, an exceptionally fast text generation model with up to 4x faster speeds.
Last year I've fixed a bug in Linux kernel OHCI (USB 1.1) stack , which rendered my old printer unreliable: OHCI adds artificial delay of 1ms for each USB transfer of send-read pattern, while my very old, host-based printer expects very tight timings and constant latency, like some kind of CnC machine.
Thank you for the support, this blog post got featured on the front page of Hacker News (YCombinator).
Our next npm major version, v12, introduces security-related default changes to npm install. All these changes are available behind warnings in npm today on 11.16.0 or newer, so you can…
We used agents to port all of Git to library-first, memory-safe Rust and it passes the entire C Git test suite.
System composition and other interfaces for Biff projects
We are pleased to announce the Pyodide 314.0 release. This release focuses on standardization and packaging, marking a significant milestone in the Python-in-the-browser ecosystem. PEP 783 is Accepted: What Does It Mean? The acceptance of PEP 783: Emscripten packaging marks perhaps the most exciting change in the…
In the previous part of the Build A Basic AI Agent From Scratch series, we added the essential tools to our agent to allow it to work…
Test-case reducers are less well known than they should be, and those who are aware of them don’t always realise the variety of ways we can use – perhaps even abuse! – them. In this post, I’m going to explore some of the things I’ve learnt while using these wonderful tools. I’ll start at the basics, because the idea…
A deep dive into the asset creation pipeline for Catlantean 3D.
We've all worked with a rockstar developer. They joined the team years ago, full of energy. They had great ideas about new tech, new paradigms, new architectures. Their cutting-edge ideas left everyone else feeling a bit behind and outdated.
Today’s coding benchmarks have established that models can write correct code, but the question we should really be asking is: can models actually write…
Emacs provides four useful status bars (mode-line, header-line, tab-bar, and tab-line), but each imposes different, inconsistent limits on multi-line layout, al...
How I developed a Klondike Solitaire game for curses in C language as an entry for the IOCCC.
WASI P3 is almost here, bringing native async support to the WebAssembly System Interface (WASI) and Component Model. In this post, we’re looking to the next big milestone: a stable, formally specified Component Model 1.0.At February’s B...
Bear with me, because some of these "lies" are going to feel obvious, or like unimportant trivia. In all honesty, that's not that far from the truth. However, I hope you'll let me try to build a detailed and fun illustration showing how something as mundane as email can break our expectations in surprising ways.
Build the smallest Rust async runner and see how futures, polling, waking, and runtimes work together.
Library maintainers may feel overwhelmed by the plurality of type checkers that exist. We offer some guidance on how to focus their efforts where they matter most.
A perceptron explained from scratch in Python, with interactive demos. Learn weights, bias, the decision boundary, epochs, learning rate, and why we normalize data.
Ethical Hacking and Cybersecurity Blog
Semantic understanding on top of Git. Diff, blame, impact, log. Functions, not lines.