The avatar for @john-guerra
John Alexis Guerra Gómez
I love to build dataviz for insight discovery. I also love to put technology to the service of humanity
Published
Edited
Jun 10, 2021
9 stars
1
Observable Tricks
Scented CheckboxVega crossfilterFaceted SearchHow to add a tooltip in D3ColorAreaRanged3.stack with d3.groupPersist InputConditional ShowExport a cell valueMulti Auto SelectSearch Checkbox 🔎☑Data Input
Save Modified SQLite file
Require npm module from local file
Also listed in…
Databases
Insert cell
Insert cell
db = new SQLite.Database()
Insert cell
Insert cell
Insert cell
res = {
db.exec("CREATE TABLE person (name TEXT);");
db.exec("INSERT INTO person(name) VALUES('John');");
return db.exec("SELECT * FROM person");
}
Insert cell
Insert cell
Insert cell
DOM.download(async () => new Blob([await db.export()]), "mydb.db")
Insert cell
Insert cell
db2 = FileAttachment("mydb.db").sqlite()
Insert cell

DOM.download(async () => new Blob([await db._db.export()]), "mydb.db")
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