GoKawiil
Tech News
A team including Eric Ridge and Patrick Reynolds has released TIN, a full-text search extension for Postgres, now generally available for Postgres and Neki databases. It adds a single index type and query operator supporting boolean, phrase, span, fuzzy, wildcard, and regex matching, plus BM25-ranked and count queries.
An independent researcher used supervised fine-tuning and agentic reinforcement learning to train a small 4B-parameter open-weights language model to generate PostgreSQL execution plans. On a set of 113 join-heavy queries, the tuned model cut latency by 44.7% on average compared to Postgres's default planner, even though the base model initially failed to produce valid plans for 99 of those queries. The project also involved building a custom measurement rig to reduce caching noise and a modified GRPO reinforcement learning method for scoring plans in a noisy environment.
The team behind Neki, released in platform preview, ran a benchmark scaling from 5 to 512 shards and reached 118,538,803 sustained queries per second over 16 minutes, using 1.22 PiB of data across 512 Postgres primaries and 480 routers. The test consisted only of single-shard point-select reads by primary key, with no writes, joins, or cross-shard queries, and per-shard throughput actually rose to 231,521 QPS at full scale, well above the initial 200k target.
PlanetScale introduced Neki, a system that adds a router, sidecars, and control plane on top of standard Postgres to enable horizontal scaling across many real Postgres shards. It supports online resharding, shard splitting, high-availability clusters per shard, topology-aware connection pooling, and coordinated schema changes without downtime.
PlanetScale unveiled Neki, a new distributed database built on real Postgres instances running across shards, now available as a platform preview. The company says it drew on eight years of experience running large sharded MySQL clusters to design a system that keeps standard Postgres semantics rather than mimicking compatibility. Neki uses a router that speaks the Postgres wire protocol to direct queries to the appropriate shard.
A new open-source project called EterDB extends PostgreSQL with the ability to reverse individual transactions, including updates, deletes, or entire batches, even after they have been committed. It tracks dependencies between reads and writes so that changes relying on a bad transaction are also caught, and it retains an append-only history that allows recovery of data from weeks or months earlier.
Ampbase's founder JP explained how the company replaced a traditional relational database with Tigris, an object storage system built on FoundationDB, using only two storage primitives. To make this work, Ampbase had to manually implement unique constraints, transactions, indices, and history tables, features a normal database engine provides automatically.