61
New
The latest blog posts to take off on Hacker News. 1,888 posts.
62
Full-Text Search with DuckDB
Pete Doherty is a NYC based software developer
63
Linux 7.0 Broke PostgreSQL: The Preemption Regression Explained
Linux 7.0 delivered roughly half the throughput of Linux 6.x on the same hardware and workload.
64
Period tracking app, Flo, found to be selling user data to Meta
What does this vagueness by-design mean for how we choose to self monitor our biological markers?
65
Agentic AI systems violate the implicit assumptions of database design
There is an implicit contract at the foundation of every database architecture decision you have ever made. You probably never wrote it down. Nobody does. It just… existed.
66
Columnar Storage Is Normalization
Something I didn't understand for a while is that the process of turning row-oriented data into column-oriented data isn't a totally bespoke, foreign concept...
67
3.4M Solar Panels
Benchmarks & Tips for Big Data, Hadoop, AWS, Google Cloud, PostgreSQL, Spark, Python & More...
68
Scientific datasets are riddled with copy-paste errors
Initial results from scanning through Excel files belonging to 600 published scientific papers.
69
5NF and Database Design
Author: Alexey Makhotkin squadette@gmail.com, (~3900 words) One of the goals of this publication is to deconstruct the traditional ways of teaching basic topics in relational databases. Previously we discussed the fourth normal form (4NF): “Historically, 4NF explanations are needlessly confusing”. Let’s discuss the…
70
Average is all you need
LLMs will make more of your average stuff. And that's OK. Here's how average SQL beats fancy attribution models when your agent writes the queries.
71
S3 Files
Andy Warfield writes about the hard-won lessons dealing with data friction that lead to S3 Files
72
Every GPU That Mattered
49 graphics cards. 30 years. From Quake to Cyberpunk.
73
74
Your File System Is Already A Graph Database
Karpathy recently posted about using LLMs to build personal knowledge bases — collecting raw sources into a directory, having an LLM “compile” them into a wiki of interlinked markdown …
75
SQLite in Production: Lessons from Running a Store on a Single File
Run Rails on SQLite with WAL and Docker volumes while accounting for the concurrency failure that appears during blue-green deploys.
76
Modern SQLite: Features You Didn't Know It Had
SQLite has evolved far beyond a simple embedded database. Explore modern features like JSON, FTS5, window functions, strict tables, and more.
77
Good CTE, Bad CTE
The planner treats CTEs very differently depending on how you write them. Here's what happens under the hood, version by version, through PostgreSQL 18.
78
What category theory teaches us about dataframes
Every dataframe library ships with hundreds of operations. pandas alone has over 200 methods on a DataFrame. Is pivot different from melt? Is apply different from map? What about transform, agg, applymap, pipe? Some of these seem like the same operation wearing different hats. Others seem genuinely distinct. Without a…
79
The revenge of the data scientist
AI eval mistakes and the data science practices that fix them.
80
21,864 Yugoslavian .yu domains
TLDR; get a list of 21,864 domains from the former Yugoslavia’s “.yu” top level domain: download the .CSV
81
Data Manipulation in Clojure Compared to R and Python
I spend a lot of time developing and teaching people about Clojure's open source tools for working with data. Almost everybody who wants to use Clojure…
82
Bayesian statistics for confused data scientists
A gentle introduction to Bayesian statistics for data scientists who, like me, are confused by it.
83
A Visual Introduction to Machine Learning (2015)
What is machine learning? See how it works with our animated data visualization.
84
Pandas Exercises for Data Analysis (Interactive)
101 interactive pandas exercises with solutions. Edit and run every code block directly in your browser — no installation needed.
85
We are building data breach machines and nobody cares
A few weeks ago, my longstanding friend and colleague Curt Cunning mentioned to me that he was slogging through Nietzsche, which bespeaks his incredible will to power through things that are unpleasant (one of the many things that makes him an exceptional engineer). In any case, it lead me to revisit some of his work…
86
Graphing how the 10k* most common English words define each other
The words are a subset of the 10,000 most common words from Google's Trillion Word Corpus , with definitions sourced from Open English Wordnet .
87
C# strings silently kill your SQL Server indexes in Dapper
If you're using Dapper with anonymous objects to query varchar columns, you're probably sending nvarchar(4000) parameters — causing CONVERT_IMPLICIT on every row and defeating your indexes. Here's the fix.
88
MinIO Is Dead, Long Live MinIO
MinIO’s repo is officially archived and abandoned. And how AI Agents helped bring it back from the dead. This post explains how a community fork restores the admin console and ships binaries via CI/CD pipeline.
89
Google Street View in 2026
Benchmarks & Tips for Big Data, Hadoop, AWS, Google Cloud, PostgreSQL, Spark, Python & More...
90
Hardwood: A New Parser for Apache Parquet
Today, it’s my great pleasure to announce the first public release of Hardwood, a new parser for the Apache Parquet file format, optimized for minimal dependencies and great performance. Hardwood is …