OpenClaw × WhatsApp: A Runtime State Split Triggered by the Bundler
An analysis of the state-consistency problem in OpenClaw's WhatsApp path.
openclawwhatsappdebuggingjavascriptbundling
Z. Yuan4 min read
They Look the Same. Why Do Strings Still Fail to Match?
Two strings can look identical and still fail to match. The usual suspects are Unicode, invisible characters, and misplaced trust in computers.
unicodepythontext-processing
Z. Yuan7 min read
SQLite in Practice (5): Who Am I? Where Am I?
From error codes and retention policies to audit logs—make your queue operable.
sqliteobservabilitydata-governancejob-queue
Z. Yuan10 min read
SQLite in Practice (4): Why Is My Query So Slow?
Use the right indexes so `ORDER BY ... LIMIT` can stop after the top 100.
sqliteindexperformanceleaderboardquery-plan
Z. Yuan6 min read
SQLite in Practice (3): Save Your Workers
Automatically reclaim stuck tasks—don’t let your queue turn into a graveyard.
sqlitejob-queuereliabilityheartbeat
Z. Yuan6 min read
SQLite in Practice (2): Atomic Claims
Making sure two workers can’t claim the same job is harder than you think.
sqlitejob-queuetransactionsconcurrency
Z. Yuan4 min read