721
Materialized views are obviously useful
As programmers we spend a lot of time shuttling data back and forth between different systems and transforming it from one format to another. Sometimes it gets pretty miserable!
Topics /
Software Engineering
The most popular blog posts about software engineering on Hacker News. 1,260 posts.
722
Ultra efficient vector extension for SQLite
Making vector search fast, memory-efficient, and natural in SQLite.
723
Editing Code in Emacs
When you write code, you want to focus on the code, not on the text of the code. This means a) you have to have a good text editing setup, and b) you need to have a muscle-memory level instinct for using that setup. The second comes with practice and with consistency (i.e. not changing your config too much too…
724
725
The Core of Rust
within Rust is a smaller language struggling to get out
726
Reviewing the cryptography used by Signal
Last year, I urged furries to stop using Telegram because it doesn’t actually provide them with any of the privacy guarantees they think it gives them. Instead of improving Telegram’s c…
727
GPT-5 vs. Sonnet: Complex Agentic Coding
OpenAI released GPT-5 yesterday, promoting it as their best model yet for agentic coding.
728
Haskelling My Python
Reimplementing Haskell lazy infinite lists using Python generators
729
Poor man's bitemporal data system in SQLite and Clojure
On trying to mash up SQLite with ideas stolen from Accountants, Clojure, Datomic, XTDB, Rama, and Local-first-ers, to satisfy Henderson's Tenth Law. Viz., to make a sufficiently complicated data system containing an ad-hoc, informally-specified, bug-ridden, slow implementation of half of a bitemporal database…
730
Writing my own dithering algorithm in Racket
My journey implementing a new dithering algorithm in the Racket programming language.
731
Clojure: Realtime collaborative web apps without ClojureScript
A blog mostly about Clojure programming
732
Yoke: Infrastructure as code, but actually
Infrastructure as code, but actually
733
What the hell is a target triple?
Cross-compiling is taking a computer program and compiling it for a machine that isn’t the one hosting the compilation. Although historically compilers would only compile for the host machine, this is considered an anachronism: all serious native compilers are now cross-compilers.
734
735
Using Deno as my game engine
Software, games, and the occasional startup.
736
OpenGL: Mesh shaders in the current year
It Happened.
737
The Weird Concept of Branchless Programming
Read THE WEIRD CONCEPT OF BRANCHLESS PROGRAMMING on sanixdk.xyz
738
MCP: An (Accidentally) Universal Plugin System
Or: The Day My Toaster Started Taking Phone Calls
739
A SQL Heuristic: ORs Are Expensive
But this is slow! With 1,000,000 applications and 1000 users uniformly distributed on both columns, it takes over 100ms. 1
740
Writing a tiny undo/redo stack in JavaScript
I’ve needed this before - a couple of times. Third time I figured I needed something small, nimble - yet complete. And - at the same time - wondering about how to do it in a very simple manner. I think it worked out great, so let’s dig in. Most UIs will have some form of undo functionality. Now, there are generally…
741
JIT: So you want to be faster than an interpreter on modern CPUs
Since my previous blog entry about JIT compiler for PostgreSQL, sadly not much happened due to a lack of time, but still some things were done (biggest improvement was the port to ARM64, a few optimizations, implementing more opcodes…). But I am often asking myself how to really beat the interpreter… And on “modern”…
742
Less Htmx Is More
How to build great websites with htmx by learning a couple browser features alongside it.
743
Using Python for Scripting
"Use the right tool" is nice in theory, but not when the tool acts a bit differently from machine to machine, and isn't always installed.
744
Broccoli Man, Remastered
A breakdown of how I used modern AI tools (Veo 3.1 and Nano Banana) to create a new version of a Google cultural classic.
745
Don't “let it crash”, let it heal
Don't "let it crash". Let it heal.
746
Simplest C++ Callback, from SumatraPDF
C++ implementation of the simplest callback
747
Avoid Mini-Frameworks
I work in Google Ads in the past several years. Over time, I've seen one pattern came along again and again, causing endless pain for developers, that is, creating mini-frameworks.
748
Reverse engineering Codex CLI to get GPT-5-Codex-Mini to draw me a pelican
OpenAI partially released a new model yesterday called GPT-5-Codex-Mini, which they describe as "a more compact and cost-efficient version of GPT-5-Codex". It’s currently only available via their Codex CLI tool …
749
Which NPM package has the largest version number?
I spent way too much time on this
750
Mistakes I see engineers making in their code reviews
In the last two years, code review has gotten much more important. Code is now easy to generate using LLMs, but it’s still just as hard to review. Many software…