These posts record how I build plastron and other reactive, offline-first tools. I do the work in public. Filter the posts by tag, or subscribe to the RSS feed.
sql.js loads the full database file into memory, but ordinary SQLite reads one page at a time. This demo keeps that demand-paged model in the browser, with pages in IndexedDB, FTS5 and CRDT in one build, from a file:// page.
localRbac enforces role-based access control with cryptography only, in a local-first CRDT database that a group edits offline and merges. Shamir secret sharing splits the master key k-of-n, and thus no single keyholder is a target for coercion.
A web application is easy to build, but IT approval for a server, a login, and a database is difficult. One offline HTML file with SQLite and Web Crypto is a free intermediate step, and its QR code removes transcription.
RheoServ Waumpaum is a credit-union core banking system in one encrypted HTML file. A CRDT merges the offline changes of the operators, and institutions settle with waumpaums.
A plastron sheetapp hides a plastron.ca share link in a PNG that you can post to X. The upstream ChaosEdgeSteg Python code runs without changes in Pyodide.
A proof of concept puts CRDT SQLite in one HTML file to merge HR data offline. The demo shows a fictional Juárez police office, and the plan is to use the same patterns in plastron.
The tortoise story of Zhuangzi in traditional Chinese. Click a character to see its decomposition tree with English glosses.