The avatar for @roboticsuniversity
roboticsuniversity
Robotics.university
Public
Edited
Jan 10
Fork of SQLite Starter
2
Insert cell
Insert cell
import { SQLiteDatabaseClient } from "@observablehq/sqlite"
Insert cell

altdb = SQLiteDatabaseClient.open("https://files.cooperative-robotics.com/sqlite/kvstore.sqlite
Insert cell
Select a data source…
Type SQL, then Shift-Enter. Ctrl-space for more options.

Insert cell
chinook.db
Type SQL, then Shift-Enter. Ctrl-space for more options.

Insert cell
db = FileAttachment("chinook.db").sqlite()
Insert cell
viewof dbTable = Inputs.select((await db.describe()).value.map(d => d.name), { label: "Table" })
Insert cell
data = db.query(`SELECT * FROM ${dbTable}`)
Insert cell
Inputs.table(data)
Insert cell
kvstore.sqlite
select * from ${kvstore.sqlite}
Insert cell
kvstore.sqlite
Type SQL, then Shift-Enter. Ctrl-space for more options.

Insert cell
FileAttachment("kvstore.sqlite").sqlite()
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