The end-to-end solution for building and hosting better data apps, dashboards, and reports.
// a sample query result set
r1 = [
{
TrackId: 1,
Name: "For Those About To Rock (We Salute You)",
Composer: "Angus Young, Malcolm Young, Brian Johnson",
UnitPrice: 0.99
},
{
TrackId: 2,
Name: "Balls to the Wall",
Composer: null,
UnitPrice: 0.99
},
{
TrackId: 3,
Name: "Fast As a Shark",
Composer: "F. Baltes, S. Kaufman, U. Dirkscneider & W. Hoffman",
UnitPrice: 0.99
}
]
// a sample query result
r1[0]
// a sample query result set with a columns property
r2 = Object.assign(
[
{
TrackId: 1,
Name: "For Those About To Rock (We Salute You)",
Composer: "Angus Young, Malcolm Young, Brian Johnson",
UnitPrice: 0.99
},
{
TrackId: 2,
Name: "Balls to the Wall",
Composer: null,
UnitPrice: 0.99
},
{
TrackId: 3,
Name: "Fast As a Shark",
Composer: "F. Baltes, S. Kaufman, U. Dirkscneider & W. Hoffman",
UnitPrice: 0.99
}
],
{
columns: [
"TrackId",
"Name",
"Composer",
"UnitPrice"
]
}
)
// a sample columns array
r2.columns
// a sample table set schema
d1 = [
{name: "albums"},
{name: "sqlite_sequence"},
{name: "artists"},
{name: "customers"},
{name: "employees"},
{name: "genres"},
{name: "invoices"},
{name: "invoice_items"},
{name: "media_types"},
{name: "playlists"},
{name: "playlist_track"},
{name: "tracks"},
{name: "sqlite_stat1"}
]
// a sample table set schema with an explicit schema property
d2 = [
{schema: "db1", name: "albums"},
{schema: "db1", name: "sqlite_sequence"},
{schema: "db1", name: "artists"},
{schema: "db1", name: "customers"},
{schema: "db1", name: "employees"},
{schema: "db1", name: "genres"},
{schema: "db1", name: "invoices"},
{schema: "db1", name: "invoice_items"},
{schema: "db1", name: "media_types"},
{schema: "db1", name: "playlists"},
{schema: "db1", name: "playlist_track"},
{schema: "db1", name: "tracks"},
{schema: "db1", name: "sqlite_stat1"}
]
// a sample column set schema
t1 = [
{name: "TrackId", type: "integer", nullable: false, databaseType: "INTEGER"},
{name: "Name", type: "string", nullable: false, databaseType: "NVARCHAR(200)"},
{name: "AlbumId", type: "integer", nullable: true, databaseType: "INTEGER"},
{name: "MediaTypeId", type: "integer", nullable: false, databaseType: "INTEGER"},
{name: "GenreId", type: "integer", nullable: true, databaseType: "INTEGER"},
{name: "Composer", type: "string", nullable: true, databaseType: "NVARCHAR(220)"},
{name: "Milliseconds", type: "integer", inullable: false, databaseType: "INTEGER"},
{name: "Bytes", type: "integer", nullable: true, databaseType: "INTEGER"},
{name: "UnitPrice", type: "number", nullable: false, databaseType: "NUMERIC(10,2)"}
]
// a sample query with one parameter
db.query(`SELECT * FROM tracks WHERE AlbumId = ?`, [AlbumId])
AlbumId = 1
// a sample query with no parameters
db.query(`SELECT * FROM tracks WHERE AlbumId = 1`)
// a sample query that is aborted on invalidation
{
const abortController = new AbortController();
invalidation.then(() => abortController.abort());
return db.query(`SELECT * FROM tracks WHERE AlbumId = 1`, {
signal: abortController.signal
});
}
function sqliteQueryTag(strings, ...params) {
return [strings.join("?"), params];
}
q1 = sqliteQueryTag`SELECT * FROM tracks WHERE AlbumId = ${AlbumId}`
db.query(...q1)
db.sql`SELECT * FROM tracks WHERE AlbumId = ${AlbumId}`
import {db} from "@observablehq/sqlite"
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.