Articles about programming
Ran Code Remediation on 7 pentest findings. All received GitHub PRs with accurate fixes — from parameterized queries for SQLi to full credential hashing refactors. NAT Gateway required for VPC-to-GitHub access.
Hands-on verification of the Aurora DSQL SQLx connector for Rust. Connection code drops from ~50 lines to one, and the OCC retry helper works — but default max_attempts=3 falls short under high concurrency.
A canonical duplication error triggered a full SEO audit. Missing sitemaps, absent structured data, no OG images for TILs — a record of pitfalls found and fixed on a Next.js App Router site with locale routing.
Build macOS/Linux dotfiles with XDG compliance, 1Password SSH integration, and a test script. Covers the design decision to use copy-based deployment over symlinks, and how CLAUDE.md enables AI-assisted maintenance.
How I added a lightweight TIL (Today I Learned) content type by defining a new Velite collection, reusing existing components with minimal adaptation, and integrating into search — all without a single new dependency.
Three patterns worth reusing: Velite's default(false) for safe schema evolution, a MAX_TAGS overflow indicator, and conditionally rendering sections that hide themselves when empty.
A simple metadata-based scoring algorithm that surfaces related articles using shared categories and tags. No ML, no full-text search — just weighted scores and existing helper functions.
Individual category and tag pages existed, but there was no way to browse them all. The interesting part: zero new data-layer code was needed — existing helper functions composed directly into new pages.
Each blog post now gets a unique OG image at build time using Next.js's opengraph-image.tsx convention and Satori. The biggest gotcha? Satori only supports inline Flexbox styles — no Tailwind, no className.
I added a hamburger menu, responsive spacing, and touch targets to a Next.js blog. The real lesson was discovering that CSS backdrop-filter silently turns parent elements into containing blocks for fixed-position children.