Blog

The field notes.

51 field reports on systems, automation, AI, and the craft of building production software. Written by the engineer who shipped the systems — not a content team.

FeaturedArchitecture12 min read

Designing a 185-Table Database Schema: Lessons from Building Nexural

How I designed a normalized database schema for a fintech platform with 7 interconnected systems. Schema phases, RLS policies, denormalization trade-offs, and migration strategies.

Read article

51 articles

Start here

Definitive reads

Cloud Automation

Building a Fintech Platform Solo: 185 Tables, 69 APIs, 7 Systems

The full story of architecting and building the Nexural ecosystem from scratch — database design, API architecture, Stripe integration, and lessons from being the sole engineer on a production fintech platform.

Next.jsSupabaseStripeArchitecture

April 20, 2026Read Article

Architecture11 min read

Real-Time WebSocket Architecture: Patterns That Actually Scale

How I handle WebSocket connections in trading platforms — reconnection strategies, heartbeats, backpressure, and the patterns that work when milliseconds matter.

WebSocketReal-TimeTypeScriptTrading

April 18, 2026Read Article

AI12 min read

Building an AI Discord Bot for a Trading Community

How I built the Nexural Discord AI Engine — 30+ commands, GPT-4o integration, auto-moderation, and market intelligence. Lessons on AI safety in financial contexts.

Discord.jsGPT-4oNode.jsSupabase

April 15, 2026Read Article

Architecture13 min read

Stripe Integration Lessons: What the Docs Don't Tell You

Webhook idempotency, subscription state machines, dunning strategies, and the edge cases that will break your billing system if you don't handle them.

StripePaymentsWebhooksSaaS

April 12, 2026Read Article

Cloud Automation10 min read

Why I Treat My Portfolio Like a Production System

SLOs, incident drills, WAF rate limiting, and OIDC federation — why I operate my portfolio site with the same rigor as enterprise infrastructure, and what it signals to hiring managers.

SLOsOperationsSecurityAWS

April 10, 2026Read Article

Architecture10 min read

Monolith vs Microservices: Why I Chose a Modular Monolith for Nexural

The Nexural platform has 7 systems but runs as a modular monolith, not microservices. Here's why that was the right call for a solo engineer, and when I'd split.

ArchitectureMicroservicesMonolithTypeScript

April 8, 2026Read Article

Career8 min read

The Recruiter Pack: Why I Give Away My QA Playbooks

I created a downloadable ZIP with my resume, test strategies, architecture samples, and operational evidence. Here's why giving away your best work for free is the best career move you can make.

CareerRecruitingQAPortfolio

April 5, 2026Read Article

Trading14 min read

Feature Engineering for Trading: 200+ Indicators That Actually Matter

How I built AlphaStream's feature engineering pipeline — which indicators predict price movement, which are noise, and how to select features that generalize.

PythonML/AITradingFeature Engineering

April 1, 2026Read Article

Trading12 min read

Building a Backtesting Engine That Doesn't Lie to You

Most backtesting engines produce results that look great but fall apart in live trading. Here's how I built QuantumTrader's backtesting engine to be honest about performance.

PythonBacktestingTradingQuantitative

March 28, 2026Read Article

$Portfolio Risk Math Explained: VaR, CVaR, and Why Covariance Estimation Matters$

Trading15 min read

Portfolio Risk Math Explained: VaR, CVaR, and Why Covariance Estimation Matters

The math behind RiskRadar — Value at Risk, Conditional VaR, Ledoit-Wolf shrinkage, and Monte Carlo simulation explained for engineers who aren't quants.

PythonRisk ManagementTradingMathematics

March 22, 2026Read Article

Cloud Automation11 min read

Terraform Module Patterns: How I Structure IaC for Reuse

Opinionated Terraform module patterns — consistent variable naming, output contracts, testing with Terratest, and the module structure that works across teams.

TerraformAWSIaCInfrastructure

March 18, 2026Read Article

DevOps9 min read

Docker in CI/CD: The Patterns That Cut My Pipeline Time by 82%

Layer caching, multi-stage builds, BuildKit, and the Docker patterns that took my CI pipeline from 45 minutes to 8 minutes.

DockerCI/CDGitHub ActionsDevOps

March 12, 2026Read Article

Cloud Automation10 min read

AWS Cost Optimization: How I Keep a Production Platform Under $50/Month

The Nexural platform runs on AWS with Vercel, Supabase, and targeted AWS services. Here's how I keep costs under $50/month for a platform with 185 tables and real-time data.

AWSCost OptimizationSupabaseVercel

March 8, 2026Read Article

Testing11 min read

Test Strategy for Startups: What to Test When You Can't Test Everything

You have 2 engineers and 100 features. You can't test everything. Here's the risk-based test strategy I use to maximize coverage with minimal investment.

TestingQAStartupspytest

March 5, 2026Read Article

Testing12 min read

Eliminating Flaky Tests: A Systematic Approach

How I took a test suite from 10% flaky rate to under 1% — retry logic, test isolation, deterministic data, and the patterns that make tests reliable.

TestingQAFlaky Testspytest

February 28, 2026Read Article

Security13 min read

OWASP Top 10 Automated Testing: A Practical Implementation

How I built a security scanner that checks for SQL injection, XSS, broken auth, and 7 other OWASP categories automatically in CI/CD pipelines.

SecurityOWASPPythonAutomation

February 22, 2026Read Article

Career11 min read

What I Learned Building in Public as a Solo Engineer

One year of building the Nexural ecosystem, trading futures, writing a book, and documenting everything. The wins, the failures, and what I'd tell someone starting today.

CareerSolo EngineeringBuilding in PublicEntrepreneurship

February 15, 2026Read Article

Career10 min read

The Solo Engineer's Toolkit: Tools That Replace a Team

How I operate as a solo engineer building production systems — the tools, workflows, and automations that let one person do the work of a small team.

ProductivityToolsSolo EngineeringAutomation

February 8, 2026Read Article

Engineering9 min read

The Bug That Taught Me More Than Any Course Ever Did

A race condition in a payment webhook handler sat undetected for 3 weeks. When it fired, it double-charged 4 customers. Here's the full postmortem and why I now test billing code differently.

DebuggingStripeWebhooksPostmortem

February 1, 2026Read Article

Testing8 min read

Your Test Coverage Number Is Lying to You

80% test coverage means nothing if you're testing the wrong 80%. Here's how I think about coverage — not as a number to chase, but as a map of where you're blind.

TestingQACode CoverageStrategy

January 28, 2026Read Article

Career10 min read

I Read 50 Senior Engineer Job Descriptions. Here's What They Actually Want.

I analyzed 50 job postings for senior/staff engineers at companies paying $180K-$350K. The patterns are clear — and most portfolios miss them completely.

CareerJob SearchSenior EngineerInterviewing

January 22, 2026Read Article

Architecture10 min read

Why I Use Raw SQL Instead of an ORM (Most of the Time)

ORMs are great until they're not. After debugging generated queries that took 30 seconds on a 185-table database, I switched to raw SQL for the hot paths. Here's when each makes sense.

SQLPostgreSQLORMPrisma

January 18, 2026Read Article

Trading10 min read

What Trading Futures Taught Me About Writing Software

I trade ES, NQ, and CL futures every morning before I write code. The parallels between risk management in trading and risk management in software are uncomfortably similar.

TradingFuturesRisk ManagementSoftware Engineering

January 12, 2026Read Article

Cloud Automation10 min read

GitHub OIDC → AWS (No Long-Lived Keys): Cloud Automation the Right Way

How to use GitHub Actions OIDC to assume an AWS IAM role and deploy/upload artifacts without storing AWS keys. Includes least-privilege IAM, trust policy patterns, and troubleshooting tips.

AWSIAMOIDCGitHub Actions

January 10, 2026Read Article

Engineering10 min read

How I Debug Production Issues (A Real Framework, Not Guessing)

Most developers debug by changing things until the error goes away. I debug by narrowing the blast radius systematically. Here's my actual framework.

DebuggingProductionIncident ResponseEngineering

January 5, 2026Read Article

Architecture11 min read

Authentication Is Harder Than You Think

I've implemented auth 4 times across different projects. Every time I thought it would take 2 days. Every time it took 2 weeks. Here's why, and what I'd do differently.

AuthenticationSecuritySupabaseJWT

December 28, 2025Read Article

Architecture9 min read

The Architecture Decision Nobody Writes Down

We spend weeks choosing between Kafka and RabbitMQ but never document why. ADRs take 15 minutes and save months of 'why did we do this?' conversations.

ArchitectureDocumentationADRDecision Making

December 20, 2025Read Article

Architecture9 min read

Rate Limiting: The Feature Nobody Thinks About Until It's Too Late

Your API works perfectly at 10 requests per second. At 10,000, it falls over. Here's how I implement rate limiting that protects without annoying legitimate users.

SecurityAPIRate LimitingArchitecture

December 15, 2025Read Article

Engineering10 min read

How to Review Your Own Code (When There's Nobody Else)

Solo engineering means no code reviews. I've developed a self-review process that catches 80% of what a second pair of eyes would find. It starts with stepping away.

Code ReviewSolo EngineeringBest PracticesGit

December 8, 2025Read Article

Engineering10 min read

The Case Against Over-Engineering (From Someone Who's Done It)

I once built a plugin architecture for a system that never needed plugins. 3 weeks of abstraction layers for a feature nobody asked for. Here's how I learned to stop.

ArchitectureOver-EngineeringYAGNIBest Practices

December 1, 2025Read Article

Architecture12 min read

Supabase in Production: What I Wish I Knew Before 185 Tables

After a year of running Supabase in production with 185 tables, here's the honest review — what's incredible, what's frustrating, and what almost made me switch.

SupabasePostgreSQLDatabaseProduction

November 22, 2025Read Article

Security10 min read

Environment Variables: The Security Hole in Every Startup

Your .env file has your database password, Stripe secret key, and AWS credentials. It's in a Slack message, a developer's laptop, and probably a Docker image somewhere. Let's fix that.

SecurityEnvironment VariablesAWSDevOps

November 15, 2025Read Article

Architecture11 min read

How I Structure a Next.js Project (After 6 Production Apps)

Folder conventions, data fetching patterns, component organization, and the file structure that scales from MVP to 185 database tables without becoming unmanageable.

Next.jsReactTypeScriptProject Structure

November 8, 2025Read Article

DevOps10 min read

Monitoring That Actually Tells You Something

Dashboards with 47 panels where everything is green aren't monitoring. They're decoration. Here's what I actually monitor and why most alerting is useless noise.

MonitoringSREAlertingDevOps

November 1, 2025Read Article

Engineering9 min read

Git Workflows That Don't Make You Want to Quit

Trunk-based vs GitFlow vs GitHub Flow — I've used all three. Here's what actually works for solo developers and small teams, and why most Git workflows are over-complicated.

GitVersion ControlWorkflowDevOps

October 25, 2025Read Article

Architecture10 min read

Why Most API Documentation Is Useless (And How to Fix Yours)

If your API docs list every endpoint but don't show me how to complete a task, they're a reference manual disguised as documentation. Here's what developers actually need.

APIDocumentationFastAPIDeveloper Experience

October 18, 2025Read Article

Career9 min read

The Myth of the 10x Developer

There are no 10x developers. There are developers with 10x clarity about what to build and what to skip. The difference is decision-making, not typing speed.

ProductivityCareerEngineering CultureDecision Making

October 10, 2025Read Article

Engineering10 min read

Building for the Next Engineer: Code That Outlasts You

Every system I've built is designed to run without me. That's not luck — it's intentional design for operability. Here's what I do differently.

Engineering CultureDocumentationOperabilityBest Practices

October 1, 2025Read Article

Career12 min read

Running an LLC as an Engineer: What Nobody Tells You

I founded Sage Ideas LLC. Here's the stuff the 'start a consulting business' articles leave out — taxes, insurance, contracts, and why I keep a personal financial runway.

LLCFreelancingBusinessCareer

September 22, 2025Read Article

Career10 min read

The Technical Interview From Both Sides of the Table

I've been the candidate sweating through system design questions and the interviewer evaluating them. The gap between what interviewers look for and what candidates prepare is enormous.

InterviewingCareerSystem DesignTechnical Interview

September 15, 2025Read Article

Engineering10 min read

The Automation Mindset: If You Do It Twice, Script It

I have 47 shell scripts, 6 CI workflows, and a cron job that texts me when my SSL cert is expiring. Here's the mindset behind automating everything.

AutomationScriptingDevOpsProductivity

September 8, 2025Read Article

Career11 min read

Writing a 120,000-Word Book While Building Software Full-Time

I wrote a 24-chapter book on trading while building the Nexural platform. Here's how I managed both, what nearly broke me, and why writing made me a better engineer.

WritingProductivityTradingPersonal Growth

September 1, 2025Read Article

Engineering10 min read

Error Handling That Respects Your Users

Your users don't care about stack traces. They care about what went wrong and what to do next. Here's how I design error experiences that help instead of frustrate.

Error HandlingUXTypeScriptReact

August 25, 2025Read Article

Engineering9 min read

Why I Document Every System I Build (And the Template I Use)

I have a 1-page template for system documentation. It takes 30 minutes to fill out and saves 30 hours of 'how does this work?' questions. Here's the template.

DocumentationArchitectureBest PracticesTemplates

August 18, 2025Read Article

Career12 min read

Everything I Shipped This Year (And What I'd Cut in Hindsight)

A year-end retrospective: 7 systems, 185 tables, 51 blog posts, a book, and a trading career. What was worth it, what wasn't, and what I'm building next.

RetrospectiveYear in ReviewCareerBuilding in Public

August 10, 2025Read Article

API Testing12 min read

Building a Production-Ready API Testing Framework

Learn how I built an API testing framework that reduced flaky tests from 10% to <1% using intelligent retry logic, Pydantic validation, and session pooling.

PythonAPI TestingpytestPydantic

January 15, 2024Read Article