Hi, I'm Andrés

Software engineer writing about what actually works in production.

Software engineer & solutions architect writing about AWS, .NET, and modern web development.

Latest posts

.NET & C# August 3, 2026 · 11 min read

Scaling Out SignalR: In-Memory State Behind a Load Balancer

Extra servers behind a load balancer silently split our SignalR presence into one reality per server. The fix: a Redis backplane plus shared state.

#signalr #dotnet #redis

Databases July 28, 2026 · 10 min read

Postgres Index Types Explained: B-tree, GIN, BRIN, and the Operators That Pick Them

A practical tour of PostgreSQL index types with real query plans: how B-tree, GIN, and BRIN work, what operator classes are, and how the operators in your WHERE clause decide which index you need.

#postgresql #indexes #performance

Databases July 27, 2026 · 10 min read

Postgres JSON vs JSONB: Storing Data Chunks for AI Processing

The real differences between JSON and JSONB in PostgreSQL, how each one stores your data, when plain JSON wins, and how JSONB earns its place holding chunk metadata in an AI pipeline.

#postgresql #jsonb #json

Security July 13, 2026 · 8 min read

How I Caught a Bot Swarm Hiding in My PostHog Analytics

A real story of detecting bot traffic with PostHog: how a viewport that did not match the screen size gave the crawlers away, and how I pinned them again once they patched that tell using user agent, OS, synthetic referrers, and sub-second event bursts.

#posthog #bot-detection #analytics

Tooling July 11, 2026 · 13 min read

Claude Code as an Orchestrator: Using Cheaper Models to Ship Real Projects

A practical guide to running Claude Code like a small team: a strong orchestrator model that delegates design, implementation, review, and testing to cheaper, faster subagents. With ready-to-copy .md files.

#claude-code #ai-agents #tooling

.NET & C# February 15, 2026 · 12 min read

Middleware in .NET Explained: How the Pipeline Actually Works (and Common Mistakes)

Understand how the ASP.NET Core middleware pipeline works under the hood, learn to write custom middleware correctly, and avoid the mistakes that cause silent bugs in production.

#dotnet #csharp #middleware

Databases October 16, 2025 · 18 min read

PostgreSQL Mistakes You're Probably Making (And How to Fix Them)

A comprehensive guide to avoiding common PostgreSQL pitfalls that can compromise performance, data integrity, and maintainability.

#postgresql #databases #sql

.NET & C# September 29, 2025 · 4 min read

Why You Should Start Using Visual Studio Code for Your .NET Projects

A step-by-step walkthrough of creating, running, and serving a .NET Web API entirely from Visual Studio Code, with no full Visual Studio required.

#dotnet #csharp #vscode