1
MongoBleed Explained Simply
CVE-2025-14847 allows attackers to read any arbitrary data from the database's heap memory. It affects all MongoDB versions since 2017, here's a simple explanation:
New
The latest blog posts to take off on Hacker News. 148 posts.
2
Pokémon Team Optimization
This article will show you how forming your Pokémon team can be turned into a mathematical optimization problem.
3
Instant database clones with PostgreSQL 18
Learn how to clone PostgreSQL databases instantly using reflinks. Turn slow template copies into milliseconds with PostgreSQL 18's new file copy options.
4
Your Supabase is public if you turn off RLS
I was chatting with a close friend of mine and he sent me a link to his new SaaS that he's developing.
5
Go ahead, self-host Postgres
Self-hosting Postgres is simpler and cheaper than managed services suggest, with comparable reliability and better performance tunability.
6
What Does a Database for SSDs Look Like?
What does a relational database designed specifically for local SSDs look like? Postgres, MySQL, SQLite and many others were invented in the 90s and 00s, the era of spinning disks. A local NVMe SSD has ~1000x improvement in both throughput and latency. Design decisions like write-ahead logs, large page sizes, and…
7
8
Avoid UUID Version 4 Primary Keys in Postgres
Introduction Over the last decade, when working on databases with UUID Version 41 as the primary key data type, these databases have usually had bad performance and excessive IO. https://datatracker.ietf.org/doc/html/rfc4122#section-4.4 ↩
9
Zmij: Faster floating point double-to-string conversion
There comes a time in every software engineer’s life when they come up with a new binary-to-decimal floating-point conversion method. I guess my time has come. I just wrote one, mostly over a weekend: https://github.com/vitaut/zmij .
10
How Google Maps allocates survival across London's restaurants
I wanted a dinner recommendation and got a research agenda instead. Using 13000+ restaurants, I rebuild its ratings with machine learning and map how algorithmic visibility actually distributes power.
11
How exchanges turn order books into distributed logs
Every modern exchange is a distributed database in disguise. This article reveals how trading engines transform chaotic streams of buy and sell orders into a perfectly ordered, replayable log, ensuring fairness, determinism, and market data reliability.
12
100k TPS over a billion rows: the unreasonable effectiveness of SQLite
A blog mostly about Clojure programming
13
Hachi: An Image Search Engine
For quite some time now, i have been working on and off on a fully self-hosted search engine , in hope to make it easier to search across Personal data in an end to end manner. Even as individuals, we are hoarding and generating more and more data with no end in sight. Such "personal" data is being stored from local…
14
The CRDT Dictionary: A Field Guide to Conflict-Free Replicated Data Types
A comprehensive guide to CRDTs and their tradeoffs, from counters to sequences. Written in the spirit of the Typeclassopedia, exploring how different CRDTs solve the distributed consensus puzzle.
15
16
Python is not a great language for data science
It may be a good language for data science, but it’s not a great one.
17
How/why to sweep async tasks under a Postgres table
I like slim and stupid servers, where each endpoint wraps a very dumb DB query. Dumb queries are fast. Fast queries make websites smooth and snappy. Keep those click/render loops sacred. Sweep complexity under a task table.
18
Building a Durable Execution Engine with SQLite
Lately, there has been a lot of excitement around Durable Execution (DE) engines. The basic idea of DE is to take (potentially long-running) multi-step workflows, such as processing a purchase order …
19
Building a Simple Search Engine That Works
You don't need Elasticsearch for most projects. I built a simple search engine from scratch that tokenizes everything, stores it in your existing database, and scores results by relevance. Dead simple to understand and maintain.
20
Weighting an average to minimize variance
How would you allocate money to a set of independent assets with to minimize volatility if some assets are more volatile than others?
21
RegreSQL: Regression Testing for PostgreSQL Queries
Stop deploying broken SQL queries. RegreSQL provides regression testing for PostgreSQL queries with performance baselines and automated warnings.
22
23
24
Listen to Database Changes Through the Postgres WAL
An in-depth guide to listening to Postgres database changes through the WAL. Covers logical replication, publications, replication slots, and an Elixir implementation.
25
Building a high-performance ticketing system with TigerBeetle
Rene Schallner (@renerocksai): software engineer turned AI researcher and engineer, in Vienna.
26
I analyzed the lineups at the most popular nightclubs
A few years back I did a bit of dance music related data visualization over at Lazily Evaluated. My favourite was an analysis of clubs and their lineups using Resident Advisor / RA data, I called it Clubster Analysis. I always wanted to dig into the technical aspects of gathering the data, analyzing it and building…
27
Optimizing Datalog for the GPU
Datalog primer and a neat data structure
28
Bloom filters are good for search that does not scale
Jonathan Arns's personal blog
29
The Case Against PGVector
The real limitations of pgvector in production: index choice between IVFFlat and HNSW, why real-time search is hard, pre- vs post-filtering pain, how performance degrades at scale, and when a dedicated vector database is the better call.
30
Absurd Workflows: Durable Execution with Just Postgres
Durable execution with just postgres.