Publications on delivered projects, automation approaches, and practical engineering solutions.
How order picking verification was automated: an employee sends invoice and product photos, OpenAI compares them and returns a structured JSON conclusion, and the Telegram bot returns the result per item.
Read postA practical PoC of fully automated EN->RU translation with Qwen 2.5 32B on Mac: CPU mode was too slow, GPU mode was production-viable, with quality control for problematic chunks.
Read postA practical DeepSeek OCR 2 test on a maritime charter book: many headings, links, and footnotes, with final assembly into a single LaTeX file.
Read postI rebuilt an email sync process from an external API in n8n: removed conflicting parallel runs, added export-readiness waiting and API rate-limit handling, and merged load + cleanup into one stable flow.
Read postWe converted raw real estate deals into a practical Supabase schema, linked projects and developers, added time analytics fields, sped up queries with indexes, and prepared a flat mart for Excel and external API use.
Read postI automated translation of 3,000 route names and descriptions from Excel into Russian using n8n and OpenAI, with intermediate quality checks, preserved file structure, and staged execution (test, 500 rows, full run).
Read postA case study about building a list of city districts across Russia: I first expected a single SQL query against "КЛАДР", then tried "ГАР" (a ~50 GB archive with download and unpacking constraints), and ultimately delivered a complete res...
Read postSequence diagrams as code make it easier to track changes and control versioning; they also let you quickly create new diagrams from existing code.
Read postPractical notes on Unicode and UTF-8 in Perl: core concepts, encodings, Encode APIs, and common pitfalls when processing text.
Read postStory of building a weather archive for Patagonia summits: parsing mountain-forecast, storing daily data in CSV, and publishing chart views for temperature, wind, and snow.
Read postA practical example from 2014: moving a complex ceiling-sales pricing workflow from manual calculations/Excel to a browser calculator with instant recalculation, hints, and fewer errors.
Read postA practical case about processing several hundred thousand e-commerce images: watermark generation, resizing, AWS S3 storage, and a custom Perl + ImageMagick pipeline from the pre-Cloudflare Images era.
Read post