Tutorials

Practical how-to guides with commands and code. Each one is a pattern I use, simplified so you can apply it.

Reading supplier bills into an ERP with an LLM OCR pipeline: a design that survives production

Design a supplier bill OCR pipeline with a vision model, strict JSON, validation rules, a review queue, idempotency and honest monthly accuracy checks.

2026-09-08 · 1,768 words

Odoo: how to stop two work orders being booked on the same machine at the same time

Add a server-side overlap constraint to Odoo 17 work orders, back it with a PostgreSQL exclusion constraint, and give planners a drill-through to the clashes.

2026-09-08 · 1,843 words

How to write an llms.txt for a business website

An llms.txt is a short Markdown map of your site at /llms.txt with an H1, a one-line summary and linked sections. Here is the format and a full worked example.

2026-09-08 · 1,575 words

How to check whether ChatGPT, Perplexity and Google AI Overviews can read your website

Read robots.txt for GPTBot, OAI-SearchBot and PerplexityBot, fetch your homepage with curl as each bot, check the raw HTML, or run one Python audit script.

2026-09-08 · 1,603 words

Google Workspace single sign-on for Odoo, with two factor authentication and role based access

Configure Google sign-in for Odoo 17 with auth_oauth, enforce 2-Step Verification in Workspace, map groups to job roles and keep a break-glass admin.

2026-09-08 · 1,758 words

A WhatsApp AI sales agent that hands leads to your ERP: the architecture

A WhatsApp webhook, a session store keyed by phone, a model with four tools, a catalogue it cannot contradict, a hand-off rule and a lead created in Odoo.

2026-09-08 · 1,570 words

A PostgreSQL major-version upgrade with no unplanned downtime: the checklist

Upgrade a production PostgreSQL database to 16 using logical replication, a rehearsed cutover and a rollback window, then rebuild backups and monitoring.

2026-09-08 · 1,700 words