The avatar for @a10k
Alok Pepakayala
Data visualization/Interactive media and full-stack data science web app developer.
Published
Zinzi BI
Edited
Aug 28, 2020
Fork of SQLite
1 star
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
viewof auto_fetch = {
var dom = html`<div>SQL File stored to LocalForage`;
dom.value = null;
var curr = await localforage.getItem('sqlite_file');
if (curr == null || !curr.constructor == ArrayBuffer) {
fetch(path_to_db).then(response => {
var f = response.arrayBuffer();
dom.value = f;
dom.dispatchEvent(new CustomEvent("input"));
localforage.setItem('sqlite_file', f);
});
} else {
dom.value = curr;
dom.dispatchEvent(new CustomEvent("input"));
}
return dom;
}
Insert cell
db = new SQLite(auto_fetch)
Insert cell
tables = db.exec("SELECT * FROM sqlite_master WHERE type = 'table'")
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
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