Published
Edited
Dec 5, 2021
1 star
Prototype client for querying Datasette instances from Observable SQL cells
This DatasetteDatabaseClient class lets you query Datasette using the Observable SQL cells.
A much better version of this is is the one by Alex Garcia here: https://observablehq.com/@ambassadors/datasette-client - you should use his instead! This one was a learning exercise for me.
covidDb
powerPlantsDb
class DatasetteDatabaseClient {
constructor(host) {
this.host = host;
}
describe() {
throw new Error("not supported");
}
async sql(strings, ...args) {
return fetch(`${this.host}?${new URLSearchParams({sql: strings[0]})}`)
.then(response => response.json())
.then(formatResults);
}
}
function formatResults({ rows, columns }) {
let results = rows.map((row) => {
return Object.fromEntries(
columns.map((column, i) => {
return [column, row[i]];
})
);
});
results.columns = columns;
return results;
}
fixturesDb = new DatasetteDatabaseClient(
"https://latest.datasette.io/fixtures.json"
)
covidDb = new DatasetteDatabaseClient(
"https://covid-19.datasettes.com/covid.json"
)
powerPlantsDb = new DatasetteDatabaseClient(
"https://global-power-plants.datasettes.com/global-power-plants.json"
)
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.
