SQLite Studio
A database GUI in one self-contained index.html — demand-paged SQLite whose pages live in IndexedDB, with a schema tree, SQL editor, CSV export and CRUD. Runs from file://.
CURRENTLY SHAPING PLASTRON
rheophile10.
flowing code.
Building reactive substrates that run everywhere. Polyglot spreadsheets, self-contained OSes, and tools that feel like water.
online
Manifesto
Manifesto
Own the software. Keep the data local. Distrust the center.
01 Own the software, completely.
02 Keep the data local; share like belts.
03 Distrust centralization that isn't a merge.
Read the manifesto
Projects
What I'm building
A polyglot reactive substrate. Cels hold values, formulas, or compiled lambdas. Writing to one fires a cascade that recomputes everything downstream in topological order.
The eventual shape is a polyglot spreadsheet: write functions in any language a compiler is installed for (JS, WAT, Python, Scheme…), then call them from formulas in other cels. The same kernel powers a desktop shell, spreadsheet UI, CLI, or web app.
plastron.ca is live today with server-backed persistence — not zero-server anymore, though that remains the goal. Offline single-file builds are still in progress: no OPFS persistence yet, but more is coming. The north star is still a single index.html you can open, edit, share, and archive, with everything round-tripping through JSON.
TypeScript kernel
plastron.ca
WASM Doom
Zero-server goal
What ships in the OS
- Sheets — per-cell view cels, formula bar, infix formulas, server-backed persistence on plastron.ca
- Notepad — textarea bound to a cel, New/Save/Open via shared file toolbar
- File Explorer — folders + drag-and-drop, fs-tree synced on the hosted build
- Doom — Freedoom running on doomgeneric compiled to WASM. 60 fps, mouse + keyboard, 28 MB WAD inlined
plastron.ca runs online today. Offline single-file builds — without OPFS for now — are still on the roadmap.
plastron-simple-examples/plastron-os — the bundled desktop shell
Sheets
A1 = 12 · B1 =A1*1.5
C1 =B1*2 → 36
C1 =B1*2 → 36
File system
/notepad/untitled-3.甲
/sheets/q4-report.甲
/sheets/q4-report.甲
Polyglot
JS · WAT · Python · Scheme
compilers as cels
compilers as cels
The graph is the substrate.
One artifact carries code + data + compilers
More work
Other projects
TypeScript
RheoServ Waumpaum
An offline-first credit-union core in one encrypted HTML file: cr-sqlite CRDT merge across operators and waumpaum settlement between institutions.
Offline Protected-B HRIS
A Protected-B HRIS that runs offline in a single HTML file, merging HR records across operators with CRDT SQLite.
The Colonial Advocate
A single-page web app modelled after William Lyon Mackenzie's 19th-century reform newspaper.
Firearms vs Homicide
Civilian firearm ownership (Small Arms Survey 2017) charted against intentional homicide rates (UNODC), by country.
genenote-js
Lion Kimbra's genenote, reimplemented in JavaScript on top of plastron.
Writing
Blog
sqlite · wasm · indexeddb · offline · vfs · fts5 · crdt
SQLite that persists without hoarding RAM 🗄️
sql.js loads the whole database into memory; ordinary SQLite doesn't. A TypeScript demo puts the demand-paged model back in the browser — SQLite whose pages live in IndexedDB, read on demand, with FTS5 and CRDT in the same build — running from a double-clicked file:// page.
Read note
rbac · crdt · cryptography · shamir · offline · sqlite
Records a group can keep — without any one keyholder becoming a target 🔐
Cryptographic role-based access control over a local-first CRDT database — records a group can keep together, merged for local and group consensus, with Shamir threshold custody so no single keyholder is ever worth coercing. A tour of the datalayer, plus a live three-user demo.
Read note
offline · html-file · qr · sqlite · lab-intake
One HTML file vs. a web application: sample intake without the IT-approval gauntlet 📄
Web apps are easy to build; getting IT to approve them is not. A single HTML file is the free intermediate step — offline, no server, but with SQLite, Web Crypto, and a scannable QR that composes your form data into a label so transcription never has to happen.
Read note
credit-union · offline · crdt · core-banking · waumpaum
RheoServ Waumpaum — a credit-union core in one HTML file 🏦
A sovereign, offline-first counterpart to enterprise core banking: a person-centered credit-union core in one encrypted HTML file, with CRDT multi-operator merge and waumpaum settlement between institutions. Teller, merge, and payment-provider walkthroughs with videos.
Read note
plastron · steganography · pyodide · chaosedgesteg
Hiding plastron links in pictures with ChaosEdgeSteg 🐢
Chaos-based edge steganography from crypt0lith, running verbatim in Pyodide cells. Hide a plastron.ca #f= link in a Twitter-safe PNG; recover it with cover + password.
Read note
plastron · hris · offline · crdt
Offline HRIS for a community police office 👮
A plastron detour — CRDT SQLite in one HTML file for offline HR merge. Juárez-skinned demo; patterns intended for plastron's own offline-capable future.
Read note
plastron · zhuangzi · interactive
曳尾塗中 — drag your tail in the mud 🐢
Zhuangzi's tortoise story in traditional Chinese. Click any character to break it down through a decomposition tree with English glosses.
Read note