Shaping Ideas IdeasConcepts ConceptsDesigns DesignsCode CodeIdeas IdeasConcepts ConceptsDesigns DesignsCode Code

into Real Projects

that Deliver Results

I am Vidal. Web apps that leave a trace: reliable data and a clear history of every change, built with Go, SvelteKit and PostgreSQL, from the model to production.

Offline-first

Apps that work without a connection and back up their data to Google Drive.

Cross-platform

Android, Windows, Linux and the web from one product.

End-to-end

Frontend, API, database and deployment, all owned by me.

How my projects evolved

Projects & Learning Journey

Contacts — offline-first contacts app

Early 2024

What I built

  • Built a cross-platform contacts manager with React Native (Android) and Electron (Windows and Linux) on a local SQLite database.
Show more (2)
  • Backed up the .db file to Google Drive (app-created files only, drive.file scope) and restored it on another device after Google Sign-In through Firebase.
  • Features: VCF/vCard import, birthday calendar and notifications, advanced search filters, English/Spanish i18n.

server-cats — PHP site on Google Cloud Dataproc

February 2024

What I built

  • Small PHP web app with login, home and logout pages served by Apache, backed by a MySQL users table.
Show more (2)
  • Docker Compose stack with PHP 7.4 and Apache, MySQL 5.7 and MongoDB 4.2, plus install scripts for Docker and the containers.
  • Deployed on a Google Cloud Dataproc cluster created with gcloud, with a Cloud Storage bucket and the full setup documented step by step in the README.

rtmp-gcloud — live streaming server

February 2024

What I built

  • Docker Compose stack for live streaming: an nginx-rtmp server behind nginx-proxy, with automatic Let's Encrypt certificates.
Show more (1)
  • First attempt at running it on Google Cloud, with a script to install Docker and the configuration for the proxy and the RTMP server.

Chiro — offline-first personal finance app

Late 2024

What I built

  • Reused the same offline-first architecture (Expo / React Native + Electron + expo-sqlite, Google Drive backup, Firebase Google Sign-In) for expenses, budgets and loans.
Show more (1)
  • The Android app is in closed testing on Google Play.

Frontend Mentor challenges

July 2025

Visit site

What I built

  • Solved 9 Frontend Mentor challenges across newbie, junior and intermediate levels, from a QR code component to a todo app.
Show more (1)
  • Built with Next.js 15, React 19, TypeScript and Tailwind CSS 4, following each design closely and responsive down to mobile.

tims — ESPOCH IT program website

August 2025

Visit site

What I built

  • Official website for the Information Technology Engineering program at the ESPOCH Morona Santiago campus, with schedule, club, student council and faculty sections in Spanish and English.
Show more (2)
  • Built with Next.js 15, TypeScript, PostgreSQL with Prisma, NextAuth v5, next-intl and Cloudinary image uploads.
  • Admin panel for news, events, faculty and users, in development.

Parque Informático — IT asset management

March 2026

Visit site

What I built

  • IT asset management system for GPMS in Morona Santiago: assets, custodians, locations and users, with a full transfer history and public lookup pages.
Show more (2)
  • Built with a NestJS 11 API (Prisma, JWT auth, Swagger), a Next.js 16 frontend with Leaflet location picking, and PostgreSQL.
  • Frontend on Cloudflare Workers via OpenNext, API on Vercel and database on Supabase.

grapi — Instagram follower analyzer

June 2026

What I built

  • Analyzes Instagram followers and following and downloads galleries and stories, built on the instagrapi library.
Show more (2)
  • FastAPI backend with PostgreSQL (Alembic migrations) caching profiles and run history, plus a Next.js 15 frontend migrated from an earlier Vue single-page app served by nginx.
  • Runs the whole stack with a single docker compose command, with live sync for development.

service-desk — iTop IT service management

June 2026

What I built

  • IT service management portal based on iTop 3.2.1, deployed with Docker Compose: an Apache and PHP container and a MariaDB 10.6 database, both on persistent volumes.
Show more (2)
  • Configured the ITIL modules (incidents, service requests, changes, problems and CMDB), a service catalog and role-based users for service desk agents, support agents, a problem manager, a change supervisor and portal users.
  • Documented the ticket flow from portal request to resolution, problem and change management, and troubleshooting for common iTop errors.

Smart safe — ESP32 and Home Assistant

June 2026

What I built

  • Keypad-controlled safe built on an ESP32 with a 4x4 matrix keypad, a DHT11 temperature and humidity sensor, an I2C LCD, an LED and a buzzer; three wrong PINs trigger an alarm.
Show more (2)
  • C++ firmware publishes the lock state, temperature, humidity and alarms over MQTT to Mosquitto, and accepts LOCK and UNLOCK commands.
  • Mosquitto and Home Assistant run in Docker; the sensors register themselves through MQTT Discovery and automations announce events through an Alexa Echo Dot.

Scaling to the web: Go, SvelteKit and PostgreSQL

July 2026

What I built

  • Rebuilt Chiro and Contacts as web apps with a SvelteKit frontend, a Go API and PostgreSQL.
Show more (2)
  • Deployed the frontend on Cloudflare, the API on Vercel and the database on Supabase.
  • All projects remain active and maintained.

Planner — task planner with visual countdown timers

September 2026

Visit site

What I built

  • Task planner with visual countdown timers, class schedules and day planning.
Show more (1)
  • Built with a Go API (Chi router, pgx), a SvelteKit 5 frontend and PostgreSQL.

Clean Classroom Reporter — classroom cleaning reports

October 2026

Visit site

What I built

  • Micro app where class presidents report whether a classroom is clean or dirty by scanning the QR code on its door, with a photo required as evidence when it is dirty.
Show more (2)
  • Admin view with the full report history, evidence photos and the previous report for each dirty one; photos are compressed in the browser to under 1 MB before upload.
  • Built with SvelteKit (Svelte 5, TypeScript) on Cloudflare Pages and Supabase (Auth, Postgres with RLS, private Storage). The evidence rule and report history are enforced in the database, and the UI is available in Spanish and English.

What I work with

Skills and stack

Core stack

Backend

  • Go (Chi)
  • TypeScript
  • NestJS
  • FastAPI
  • PHP

Data

  • PostgreSQL
  • Prisma and pgx
  • SQLite
  • MySQL and MongoDB
  • Supabase

Quality and security

  • Integration tests against a real database
  • Load testing with k6
  • Static analysis with Semgrep

Frontend

  • SvelteKit
  • Next.js
  • React Native

Cloud and deployment

  • Cloudflare
  • Vercel
  • Google Cloud
  • Docker Compose
  • nginx and Let's Encrypt

Systems

  • Linux
  • Git

IoT and automation

  • ESP32 (C++)
  • MQTT
  • Home Assistant

Service management

  • ITIL
  • iTop

Hiring or have a project? Write to me.

Get in touch

I only use your details to reply to your message. They are sent through EmailJS and never shared with anyone else.