From the archive
Friday, 20 November
Folded from 34 sources that day.
Sorted by quality and by how many sources covered it, the same for everyone.
-
How Spanner Graph detects ads fraud and abuse at Google at multi-billion node scale
Google Ads moved its anti-abuse graph from offline MapReduce to Spanner Graph, enabling real-time detection of multi-hop links between malicious accounts, payments and domains.
-
PostgreSQL 19 vs 18: Native REPACK, pg_plan_advice, Graph Myth & Production Upgrade Guide
Compares PostgreSQL 19 with 18, covering native REPACK CONCURRENTLY, pg_plan_advice, ON CONFLICT DO SELECT and parallel index autovacuum. It also warns of default changes such as JIT now being off and a startup failure from the old io_workers setting.
-
What's left in Postgres 19
PostgreSQL 19 is out after several delays and reverts. The author highlights the interesting features that remain and notes that the list of lost features is long.
-
DynaPORT modernization on Google Cloud with AlloyDB for PostgreSQL and GKE
A case study of TCS migrating the DynaPORT port terminal system from a monolith with stored procedures to AlloyDB and GKE, including moving over 1.2 million lines of code.
-
pgjumbo: A PostgreSQL Client for macOS, Windows, and Linux
pgjumbo is a free new PostgreSQL client that shows which rows, triggers and cascades a write will touch, and lets you rehearse it before committing.