2011
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...
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 4,224 posts.
2012
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.
2013
2014
Introducing Dash – Reactive Web Apps for Python
Create Reactive Web Apps in pure Python
2015
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.
2016
The Inner Workings of Distributed Databases
Comparison of replication options of time-series databases.
2017
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.
2018
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.
2019
2020
Is BI dead? – On dismantling data's ship of Theseus
On dismantling data's ship of Theseus.
2021
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.
2022
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…
2023
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.
2024
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 .
2025
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 …
2026
2027
2028
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.
2029
The revenge of the data scientist
AI eval mistakes and the data science practices that fix them.
2030
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.
2031
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...
2032
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…
2033
2034
2035
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 ...
2036
2037
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…
2038
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…
2039
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!
2040
Amazon DynamoDB Transactions
May 20, 2024: As of September 2022, DynamoDB now supports 100 items per transactions. March 13, 2020: Post updated to clarify how to use transactions with global tables and the increase in the maximum number of items per transaction from 10 to 25. Over the years, customers have used Amazon DynamoDB for lots of…