The Stats Sync Pattern: Aggregating Metrics Across Distributed Services
Platform metrics live across multiple services on different machines. A bash cron job, Tailscale, and a POST endpoint solved it.
Technical insights, research notes, and practical knowledge about building AI-powered solutions.
Platform metrics live across multiple services on different machines. A bash cron job, Tailscale, and a POST endpoint solved it.
I replaced SSH + grep with 17 MCP tools that let an AI agent deploy, debug, query databases, and auto-fix common errors.
Next.js App Router was opening a new database connection per request. Here's how a Prisma singleton proxy fixed it before PostgreSQL ran out of slots.
Project updates lived in email threads, files in Google Drive links, invoices in Stripe emails. I built a portal to centralize all of it.
Mixing monthly retainers and one-time project fees in Stripe, tracking MRR accurately, and building tax-ready accounting exports.
An embedded Claude chatbot on my homepage qualifies leads and generates structured Project Discovery Reports — all before I've said a word.
Next-Auth's config churn finally pushed me to build a centralized auth service. One service, five providers, zero per-app configuration.
No Kubernetes. No Docker Swarm. Just Linux primitives, systemd, and a symlink swap that takes less than a second.
One command now creates a Linux user, database, auth service, storage bucket, Nginx config, SSL cert, and systemd unit. Here's how I built it.
Third-party SaaS sprawl was costing me time, money, and sanity. Here's how I consolidated everything into platform-level services.

Client AI · Online

Hey, I'm Page.
Tell me what you need. I'll point you to the right person — or tell you if we're not the right fit.
Powered by Claude · Responses may vary