[{"_1":2,"_217":-5,"_218":-5},"loaderData",{"_3":4,"_92":93,"_204":205,"_216":-5},"root",{"_5":6,"_33":34,"_59":60,"_90":91},"ctx",{"_7":8,"_18":19,"_20":-5,"_21":22,"_23":24,"_25":26,"_27":26,"_28":26,"_29":30,"_31":32},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5},"sessionClaims","sessionId","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","environmentVariableKeys",[],"user","preferences_keybindings","default","preferences_theme","light","preferences_fixers",false,"preferences_copilot","preferences_selection_ai","preferences_model","claude-3-5-haiku-20241022","notification_count",0,"ENV",{"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56,"_57":58},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","7ff0b93ea2d73d116aaa5223804b392e50c8d4cf","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","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","API_URL","https://api.val.town","WORKER_FINGERPRINT","c7de7de11d2fa3884730f0fa9fd384f8","clerkState",{"_61":62},"__internal_clerk_state",{"_63":64,"_65":44,"_66":67,"_68":67,"_69":26,"_70":67,"_71":67,"_72":67,"_73":67,"_74":67,"_75":67,"_76":67,"_77":67,"_78":79,"_88":26,"_89":26},"__clerk_ssr_state",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__signInForceRedirectUrl","__signUpForceRedirectUrl","__signInFallbackRedirectUrl","__signUpFallbackRedirectUrl","__clerk_debug",{"_80":26,"_81":67,"_82":83,"_84":67,"_85":44,"_86":26,"_87":67},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","remixVersion",2,"routes/_app.v.$handle.$name",{"_94":95,"_96":97,"_95":98,"_187":-5,"_188":-5,"_189":190,"_133":134,"_141":142,"_101":102,"_99":100,"_119":-7,"_51":52,"_203":26},"type","val","author","8d6857d3-cf1c-4e98-a094-0e379c10badf",{"_99":100,"_96":97,"_101":102,"_103":-5,"_104":-5,"_105":106,"_107":108,"_109":110,"_111":112,"_113":26,"_114":112,"_115":116,"_117":118,"_119":120,"_121":26,"_122":123,"_124":32,"_125":126,"_127":128,"_129":128,"_130":32,"_131":-5,"_20":132,"_137":-5,"_138":-7,"_139":140,"_141":142,"_143":144},"name","vtdb","valNameId","8c3008b8-e66e-11ef-ba81-e6cdfca9ef9f","parentFolderId","isOwned","privacy","public","readme","# Val Town Database\n\nThis val exports `vtdb`, a correctly typed **Kysely** instance\nto query the [@sqlite.db](https://www.val.town/v/sqlite/db) database containing public vals.\n\nExample usage:\n\n```ts\nimport { vtdb } from 'https://esm.town/v/g/vtdb';\n\nconst vals = await vtdb.selectFrom('vals')\n .selectAll()\n .orderBy('created_at desc')\n .limit(5)\n .execute();\nconsole.log(vals.map((val) => val.name));\n```","valType","script","currentVersion","7cbfd792-e672-11ef-9abe-e6cdfca9ef9f","legacyPrivate","id","code","import type { CompiledQuery, DatabaseConnection, Dialect, QueryResult, Selectable } from 'npm:kysely';\nimport { Kysely } from 'npm:kysely';\nimport { DummyDriver, SqliteAdapter, SqliteIntrospector, SqliteQueryCompiler } from 'npm:kysely';\nimport SqlString from 'npm:sqlstring';\n\nimport { db as restdriver } from 'https://esm.town/v/sqlite/db';\n\ninterface Database {\n vals: ValsTable;\n}\ninterface ValsTable {\n id: string;\n name: string;\n code: string;\n version: number;\n type: 'script' | 'rpc' | 'interval' | 'httpnext' | 'http' | 'express' | 'email';\n privacy: 'public';\n created_at: string;\n author_id: string;\n author_username: string;\n}\ntype Val = Selectable;\n\nclass VTDriver extends DummyDriver {\n async acquireConnection(): Promise {\n return new VTConnection();\n }\n}\nclass VTConnection implements DatabaseConnection {\n async executeQuery(compiledQuery: CompiledQuery): Promise> {\n const formattedQuery = SqlString.format(compiledQuery.sql, compiledQuery.parameters);\n const { columns, rows } = await restdriver.execute(formattedQuery) as any;\n const res = { rows: rows.map( row => Object.fromEntries( row.map((v, i) => [columns[i], v]) ) ) };\n return Promise.resolve(res);\n }\n\n async *streamQuery(): AsyncIterableIterator> {\n throw new Error('streamQuery not implemented');\n }\n}\n\nconst dialect: Dialect = {\n createAdapter: () => new SqliteAdapter(),\n createDriver: () => new VTDriver(),\n createIntrospector: (db) => new SqliteIntrospector(db),\n createQueryCompiler: () => new SqliteQueryCompiler(),\n};\n\nexport const vtdb = new Kysely({ dialect });\nexport default vtdb;","createdAt",["D",1739056486526],"version",11,"currentUserHasLiked","likeCount",4,"forkCount","referenceCount",3,"dependencyCount",1,"commentCount","prCount","mergedPr",{"_133":134,"_135":136},"handle","g","profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJqRlBqSjdFTUlTVmVORmpObmFqZmJLVWh5VCJ9","forkedVal","interval","slug","g/vtdb","description","Val Town Database This val exports vtdb , a correctly typed Kysely instance\nto query the @sqlite.db database containing public vals. Example usage: import { vtdb } from 'https://esm.town/v/g/vtdb';\n\nconst vals = await vtdb.selectFrom('vals')\n .selectAll()\n .orderBy('created_at desc')\n .limit(5)\n .execute();\nconsole.log(vals.map((val) => val.name));","versions",[145,148,152,156,160,164,168,172,175,178,181,184],{"_119":120,"_146":-5,"_117":147,"_114":112},"prId",["D",1739056486526],{"_119":149,"_146":-5,"_117":150,"_114":151},10,["D",1739056421268],"55dab278-e672-11ef-a266-e6cdfca9ef9f",{"_119":153,"_146":-5,"_117":154,"_114":155},9,["D",1739056389861],"4322254e-e672-11ef-bcc8-e6cdfca9ef9f",{"_119":157,"_146":-5,"_117":158,"_114":159},8,["D",1739056139350],"add27d22-e671-11ef-851a-e6cdfca9ef9f",{"_119":161,"_146":-5,"_117":162,"_114":163},7,["D",1739056037329],"7102dd7e-e671-11ef-8107-e6cdfca9ef9f",{"_119":165,"_146":-5,"_117":166,"_114":167},6,["D",1739055995243],"57ed9cde-e671-11ef-8c72-e6cdfca9ef9f",{"_119":169,"_146":-5,"_117":170,"_114":171},5,["D",1739055813546],"eba08190-e670-11ef-bb37-e6cdfca9ef9f",{"_119":123,"_146":-5,"_117":173,"_114":174},["D",1739055734966],"bccbc30c-e670-11ef-828b-e6cdfca9ef9f",{"_119":126,"_146":-5,"_117":176,"_114":177},["D",1739055700381],"a82bfd90-e670-11ef-ad00-e6cdfca9ef9f",{"_119":91,"_146":-5,"_117":179,"_114":180},["D",1739055580170],"60857b42-e670-11ef-819e-e6cdfca9ef9f",{"_119":128,"_146":-5,"_117":182,"_114":183},["D",1739055364284],"dfd76a50-e66f-11ef-9b61-e6cdfca9ef9f",{"_119":32,"_146":-5,"_117":185,"_114":186},["D",1739054794435],"8c33fbb2-e66e-11ef-ba81-e6cdfca9ef9f","recentThread","breadcrumbs","comments",[191],{"_114":192,"_193":194,"_117":195,"_196":197,"_198":26,"_199":26,"_20":200},"aa637d16-e947-11ef-8e51-e6cdfca9ef9f","body","So cool!!! 🫶\n\nI'm definitely going to reach for this the next time I need to query public vals\n\nps - I posted this in our [community discord's #showcase channel](https://discord.com/channels/1020432421243592714/1279542466357366804/1339230657028554834) - you can [join here](https://discord.com/invite/dHv45uN5RY)",["D",1739367948236],"updatedAt",["D",1739367986322],"canDelete","canEdit",{"_133":201,"_135":202},"stevekrouse","https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg","isOwner","routes/_app.v.$handle.$name.versions.$(version)",{"_94":206,"_207":208,"_95":209},"single","redirect","/v/g/vtdb/versions",{"_114":155,"_115":210,"_119":153,"_117":211,"_212":100,"_101":102,"_109":110,"_133":134,"_11":97,"_213":-5,"_214":-5,"_215":-5,"_203":26,"_139":140},"import type { CompiledQuery, DatabaseConnection, Dialect, QueryResult, Selectable } from 'npm:kysely';\nimport { Kysely } from 'npm:kysely';\nimport { DummyDriver, SqliteAdapter, SqliteIntrospector, SqliteQueryCompiler } from 'npm:kysely';\nimport SqlString from 'npm:sqlstring';\n\nimport { db as restdriver } from 'https://esm.town/v/sqlite/db';\n\ninterface Database {\n vals: ValsTable;\n}\ninterface ValsTable {\n id: string;\n name: string;\n code: string;\n version: number;\n type: 'script' | 'rpc' | 'interval' | 'httpnext' | 'http' | 'express' | 'email';\n privacy: 'public';\n created_at: string;\n author_id: string;\n author_username: string;\n}\ntype Val = Selectable;\n\nclass VTDriver extends DummyDriver {\n async acquireConnection(): Promise {\n return new VTConnection();\n }\n}\nclass VTConnection implements DatabaseConnection {\n async executeQuery(compiledQuery: CompiledQuery): Promise> {\n console.log(compiledQuery);\n const formattedQuery = SqlString.format(compiledQuery.sql, compiledQuery.parameters);\n console.log(formattedQuery);\n const { columns, rows } = await restdriver.execute(formattedQuery) as any;\n const res = { rows: rows.map( row => Object.fromEntires( row.map((v, i) => [columns[i], v]) ) ) };\n return Promise.resolve(res);\n }\n\n async *streamQuery(): AsyncIterableIterator> {\n throw new Error('streamQuery not implemented');\n }\n}\n\nconst dialect: Dialect = {\n createAdapter: () => new SqliteAdapter(),\n createDriver: () => new VTDriver(),\n createIntrospector: (db) => new SqliteIntrospector(db),\n createQueryCompiler: () => new SqliteQueryCompiler(),\n};\n\nexport const vtdb = new Kysely({ dialect });\nexport default vtdb;",["D",1739056389861],"valName","deletedAt","messageId","threadId","routes/_app","actionData","errors"]

vtdb

Version 9