Piotr
Ponikiewski

Cross-platform time-tracker for teams built on Tauri 2 + Rust. Offline-first architecture with local SQLite as the source of truth and async sync to Supabase via an outbox queue.

• Outbox pattern with LWW merge, local writes guarantee operation without connectivity; conflicts resolved deterministically on reconnect
• Multi-tenant RBAC: workspace isolation enforced via Postgres Row-Level Security policies; invitations via single-use tokens
• Rust side-car handles code-signed auto-updates and GitHub Releases delivery

PWA for managing prayer groups built on React 19 + Supabase. The core domain problem, deterministic member position rotation, is modelled as a pure function over a state snapshot, testable without UI.

• Rotation algorithm as an isolated pure function, decoupled from the data layer and covered by unit tests
• Authorization via Row-Level Security: Supabase policies are the sole enforcement boundary, no additional middleware
• Feature-based architecture with Playwright e2e coverage on critical paths (auth, rotation, invitations)

Privacy-by-design personal budget manager on Tauri 2: no data ever leaves the user's disk. Persistence through SQLite with a type-safe Drizzle ORM schema and automatic migrations on startup.

• Drizzle ORM as single source of truth for schema, migrations generated from TypeScript, zero hand-written SQL
• Discriminated union for entry types: separate category sets for income vs. expense enforced at the type level
• Zero network dependencies at runtime, Tauri IPC is the only boundary between UI and the data layer