←SELECTED WORKS•CASE 06•web

Sticker Website CMS

Decoupled flat-file CMS and trilingual sticker gallery web application with local Node staging, SFTP remote sync, and zero-database static FTP deployment

DECOUPLED FLAT-FILE CMSSTATIC FTP PRODUCTION READY
cuhk.edu.hk/sticker/
CUHK Sticker Multi-Language CMS & Web App
Single stickers.json data store with local Node staging and automated SFTP production deployment.● LIVE
✦ Architecture: Decoupled Flat-File + SFTP Sync + Trilingual RoutingPRODUCTION
SYSTEM // STICKER_FAQ

Decoupled Flat-File Trilingual CMS

Zero-database static FTP deployment with local Node staging and atomic SFTP asset synchronization.

CUHK Sticker Multi-Language CMS & Web App

Single stickers.json data store with local Node staging and automated SFTP production deployment.

01 // PROVEN IMPACTVERIFIED
0%

Static production edge delivery with zero database security maintenance overhead.

PAGE SPEED: 100/100● ZERO DB VULNERABILITIES
02 // THE CONTEXTPROBLEM ➔ FIX
THE CHALLENGE

Strict institutional constraints prohibited running Node.js or database engines on the production tier.

THE SOLUTION

Engineered local containerized staging CMS generating static JSON/HTML deployed seamlessly via SFTP/FTP.

ZERO LONG PARAGRAPHS
WORKFLOW // DECOUPLED FLAT-FILE CMS & SFTP PIPELINE
PRIVATE // LOCAL ENVIRONMENTPUBLIC // EDGE ENVIRONMENT (DOUBLE SAFETY NET)ISOLATIONNO PUBLIC INGRESSMCP / AIJSON ➔HTML/JSDirect Access BlockedLocal CMSPrivate Local ServerVisual Content EditorFAQStickersDescriptionPacksLinks+ Full content controlsFlat-File Database ExportExport JSON (stickers.json)MCP ServerAI Management GatewayAdministrator AI UpdatesPrompt / tool calls update local backendSFTPStagingSafety Layer 1JSON IngestReceives JSON onlyNode PreviewStaging verificationInternal isolation ✓ProductionSafety Layer 2Static EdgeZero-DB deploymentPublic SiteTrilingual galleryEdge delivery ✓Public BrowsingVisitor Access (Isolated from Backend)Accesses only static edge production
LOCAL NODE STAGING -> SFTP PRODSTATIC ZERO-DB EDGE ✓
02 // XAVIER'S ROLE & HOW HE BUILT ITFULL-STACK LEAD & SOLUTION ARCHITECT

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.

WHAT XAVIER DIRECTLY DELIVERED & SHIPPED
Architected lightweight flat-file data structure (stickers.json) eliminating SQL injection risks and database licensing
Engineered local Node/Express staging CMS (/admin/) for staff to manage sticker packs, user guides, and FAQs visually
Built one-click SFTP synchronization (ssh2-sftp-client) that pulls live production JSON and pushes confirmed updates
Structured physical trilingual routing (/english/sticker/, /chinese/sticker/tc/, /sc/) for 100/100 Lighthouse speed
Dockerized the staging environment for seamless local deployment on Synology NAS infrastructure
HANDS-ON OWNERSHIPDIRECT ARCHITECT & BUILDER
03 // LANGUAGES & TOOLS USED
LANGUAGES & CORE RUNTIME
Vanilla JavaScript (ES6+)Node.jsHTML5CSS3
FRAMEWORKS & ENGINES
Express.js (Staging only)Pure Semantic CSSdotenv
TOOLS, AI MODELS & APIS
SFTP (ssh2-sftp-client)REST API (/api/fetch, /api/save)Docker Compose
STORAGE & INFRASTRUCTURE
Flat-File JSON (stickers.json)Static FTP ProductionSynology NAS Staging
CASE STUDY TECH ECOSYSTEM
Vanilla JavaScript (ES6+)Node.jsExpress.jsssh2-sftp-clientDockerFlat-File JSONHTML5CSS3
TECH ARCHITECTURE● FULLY FUNCTIONAL
04 // HOW THE SYSTEM WORKS

HOW THE DECOUPLED CMS WORKS

4-STEP PIPELINE
STEP 01
01/04

Visual Admin Form

Staff edit sticker packs, guides, and FAQs in a friendly browser form on the local staging portal.

StatusActive
STEP 02
02/04

Flat-File JSON Save

Validates content and updates the lightweight stickers.json data store with zero database overhead.

StatusActive
STEP 03
03/04

One-Click SFTP Sync

Secure ssh2-sftp-client automatically pushes updated files to the production FTP hosting server.

StatusActive
STEP 04
04/04

Instant Edge Loading

Visitors enjoy lightning-fast browsing across English, Traditional, and Simplified Chinese.

StatusActive