kysely = import("https://cdn.jsdelivr.net/npm/kysely/dist/esm/index.js")
vfs = import("https://cdn.jsdelivr.net/npm/@typescript/vfs@1.4.0/+esm")
ts = (await import("https://cdn.jsdelivr.net/npm/typescript@4.8.4/+esm")).default
Kysely = kysely.Kysely
DummyDriver = kysely.DummyDriver
SqliteAdapter = kysely.SqliteAdapter
SqliteIntrospector = kysely.SqliteIntrospector
SqliteQueryCompiler = kysely.SqliteQueryCompiler
tsEnv = {
storage;
const {createSystem, createVirtualTypeScriptEnvironment, createDefaultMapFromCDN} = vfs;
const fsMap = await createDefaultMapFromCDN({target: ts.ScriptTarget.ES2021}, ts.version, true, ts);
const system = createSystem(fsMap);
const tsEnv = createVirtualTypeScriptEnvironment(system, [], ts, {allowJs: true});
tsEnv.createFile("/index.js", " "); // This is where our code will go. Note: can’t be empty 😅
return tsEnv;
}
completions = {
tsEnv.updateFile("/index.js", editor1.code || " ");
return tsEnv.languageService.getCompletionsAtPosition("/index.js", editor1.offset, {});
}
sql = db.selectFrom("person").select("id").compile()
db = new Kysely({
dialect: {
createAdapter() {
return new SqliteAdapter();
},
createDriver() {
return new DummyDriver();
},
// createIntrospector(db: Kysely<unknown>) {
// return new SqliteIntrospector(db)
// },
createQueryCompiler() {
return new SqliteQueryCompiler();
}
}
})
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.
