ojs
ojs
ojs
sql
ojs
ojs
ojs
ojs
ojs
ojs
ojs
ojs
sql
ojs
sql
ojs
ojs
ojs
ojs
ojs
ojs
ojs
ojs
ojs
ojs
sql
ojs
ojs
ojs
ojs
ojs
ojs
Author
Dominik Moritz
@domoritz
Faculty at CMU (@cmudig) and researcher at @apple.
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
© 2026 Observable, Inc.