Reading up on database

Using Cloudflare Workers with Hyperdrive and TanStack Start requires per-request database objects to avoid runtime errors and connection limits.

PostHog's engineer used parallel Claude Code sessions to rewrite their SQL parser, achieving a 70x speedup by fuzzing against the old ANTLR-based parser as an oracle.

Kanel generates TypeScript types from a live PostgreSQL database, offering type safety without an ORM.

A developer built a free, open-source browser-based tool that converts SQL CREATE TABLE statements into interactive ER diagrams without uploading data to any server.

DuckDB's internal architecture makes it fast and easy to use for local analytical queries, often outperforming cloud data warehouses on data that fits on a laptop.

PostHog used a Karpathy-style AI agent to find a 3-year-old ClickHouse bug where `toTimeZone()` disabled primary key usage, and the fix cut query time by 37%

Commenters debate using Postgres for durable workflows, praising its flexibility but warning it often leads to building a poor copy of dedicated workflow engines like Temporal.

Charles Leifer argues Redis lost focus by chasing every new database trend, abandoning its simple data-structure-server identity, a shift driven by VC-backed ambition that Valkey now capitalizes on by sticking to core strengths.

Honker is a SQLite extension that provides durable queues, pub/sub, and task scheduling within the same database file, enabling atomic transactional enqueue without a separate broker like Redis.

DuckDB's full-text search extension offers BM25 scoring, stemming, and stop-word removal but lacks result highlighting and phrase queries.

Honker brings Postgres NOTIFY/LISTEN semantics to SQLite by polling the WAL file, enabling cross-process push-style event delivery with single-digit millisecond latency without a broker.

The article argues that for many small-scale, read-heavy, or single-user applications, flat files like JSON can outperform a full DBMS, but warns that scaling or adding write concurrency will force you to rebuild a database.

Myflames converts MySQL EXPLAIN ANALYZE JSON into interactive flamegraph SVGs and a compact text digest that reduces LLM input tokens by 75% for query diagnosis.

The Hacker News commenters debate whether Postgres can truly replace specialized databases like Redis or Elasticsearch, with pushback on performance claims for caching and search.

The Fifth Edition of the Red Book collects opinionated readings on database research, from classic RDBMS to weak isolation and large-scale dataflow engines.

PostgreSQL 18 adds instant, zero-copy database cloning via CREATE DATABASE with FILE_COPY and WAL_LOG strategies, enabling template-based cloning for testing and CI.

SQLite uses four independent test harnesses, 100% branch coverage, and millions of test cases for reliability.