Andre Pesquerra
back home

Projects

Everything I've built, newest first.

  • The Gavina Noble Dental Clinic website

    Gavina Noble Dental Clinic

    2026

    A web and Android system I built for a real dental clinic as our capstone project, leading a 5-person team as project lead, backend head and designer. Patients book appointments and view their own treatment history through an interactive 3D/2D dental chart, with each tooth color-coded by condition. The staff side covers appointments, patient records, messaging, inventory, staff and activity logs. Built with native PHP, MySQL and vanilla JavaScript, with Three.js for the 3D chart. Won Best in Project Implementation at our defense.

    • Next.js
    • TypeScript
    • Tailwind CSS
    • Supabase
    • PostgreSQL
    • Three.js
    • Vercel
  • The Revolution - PBBG website

    Revolution - PBBG

    2026

    A persistent browser-based strategy game I develop for a client, handling the full stack on my own: backend, frontend and UI/UX. Players build up their tribe through resource systems like lumber, mining and farming, each with research skill trees and workforce assignment. I also built The Monolith, the game’s social hub with chat, shop, syndicates, trainer, hunting board and proving grounds, plus an achievements system and a bullet-storm roguelite mini-game. Built with native PHP, MySQL and vanilla JavaScript, using an AJAX-driven architecture on a live server.

    • PHP PDO
    • CSS
    • HTML
    • JavaScript
  • The MAC Performance website

    MAC Performance

    2026

    A sample website for MAC Automotive Performance, a car repair and accessories shop in Olongapo City. It shows the shop's services, accessories, hours and Google reviews in a black-and-gold design. A demo customer area lets visitors book a service visit and order accessories to collect or have fitted on the same visit. It's built with Next.js, React and Tailwind CSS, and has no database yet: bookings and the cart stay in the visitor's browser, and the prices and products are demo data.

    • Next.js
    • React
    • TypeScript
    • Tailwind CSS