How to Build a Real-Time Indexing Pipeline With Redis and PostgreSQL 19
A production-honest walkthrough of a Postgres-to-Redis indexing pipeline, including the 8KB NOTIFY limit, pending-message reclaim, and when to use logical replication instead.
Technology Sub-category
Software
Deep dives into software engineering, open-source ecosystems, developer tooling, and modern architecture. Our technical writing covers cloud-native infrastructure, cybersecurity protocols, and programming paradigms.
Redis, Valkey, Dragonfly, and Tellstone: One Thread vs. Many, Explained Simply
Redis forked into Valkey in 2024. Dragonfly rebuilt the engine multi-threaded. Tellstone is a tiny Go experiment. Here's what actually differs.
PostgreSQL vs DynamoDB: When to Switch and How Much It Costs at Scale
AWS's own price list shows DynamoDB on-demand costing 26x more than provisioned, and RDS PostgreSQL swinging hard on Multi-AZ and reserved-instance terms.
How Discord's Gateway Handles Millions of Concurrent WebSocket Connections
Discord's gateway scaled past 12 million concurrent WebSocket users with one Erlang process per session. Here's how the real architecture works.
TypeScript 7's Go Port and scriptc Both Cut Node Out of the Build
TypeScript 7's Go-based compiler cuts full builds up to 12x, and Vercel's scriptc compiles TypeScript straight to native binaries with no Node or V8 runtime.
Claude Opus 5 Edges Past Fable 5 on the Artificial Analysis Intelligence Index
Anthropic's Claude Opus 5 scored 61 on the Artificial Analysis Intelligence Index at launch, edging past Fable 5's 60 while cutting cost per task 26%.
Zig Proposal Adds Fil-C-Style Memory Safety at a 1–6x Cost
Andrew Kelley's Zig issue #36237 proposes a new "fil" ABI using Fil-C's InvisiCaps, promising no unsafe escape hatch — for a 1–6x runtime penalty.
Polar Signals Swaps SVG For Canvas, Cuts Flame Graph Render Time 3.6x
Polar Signals rebuilt its flame graph renderer in Canvas instead of SVG, cutting isolated render time from 164ms to 46ms and reset time from 528ms to 47ms.
How a 23-Year-Old Disproved Math's Assumed Speed Limit for Multiplication
In 1960, 23-year-old Anatoly Karatsuba disproved a conjecture on the fastest way to multiply numbers, cutting operations from 1,000,000 to under 57,000.