SQLite in Practice (1): The Database Is Locked Again!
Use WAL and busy_timeout to bring lock contention in multi-worker setups down to an acceptable level.
sqlitewalbusy-timeoutconcurrencyjob-queue
Z. Yuan6 min read
A First Look at SQLite (2): The CLI, Indexes, and PRAGMA
Taming SQLite: from schema inspection to query plans.
sqlitesqlclitransactionspragmasindex
Z. Yuan5 min read
A First Look at SQLite (1): Why Is It Always You?
A lightweight database that runs without a service.
sqlitedatabasestorage
Z. Yuan5 min read
FortiClient VPN Split Routing Configuration and Route Testing
Let FortiClient handle only the company intranet, while all other traffic returns locally.
vpn-routingmacosforticlient
Z. Yuan8 min read
Advanced Implementation of Docusaurus Sidebar Counting: Recursive Counting and Stable Slugs
Recursive counting of subfolders and slug stability optimization.
DocusaurusSidebarEnhancement
Z. Yuan4 min read
Fix Markdown PDF Mermaid Export Error
Fix export errors to ensure Mermaid diagrams render correctly.
Markdown-PDFMermaidExportError
Z. Yuan3 min read