Forked from tmcw/duckDbCsv
Public
Script
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
import { fetch } from "https://esm.town/v/std/fetch";
import { insertDataIntoDuckDb } from "https://esm.town/v/neverstew/insertDataIntoDuckDb";
import { getDuckDB } from "https://esm.town/v/tmcw/getDuckDB?v=1";
export const duckDbJson = (async () => {
const db = await getDuckDB();
const r = await fetch("https://jsonplaceholder.typicode.com/todos");
await insertDataIntoDuckDb(db, await r.json());
const c = await db.connect();
const res = await c.query(`select * from data where completed`);
c.close();
db.terminate();
return res.toArray().map((r) => r.toJSON());
})();
// Forked from @tmcw.duckDbCsv
Val Town is a social website to write and deploy JavaScript.
Build APIs and schedule functions from your browser.
Comments
Nobody has commented on this val yet: be the first!
October 23, 2023