[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_164":165,"_166":167},"routes/_app.x.$handle.$name",{"_95":94,"_32":45,"_103":85,"_27":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":25,"_118":119,"_120":25,"_121":-5,"_122":-5,"_123":124},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":49,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":-5,"_57":49,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":25},"version",4,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.tsx","latestPath","fileId","beaa4438-279c-11f0-9d52-569c3dd06744","name","fileType","script","content","import * as kysely from \"npm:kysely@^0.27.3\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite?v=5\";\n\nexport interface VtDialectConfig {\n authToken?: string,\n}\n\nexport class VtDialect implements kysely.Dialect {\n #config: VtDialectConfig\n\n constructor(config: VtDialectConfig) {\n this.#config = config;\n }\n\n createAdapter(): kysely.DialectAdapter {\n return new kysely.SqliteAdapter();\n }\n\n createDriver(): kysely.Driver {\n return new VtDriver();\n }\n\n createIntrospector(db: kysely.Kysely): kysely.DatabaseIntrospector {\n return new kysely.SqliteIntrospector(db);\n }\n\n createQueryCompiler(): kysely.QueryCompiler {\n return new kysely.SqliteQueryCompiler();\n }\n}\n\nexport class VtDriver implements kysely.Driver {\n async init(): Promise {\n }\n\n async acquireConnection(): Promise {\n return new VtConnection();\n }\n\n async beginTransaction(\n connection: VtConnection,\n _settings: kysely.TransactionSettings,\n ): Promise {\n throw new Error(\"val.town does not support transactions\");\n }\n\n async commitTransaction(connection: VtConnection): Promise {\n throw new Error(\"val.town does not support transactions\");\n }\n\n async rollbackTransaction(connection: VtConnection): Promise {\n throw new Error(\"val.town does not support transactions\");\n }\n\n async releaseConnection(connection: VtConnection): Promise {\n }\n\n async destroy(): Promise {\n }\n}\n\nexport class VtConnection implements kysely.DatabaseConnection {\n async executeQuery(compiledQuery: kysely.CompiledQuery): Promise> {\n const result = await sqlite.execute({\n sql: compiledQuery.sql,\n args: compiledQuery.parameters as any\n });\n return {\n numAffectedRows: BigInt(result.rowsAffected),\n rows: result.rows as R[],\n };\n }\n\n async *streamQuery(\n _compiledQuery: kysely.CompiledQuery,\n _chunkSize: number,\n ): AsyncIterableIterator> {\n throw new Error(\"val.town does not support streaming yet\");\n }\n}\n","import { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport * as kysely from \"npm:kysely@^0.27.3\";\n\nexport class VtDialect implements kysely.Dialect {\n createAdapter(): kysely.DialectAdapter {\n return new kysely.SqliteAdapter();\n }\n\n createDriver(): kysely.Driver {\n return new VtDriver();\n }\n\n createIntrospector(db: kysely.Kysely): kysely.DatabaseIntrospector {\n return new kysely.SqliteIntrospector(db);\n }\n\n createQueryCompiler(): kysely.QueryCompiler {\n return new kysely.SqliteQueryCompiler();\n }\n}\n\nexport class VtDriver implements kysely.Driver {\n async init(): Promise {\n }\n\n async acquireConnection(): Promise {\n return new VtConnection();\n }\n\n async beginTransaction(\n connection: VtConnection,\n _settings: kysely.TransactionSettings,\n ): Promise {\n throw new Error(\"val.town does not support transactions\");\n }\n\n async commitTransaction(connection: VtConnection): Promise {\n throw new Error(\"val.town does not support transactions\");\n }\n\n async rollbackTransaction(connection: VtConnection): Promise {\n throw new Error(\"val.town does not support transactions\");\n }\n\n async releaseConnection(connection: VtConnection): Promise {\n }\n\n async destroy(): Promise {\n }\n}\n\nexport class VtConnection implements kysely.DatabaseConnection {\n async executeQuery(compiledQuery: kysely.CompiledQuery): Promise> {\n const result = await sqlite.execute({\n sql: compiledQuery.sql,\n args: compiledQuery.parameters as any,\n });\n return {\n numAffectedRows: BigInt(result.rowsAffected),\n rows: result.rows as R[],\n };\n }\n\n async *streamQuery(\n _compiledQuery: kysely.CompiledQuery,\n _chunkSize: number,\n ): AsyncIterableIterator> {\n throw new Error(\"val.town does not support streaming yet\");\n }\n}","createdAt",["D",1711933311855],"branchVersion","branchId","bea857ae-279c-11f0-9d52-569c3dd06744","id","bea8114a-279c-11f0-9d52-569c3dd06744","kyselyVtDialect",["D",1746221461553],"deletedAt","legacyEnvVars",true,"privacy","public","httpPrivacy","description","imageUrl","c2a2fc8a-0a8c-4a4d-aba0-1ce9b42cecee","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",1,"orgId","ef233ec9-c465-4ecf-b676-6fe2df48e438","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":55,"_99":100,"_101":25},"branch",{"_13":84,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"isOwned",5,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","easrng","handle","displayName","avatar","https://images.clerk.dev/oauth_github/img_2Qn86tpR8Fwsj1TjoMg9t1DCmc2.png","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":160,"_47":-5,"_48":49,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":-5,"_57":49,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":161,"_79":162,"_81":163,"_83":25},"tree",[151,152],"files",[151,152],"counts",{"_141":138,"_142":61,"_143":138,"_144":145,"_146":147},"contents",[125,126],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":134,"_32":135,"_30":136,"_128":-5,"_41":42,"_40":61,"_129":49,"_38":137,"_13":138,"_33":20,"_35":139,"_24":25,"_132":-5,"_27":140},{"_43":127,"_32":28,"_30":31,"_128":-5,"_41":42,"_40":14,"_129":25,"_38":130,"_13":131,"_33":34,"_35":37,"_24":25,"_132":-5,"_27":133},"beb9bb7a-279c-11f0-9d52-569c3dd06744","parentId","latest",["D",1711933311855],3,"label",[28],"beaa4da2-279c-11f0-9d52-569c3dd06744","README.md","beaa4e4c-279c-11f0-9d52-569c3dd06744",["D",1711931978812],0,"# Kysely Dialect for @std/sqlite\n## Caveats\nIt doesn't support transactions, there's no real way to do them on top of @std/sqlite AFAICT.\n## Usage\n```ts\nimport { VtDialect } from \"https://esm.town/v/easrng/kyselyVtDialect\";\nimport { Kysely } from \"npm:kysely\";\n\nconst db = new Kysely({\n dialect: new VtDialect(),\n});\n```\n## Demo\nSee @easrng/kyselyVtDemo, which uses this along with @easrng/kyselyVtTypes to generate schema types.",[135],"pulls","branches","forks","envVars",{"_148":138,"_150":138},"connections",{"_148":138,"_149":138},"count","unfilledCount","emptyCount",{"_43":134,"_32":135,"_30":136,"_128":-5,"_41":42,"_40":61,"_129":49,"_38":157,"_13":138,"_33":20,"_35":139,"_24":25,"_132":-5,"_154":158,"_27":159},{"_43":127,"_32":28,"_30":31,"_128":-5,"_41":42,"_40":14,"_129":25,"_38":153,"_13":131,"_33":34,"_35":37,"_24":25,"_132":-5,"_154":155,"_27":156},["D",1711933311855],"children",[],[28],["D",1711931978812],[],[135],["D",1746221461553],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":55,"_99":100,"_101":25},{"_13":84,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"ctx",{"_77":-5,"_122":197,"_198":199,"_200":201,"_202":25,"_203":25,"_204":25,"_205":49,"_206":-5,"_207":-7,"_208":-7,"_209":138,"_210":25,"_211":25,"_212":-5,"_213":25,"_214":25,"_215":25,"_216":-5},"ENV",{"_168":169,"_170":171,"_172":85,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v4