Alexander
Safiullin

Telegram content automation · multi-channel publishing

Architected and built a production-oriented Telegram content automation system serving multiple Telegram channels through several workflow-specific AI agents. The backend owns drafts, versions, media, scheduling, publication, retries, and persistence; agents perform generation, transformation, scraping, localization, and content preparation.

• Deterministic backend around AI agents — TanStack Start / grammY / Turso architecture keeps business-critical state transitions outside the agent runtime.
• Plugin-based workflow architecture where Telegram topics bind to workflow-specific agent_code values, letting multiple agents share one bot, one operator surface, and one draft lifecycle.
• Draft lifecycle services — creation, versioning, rendering, media mutation, scheduling, unscheduling, publication, discussion routing, comment-driven revisions.
• Typed tRPC control-plane contract shared by the backend and Bun-compiled agent callback CLIs, cutting schema drift between workflow agents and the application core.
• Drizzle / Turso schemas for drafts, versions, media, projections, topic bindings, scheduled jobs, recurring schedules, idempotency keys, voice intake, and workflow-owned state.
• Telegram Mini App editor — React + TanStack Query + Mantine, Markdown preview, signed auth, media-aware editing, save / schedule / unschedule flows.
• Reliability: QStash signature verification, command idempotency, callback de-duplication, projection-backed reply routing, OpenClaw webhook session persistence fixes.
• Effect / Effect.TS Telegram userbot RPC services for media-album publishing — typed errors, session validation, exclusive operation gating, timeouts, platform failure modes.
• Scheduled generation workflows including Playwright-based scraping of external sources and human-approved draft publication.

Audio learning app · podcasts & long-form foreign-language study

Media-heavy language-learning app combining podcast listening, transcription, AI explanations, quizzes, Anki workflows, Telegram bot/WebApp integration, and offline-friendly mobile playback. Both Telegram users and a standalone web app served from the same TanStack Start codebase.

• Full-stack audio learning app with authenticated server functions, Telegram bot/WebApp integration, podcast ingestion, episode playback, standalone web routes.
• Podcast & personal-audio workflows — Podcast Index ingestion, Yandex Disk browsing, persisted libraries, playlist navigation, dynamic artwork theming, mobile player state.
• Transcription architecture with range coverage tracking, lock management, provider-backed STT, persisted segments, R2 audio chunks, retry behavior, usage/cost event recording.
• Offline-friendly playback — Serwist service workers, Browser Cache API, range-aware audio caching, Dexie / IndexedDB persistence, TanStack Query persistence.
• AI-assisted learning — contextual transcript explanations, audition/quiz workflows, Anki note generation with model metadata sync and audio media upload.
• Go audio proxy with JWT validation and Go FFmpeg worker with OpenAPI codegen and R2 chunking; Cloudflare image resizing worker.
• Automated Fly.io / Cloudflare deploys with GitHub Actions path filters, SOPS secrets, version tags, health checks, Playwright smoke tests.
• Layered test coverage across Bun unit tests, Vitest UI/integration tests, and Playwright mobile smoke / E2E scenarios.

Telegram Mini App + standalone web · Qi Men Dunjia walking recommendations

Chinese metaphysics application computing auspicious walking directions and time windows using Qi Men Dunjia and BaZi. Runs both as a Telegram Mini App and as a standalone web app from one shared TanStack Start codebase.

• Dual-runtime Qi Men web app for Telegram Mini App and standalone browser use, sharing route tree, state architecture, and business logic across both environments.
• Layered client-state architecture — TanStack Query (server), Jotai (orchestration), IndexedDB / sessionStorage / Telegram CloudStorage (persistence).
• Client-side Qi Men / BaZi stroll search engine over shared domain libraries — ordinary results and best-of-week/month pipelines.
• Read-through best-results cache with contextKey reuse checks and in-flight deduplication to avoid duplicate 30-day calculations across route mounts.
• Better Auth extended with Telegram OIDC, Telegram native auth, Google login, account merge flows, Drizzle-backed auth/session schemas.
• Storage-first settings hydrating from IndexedDB or Telegram CloudStorage, with optional server sync gated by subscription tier.
• Offline-capable after first load — Serwist service worker for app-shell / assets, TanStack Query IndexedDB persistence for Qi Men reference content.
• Fly.io CI/CD with GitHub Actions path filters, SOPS/age secret staging, tag-derived versions, Sentry source-map upload, runtime env validation.

Interactive Qi Men Dun Jia calculator & educational site

Production-oriented Chinese metaphysics calculator and content site combining Astro content delivery with Solid.js interactive calculator islands and shared TypeScript domain packages.

• Interactive Qi Men Dun Jia calculator and educational site — Astro, Solid.js, Panda CSS, reusable TypeScript domain packages.
• Client-side chart state restoration and URL synchronization — calculated charts can be shared, restored, and migrated from legacy links.
• Offline-capable calculator behavior — PWA precaching, IndexedDB-backed TanStack Query persistence, local saved-chart storage.
• Saved-charts repository — local persistence, record sanitization, search, metadata editing, sharing, restoration, Playwright regression coverage.
• Better Auth guest sessions with protected Astro server actions, transparent unauthorized-session recovery, unit tests for retry/concurrency behavior.
• Shared Drizzle/Turso schemas for auth, Telegram bot users, subscriptions, referrals, promo broadcasts, Stripe webhook idempotency.
• CI/CD automation — Turborepo, Docker, Fly.io deployment, SOPS secret staging, change-based workflow filters, deployment version tags.
• Reusable domain libraries — BaZi, Qi Men, lunar calendar utilities, metadata rules, generated reference info across a pnpm / Turborepo monorepo.