[{"_1":2,"_185":-5,"_186":-5},"loaderData",{"_3":4,"_95":96},"root",{"_5":6,"_36":37,"_68":69},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":-5,"_32":33,"_34":20,"_35":20},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20,"_21":22},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"tokenType","session_token","user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesChatPanelState","notificationCount",0,"flagDenols","isBusinessOrgMember","ENV",{"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59,"_60":61,"_62":63,"_64":65,"_66":67},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","9482d6a85defc047e7d1f1641eacf38e5d402415","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","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","API_URL","https://api.val.town","clerkState",{"_70":71},"__internal_clerk_state",{"_72":73,"_74":47,"_75":76,"_77":76,"_78":20,"_79":76,"_80":76,"_81":76,"_82":76,"_83":84,"_93":20,"_94":20},"__clerk_ssr_state",{"_21":22,"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_85":20,"_19":20,"_86":76,"_87":88,"_89":76,"_90":47,"_91":20,"_92":76},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_97":98,"_99":100,"_101":102,"_103":104,"_160":161,"_182":183,"_184":-5},"handle","vvampa","name","dns","path","lib/sqliteClient.ts","project",{"_105":106,"_99":100,"_107":108,"_109":-5,"_110":20,"_111":112,"_113":-5,"_114":-5,"_12":115,"_116":-5,"_117":20,"_118":-5,"_119":-5,"_120":33,"_14":121,"_122":123,"_124":125,"_126":127,"_128":-5,"_129":130,"_131":130,"_132":133,"_134":133,"_135":133,"_136":130,"_137":130,"_23":138,"_141":142,"_146":147,"_159":20},"id","0fef6ee0-060e-11f1-b9bd-42dde27851f2","createdAt",["D",1770679289177],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","4014c640-61ba-11f0-852d-15ceec715ebe","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","4014c641-61ba-11f0-852d-15ceec715ebe","tursoName","0fef6ee0060e11f1b9bd42dde27851f2","tursoHostname","0fef6ee0060e11f1b9bd42dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1775517075736],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_97":98,"_139":140},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ6dlV1b1h4VzRxbTBVblhueldOUjc4R3N1ViJ9","org",{"_97":98,"_143":140,"_12":115,"_144":145},"avatar","tier","free","branch",{"_148":149,"_99":45,"_105":150,"_151":106,"_152":-5,"_153":-5,"_154":-5,"_155":-5,"_156":-5,"_157":100,"_158":98},"version",116,"0ff07f1a-060e-11f1-b9bd-42dde27851f2","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_105":162,"_99":163,"_164":165,"_166":167,"_168":150,"_169":170,"_171":172,"_107":173,"_148":33,"_174":175,"_176":177,"_178":20,"_179":-5,"_101":180},"59468718-172f-11f1-a0d9-42dde27851f2","sqliteClient.ts","fileId","594687e0-172f-11f1-a0d9-42dde27851f2","parentId","34b6594e-0610-11f1-966e-42dde27851f2","branchId","branchVersion",70,"latest",true,["D",1772562755377],"fileType","script","content","type SqlExecInput = string | { sql: string; args?: unknown[] };\ntype SqlExecOutput = { rows: Record[] };\n\ninterface SqlExecutor {\n execute(input: SqlExecInput): Promise;\n}\n\nlet executorPromise: Promise | null = null;\n\nfunction isUnauthorizedError(err: unknown): boolean {\n const msg = err instanceof Error ? err.message : String(err);\n return msg.includes(\"401\") || msg.toLowerCase().includes(\"unauthorized\");\n}\n\nfunction isNetworkImportError(err: unknown): boolean {\n const msg = err instanceof Error ? err.message : String(err);\n return msg.includes(\"dns error\") || msg.includes(\"Could not resolve host\");\n}\n\nasync function createValTownExecutor(): Promise {\n const mod = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const vt = mod.sqlite as {\n execute: (input: SqlExecInput) => Promise;\n };\n\n await vt.execute(\"select 1 as ok\");\n return { execute: (input: SqlExecInput) => vt.execute(input) };\n}\n\nasync function createLocalExecutor(): Promise {\n const { Database } = await import(\"jsr:@db/sqlite@0.12.0\");\n const dbPath = Deno.env.get(\"LOCAL_SQLITE_PATH\") || \"./local.dev.sqlite3\";\n const db = new Database(dbPath);\n\n return {\n async execute(input: SqlExecInput): Promise {\n const sql = typeof input === \"string\" ? input : input.sql;\n const args = typeof input === \"string\" ? [] : (input.args ?? []);\n const stmt = db.prepare(sql) as {\n all: (...params: unknown[]) => Record[];\n };\n const rows = stmt.all(...args);\n return { rows: rows ?? [] };\n },\n };\n}\n\nasync function resolveExecutor(): Promise {\n const mode = (Deno.env.get(\"SQLITE_MODE\") || \"auto\").toLowerCase();\n if (mode === \"local\") return await createLocalExecutor();\n if (mode === \"valtown\") return await createValTownExecutor();\n\n try {\n return await createValTownExecutor();\n } catch (err) {\n if (isUnauthorizedError(err) || isNetworkImportError(err)) {\n console.warn(\"Falling back to local SQLite for development.\");\n return await createLocalExecutor();\n }\n throw err;\n }\n}\n\nasync function getExecutor(): Promise {\n if (!executorPromise) executorPromise = resolveExecutor();\n return await executorPromise;\n}\n\nexport const sqlite = {\n async execute(input: SqlExecInput): Promise {\n const exec = await getExecutor();\n return await exec.execute(input);\n },\n};\n","deleted","label",[181,163],"lib","permalink","https://www.val.town/x/vvampa/dns/code/lib/sqliteClient.ts","extension","actionData","errors"]