Articles
Two Strikes, Edits and the Owner Exemption
A ban policy that's strict for spammers and fair to members: strikes counted per deleted message, edits scored again, the owner never banned, and a one-line command to undo a ban.
Read more
Exactly-Once (Almost) on Telegram Long Polling
An update ledger, deterministic action keys and an alert outbox in SQLite, so a crash never deletes, bans or counts a strike twice. Plus the one gap Telegram's API leaves open.
Read more
System-1 Moderation: Five Yes/No Questions and Two Thresholds
Five independent yes/no policy questions, one probability each, delete and review thresholds in code, and a human for the grey zone. Why the "is false" clauses matter more than the thresholds.
Read more
From Brainstorm to PIO to a One-Shot Agent Build
A chat brainstorm became a five-section Problem–Integrations–Outcome spec, and the spec became 550 lines of code and 12 tests in one agent session. What worked, and what I'd do differently.
Read more
A Telegram Community Bot That Runs Itself
How I built a Telegram bot that approves join requests, deletes spam with a fast classifier, bans on the second strike and posts one quiet nightly digest. One Python file, no dependencies, running on a homelab. The series overview.
Read more
Every Integration Behind a One-Person Lead Engine: The Map
Apify, Companies House, Lighthouse, a sending tool with no API, Cloudflare Workers and KV, Mailjet, Cal.com, ntfy, Cloudflare Web Analytics, Search Console, PageSpeed and Bing: what each one does, how it connects, which credential it needs, and where each is explained in detail.
Read more
Bing Webmaster Tools in 15 Minutes: Three Ways to Verify, One Gotcha
Bing sent one of my sites more visitors than Google did, and I'd never registered it. Verifying three sites three ways: a DNS CNAME (it must not be proxied), a meta tag, and the XML file, plus what to keep in place afterwards.
Read more
Page 1, Zero Clicks: Giving Astro Articles a Separate SEO Title
Six of my articles ranked on Google's first page and got no clicks. Their titles were written as stories, not as answers. A three-line change to an Astro content collection gives each article a search title while the page keeps its headline.
Read more
A Monthly Website Check in One Command: Web Analytics + Search Console
One make target pulls Cloudflare Web Analytics and Google Search Console for every site I run and prints a single report. What it shows, how to tell bots from people, why sampled numbers jump between runs, and the one list worth acting on.
Read more
Change One Thing: A Subject-Line A/B Test With 60 Leads per Arm
After two weeks and zero positive replies, the rule said change one thing, and the subject line is the cheapest. The two variants, why everything else stays frozen, and a judging rule for a test far too small for statistics.
Read more
880 Listings, 125 Leads: Where a Compliant B2B List Shrinks
One week's scrape of 880 map listings ended as 125 emails. A stage-by-stage table of what dropped out and why, which losses are the law doing its job, which rules I keep despite the cost, and the one lever that actually moves the yield.
Read more
In Cold Email, Sending Capacity Runs Out Before Leads Do
Two warmed inboxes at 15 emails a day each, one follow-up per lead: that's 15 new companies a day, not 30. The arithmetic of daily caps, why my follow-ups and new emails collided, and how I size a weekly batch now.
Read more
The Sunday Outbound Review: One Hour, One Decision
How I review a week of cold email every Sunday: export, log the replies by hand, rebuild the funnel, read three numbers, change one thing, and build Monday's batch. Plus what two weeks of sending actually returned.
Read more
Shipping a Landing Page Fully as Code: From an Empty Folder to a Live Domain
A small static landing page, its security headers, a sample PDF, the hosting config, the canonical-host redirect, the custom domain and the email DNS checks, all as files and commands. The checklist, and the traps on the way.
Read more
Cloudflare Pages Projects Are Now Workers: What Changed for a Static Site
Running 'wrangler pages project create' gave me a Worker with static assets, a workers.dev address, a generated config pointing at a missing script, and a server adapter added to my static site. What I kept, what I reverted, and the config that works.
Read more
Lighthouse Numbers Vary: Making Speed Claims You Can Defend
The same website measured 4.5 seconds, then 12, then 13. If an email says '12.9 seconds' and the recipient sees 3, you've lost them. Why Lighthouse varies, and the three rules I use before putting a speed number in front of anyone.
Read more
Cold Email Personalised With a Website Audit, Not an AI Opener
Most cold email 'personalisation' is an AI-written line about the company. I used something the recipient can verify: one measured problem on their own website. How the finding is chosen, why fine sites get no email, and the plain-text template.
Read more
Matching Businesses to Companies House Without False Positives
The UK company register has a free API, and a naive name match will happily pair a vet practice with a different company that shares the words 'vet', 'care' and the city. The rules that removed every wrong match in my first run.
Read more
Finding a Business Email on Its Own Website (Including the Ones Cloudflare Hides)
No enrichment database: a few pages of the business's own site, mailto links, plain text and Cloudflare's obfuscated addresses, then strict rules about which address to keep. 16 of 26 small business sites had one.
Read more
From Google Maps to a UK Lead List: Apify, Business Websites and Companies House
A three-step pipeline that turns a niche and a city into a short list of UK companies with a real business email and a reason to write to them: scrape, enrich, audit. What each step keeps, what it throws away, and the numbers from a first run.
Read more
The Outbound Pipeline, End to End: Maps Listing to One Honest Email
Four stages, three scripts and two external services: a maps scrape, enrichment from the business's own website and the company register, an audit batch that finds one real problem, and a sending tool that only sees the final CSV. What each stage keeps, drops and costs, and why there's no crawler in it.
Read more
Keep Outbound Away From Your Inbound Engine
I already had an opt-in lead engine: forms, double opt-in, retention, drips. Adding cold outreach next to it meant deciding what must never touch it. Separate brand, domain, sender and data, and why each one matters.
Read more
Is B2B Cold Email Legal? The EU, the UK and the US for a Small EU Business
Before writing a scraper, I checked where I could legally send a cold email from Poland. Spoiler: not to Poland. What the EU, UK and US rules require, what 'public business data' doesn't change, and what the fines look like.
Read more
Querying Cloudflare Web Analytics with the GraphQL API
My analytics dashboard said 3 visits a day; the script wasn't even on the pages. How I fixed the setup, then pulled visits per site, top pages, referrers and countries from Cloudflare's GraphQL API, and what the numbers revealed.
Read more
A Google API Key vs a Service Account JSON: What Each One Unlocks
I had a PageSpeed Insights API key and assumed it would read Search Console. It can't. What an API key can do, what a service account key can do, where OAuth fits, and what each found on my own sites.
Read more
Google Search Console API with a Service Account, Step by Step
Google Search Console API with a service account JSON key: verify domains, grant access, then pull clicks and queries, submit sitemaps, inspect URLs in Python.
Read more
A Multi-Site Inbound Lead Engine for a One-Person Business: The Whole Series
Every article from building one lead engine across six sites: lead magnets, same-origin forms, consent and double opt-in, email, a pull-only homelab, privacy, and auditing my own sites, each in a line or two.
Read more
Cloudflare Today, Open Source When Needed: A Lead Engine Built to Swap
Why my multi-site inbound lead engine runs on Cloudflare Pages, Workers and KV, what that buys a one-person business, and the exit plan for every piece: what would replace it, and what keeps the swap cheap.
Read more
A Contact Link Instead of an Email in Every Footer
Now that every site has a contact form I can choose to answer, does the email address need to be on every page? Where I removed it, where it has to stay, and the render-blocking script it was costing.
Read more
Share Cards as Code: Rendering og:images with Playwright (JPEG, Not WebP)
One script renders the 1200×630 share cards for three sites and every ebook from HTML, with each site's own fonts. Why the cards are JPEG even though WebP is smaller, and how pages fall back to the site card.
Read more
Checking og:image Properly: Size and Format from the First Bytes
My audit said three sites had a share image. Two shared a 248×56 logo, one a 675 KB square JPEG named .png. How the audit now downloads the image and reads its real format and size from the bytes, safely.
Read more
Lazy-Loading the Cal.com Embed with IntersectionObserver
A booking calendar near the bottom of a landing page was loading about 1 MB of JavaScript on first paint. Twenty lines wrap Cal.com's snippet so it starts only when the calendar is close.
Read more
A Content Security Policy on Cloudflare Pages, Tested in a Real Browser
Adding CSP, HSTS and X-Frame-Options with a _headers file, finding every third party a site really loads, overriding the policy for one path, and catching violations with Playwright before deploy.
Read more
My LCP Was Render Delay: Self-Hosting Google Fonts with Fontsource
Lighthouse said 3.8 s LCP on mobile. The breakdown said almost all of it was render delay from render-blocking font CSS, loaded twice. Self-hosting the fonts brought it to 2.4 s.
Read more
A Missing 404 Page Hid 273 Broken Links
On Cloudflare Pages, a static site without 404.html answers every unknown URL with the homepage and a 200. Link checkers see nothing wrong. Here's how I found out, and the remark plugin that fixed the links.
Read more
I Ran My Website Audit on My Own Sites: 71 to 99
Eating my own dogfood: the free website audit on this site, the ebooks library and the consulting page. The tool had bugs first, then the sites did.
Read more
Android Signing Keys vs Bitcoin Seed Phrases
Understand how an Android PKCS#12 signing key differs from Bitcoin recovery words, passphrases, addresses, and the trust models used by web and desktop apps.
Read more
GitHub Releases and Obtainium for Android APK Updates
Sign APKs in GitHub Actions, publish them as GitHub Releases and update with Obtainium: keep the package ID and signing key stable so every release installs.
Read more
Building a Native Android DJI Tello Controller with Kotlin
How I moved a DJI Tello controller from a Rust desktop prototype to a native Kotlin Android app with Compose, UDP control, H.264 video, and safer flight handling.
Read more
Why a 9 MB Tauri Binary Becomes an 81 MB AppImage
A practical explanation of Rust and Tauri binary size, Cargo target folders, Linux system dependencies, and the portability cost of AppImage bundles.
Read more
A Failed Check Is Not a Bad Score
Why my website audit reports a check that couldn't run as 'not checked' instead of a low score — and the bug in my own report that taught me the difference.
Read more
A Client-Ready HTML Report Without AI
My audit tool's emailed report reads like I wrote it by hand. It's rules and a template: every sentence comes from a measured number. Here's how, and why.
Read more
Pure-Rust Face Detection Without OpenCV or ONNX Runtime
How I added CNN face detection to a Tauri application with pure Rust, compiled model weights, AVX2, and a bounded latest-frame worker.
Read more
Emailing a Full Website Report: Confirm First, Then Crawl
How my audit tool emails a deep report: a signed start link proves the address, a background queue crawls the site, and the report link lives 7 days.
Read more
From Five Lead Silos to One Lead Hub: Before and After
How six sites went from KV, formsubmit, Formbricks, Cal.com and PocketBase to one lead hub — what I gained, what I gave up, and exactly what I capture now.
Read more
A Bind-Mounted Repo Turns Runtime Files Into Git Files
My audit tool's production container mounted the git repo, so live leads were written into a tracked CSV. How I moved runtime data out and pulled safely.
Read more
Debugging a Pasted Secret: The Key Was 65 Characters
A server-to-server call kept failing with 403. A probe that prints only the key's length and hash prefix showed one extra character from a paste.
Read more
Building a DJI Tello Desktop Controller with Rust and Tauri
How I built a working DJI Tello desktop controller with Rust, Tauri, Vue, UDP telemetry, H.264 video, recording, and flight-safety boundaries.
Read more
Server-to-Server Leads: A Key for Kinds Only the Backend May Send
My audit tool's backend posts leads to the same forms Worker as my browser forms. Why that one kind needs a shared key, and how the forward stays best-effort.
Read more
One Checkbox, Two Problems: Unbundling Consent on a Lead-Magnet Form
My website-audit form had one required checkbox that bundled marketing consent and promised an email that never existed. How I split it and made the code match.
Read more
Cloudflare Email Obfuscation Fooled My Deploy Check
What Cloudflare's data-cfemail attribute is, why curl and grep can't see the email behind it, and ten lines of Python that decode it (a one-byte XOR).
Read more
Cal.com Bookings Into My Own Pipeline: a Signed Webhook and a PAID BOOKING Alert
Verifying Cal.com's webhook signature in a Cloudflare Worker, storing only scheduling facts, and getting an urgent phone alert the first time someone pays.
Read more
Replacing a Formbricks Qualifier with My Own Form
Why I moved my consulting qualifier from a hosted Formbricks survey to a same-origin form that lands in the same list as every other lead.
Read more
Deploy a Direct-Upload Cloudflare Pages Site from a Git Worktree
wrangler pages deploy uploads whatever is in the folder. Build from a git worktree with npm ci so drafts and stale files never go live on a direct-upload site.
Read more
A Weekly ntfy Digest With Counts Only
One low-priority notification a week from my homelab: new leads, confirmed subscribers, drips, suppressions and spam filtered — numbers only, never an address.
Read more
A Mailjet Event Webhook That Only Suppresses Permanent Failures
Feeding Mailjet bounces, spam complaints and blocks into a hashed do-not-send list from a Cloudflare Worker: what to suppress, what to ignore, how to authenticate.
Read more
Writing the Privacy Page Found a Retention Bug
Updating my privacy pages for double opt-in exposed newsletter sign-ups with no expiry. Fixing it meant retention that depends on subscription status.
Read more
A Spam Blocklist That Stores Instead of Drops — and Why I Deferred Turnstile
Scripted sales pitches slipped past my form honeypot. A sender blocklist in the Worker stopped them with zero visitor friction; Turnstile can wait.
Read more
Cloudflare Error 1010 Silently Blocked My Own Homelab Alerts
My homelab's failure alerts never arrived: Cloudflare blocked Python urllib's default User-Agent with error 1010 before the request reached my ntfy server.
Read more
Validate Mermaid Diagrams Before You Push Them
Check every Mermaid block in your Markdown with mmdc before pushing: parse errors with line numbers, PNG renders to judge layout, fixes for tangled diagrams.
Read more
Shell Traps While Watching Logs: grep Buffering and pkill -f Killing Itself
Two shell traps that cost me a test run: a log file that stayed empty because grep buffers, and pkill -f matching its own shell. Causes and reliable fixes.
Read more
Testing Form States with Playwright Route Mocking (Without Sending a Single Email)
How I test every message a form can show, success, check your inbox and the no-JS return, by mocking the forms endpoint in Playwright against a static build.
Read more
From Form to First Drip: Testing an Email Pipeline on Production
How I tested double opt-in and a drip sequence end to end on live sites without emailing real visitors: an allow-list, the checks at each hop, and surprises.
Read more
One Sender Adapter, Two Providers: Switching Mailtrap and Mailjet Without Code Changes
How my Worker and Python hub send through Mailtrap or Mailjet behind one switch, and the provider quirks: auth, success checks, tracking and headers.
Read more
Mailjet Held My Emails: Validating a Sending Subdomain with Cloudflare DNS
SPF and DKIM were right, yet Mailjet held every email. The missing piece was a domain ownership TXT record, placed one level too high by Cloudflare.
Read more
GDPR-Friendly Lead Capture for a Small EU Business
How I capture leads across three sites under GDPR and Polish law: site profiles, recorded consent, double opt-in, retention, erasure and what I keep off the site.
Read more
Architecture Decision Records for a One-Person Business
Why I keep ADRs and learning notes as a solo developer, the format I use, three real examples, and how honest checklists stop me building the wrong thing.
Read more
Debugging Notes from a Week on Cloudflare (and Docker)
Fourteen real Cloudflare Pages, Workers, wrangler, Docker and Python gotchas, each as symptom, cause and fix, collected while shipping lead capture.
Read more
One Canonical Address Per Site: Apex vs www and pages.dev Redirects on Cloudflare
A Cloudflare Pages site answers on apex, www and pages.dev. How I made one host canonical with custom domains, Redirect Rules, Bulk Redirects and a curl check.
Read more
Publish Future-Dated Posts on Cloudflare Pages With a Cron Worker
Static sites only publish posts dated in the past at build time, and Pages only builds on push. A tiny cron Worker and deploy hooks fix scheduled posts.
Read more
A Pull-Only Homelab: Mirroring Cloudflare KV to SQLite Without a Tunnel
How I back up a Cloudflare Workers KV lead inbox into SQLite on a homelab with outbound-only HTTPS, a read-only token, retention rules and a safety brake.
Read more
Mailpit vs Mailtrap vs listmonk: What Each One Is Actually For
Mailpit catches test email locally, Mailtrap delivers it, listmonk sends newsletters. When to use each, plus SPF, DKIM and DMARC for a sending subdomain.
Read more
The Python Email Header Bug That Silently Breaks One-Click Unsubscribe
Python's email package folds a long List-Unsubscribe URL into an RFC 2047 encoded-word that mail clients can't use. How I found it in Mailpit and fixed it.
Read more
A Drip Email Engine in Standard-Library Python
Sequences as TOML files, a send ledger that never emails twice, last-moment suppression checks and a swappable SMTP/Mailtrap sender, with no dependencies.
Read more
A Do-Not-Send List That Stores No Email Addresses
How to build an email suppression list keyed by SHA-256 hashes in Cloudflare KV: written by unsubscribes, checked before every send, kept after erasure.
Read more
Double Opt-In on Cloudflare Workers with Stateless Signed Links
Build double opt-in and one-click unsubscribe in a Cloudflare Worker with HMAC-signed links, no token table, and pages that mail scanners can't trigger.
Read more
Self-Hosting ntfy Behind a Cloudflare Tunnel, Locked Down
Run ntfy on a homelab behind a Cloudflare Tunnel with deny-all access, an admin user for your phone and a write-only publisher token for your sites.
Read more
Retention as a KV TTL: Let the Platform Enforce Your Privacy Policy
Set Cloudflare KV expiration per form kind so your privacy policy's retention periods are enforced by the platform, not by a cleanup job you'll forget.
Read more
One Forms Worker for Every Site: Same-Origin Routes over Cloudflare Pages
How a single Cloudflare Worker serves the contact forms of several Astro and Hugo sites same-origin, using zone routes that take precedence over Pages.
Read more
Contact Forms with Cloudflare Workers KV and Self-Hosted ntfy Alerts
A form backend in about a hundred lines: store each lead in Workers KV first, then push a privacy-friendly ntfy alert to my phone without slowing the visitor.
Read more
app.domain or domain/app? Where to Put a Lead-Magnet PWA (and What It Means for SEO)
Why my Pyodide solver lives on app.multibodysystemsdynamics.com while static Astro pages do the ranking, and how deep links connect the two.
Read more
Ship a Python Library as an Installable Web App with Pyodide
How I run an open-source Python solver in the browser with Pyodide: a pinned, hash-checked wheel, a Web Worker, an atomic service worker and Cloudflare Pages.
Read more
Selfhosted Connectivity: Wi-Fi, LAN Inventory, TR-181, and EasyMesh
A structured homelab connectivity note: Wi-Fi measurements, LAN discovery, TR-471 throughput, TR-181 observability, OpenWrt, and EasyMesh.
Read more
Shipping Custom Sites: The Practices I Keep Across Every Project
The best parts of six real sites, in one checklist: static first, legal pages as Markdown, forms without third parties, security headers, quality gates and more.
Read more
Checking HTTPS Like a Visitor: Certificates, Redirects and TLS Versions in Node
How my website audit checks HTTPS with Node's tls module: certificate validity and expiry, TLS version, the http-to-https redirect, and never penalising what it couldn't see.
Read more
Expiring Report Links: Why My Audit Reports Don't Live Forever
How the website audit tool shares full reports through random, 24-hour tokens instead of guessable IDs, and deletes run files after a week.
Read more
From Scores to Sentences: How My Website Audit Writes a Plain-English Diagnosis
How the audit tool turns Lighthouse JSON, HTML checks and security reports into one readable diagnosis line and a severity-sorted list of the top issues to fix.
Read more
Running Strangers' URLs Safely: The Guards in My Website Audit Tool
A public audit tool fetches whatever URL a stranger types. The guards I use: SSRF checks with DNS, redirect limits, rate limits, a concurrency cap and execFile.
Read more
What My Website Audit Checks and How the Score Is Computed
Every check in my free website audit — Lighthouse, technical SEO, HTTPS and headers, links, latency — and how the weighted grade is built, limits included.
Read more
How My Website Audit Tool Works: Astro, Express and Parallel Shell Audits
The architecture behind a free website audit tool: an Astro front end, an Express API, shell audit phases running in parallel and a tokenized report link.
Read more
Pressure-Testing an Offer I Never Launched: A Heat-Pump Sensor Kit
The first offer through my landing blueprint: a rented sensor kit and a calibrated feasibility report for homeowners deciding on a heat pump and solar. It scored 34 out of 50. The damaging admissions were the best part; the guarantee and the value stack were the weakest. A review, with what I'd change.
Read more
Above the Fold in Five Seconds: The Checklist I Wrote
The first screen of a landing page gets about five seconds. My checklist for it: a headline about the result, a 'without' line of specific pains, one call to action with a verb, a guarantee in 15 words under the button, proof only if it's real, and a five-second test with a stranger.
Read more
A Landing Page Pipeline That Refuses to Ship a Bad Offer
I wrote a blueprint for going from a business idea to a live landing page: an intake call, an offer review based on Hormozi's frameworks with a kill switch, one site.md file that drives every word on the page, and a schema that won't pass a page without a guarantee or damaging admissions. What's in it, what I actually built, and what's still on paper.
Read more
Free Ebooks as a Filter, Not a Lead Magnet
My ebooks are free, HTML only, with no email gate. The plan for turning readers into paid 30-minute calls is built to disqualify most of them: a qualifier with hard gates, honest endings for people who aren't ready, and context from what they read. The design and the reasoning.
Read more
A Free Ebook Library as a Static Site
Eight ebooks and about a hundred chapters, written in Markdown and published as one static site: charts from JSON code blocks, Mermaid and KaTeX, search with no server, and a plugin that fixes links between chapters. It started as a container on a home server. Then I asked what the container was actually doing.
Read more
Why I Dropped Formbricks From My Lead Funnel
Formbricks is a good survey tool, and I'd automated it as code. For my web audit's lead funnel it was still the wrong tool: survey-shaped data isn't CRM-shaped, I already owned the form, routing was five lines of code, and two stores drift. What replaced it, and when Formbricks is the right call.
Read more
Keep the Scraper Off the Internet, and Off Everything Else
An image scraper for a real estate editor became a small FastAPI service on an internal-only Docker network. A good start, but the public site had an unauthenticated proxy to it, and the scraper fetched any URL it was given. Internal-only isn't safe if something public forwards to it. The design, the server-side request forgery risk, and the fix.
Read more
A Public AI Chatbot Is a Public Bill
The property chatbot on a real estate site called OpenAI on every message, from an endpoint anyone could reach. CORS and a rate limit were added, with a test script. A later review found the origin check could be fooled, requests without an Origin skipped it, and the rate limit trusted a header the client sets. What each control really does, and the fix.
Read more
I Replaced Decap CMS With My Own Editor, and Forgot to Lock the Actions
A real estate site needed an owner-friendly editor. Decap CMS fought back, so I built a small one: static public pages, server-rendered edit pages, Markdown files on disk, protected by Cloudflare Access and a password. Reviewing it later, the pages were protected and the write endpoints behind them weren't. What I built, the gap, and the fix.
Read more
An Agent Skill That Checks Instead of Trusting
With surveys as JSON, an AI agent can write the forms. The question is how to stop it shipping a broken or dishonest one. A small skill tells the agent what to read and which commands to run; a validator script decides, with errors that block and warnings that need a human. What it checks and why.
Read more
Formbricks as Code: Surveys as JSON and a Small CLI
Clicking through a survey builder for every lead form doesn't scale, and it leaves no history. A small Python CLI wrapped in make turns Formbricks surveys into JSON files: list, export, create as draft, publish, collect responses, close. The commands, the lifecycle, and three API gotchas.
Read more
A Track-Day HUD From Action-Camera Telemetry
Paid apps overlay speed and lap times on track-day videos. My action camera already records GPS. With exiftool, a Python notebook and Matplotlib I extracted it, compared laps and two drivers, and rendered a HUD onto the video. What worked, the metadata gotcha, and what I'd build now.
Read more
Auth for a One-Person SaaS: PocketBase, Firebase or Code It Yourself
In 2025 every side project needed login, and I tried them all: PocketBase, Firebase Auth, Logto, a hand-written FastAPI flow, and forward auth in front of a proxy. The difference between who you are and what you may do, why hiding content in a static site protects nothing, and which option I'd pick now.
Read more
Rent or Buy, as a Spreadsheet Person
A mortgage model in Python: French amortization, net worth that starts below zero, a property seen as a stock with rent as its dividend, and why a flat that rose 50% since 2020 hasn't really moved once inflation is counted. What I built in 2025 and what I'd model differently now.
Read more
R Stocks, Three Years Later: Rebuilding It in Python With a Friend
In 2025 the R Shiny stock dashboard from 2022 became PyStonks: a yfinance notebook first, SQLite storage, Streamlit with PocketBase login, then FastAPI. What changed with a second person on the project, why the data model came before any screen, and the honest maths on converting users.
Read more
From One Wedding to a Micro-SaaS
It started as a favour: a place for guests to drop their photos from one wedding. Turning it into a product meant a domain, an offer, unit economics on a napkin, and a rebuild where everything that could be static was static. What I made in 2025 and what I'd do differently now.
Read more
Everything I Built With LLMs in 2024, and What I'd Keep
A multi-model chat app, a YouTube summarizer, chat-with-your-PDFs, chat-with-a-dataframe, scrape-and-ask, function calling and structured outputs, all self-hosted in containers. Looking back, the frameworks churned and two API features turned out to matter: structured outputs and tool calls.
Read more
Raspberry Pi, Mini PC or Cloud VPS? I Measured Them
Idle power, yearly electricity cost and real Docker build times on a Raspberry Pi 4, an Orange Pi 5, an Intel N95 mini PC and Hetzner cloud servers. The same image took an hour on a Pi and 45 seconds on the mini PC. What the numbers say about where to self-host.
Read more
The First Websites I Built for Other People
In 2024 I rebuilt websites for people close to me: a psychologist paying $80 a month for a marketplace page, a real estate agent whose competitors took a second to load, a knitting club, a family craft shop and a café menu. What each needed, the process that repeated, and what I'd do differently now.
Read more
Interactive Physics: A Double Pendulum and a Slider-Crank You Can Play With
Two small Python apps from 2023: a double pendulum that shows chaos, where tiny changes in the start give completely different paths, and a slider-crank that shows why a piston never moves at constant speed. How they were built, and why today I'd make them run in the browser.
Read more
The Serverless Bill That Sent My App Home
A free, open-source Python app on Google Cloud Run cost me around $500 in a month. How it moved to Docker at home behind a Cloudflare tunnel, with access rules instead of open ports, and the checks I now run before deploying anything serverless.
Read more
A Weather Planner for Bikepacking, Built From Free Data
After getting caught in cold rain on a bike trip across Europe, I built an open-source app: click a place on a map, see what the weather is usually like each month and what's forecast this week. Dash, Leaflet, Meteostat and Open-Meteo, and what I'd build differently today.
Read more
Why I Moved Off WordPress, and When You Shouldn't
In 2022 I moved my own blog from WordPress to Hugo. Later, helping with a small business site, a simple analytics script turned out to need a paid plan. What I measured (about 500 ms per request against 100 ms static), how a migration actually goes, and when staying on WordPress is the right call.
Read more
Why should you care about DuckDB?
People call DuckDB the 'opposite of Redshift' not because they do different things,
Read more
Rill Architecture Documentation
A deep dive into the Rill BI-as-code platform architecture, technology stack,
Read more
Mastering Healthcare Analytics
Dive into the advanced AI tools within DataNova that automatically detect patterns.
Read more
The Discovery Questions I Ask Before Any Data Project
Most failed dashboards fail before the first query: nobody agreed what decision they support. The questions I ask before building a report, a pipeline or a model, grouped by problem, users, decisions, data, delivery and success, and how they map to a one-page Problem–Integrations–Outcome spec.
Read more
Consumer Insights Analytics
How to create a Consumer Insights Analytics with AI Powered ChatBot
Read more
What 5% Inflation Does to a Lifetime of Savings
A six-input model I built as a small Shiny app: save a fixed amount every year, keep it in cash, retire, and see how long it lasts. With no inflation the savings last past 97. With 5% a year they run out around 75. The model, its assumptions, and why a calculator beats an argument.
Read more
A Stock Dashboard From Free Data, Shipped as a Container
R Stocks: an open-source R Shiny dashboard for prices, dividends, indexes, commodities, currencies and inflation, built from four free data packages. Why one Dockerfile for both x86 and a Raspberry Pi took longer than the app, and what I'd change today.
Read more
Mastering AI-Powered Insights with DataNova’s Smart Analysis Tools
Dive into the advanced AI tools within DataNova that automatically detect
Read more
Advanced Data Cleaning Techniques in Excel
Learn how to clean and prep your data for analysis using DataNova’s intuitive
Read more
Integrating DataNova with Google Sheets for Seamless Collaboration
Discover how to use DataNova’s cloud integration to bring your Excel analytics
Read more
Marketing Analytics Insights
How to use data to optimize marketing campaigns and ROI.
Read more
Customer Segmentation for Real Estate
How to create a Real Estate Customer Segmentation with AI Powered ChatBot
Read more
Shopify Analytics Insights
How to leverage Shopify data for better business decisions and growth.
Read more
Interesting Telecom Concepts
Exploring the fundamental concepts of telecommunications, from cable modems
Read more