John H's Website

Notes

Notes

Pitfalls and optimizations from work and side projects, plus a few practical how-to guides.

Extension popup with Taiwan selected automatically and cn-sdjn-fx-01-01 as the default node
Tech share11 min

How to Actually Fix Bilibili Buffering for Good

Why popular Bilibili videos play fine overseas while unpopular ones stall: CDN caching and trips back to origin, why the narrowest link sets your speed, why DNS and VPN tricks are hit or miss, and how my extension picks a default node from real tests across 14 Taiwanese ISPs.

繁體中文 / English

Read note
LINE Shopping live hall feed with the 20%–50% play zone and each card’s trigger line at 30% marked; only one card is playing
Tech share4 min

Auto-Play on Scroll — Live Stream List

TikTok-style auto-play for a live stream list: exactly one video plays while scrolling, no flicker on fast swipes, and resources are released as soon as a card leaves the viewport.

繁體中文 / English

SiyaMap architecture drawn as a concert venue seat map: a seat-view photo sits at the stage, inner sections are Route 53, CloudFront and S3, outer sections are Neon, apps/web (Lambda · Next.js + Hono) and image-processor (Lambda · sharp)
Tech share16 min

SiyaMap System Architecture

Full-stack architecture of a concert seat-view sharing platform: AWS serverless infrastructure, the watermark and resize image pipeline, PostgreSQL modeling, and a layered Hono backend.

繁體中文 / English

Dark monitoring panels comparing memory over time: before, usage climbs to the limit and the job dies with OOM and exit 1; after, batches are loaded and released below the limit and finish before the time limit
Tech share5 min

Large-Scale Billing Statement Duplicate-Check Monitor Optimization

Turning a duplicate-rule check over 100K+ billing records from timeouts and OOMs into a daily monitor that reliably finishes within its time and memory limits.

繁體中文 / English