From the archive
Tuesday, 17 November
Folded from 39 sources that day.
Sorted by quality and by how many sources covered it, the same for everyone.
-
Distributed primary keys
Compares five primary key designs for tables written by several regions under logical replication. Per-region sequences can reuse ids after failover, while uuidv7() and composite keys avoid coordination.
-
Redict deprecated in favor of Valkey
Drew DeVault has deprecated Redict, his Redis fork from after the 2024 license change, and recommends Valkey, which is compatible. He advises against returning to Redis because its contributor license agreement enables future relicensing.
-
Running the full server-side Datasette Python app in the browser with service workers and Pyodide
Datasette Lite has been rewritten with service workers and now runs almost identically to the server-side Datasette. Links can load specific Datasette versions, SQLite builds and plugins.
-
PostgreSQL in Docker for Production: Volumes, Shared Memory, Pooling & Backups
A checklist of Docker defaults that break containerized Postgres, including the 64 MB /dev/shm limit and the PostgreSQL 18 PGDATA path change, with a safe 17-to-18 upgrade procedure.
-
Apache Cloudberry 2.2.0 released on the PostgreSQL 14.10 kernel
Apache Cloudberry 2.2.0 moves its MPP kernel to PostgreSQL 14.10, includes many upstream CVE fixes, adds six extensions, and supports Rocky Linux 8 to 10 and Ubuntu 24.04.