Skip to content

WorthPosting

  • Home
  • About

Category: Software Engineering

Cat Links Software Engineering

MVCC and VACUUM in PostgreSQL: Dead Tuples, Autovacuum Tuning, and What PG18 Changed

Posted on September 10, 2026September 11, 2026

Every UPDATE in PostgreSQL is secretly an INSERT-plus-a-tombstone. The old row version stays on disk, fully readable to any transaction

Continue readingMVCC and VACUUM in PostgreSQL: Dead Tuples, Autovacuum Tuning, and What PG18 Changed

Cat Links Software Engineering

epoll Under the Hood: How Linux Event Loops Actually Work

Posted on September 9, 2026

Every high-concurrency network server on Linux eventually converges on the same bottleneck: not CPU, not memory, but the question of

Continue readingepoll Under the Hood: How Linux Event Loops Actually Work

Cat Links Software Engineering

Defending Against Supply Chain Attacks: An npm and PyPI Defense Playbook

Posted on September 9, 2026September 10, 2026

When a popular npm package turns malicious, the window between publication and detection is measured in hours, and the first

Continue readingDefending Against Supply Chain Attacks: An npm and PyPI Defense Playbook

Cat Links Software Engineering

The Rust Borrow Checker Demystified: Aliasing, Memory Model, and When to Fight Back

Posted on September 8, 2026

What the borrow checker actually enforces, what Rust’s memory model promises, and which patterns — RefCell, Mutex, ownership restructuring — resolve the common contention points. … Continue readingThe Rust Borrow Checker Demystified: Aliasing, Memory Model, and When to Fight Back

Cat Links Software Engineering

The Transactional Outbox Pattern: Reliable Events Without Distributed Transactions

Posted on September 8, 2026

Solve the dual-write problem with one extra table and SKIP LOCKED: a working Go implementation of the transactional outbox, plus the delivery-semantics gotchas that bite in production. … Continue readingThe Transactional Outbox Pattern: Reliable Events Without Distributed Transactions

Cat Links Software Engineering

Go Memory Management Under the Hood: Allocator, Stacks, Escape Analysis, and GC

Posted on September 8, 2026

Every go process you ship is quietly running a second program: the garbage collector. It shares your heap, pauses your

Continue readingGo Memory Management Under the Hood: Allocator, Stacks, Escape Analysis, and GC

Cat Links Software Engineering

SLOs and Error Budgets in Practice: Building Reliability You Can Alert On

Posted on September 8, 2026September 8, 2026

Your service was up 99.95% of the time last month. Great number — until you realize that users filed complaints

Continue readingSLOs and Error Budgets in Practice: Building Reliability You Can Alert On

Cat Links Software Engineering

Cursor-Based Pagination Done Right: Keyset Queries, Opaque Cursors, and the Pitfalls That Bite

Posted on September 6, 2026

Every API that returns a list eventually has to answer the same question: how do you hand out a million

Continue readingCursor-Based Pagination Done Right: Keyset Queries, Opaque Cursors, and the Pitfalls That Bite

Cat Links Software Engineering

Secrets Management in Practice: From Hardcoded Credentials to Short-Lived Identity

Posted on September 5, 2026September 6, 2026

Most breaches involving secrets do not involve sophisticated attacks. They involve a credential that was committed to a git repository

Continue readingSecrets Management in Practice: From Hardcoded Credentials to Short-Lived Identity

Cat Links Software Engineering

Reading EXPLAIN ANALYZE: Why Postgres Ignores Your Index

Posted on September 5, 2026

Every slow query investigation eventually reaches the same moment: you run EXPLAIN ANALYZE, and the plan makes no sense. Postgres

Continue readingReading EXPLAIN ANALYZE: Why Postgres Ignores Your Index

Posts navigation

Older posts
  • Home
  • About
Copyright © 2026 WorthPosting | Signify by WEN Themes
Scroll Up