AI-assisted dev & automation studio: one person working with AI coding tools. Based in UTC+3. Fixed-price fixes and small builds.
A small Node API plus a client data layer that reproduces the classic stale-session bug: a cache key without the user ID, a cache that isn't cleared on logout, and a per-user API response marked public. It includes the fix (with a React/TanStack Query version) and tests that fail on the buggy build and pass on the fixed one.
A message like quote acme 2 hours becomes a priced quotation with the client's rate, a loyalty discount for repeat clients and VAT. It gets an auto-incremented number, is rendered from a template, logged to a sheet, and a summary is sent back as the reply. It parses the WhatsApp Cloud API webhook format. Google Drive, Sheets and WhatsApp sending sit behind small adapters (offline in this demo).
Covers 12 locations, containers and vehicles, with status dropdowns, colour coding, a dashboard by location and status, a "not checked in 30+ days" counter, and a printable manifest per location or vehicle. Works in any Excel version and in Google Sheets. Sample data is fictional.
The step-by-step order I use to get a broken WordPress site back up safely: recovery mode, debug log, isolating plugins and themes with WP-CLI or SFTP, PHP version and memory limits, checksum verification, and when to restore from backup.