The end-to-end solution for building and hosting better data apps, dashboards, and reports.
db = new QuestDatabaseClient("https://demo.questdb.io")
db
Plot.plot({
y: {
label: "↑ galon_price"
},
marks: [
Plot.ruleY([0]),
Plot.areaY(gas_prices, {x: "time", y1: "min", y2: "max", curve: "step", fill: "#ccc"}),
Plot.line(gas_prices, {x: "time", y: "avg", curve: "step"})
]
})
Plot.plot({
y: {
label: "↑ tempF"
},
marks: [
Plot.ruleY([0]),
Plot.areaY(weather, {x: "time", y1: "min", y2: "max", curve: "step", fill: "#ccc"}),
Plot.line(weather, {x: "time", y: "avg", curve: "step"})
]
})
db
Plot.plot({
y: {
label: "↑ Hourly trips (thousands)",
transform: d => d / 1000
},
marks: [
Plot.ruleY([0]),
Plot.line(trips, {x: "time", y: "count", curve: "step"})
]
})
db
class QuestDatabaseClient {
constructor(host) {
this.host = host;
}
async sql(strings, ...args) {
if (strings.length > 1) throw new Error("query parameters not supported");
return fetch(`${this.host}/exec?${new URLSearchParams({query: strings[0]})}`)
.then(response => response.json())
.then(formatResults);
}
}
async function exec(query) {
return fetch(`https://demo.questdb.io/exec?${new URLSearchParams({query})}`)
.then(response => response.json())
.then(formatResults);
}
function formatResults({error, columns, dataset}) {
if (error) throw new Error(error);
const rows = dataset.map(row => {
return Object.fromEntries(columns.map(({name, type}, i) => {
return [name, formatValue(row[i], type)];
}));
});
rows.columns = columns.map(({name}) => name);
return rows;
}
function formatValue(value, type) {
switch (type) {
case "TIMESTAMP": return new Date(value);
default: return value;
}
}
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.
