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

One platform to build and deploy the best data apps

Experiment and prototype by building visualizations in live JavaScript notebooks. Collaborate with your team and decide which concepts to build out.
Use Observable Framework to build data apps locally. Use data loaders to build in any language or library, including Python, SQL, and R.
Seamlessly deploy to Observable. Test before you ship, use automatic deploy-on-commit, and ensure your projects are always up-to-date.
Learn more