▤ PROJECTS / ARCHIVE
A working archive of products, tools, and experiments.
The portfolio platform behind www.lst97.dev: a desktop-styled public site, a Payload CMS, and a server domain running retrieval-augmented generation, an agentic AI assistant, GitHub and WakaTime knowledge, and a structured contact workflow.

The operating system behind a custom fabrication and joinery business — a quote-to-cash pipeline with split payments, bank reconciliation, a commerce back-office, and PDF documents delivered over token-scoped public links.

A Cantonese-learning platform built on a curated lexical corpus and word-level karaoke timing — dictionary lookup, sentence study, talk lessons and a graded practice loop served by a clean-architecture API.

A self-hosted Australian address autocomplete service searching ~16 million Geoscape G-NAF addresses, measured under 50 ms p95 on PostgreSQL indexes alone.
An overview of 89 public and 22 private repositories spanning eight years — from embedded systems and Android apps to API platforms, Cantonese language technology, and locally-run speech models.

An open-source full-stack application that crawls Hong Kong LCSD SmartPLAY facility availability into PostgreSQL and serves date-, district-, and venue-filtered search with availability watchers and webhook notifications.

A private full-stack expense and settlement platform that keeps a shared Google Sheets ledger and an application database consistent — stable transaction identity, conflict-fingerprint write protection, formula-safe spreadsheet updates, multi-currency balances, and partial settlement with credit handling.
A personal-use CLI that scaffolds a new LAST project from a pinned template, plus the two starters it offers: Payload CMS with TanStack Start, or a CMS-free TanStack Start application on the same backend kernel.
A self-hosted comment system for any page: a Payload and TanStack Start service with moderation, site-scoped API keys and a plugin pipeline, plus drop-in React, Vue, Angular and plain-HTML widgets published as one package.