CMU Data Interaction Group

Dominik Moritz

Is it possible to export a DuckDB database or table to a file?

Michael Whitaker

Yes. The easiest way is to write a query, get the result as Apache Arrow and then write that to a buffer.

Is it possible to create a table from an array of objects? It would be neat to write dbClient = DuckDBClient.of([{data: [{a:"Hello"}, {a:"World"}], columns: ["a", "b", "c"]}]); (columns would be optional).

I've tried the following and it does not work throwing an error: 
DuckDBClient.of([
  {file: FileAttachment("penguins.csv"), header: true}
])

Ismael

Thanks for raising the issue. I fixed it.

might be nice to link to the client in the observable repo:
https://github.com/observablehq/stdlib/blob/main/src/duckdb.js

Ian Johnson

or i suppose this one, like was linked in the cmudig/duckdb notebook: https://observablehq.com/@observablehq/duckdb

looks like we don't need `.toArray().map(Object.fromEntries)` anymore?

Purpose-built for displays of data