MC/TECH
DATABASES · ARCHITECTURE

Write skew, snapshot isolation and what SERIALIZABLE actually catches

The anomaly that snapshot isolation allows, why it passes every test you write, and the three ways to fix it: serializable with retries, locking the right rows, or materializing the conflict.

Pedro Pereira Pedro Pereira 19 Oct 2026 6 min read
MC/TECH
CI/CD · SECURITY · SUPPLY CHAIN

GitHub Actions: pull_request_target, OIDC and SHA pinning

Four small workflow changes that close most of the serious holes in a typical GitHub Actions setup: untrusted checkouts, script injection, long-lived cloud secrets and mutable action tags.

Pedro Pereira Pedro Pereira 14 Oct 2026 5 min read
MC/TECH
AI · SECURITY

Prompt injection through tool results and why agents need privilege separation

The dangerous prompt injection is not what the user types, it is what the agent reads. How the confused deputy problem shows up in LLM agents and which designs actually limit the damage.

Pedro Pereira Pedro Pereira 09 Oct 2026 8 min read
MC/TECH
INFRASTRUCTURE · KUBERNETES · PERFORMANCE

CPU limits, CFS throttling and the latency you cannot see in averages

A container can be throttled while its CPU graph shows 20% usage. Here is how CPU limits really work, how to measure throttling, and what it does to a multi-threaded runtime.

Pedro Pereira Pedro Pereira 07 Oct 2026 7 min read
MC/TECH
SECURITY · SUPPLY CHAIN · .NET

Dependency confusion and NuGet package source mapping

How an attacker can get their package installed instead of your internal one, why it works, and the NuGet feature that closes the gap.

Pedro Pereira Pedro Pereira 01 Oct 2026 5 min read
MC/TECH
DATABASES · PERFORMANCE

Postgres HOT updates, fillfactor and the hidden cost of indexes

Why adding one index to a frequently updated table can multiply your write cost, and how heap-only tuples and fillfactor decide whether that happens.

Pedro Pereira Pedro Pereira 28 Sep 2026 4 min read