391
Why LLMs Can't Write Q/Kdb+: Writing Code Right-to-Left
In my previous post I showed how LLMs struggle with coding in q/kdb+; having immediate feedback loops using the q-MCP server does help a…
New
The latest blog posts to take off on Hacker News. 4,224 posts.
392
Analyzing database trends through 1.8M Hacker News headlines
We analyzed 1.8 million Hacker News headlines spanning February 2007 to June 2025 to examine database engine popularity trends. Using camelAI connected to a ClickHouse database, we uncovered which databases the HN...
393
Postgres LISTEN/NOTIFY does not scale
Learn why Postgres LISTEN/NOTIFY doesn't scale for high-throughput use cases and what architectural alternatives Recall.ai uses in production.
394
Speeding up PostgreSQL dump/restore snapshots
How targeted improvements helped us speed up bulk data loads and complex schemas.
395
Mini NASes marry NVMe to Intel's efficient chip
I'm in the process of rebuilding my homelab from the ground up, moving from a 24U full-size 4-post rack to a mini rack. One of the most difficult devices to downsize (especially economically) is a NAS. But as my needs have changed, I'm bucking the trend of all datahoarders and I need less storage than the 120 TB (80…
396
Data on AI-related Show HN posts
The idea for this article didn't exist in my brain before this morning. But there I was, scrolling the New page and even more tired of all the AI-related Show HN posts than usual. I was confident that their numbers were multiplying and wanted proof. Exactly how much more AI crap is on my lawn compared to last year?
397
PlanetScale for Postgres
PlanetScale now supports Postgres
398
People Keep Inventing Prolly Trees
A novel data structure has been invented four times now, with three different names. We think that's a good sign.
399
Scaling our observability platform by embracing wide events and replacing OTel
Read how we scaled our observability platform from 19PB to 100PB and 500 trillion rows by replacing OpenTelemetry with a native ClickHouse-to-ClickHouse pipeline, embracing wide events and cutting CPU usage by 90%.
400
Building agents using streaming SQL queries
Table of Contents Agents Need to Interact With LLMs Agents Should Be Event-Driven Agents Need Context Agents Require Memory When SQL Is Not Enough Parting Thoughts AI Agents have improved in leaps …
401
402
A Python-first data lakehouse
Prototype in Marimo, deploy in Bauplan. Learn how to build production-grade pipelines from notebooks with a Python-native stack. No handoffs, no rewrites.
403
Time Series Forecasting with Graph Transformers
Introduction to Kumo Relational — the relational foundation model for predictive AI on relational data
404
Working on databases from prison
How Preston Thorpe went from a prison cell and a college program to a full-time database engineering role at Turso, working on the SQLite rewrite in Rust.
405
Model Once, Represent Everywhere: UDA (Unified Data Architecture) at Netflix
Introducing UDA, the knowledge-graph-based architecture that translates conceptual domain models into consistent schemas and data…
406
Wrong ways to use the databases, when the pendulum swung too far
Disclaimer: This story took place when I was a junior developer for a previous employer ages ago. Some details might be fuzzy, and goes without saying this is entirely from my own POV so take everything here with humor and a grain of salt.
407
How we decreased GitLab repo backup times from 48 hours to 41 minutes
Learn how we tracked a performance bottleneck to a 15-year-old Git function and fixed it, leading to enhanced efficiency that supports more robust backup strategies and can reduce risk.
408
Jepsen: TigerBeetle 0.16.11
TigerBeetle is an Online Transactional Processing (OLTP) database built for double-entry accounting with a strong emphasis on safety and speed. It builds on the Viewstamped Replication (VR) consensus protocol to offer Strong Serializable consistency. Unlike general-purpose databases, TigerBeetle stores only accounts…
409
I made a search engine worse than Elasticsearch (2024)
Integrating my BM25 pandas search library, SearchArray, into BEIR, in order to embarass myself in public.
410
Conformance checking at MongoDB: Testing that our code matches our TLA+ specs
Testing code fidelity with TLA+ specs at MongoDB. Explore conformance checking experiences and agile modelling in distributed systems.
411
How to Store Data on Paper?
How to print my voice? How to put music on paper? How to print an executable program? All this boils down to storing digital data on paper. This is also called paper data storage . Arrived in this domain from poetry, I’ve been investigating the area for some time. Here is what I found.
412
Valkey Turns One: Community fork of Redis
Valkey is not only thriving, but now outperforming Redis 8.0 in real world benchmarks.
413
ClickHouse raises $350M Series C
ClickHouse, Inc., a leader in real-time analytics, data warehousing, observability, and AI/ML, today announced it has raised $350 million in Series C financing.
414
HTAP is Dead
Databricks offers a unified platform for data, analytics and AI. Build better AI with a data-centric approach. Simplify ETL, data warehousing, governance and AI on the Data + AI Platform.
415
Just make it scale: An Aurora DSQL story
AWS Senior Principal Engineers, Niko Matsakis and Marc Bowes, take us inside Aurora DSQL's development: scaling write operations without two-phase commit, overcoming garbage collection hurdles, and embracing Rust for both data and control planes.
416
Postgres IDE in VS Code
We are excited to announce the public preview of the brand-new PostgreSQL extension for Visual Studio Code (VS Code), designed to simplify PostgreSQL...
417
KumoRFM: A Foundation Model for In-Context Learning on Relational Data
Introduction to Kumo Relational — the relational foundation model for predictive AI on relational data
418
Loading Pydantic models from JSON without running out of memory
Pydantic’s JSON loading uses a huge amount of memory; here’s how to reduce it.
419
Litestream: Revamped
Bringing in what we learned from LiteFS
420
A simple search engine from scratch
*if you include word2vec.