The avatar for @observablehq
Observable
The end-to-end solution for building and hosting better data apps, dashboards, and reports.
Unlisted
Edited
Feb 8, 2023
10 forks
Importers
70 stars
9
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
chinook.db
SELECT * FROM customers
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
chinook.db
SELECT * FROM tracks
Insert cell
Insert cell
chinook.db
SELECT *
FROM tracks
ORDER BY Milliseconds DESC
LIMIT 10
Insert cell
Insert cell
longTracks
Insert cell
Insert cell
longTracks.columns
Insert cell
Insert cell
Insert cell
viewof name = Inputs.text({label: "Name", placeholder: "Search tracks", value: "jimmy"})
Insert cell
likeName = `%${name}%`
Insert cell
chinook.db
SELECT * FROM tracks WHERE Name LIKE ${likeName} OR Composer LIKE ${likeName};
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
class CustomDatabase {
async sql(strings, ...args) {
return [{column1: "value1", column2: "value2", column3: "value3"}];
}
}
Insert cell
custom = new CustomDatabase()
Insert cell
custom
select *
Insert cell
Insert cell
import {buttons} from "@observablehq/keys"
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