Héctor Loyo

Full-stack developer at PiByte Labs. I build invoicing and fiscal systems, ERPs, e-commerce platforms, and marketing sites, end to end, from database to interface.

Projects I’ve worked on

zql open source

2023–present

An open-source, type-safe data access layer for PostgreSQL: raw SQL typed by pgtyped, Zod-validated inputs, automatic snake_case/camelCase conversion, and a typed query factory. The data layer that powers Agates, ESPAU, and Increscendo.

  • TypeScript ·
  • PostgreSQL ·
  • pgtyped ·
  • Zod ·
  • Kanel
repo ↗

ESPAU

2026–present

Public site and clinical admin platform for a nonprofit autism organization: managing student records, therapy programs, and developmental assessments (DENVER model, ADOS-2) on a type-safe PostgreSQL backend with role-based access.

  • Next.js ·
  • PostgreSQL ·
  • pgtyped ·
  • NextAuth
live ↗

Café Combate

2024–present

A 13-app ERP for a coffee roaster spanning warehouse and inventory, CFDI invoicing, sales, purchasing, and production planning, plus a public storefront, with role-based access and offline-capable sync.

  • Express ·
  • React ·
  • MongoDB ·
  • Facturapi ·
  • Stripe

Agates From Mexico

2023–present

A full e-commerce store for collectible agates: rich multi-image product listings, role-based admin, cart and wishlist, Stripe/PayPal checkout, and ShipStation fulfillment, all on a custom type-safe data layer.

  • Next.js ·
  • PostgreSQL ·
  • Stripe ·
  • PayPal ·
  • NextAuth
live ↗

Corporativo Fiscal

2023–present

A corporate fiscal-management platform built as Express microservices: invoicing alongside customer, HR, and document-reception modules, with encrypted storage on Google Cloud.

  • Express ·
  • React ·
  • MongoDB ·
  • Google Cloud

Facturalandia

2023–present

A CFDI 4.0 electronic-invoicing platform: invoice creation, IVA/IEPS tax calculation, PDF generation, and real-time cancellation tracking via HMAC-signed webhooks. Also deployed for the Sonolife client.

  • Express ·
  • React ·
  • MongoDB ·
  • Facturapi ·
  • Firebase

The Bull Rider

2026

Promotional site for an independent western feature film: bilingual storytelling, art-directed responsive hero, gallery, and a sponsorship/investment pitch with tax-deduction compliance details.

  • Next.js ·
  • i18n ·
  • React Email ·
  • Resend
live ↗

Benjamín Rodríguez y Asociados

2025

Site for an insurance and advisory firm: services, FAQs, and a Google-Maps branch locator with marker clustering plus a contact form.

  • Next.js ·
  • Google Maps ·
  • Tailwind
live ↗

Chachitos

2025

Brand site for a Mexican cereal maker with 70+ years of history: a Google-Maps store locator with nearest-branch search, a blog, and product/flavor showcases.

  • Next.js ·
  • Tailwind ·
  • Google Maps ·
  • Resend
live ↗

Danny Cuevas

2025

Portfolio site and album-management backend for a wedding photographer: authenticated admin, album and gallery browsing, and large-scale photo uploads to Backblaze B2.

  • Next.js ·
  • PostgreSQL ·
  • NextAuth ·
  • Backblaze B2
live ↗

Increscendo Eventos

2025

Marketing site and admin platform for an events company: a quote generator with PDF export, a rich-text blog, client testimonials, and authenticated management of products, clients, and event types.

  • Next.js ·
  • PostgreSQL ·
  • NextAuth ·
  • Tiptap ·
  • AWS S3
live ↗

Portillo y Young

2025

Bilingual website for an architecture firm: services and project detail pages, with a validated, spam-protected contact form wired to transactional email.

  • Next.js ·
  • i18n ·
  • react-hook-form ·
  • Resend
live ↗

Iván Lara

2024

Portfolio for an event and wedding photographer: masonry galleries organized by event type, with per-event detail pages served from a lightweight gallery API.

  • Next.js ·
  • react-plock ·
  • Resend
live ↗

Uniplach

2024

Dual-brand site for a holding company (La Vaquita and Displach): catalog browsing for animal and agricultural products with data synced from Google Sheets/Drive, plus a branch locator.

  • Next.js ·
  • Cloudinary ·
  • Framer Motion ·
  • Google Sheets
live ↗

Kolabr open source

2023–2024

An open-source real-time collaborative Kanban board: live multi-user boards with drag-and-drop, custom authentication, and persistent storage.

  • SvelteKit ·
  • Liveblocks ·
  • Lucia ·
  • MongoDB
repo ↗