BLOG & KNOWLEDGE BASE

Architecture.AI Systems.Growth Engineering.

Deep technical content on building sovereign infrastructure, private AI agents, PostgreSQL at scale, and full-stack systems design.

< EXPLORE_KNOWLEDGE />
// CONTENT_PILLARS

What I Write About

< INFRASTRUCTURE />

Self-hosted alternatives to SaaS, Coolify deployment guides, n8n automation patterns, PostgreSQL schema design, and Docker production setups.

< AI_SYSTEMS />

Private LLM deployment, RAG pipelines with pgvector, LangChain vs bare API patterns, and AI agents that run on your own hardware.

< GROWTH_ENGINEERING />

Server-side conversion tracking, CAPI setup, attribution modeling, CAC/LTV calculators, and funnel analytics that survive iOS14.

Topic Index

🏗️

Sovereign Infrastructure

Why self-hosted beats SaaS past $1M revenue. Coolify, n8n, Supabase, and the stack for infrastructure independence.

🤖

Private AI Agents

Running Llama, Mistral, and custom fine-tunes on your own VPS. No OpenAI data risk. Full control.

🐘

PostgreSQL Deep Dives

JSONB vs relational, pgvector for semantic search, Row-Level Security for multi-tenancy, and asyncpg patterns.

📡

Server-Side Tracking

Facebook CAPI, Google Enhanced Conversions, and TikTok Events API. Attribution without cookies or pixels.

FastAPI Patterns

Async architecture, dependency injection, Pydantic v2, background tasks, and deployment on Coolify.

🌐

Astro & Frontend

SSR with Astro, React islands, Tailwind design systems, and building Lighthouse 100 marketing sites.

🧮

Calculator Architecture

ROAS, CAC, LTV, cohort analysis. How I build interactive financial tools that capture leads and educate buyers.

🔐

Security & DevOps

SSH hardening, Docker secrets, PostgreSQL RLS, and zero-trust architecture for agencies handling client data.

Featured: The Sovereign Stack Guide

The most common question I get after a strategy call: "What would you actually build for us?" The answer is almost always the same stack, adapted to the problem.

The Core Stack

Backend: Python 3.12 + FastAPI + asyncpg + PostgreSQL 16. This handles everything from lead capture to AI agent orchestration to billing webhooks. One language, one database, full async.

Automation: Self-hosted n8n on a $10/mo VPS (or shared with the main server). Replaces Zapier entirely. Handles CRM syncs, email sequences, Slack notifications, and webhook relay without per-task fees.

Frontend: Astro SSR for marketing pages, React for dashboards and interactive tools. Tailwind for design system. Zero client-side JavaScript unless needed.

Infra: Coolify on a Hetzner or Digital Ocean VPS. Git-push deploys. Auto SSL. Docker Compose per service. Total cost: $50–$200/mo depending on scale, vs. $3,000–$5,000/mo in SaaS subscriptions.

AI: Ollama + pgvector for private LLM operations. OpenAI API only for non-sensitive tasks. Fine-tuned Llama for client-specific workflows.

Built From Real Projects, Not Tutorials

Every post on this blog comes from a system I have actually deployed in production. No tutorial repos. No "example" codebases. If I write about a PostgreSQL optimization, it is because I ran EXPLAIN ANALYZE on a 50M-row table and found the winning index.

I have built systems for media agencies, solar installation companies, law firms, e-commerce brands, and SaaS startups. The patterns repeat. The mistakes repeat. The solutions I write about are the ones that closed the gap between "it works in dev" and "it works at scale."

50+
Systems Referenced
8yr
Production Experience
$10M+
Revenue on These Stacks

Want This Applied to Your Stack?

Reading about architecture is useful. Having it built for you is better.

Book a Strategy Session

// LATEST_POSTS

RSS
ALL (67)growth (19)development (16)infrastructure (14)ux (4)ai (3)postgresql (3)fastapi (2)marketing (2)frontend (1)ecommerce (1)security (1)tracking (1)
Mar 16, 2026 ai 2 min

Vector Search in Postgres: Preparing Your Data for AI

You do not need a dedicated vector database to build AI features. I use pgvector inside PostgreSQL to store embeddings right next to relational data.

pgvector postgresql ai
Mar 11, 2026 ai 1 min

Deploy Private LLMs on Your Own Hardware

Run Llama, Mistral, and custom fine-tunes without sending data to OpenAI. Full guide with Ollama + pgvector.

llm ollama pgvector
Mar 24, 2025 ai 1 min

Anti-Pattern: Using Zapier for Core Business Logic

Webhook reliability on commercial iPaaS platforms sits around 97%. That 3% failure rate means lost leads. Business logic belongs in your backend.

zapier n8n anti-pattern