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, a typed query factory, and a CLI that runs the whole codegen pipeline. The data layer that powers Agates, ESPAU, Increscendo, and the Café Combate storefront.

  • TypeScript ·
  • PostgreSQL ·
  • pgtyped ·
  • Zod ·
  • Kanel
case study → 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, two-factor auth, and encrypted records.

  • Next.js ·
  • PostgreSQL ·
  • pgtyped ·
  • NextAuth
case study → 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 full e-commerce storefront with Mercado Libre integration, with role-based access and offline-capable sync.

  • Express ·
  • React ·
  • MongoDB ·
  • Next.js ·
  • PostgreSQL ·
  • Facturapi ·
  • Stripe
case study →

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
case study → 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
case study →

Facturalandia

2023–present

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

  • Express ·
  • React ·
  • MongoDB ·
  • Facturapi ·
  • Firebase
case study →

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
case study → 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
case study → 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
case study → 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
case study → 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
case study → 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
case study → 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
case study → 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
case study → repo ↗