We are a research group at the CMU HCII. Our mission is to empower people to analyze and communicate data with interactive systems.
Public
Edited
Jan 25, 2023
1 fork
Importers
39 stars
dbClient1 = new DuckDBClient()
Inputs.table(await dbClient1.query(query))
dbClient1.table(query)
dbClient1
dbClient1
Type Table, then Shift-Enter. Ctrl-space for more options.
dbClient1.queryRow(`SELECT 1 + 2`)
dbClient1.explain(query)
sequence = dbClient1.query(query)
vl
.markLine()
.data(sequence)
.encode(vl.x().fieldQ("x"), vl.y().fieldQ("y"))
.width(600)
.render()
Plot.plot({
marks: [Plot.line(sequence, { x: "x", y: "y" })]
})
dbClient2 = {
const client = new DuckDBClient()
await client.query('CREATE TABLE professoren (persnr INTEGER, name STRING, rang STRING);');
await client.query('CREATE TABLE studenten (matrnr INTEGER, name STRING, semester INTEGER);');
return client
}
dbClient2.describe()
dbClient2
dbClient2.describe('studenten')
dbClient2
dbClient3 = DuckDBClient.of([
FileAttachment("weather.parquet"),
FileAttachment("penguins.csv"),
FileAttachment("cars.json")
])
dbClient3.describe()
dbClient3.table(`
SELECT
species,
avg(flipper_length_mm) as 'Average Flipper length (mm)'
FROM penguins
GROUP BY species
`)
dbClient3.table(`SELECT count(*) FROM weather`)
dbClient3.table(`SELECT count(*) FROM parquet_scan('weather.parquet')`)
dbClient3.table(`
SELECT *
FROM weather
LIMIT 100
`)
dbClient3.table(aggregate)
dbClient3.explain(aggregate)
{
await dbClient3.query(`
CREATE TABLE IF NOT EXISTS weather_aggregate AS
SELECT location, min(temp_min), max(temp_max), avg(wind), avg(precipitation)
FROM weather
GROUP BY location`);
return dbClient3.describe('weather_aggregate');
}
{
const client = new DuckDBClient();
await client.query('CREATE TEMP TABLE temporary AS SELECT 1');
await client.query('CREATE TABLE permanent AS SELECT 1');
const before = await client.describe();
await client.reconnect();
const after = await client.describe();
return md`
Before reconnect:
${before}
After reconnect:
${after}`;
}
dbClient3
dbClient3
Type Table, then Shift-Enter. Ctrl-space for more options.
dbClient4 = new DuckDBClient()
FileAttachment("weather.parquet").constructor.name
{
const db = await dbClient4.db();
const conn = await db.connect();
const start = performance.now();
const result = await conn.send(`SELECT * FROM generate_series(1, 1000000)`);
const firstBatch = (await result.next()).value;
await conn.close();
const duration = performance.now() - start;
return { size: firstBatch.numRows, time: duration };
}
{
const start = performance.now();
const result = await dbClient4.query(
`SELECT * FROM generate_series(1, 1000000)`
);
const duration = performance.now() - start;
return { size: result.numRows, time: duration };
}
libraryVersion
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.
