The avatar for @saneef
Saneef H. Ansari
Consultant Designer & Developer
Public
Edited
Nov 8, 2022
2 stars
Insert cell
Insert cell
db
SELECT
DISTINCT(t.TrackId), t."Name", a."Title" as Album, ar."Name" as Artist, g."Name" as "Genre"
FROM
Track t
INNER JOIN
Album a
ON
t.AlbumId = a.AlbumId
INNER JOIN
Artist ar
ON a.ArtistId = ar.ArtistId

INNER JOIN
Genre g
ON
t.GenreId = g.GenreId

WHERE g.Name = "Jazz"

-- LIMIT 30 OFFSET 0;
Insert cell
Insert cell
db = SQLiteHTTPVFSDatabaseClient.open({
configs: [
{
from: "jsonconfig",
configUrl: "https://joyful-dragon-f97da4.netlify.app/chunked/config.json"
}
]
})
Insert cell
Insert cell
Insert cell
Insert cell
class SQLiteHTTPVFSDatabaseClient {
static async open({ configs, maxBytesToRead }) {
const worker = await createDbWorker(
// you can also pass multiple config objects which can then be used
// as separate database schemas with `ATTACH virtualFilename as schemaname`,
// where `virtualFilename` is also set in the config object.
configs,
workerUrl,
wasmUrl,
maxBytesToRead // optional, defaults to Infinity
);

return new SQLiteDatabaseClient(worker.db);
}
}
Insert cell
Insert cell
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