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