Comments (11)
Michael Whitaker
Feb 8, 2022Is it possible to export a DuckDB database or table to a file?
Dominik Moritz
Feb 8, 2022Yes. The easiest way is to write a query, get the result as Apache Arrow and then write that to a buffer.
Fil
May 27, 2022Is 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).
Ismael
Aug 24, 2022I've tried the following and it does not work throwing an error:
DuckDBClient.of([
{file: FileAttachment("penguins.csv"), header: true}
])
Dominik Moritz
Aug 24, 2022Thanks for raising the issue. I fixed it.
Ian Johnson
Jan 25, 2023might be nice to link to the client in the observable repo:
https://github.com/observablehq/stdlib/blob/main/src/duckdb.js
Jan 25, 2023
or i suppose this one, like was linked in the cmudig/duckdb notebook: https://observablehq.com/@observablehq/duckdb
Dominik Moritz
Jan 25, 2023I added a link to the note.
Fil
May 27, 2022looks like we don't need `.toArray().map(Object.fromEntries)` anymore?
Dominik Moritz
May 29, 2022Right, I fixed that. Thanks!
Fil
May 27, 2022and no need for toArray() here