Skip to content

Typed SQLite reports

dev.formless.database-demo proves private durable state without arbitrary filesystem or SQL authority.

The plugin owns a WAL-mode SQLite database in its Host-assigned private storage. Its capability exposes named report operations and typed parameters. The Canvas receives table and chart results; it never receives a database path or arbitrary SQL execution primitive.

This pattern keeps policy readable and migrations owned by the provider. A replacement plugin can preserve compatible capability operations while evolving its internal schema.

Use it for dashboards, caches, local indexes, and derived operational data. Separate destructive data purge from plugin uninstall so operators can replace or reinstall code without silently deleting state.