Live data

Spreadsheet and Database can both read and write data that doesn't live on this device at all - a Postgres database, an Airtable base, or a Google Sheet. Once you connect one in Settings > Data sources, its tables show up in the Database app exactly like any other table, and Spreadsheet can pull numbers straight out of them with a formula.

Connecting a source

Open Settings > Data sources and pick Postgres, Airtable, or Google Sheets:

• Postgres needs a connection string. Only a table with a real "id" column can be edited from here - a table without one is still fully readable, just not writable.
• Airtable needs a personal access token with read and write access to the base you name, plus that base's ID.
• Google Sheets needs a service account's credentials, shared with edit access on the spreadsheet you want to connect, plus that spreadsheet's ID.

Every connection is checked with a real round trip before it's saved, so a mistyped credential is caught immediately rather than surfacing later as a confusing error.

In the Database app

Every table (or Sheet tab) on a connection shows up under its own group in the sidebar, next to your own tables and any app-owned ones. Rows are editable wherever the source allows it; columns come from the source's own structure and can't be renamed or retyped here. Changes you make sync back to the real source, and changes made there show up here within moments.

In Spreadsheet

Two formulas read your connected tables directly:

• =DB("table", "column") totals a numeric column, or lists the matching text values if it isn't one. Add a filter like =DB("orders", "total", "status=paid") to narrow it down first.
• =TABLE("table", "column") works the same way on its own, and can also be dropped inside another formula - =SUM(TABLE("orders", "total")) - to pull a whole column into a bigger calculation.

Spreadsheet also understands plain language: type =AI("total sales by month") into a cell and it compiles into a real formula the first time it runs, using whatever data is already on the sheet. Once compiled, the cell shows (and can be edited like) an ordinary formula - there's no separate "AI mode" to it.

Charts

Both apps can turn a table into a bar, line, or pie chart, drawn right there in the app - no separate chart editor.

• In Spreadsheet, use the Charts strip below the sheet to insert one from any range.
• In Database, open the Chart panel above the grid for the current view, pick a category and (optionally) a number column to total, and it updates as the view's rows change.