Public
Edited
Feb 2, 2023
Insert cell
md`# SQLite`
Insert cell
Insert cell
dbc = FileAttachment("chinook.db").sqlite()
Insert cell
tracks = dbc.query(`select * from tracks`)
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
db.queryRow(`SELECT sqlite_version()`)
Insert cell
db.query(`SELECT datetime('now', 'localtime')`)
Insert cell
db.query(`SELECT random() AS Random;`)
Insert cell
db.query(`SELECT abs(random() % 100) AS Random_0_100;`)
Insert cell
db.query(`SELECT abs(random()) % (100-1)+1 AS Random_1_100;`)
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