Skip to content
#0076
Sqlite
NEW PRIMITIVE

Embed a live SQL result into your wiki

The team runbook for "what's in the dead-letter queue right now?" used to be three steps: SSH into the worker box, run a script, paste the output into the doc. Three steps that nobody did, so the doc was always stale.

You replace those three steps with an iframe. The src is a base64-encoded SELECT against /hoody/databases/jobs.db filtering for failed jobs from the last hour. The iframe renders the rows as a table.

Now the runbook page in Notion has a live table. Anyone reading it sees the current state, not last week's. When the page reloads, the rows reload. When the table is empty, that's the answer.

You did not build a metrics service. You did not run a frontend. You pasted one URL into one iframe.

The runbook stops describing the database and starts being it.