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
19 Oct 2026
6 min read
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
14 Oct 2026
5 min read
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
09 Oct 2026
8 min read
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
07 Oct 2026
7 min read
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
01 Oct 2026
5 min read
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
28 Sep 2026
4 min read