Cherry Pi uses SQLite as substrate: apps, layers, and memory as single database files
sull · x · 2026-11-05
Redstar Systems highlights Cherry Pi's engineering design where every app is a single SQLite file (.pi format) containing code, assets, and data—openable, copyable, signable, and sendable. Apps are authored as folders (Lua manifest, SQL schema, handlers) and run in place unsigned, with a sandboxed empty environment rejecting function definitions and require calls. The workspace database holds desktop state, settings, trash, and grants; separate stores handle machine identity, pairing, and admin ledgers. The same format previously packaged portable agent apps.
More from coding & agent
- Levels decompiles Battlefield 1942 with Claude Code, ports it to browser with working multiplayer — huangyun_122 · 2026-11-05
- Kubernetes promotes AI Conformance to permanent SIG Architecture subproject — TerryTangYuan · 2026-11-05
- quiet.md goes open source: Rust+GPUI editor, Feishu-compatible, ~5ms frames on 1M-char docs — dotey · 2026-11-05
- A background agent that auto-structures messy scientist Excel data, day 17 of agent series — nlarusstone · 2026-11-05
- Code mode isn't about MCP: it's about whether tool results go to context or program variables — ritakozlov · 2026-11-05
- Agent Arena: frontier models show 55-minute gap on long-horizon agent tasks — arena · 2026-11-05