61
Python Polars Cheatsheet (based on our O'Reilly book)
Quick reference guide for transforming, analyzing, and visualizing data with Python Polars.
New
The latest blog posts to take off on Hacker News. 4,224 posts.
62
63
A Preview of DuckDB v2.0
DuckDB 2.0 is coming this fall. In this post, we preview its headline features: DuckDB as a server, triggers, the VARIANT type, asynchronous I/O, a new SQL parser, a new storage format, and much more.
64
How Compaction Works in Pi
Why compaction is needed for large language models and how Pi implements it
65
Does anyone run Postgres without PgBouncer?
Almost every notable managed Postgres provider bundles a connection pooler, giving us a strong hint that connection management is a product problem rather than a user problem.
66
Breaking the WAL
I did this from a lawn chair on the Sunshine Coast.
67
Grok 4.6 scores 61 on the Artificial Analysis Intelligence Index
SpaceXAI returns to the intelligence frontier with strengths in agentic performance and cost efficiency
68
Tracking down the 16-year-old WAL-reset SQLite bug
Tailscale and SQLite developers traced maddening corruption incidents to find the WAL-Reset data race, then uncovered a second stale expression index bug.
69
Asynchronous I/O in DuckDB: Work, Thread, Work
Starting with v2.0, scheduled for fall 2026, DuckDB will support asynchronous reads of Parquet and CSV files. This can significantly speed up queries when synchronous I/O does not saturate the available bandwidth, as is typical in EC2/S3 compute-storage setups.
70
How We Pushed CDC into Postgres
Discover Snowflake Postgres Mirroring. Learn how push-based change data capture delivers transactional replication to your data lake with zero lag.
71
We replaced Redis with MySQL for inventory reservations and it scaled
How we used SKIP LOCKED, composite primary keys, and connection visibility to hit our scale targets.
72
An all-sky map of half a million supermassive black holes
The Black Hole Mapper reaches a milestone with its first southern hemisphere optical observations, coordinated eROSITA X-ray identification, and multi-epoch tracking of accreting black holes across the universe.
73
Making Postgres 300x faster for analytics: batching, operator fusion, and SIMD
Last week we released version 0.2 of pgrust. This release was all about performance. It’s 10x faster than the previous version of pgrust. On OLTP benchmarks, pgrust is 30% faster than Postgres, and on Clickbench, Clickhouse’s benchmark for analytical databases, pgrust is 300x faster than Postgres. It’s even ahead of…
74
Beating GPT-5.6 Sol on retrieval with 100x cheaper open models
A 4B open-source model post-trained with Castform retrieved search results as accurately as GPT-5.6 Sol, while costing 100x less.
75
Three Six Mafia – Data about "6/6/6 dating" (2024)
Most guys my age have "the chat". The one with your college buddies that only exists to share memes, argue, bully, and occasionally announce that you got a promotion or had a kid. I am like most guys.
76
DuckDB – Data power tools for your laptop, now in Clojure (2023)
A well-written, *FAST* data science database for your laptop.
77
Andy Pavlo joins ClickHouse to establish ClickHouse Labs
I am excited to announce that I am joining ClickHouse, Inc. to establish and lead a new research team at ClickHouse Labs.
78
Explorative modeling: Train on the best of K guesses
What in the world is Explorative Modeling?
79
Algorithms on billion-scale graph using 10GB RAM: I love DataFusion
In a previous post, I was sceptical about using Apache DataFusion for graph analytics. However, after some thought and experimentation, I changed my mind. I have reconsidered my approach and now have a working implementation of basic graph algorithms, such as WCC, PageRank and MSSP. For example, I can identify weakly…
80
Massively Parallel Postgres Backups
PlanetScale backs up petabyte-scale sharded Postgres databases in hours using parallel infrastructure, object storage, and WAL replay.
81
Making Postgres queues scale
Lessons learned from scaling Postgres-backed durable queues for users running tens of billions of workflows per month.
82
Scaling NumPy on Free-Threaded Python
A recap on the work done in NumPy and CPython to make multi-threaded NumPy workloads scale on the free-threaded build of CPython.
83
The mean means nothing: data visualization to debug a latency problem
I was recently trying to validate some performance improvements related to lld at $DAYJOB and it was a little frustrating to see the improvements in our benchmarks but not in the live-production dashboards.
84
SQLite in Production: Optimizing WAL Mode, Concurrency, and VFS Layers
Transitioning SQLite from a local development tool to a production-grade database requires a deep understanding of its internal mechanics. This article explores how to tune WAL mode, manage busy handlers, and leverage custom Virtual File System (VFS) layers to achieve ultra-low latency.
85
PGSimCity - How PostgreSQL Works
An independent, non-commercial educational visualization of PostgreSQL internals. Not affiliated with Electronic Arts.
86
Postgres LISTEN/NOTIFY actually scales
How we optimized Postgres LISTEN/NOTIFY-backed data streams to 60K writes per second on a single Postgres server, with millisecond-scale latency.
87
The startup's Postgres survival guide
A guide to preventing Postgres from toppling over.
88
89
90
Detecting LLM-Generated Texts with “Classical” Machine Learning
.admonition { margin: .75em 0; padding: .6rem; overflow: hidden; font-size: 12px; page-break-inside: avoid; border-left: .3rem solid #42b983; border-radius: .3rem; box-shadow: 0 0.1re