Data visualization/Interactive media and full-stack data science web app developer.
function image_url_to_blob(img_url) {
return png2blob(img_url).then(blob2buffer);
}
function blob_to_sqlite(buf) {
return new SQLiteDatabaseClient(new Uint8Array(buf));
}
viewof db = {
var dom = html`<div>💿`;
dom.value = null;
var curr = await localforage.getItem(local_forage_key);
if (curr == null || !curr.constructor == ArrayBuffer) {
var download = await image_url_to_blob(url);
localforage.setItem(local_forage_key, download);
dom.value = blob_to_sqlite(download);
dom.dispatchEvent(new CustomEvent("input"));
} else {
dom.value = blob_to_sqlite(curr);
dom.dispatchEvent(new CustomEvent("input"));
}
return dom;
}
db
db.describe()
// preventing intermediate queries from being generated while using the slider...
debounce_range = debounce(viewof range, 200)
sample = db.query(
`SELECT
*
FROM
(SELECT
DISTINCT(EnglishProductName) AS product, Color,sum(SalesAmount) AS total
FROM
FactInternetSales
INNER JOIN
DimProduct ON FactInternetSales.ProductKey = DimProduct.ProductKey
GROUP BY
EnglishProductName)
WHERE
total BETWEEN ${debounce_range[0]} AND ${debounce_range[1]}
`
)
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.
