2011
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.
Top posts
Every blog post that took off on Hacker News, ranked by the votes of its best submission. 4,225 posts.
2012
Anonymous Correctly Predict The De-listing $1B Company
" Anonymous " has a new project called Anonymous Analytics , which recently predicted that a Hong Kong company, Chaoda Modern Agriculture h...
2013
Backblaze Drive Stats: 2018 Q3 Hard Drive Failure Rates
Backblaze has 99,636 spinning hard drives. This review looks at the quarterly and lifetime statistics for the data drive models in operation in our data centers.
2014
2015
Introducing Dash – Reactive Web Apps for Python
Create Reactive Web Apps in pure Python
2016
Index Merges vs. Composite Indexes in Postgres and MySQL
Composite indexes aka multi-column indexes are about 10x faster than index merges. In Postgres, the gap is larger than in MySQL because Postgres doesn’t support index-only scans for queries that involve index merges.
2017
The Inner Workings of Distributed Databases
Comparison of replication options of time-series databases.
2018
Call me maybe: etcd and Consul
In the previous post, we discovered the potential for data loss in RabbitMQ clusters . In this oft-requested installation of the Jepsen series, we’ll look at etcd : a new contender in the CP coordination service arena. We’ll also discuss Consul ’s findings with Jepsen.
2019
Backblaze Drive Stats for Q3 2025
Read the Q3 2025 Drive Stats report to see the latest annualized failure rates, and an analysis of how we define failure in the first place.
2020
2021
Is BI dead? – On dismantling data's ship of Theseus
On dismantling data's ship of Theseus.
2022
Postgres audit tables saved us from taking down production
Learn how audit tables helped us avoid a serious incident, and how you can create audit tables in your own Postgres databases.
2023
DuckDB 0.9
The DuckDB team is happy to announce the latest DuckDB release (0.9.0). This release is named Undulata after the Yellow-billed duck native to Africa. To install the new version, please visit the installation guide. The full release notes can be found on GitHub. There have been too many changes to discuss them each in…
2024
How to make any immutable data structure distributed
Spark-style distributed datasets can be modeled with a few lines of code, using Unison's distributed computing library. This article teaches you how.
2025
SQLite 3.43
A complete list of SQLite releases in a single page and a chronology are both also available. A detailed history of every check-in is available at SQLite version control site .
2026
PostgreSQL 9.6 Beta 1 Released
The PostgreSQL Global Development Group announces today that the first beta release of PostgreSQL 9.6 is available for download. This …
2027
2028
2029
Apache Kafka, Samza, and the Unix Philosophy of Distributed Data
Confluent is building the foundational platform for data in motion so any organization can innovate and win in a digital-first world.
2030
The revenge of the data scientist
AI eval mistakes and the data science practices that fix them.
2031
A baffling scale transform on a chart of university course selection trends
Harvard Magazine printed the following chart that confirms a trend in undergraduate majors that we all know about: students are favoring STEM majors at the expense of humanities.
2032
The Best Free and Open Source Data Mining Software
The process of extracting patterns from data is called data mining. It is recognized as an essential tool by modern business since it is ab...
2033
PostgreSQL 14 Internals
I’m excited to announce that the translation of the “ PostgreSQL 14 Internals ” book is finally complete thanks to the amazing work of Liudmila Mantrova. The final part of the book considers each of the index types in great detail. It explains and demonstrates how access methods, operator classes, and data types work…
2034
2035
2036
Shenandoah GC in production: experience report
Update: I've made several edits to the post since Aleksey Shipilëv was kind enough to suggest many corrections and improvements.If you closely follow JVM development scene, you've probably noticed ...
2037
2038
Analyzing Indie Hacker Products with Verified Revenue
Indie Hackers is a wonderful community for founders, a vast ocean of shared knowledge and a place to showcase your product journey. A lot of people are sharing their products there along with the revenue, often verified by Stripe. We analyzed the available data to check how much revenue are those products making and…
2039
Federal Reserve Bank of NY converts major economic model to Julia
Marco Del Negro, Marc Giannoni, Pearl Li, Erica Moszkowski, and Micah Smith We have implemented the FRBNY DSGE model in a free and open-source language called Julia. The code is posted here on GitHub, a public repository hosting service. This effort is the result of a collaboration between New York Fed staff and folks…
2040
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!