Visual Admin Form
Staff edit sticker packs, guides, and FAQs in a friendly browser form on the local staging portal.
Decoupled flat-file CMS and trilingual sticker gallery web application with local Node staging, SFTP remote sync, and zero-database static FTP deployment

Zero-database static FTP deployment with local Node staging and atomic SFTP asset synchronization.
Single stickers.json data store with local Node staging and automated SFTP production deployment.
Static production edge delivery with zero database security maintenance overhead.
Strict institutional constraints prohibited running Node.js or database engines on the production tier.
Engineered local containerized staging CMS generating static JSON/HTML deployed seamlessly via SFTP/FTP.
CASE STUDY ROLE: FULL-STACK LEAD & SOLUTION ARCHITECT
Xavier designed the flat-file architecture that replaced heavy SQL databases with a simple stickers.json data store.
He built an intuitive local admin portal (/admin/) with rich form editors for all 3 languages, coded an automated SFTP synchronization engine (ssh2-sftp-client) for one-click publishing, and structured the public website with vanilla JavaScript and pure CSS for sub-second load times.
Staff edit sticker packs, guides, and FAQs in a friendly browser form on the local staging portal.
Validates content and updates the lightweight stickers.json data store with zero database overhead.
Secure ssh2-sftp-client automatically pushes updated files to the production FTP hosting server.
Visitors enjoy lightning-fast browsing across English, Traditional, and Simplified Chinese.