Vals using kysely

Val Town Database This val exports vtdb , a correctly typed Kysely instance to query the @sqlite.db database containing public vals. Example usage: import { vtdb } from 'https://esm.town/v/g/vtdb'; const vals = await vtdb.selectFrom('vals') .selectAll() .orderBy('created_at desc') .limit(5) .execute(); console.log(vals.map((val) => val.name));

An interactive, runnable TypeScript val by pomdtr

Forked from easrng/kyselyVtDemo

Kysely on val.town Uses @easrng/kyselyVtDialect as a Kysely Dialect and @easrng/kyselyVtTypes for type autogeneration.

Kysely Dialect for @std/sqlite Caveats It doesn't support transactions, there's no real way to do them on top of @std/sqlite AFAICT. Usage import { VtDialect } from "https://esm.town/v/easrng/kyselyVtDialect"; import { Kysely } from "npm:kysely"; const db = new Kysely({ dialect: new VtDialect(), }); Demo See @easrng/kyselyVtDemo, which uses this along with @easrng/kyselyVtTypes to generate schema types.

An interactive, runnable TypeScript val by neverstew