Public
Edited
Oct 8, 2024
1 fork
1 star
Insert cell
Insert cell
viewof duckdbWasmVersion = Inputs.select(
["latest", "next", "1.28.1-dev232.0", "1.29.0"],
{
label: "Select the duckdb wasm version",
value: "latest"
}
)
Insert cell
duckdb = import(
`https://cdn.jsdelivr.net/npm/@duckdb/duckdb-wasm@${duckdbWasmVersion}/+esm`
)
Insert cell
duckdb.PACKAGE_VERSION
Insert cell
bundles = duckdb.getJsDelivrBundles()
Insert cell
bundle = duckdb.selectBundle(bundles)
Insert cell
async function makeDB() {
const logger = new duckdb.ConsoleLogger();
const worker = await duckdb.createWorker(bundle.mainWorker);
const db = new duckdb.AsyncDuckDB(logger, worker);
await db.instantiate(bundle.mainModule);
return db;
}
Insert cell
db = makeDB()
Insert cell
db.getVersion()
Insert cell
connection = await db.connect()
Insert cell
queries = new Map([
["time", "SELECT CURRENT_DATE, CURRENT_TIMESTAMP, CURRENT_TIME"],
[
"https://",
"SELECT COUNT(*) FROM read_parquet('https://huggingface.co/datasets/linxy/LaTeX_OCR/resolve/refs%2Fconvert%2Fparquet/full/train/0000.parquet?download=true')"
],
[
"hf://",
"SELECT COUNT(*) FROM read_parquet('hf://datasets/nyu-mll/glue/ax/test-00000-of-00001.parquet')"
]
])
Insert cell
Insert cell
Insert cell
result = connection.query(query)
Insert cell
Array.from(result)
Insert cell
result.toArray()
Insert cell
Inputs.table(result)
Insert cell

Purpose-built for displays of data

Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
Learn more