IotaHub
Front-end Developer
Transferred to the product team after working on integrations, building and refining customer-facing interfaces.
IotaHub
Transferred to the product team after working on integrations, building and refining customer-facing interfaces.
IotaHub
Integrated systems, APIs and data flows, translating operational needs into reliable implementations.
PUCPR · Campus Toledo
Pontifical Catholic University of Paraná.
14 documented systems

Terminal database workbench
A terminal workbench for PostgreSQL, MySQL, MariaDB and SQLite, with a TUI, a command line and an MCP server with guardrails for AI agents.
It brings a SQL editor with Vim mode and live diagnostics, a results grid, a command palette, schema diff, EXPLAIN plans drawn as trees, import, export and backup, plus connections over TLS, SSH tunnels and proxies. A DELETE without WHERE on production only runs after typing the connection's name, read-only connections are enforced on the server too, and AI agents only write through approved, timed grants. It is local-first with no telemetry, and ships through Homebrew, Scoop, the AUR, .deb/.rpm packages and a Windows installer.





Modular commerce platform
A modular delivery operations ecosystem: multi-tenant storefront, dashboard, API, native client, module manager and local printing bridge.
It covers catalogs and variations, cart, delivery, real-time orders, customers, business hours, cash flow, accounts, purchasing, inventory, suppliers and staff. The Rust API centralizes authentication, multi-tenant rules, auditing, rate limiting, files and integrations; local modules keep checkout and printing close to daily operations.





Offline-first agricultural research
A platform for planning field trials and collecting evaluations, photos, QR data and location even while offline.
The PWA/Capacitor client keeps a local operation queue with synchronization, conflict and quota states. A Rust/Axum backend coordinates PostgreSQL, SeaORM, S3 files and OpenAPI; a separate master app manages companies, plans, billing, storage and auditing without exposing each tenant's agronomic data.




Class representative election
A mobile-first app for candidate registration and class representative voting with a controlled voting window and duplicate prevention.
Route Handlers keep Supabase credentials on the server, validate uploads and normalize voter names. Database constraints, rate limiting and time-window checks reinforce the public flow without an unnecessary admin panel.


Registration, PIX and check-in
A scientific event registration system with multiple attendees per order, pricing tiers, PIX payments and manual confirmation.
The server calculates pricing and capacity, generates a BR Code with CRC16 and stores receipts in a private bucket. The admin area brings together orders, attendees, tiers, check-in, receipts, status, notes and CSV exports.


Conversational collection via WhatsApp
A Python engine that turns WhatsApp conversations and voice notes into structured agricultural harvest records.
The agent rewrites a complete draft on every turn, transcribes audio, validates cities and seed varieties against hybrid BM25/fuzzy catalogs, persists conversations and collections, and tracks delivery and follow-ups. FastAPI and PostgreSQL provide auditing and continuity.
Construction financial management
A management system for tracking projects, materials, labor, investors, contributions, documents and construction progress.
Reports consolidate finances, ROI and profit allocation. Server Actions, Zod validation, resource/action permissions and PostgreSQL RLS policies protect operations and documents per user.

Educational web security CTF
A progressive lab with 60 exercises covering DevTools, API inspection, HTTP requests, authentication, cookies and JWT.
Each challenge explains the concept, uses analogies, provides reproducible steps and validates a flag. Progress stays in the browser, with four levels separating fundamentals, inspection, controlled mutations and sessions.



Distributed KVM for Windows
A LAN-only app for sharing keyboard, mouse and clipboard across Windows PCs, including multi-machine workspaces.
The Rust/Tauri architecture uses mDNS discovery, QUIC with TLS and Ed25519 identities, Win32 capture/injection and a bilingual React/Mantine UI. Its internal lab exposes probes and input-pipeline metrics for diagnosing real hardware.



Computer vision study
A study project that visually recognized a bite in a fishing minigame and triggered a key press.
The work explored image augmentation, bite/idle classification with YOLOv8, PyTorch/CUDA training, screen-region capture and real-time inference with thresholds, consecutive frames and cooldown. It was built only for learning and is archived; automation must respect the game's terms.

Visual factory planning
A visual editor for designing Satisfactory factories and tracking flow, efficiency, clock speed and power in real time.
Machines, splitters, mergers, storage, text and frames form interactive graphs. Magic Planner builds production chains automatically; projects can be saved, published, forked and exported using data extracted from the game's official documentation.


Native TV experience
A Roku TV channel that consumes a movies and series API and organizes the catalog into remote-friendly rows.
BrightScript tasks load and normalize categories, artwork, plots, ratings, genres and URLs into SceneGraph ContentNodes, distinguishing movies from series while keeping network work off the UI thread.

Desktop mod manager
A desktop app for searching, resolving dependencies, downloading and organizing Factorio mods by profile.
The Rust backend proxies the official API, selects compatible releases and powers a persistent queue with pause, HTTP Range resume, progress and stall detection. Profiles isolate mods and configuration, using Windows junctions for activation and game launching.




1st place at Start Farm 2025
An award-winning IoT prototype for monitoring industrial air emissions and surfacing thresholds and alerts in a dashboard.
CO, NO₂, SO₂ and PM2.5 sensors connect ESP32 and SX1278/LoRa radios to a gateway and React interface. The demo includes indicators, time series, devices and reports; some data remains simulated because this is a hackathon prototype.


I build products across interface, backend and operations.
I'm João, a Front-end Developer at IotaHub and Software Engineering student at PUCPR. I like understanding the complete flow—from the first interaction to persisted data and the infrastructure keeping it running.
At IotaHub, I work with Angular and NestJS. In personal projects, I explore React, TypeScript, Rust, Node.js, Python, desktop and mobile apps, cloud, AI and computer vision. The projects above include production products as well as studies identified as prototypes or archived work.
“These semantic aspects of communication are irrelevant to the engineering problem.”