Skip to content

v0.3.0: DataCanvas spillover for tabular search results

Choose a tag to compare

View all tags
@cyanheads cyanheads released this 09 Jun 03:23
v0.3.0
This tag was signed with the committer’s verified signature.
cyanheads Casey Hand
SSH Key Fingerprint: lkZCAfVCK5qsrcvEYCs0BnVRDCX7pKsdCZkw5yYKMuw
Verified
Learn about vigilant mode.
67859ec
This commit was signed with the committer’s verified signature.
cyanheads Casey Hand
SSH Key Fingerprint: lkZCAfVCK5qsrcvEYCs0BnVRDCX7pKsdCZkw5yYKMuw
Verified
Learn about vigilant mode.

DataCanvas spillover for tabular search results

Opt-in DuckDB SQL surface for the 8 multi-row search tools. When CANVAS_PROVIDER_TYPE=duckdb, search tools page the full matched set into a staged table and return a canvas_id; two new dataframe tools run SQL against it.

Added:

  • openfda_dataframe_query — read-only SQL (SELECT, GROUP BY, aggregates, joins) over staged result sets (#1)
  • openfda_dataframe_describe — lists tables and column schemas on a DataCanvas (#1)
  • DataCanvas spillover on 8 search tools: optional canvas_id input + canvas_id/canvas_table/spilled/truncated outputs (#1)
  • Off by default — without CANVAS_PROVIDER_TYPE=duckdb, search tools return inline results byte-unchanged

Dependency bumps:

  • @duckdb/node-api ^1.5.3-r.3 (new, optional DuckDB canvas backend; lazy-loaded)

310 tests pass; bun run devcheck clean.

Assets 3
Loading