Knowledge base • Updated regularly

Practical patterns for real-world development

Most development happens inside existing systems. This is a working knowledge base of scripts, patterns, and experiments shaped by real constraints: messy data, limited schema control, and the need to be reliable.

3 Patterns documented
SQL Primary focus
Open Source & free
Patterns View all patterns →

Fixing data problems safely

Reversible data fixes, verification queries, and safe update patterns that won't blow up in production.

sqldata-fixoperations

Making systems talk to each other

Sync pipelines, validation stages, retries, and failure handling for integrations that don't break at 3am.

apipipelinesintegration

Making operational systems understandable

Status models, visual clarity, and progress tracking without the noise. When things go wrong, know why.

uxopsobservability
Quick Reference Browse all snippets →

SQL Fix: Bulk Update with JOIN

Update multiple rows using a temporary table and JOIN. Useful when you have a list of IDs and new values.

sqldata-fix
Experiments See all experiments →

Flocking Algorithm (Boids)

Implementation of Craig Reynolds' Boids flocking simulation in Three.js

threejsalgorithmsimulation

Three.js: Animated Node Graph

3D visualization of connected nodes with physics simulation

threejsvisualizationwork-in-progress
Tools

Browser-based utilities

Small tools for common development tasks. JSON helpers, format converters, and quick testers — all running locally in your browser.

JSON Formatter
Base64 Encoder