[{"_1":2,"_171":-5,"_172":-5},"loaderData",{"_3":4,"_92":93},"root",{"_5":6,"_35":36,"_65":66},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":20,"_34":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","notificationCount",0,"flagDenols","isTeamOrgMember","ENV",{"_37":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},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","c2ca74b25698bc62f1250d595e4f42af9437a7d5","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","API_URL","https://api.val.town","clerkState",{"_67":68},"__internal_clerk_state",{"_69":70,"_71":46,"_72":73,"_74":73,"_75":20,"_76":73,"_77":73,"_78":73,"_79":73,"_80":81,"_90":20,"_91":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",{"_82":20,"_19":20,"_83":73,"_84":85,"_86":73,"_87":46,"_88":20,"_89":73},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_94":95,"_96":97,"_98":99,"_100":101,"_149":150,"_168":169,"_170":-5},"handle","ericc","name","kv","path","main.ts","project",{"_102":103,"_96":97,"_104":105,"_106":-5,"_107":20,"_108":109,"_110":111,"_112":-5,"_12":113,"_114":-5,"_115":20,"_116":-5,"_117":-5,"_118":32,"_14":119,"_120":121,"_122":121,"_123":124,"_125":124,"_126":124,"_127":121,"_128":121,"_23":129,"_132":133,"_135":136,"_148":20},"id","eb9ee560-6f19-11f0-aa12-0224a6c84d84","createdAt",["D",1754081756633],"deletedAt","legacyEnvVars","privacy","public","description","KV wrapper around val SQLite","imageUrl","cbc3828a-afc7-437e-a2bd-301f961c803b","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","85869c1c-9fd0-4e69-a5b5-490b9f6ab4d1","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_94":95,"_130":131},"profileImageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/9fd20eef-2c43-4cad-8e55-b63ee64a1800/square512","org",{"_94":95,"_134":131,"_12":113},"avatar","branch",{"_137":138,"_96":44,"_102":139,"_140":103,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":97,"_147":95},"version",4,"eb9f7246-6f19-11f0-aa12-0224a6c84d84","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_102":151,"_96":99,"_152":153,"_154":-5,"_155":139,"_156":138,"_157":158,"_104":159,"_137":160,"_161":162,"_163":164,"_165":20,"_166":-5,"_98":167},"85f1243e-6f1a-11f0-83a3-0224a6c84d84","fileId","eba200d8-6f19-11f0-aa12-0224a6c84d84","parentId","branchId","branchVersion","latest",true,["D",1754082015539],3,"fileType","script","content","import { type InValue, sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst TABLE_NAME = \"kv_store_v1\";\n\nexport interface KvEntry {\n key: string;\n value: T;\n updatedAt: number;\n}\n\nexport interface KvStore {\n set(key: string, value: T): Promise;\n get(key: string): Promise;\n delete(key: string): Promise;\n list(prefix?: string): Promise[]>;\n}\n\nclass SqliteKVStore implements KvStore {\n private initialized = false;\n\n private async ensureTable(): Promise {\n if (this.initialized) return;\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n key TEXT PRIMARY KEY,\n value TEXT NOT NULL,\n updated_at INTEGER NOT NULL\n )\n `);\n\n this.initialized = true;\n }\n\n async set(key: string, value: T): Promise {\n await this.ensureTable();\n\n const jsonValue = JSON.stringify(value);\n const timestamp = Date.now();\n\n await sqlite.execute({\n sql: `\n INSERT INTO ${TABLE_NAME} (key, value, updated_at) \n VALUES (?, ?, ?)\n ON CONFLICT(key) DO UPDATE SET \n value = excluded.value,\n updated_at = excluded.updated_at\n `,\n args: [key, jsonValue, timestamp],\n });\n }\n\n async get(key: string): Promise {\n await this.ensureTable();\n\n const result = await sqlite.execute({\n sql: `SELECT value FROM ${TABLE_NAME} WHERE key = ?`,\n args: [key],\n });\n\n if (result.rows.length === 0) {\n return undefined;\n }\n\n try {\n return JSON.parse(result.rows[0].value as string) as T;\n } catch (error) {\n throw new Error(\n `Failed to parse stored value for key \"${key}\": ${error.message}`,\n );\n }\n }\n\n async delete(key: string): Promise {\n await this.ensureTable();\n\n await sqlite.execute({\n sql: `DELETE FROM ${TABLE_NAME} WHERE key = ?`,\n args: [key],\n });\n }\n\n async list(prefix?: string): Promise[]> {\n await this.ensureTable();\n\n let sql: string;\n let args: InValue[];\n\n if (prefix) {\n sql =\n `SELECT key, value, updated_at FROM ${TABLE_NAME} WHERE key LIKE ? ORDER BY key`;\n args = [`${prefix}%`];\n } else {\n sql = `SELECT key, value, updated_at FROM ${TABLE_NAME} ORDER BY key`;\n args = [];\n }\n\n const result = await sqlite.execute({ sql, args });\n\n return result.rows.map((row) => {\n try {\n return {\n key: row.key as string,\n value: JSON.parse(row.value as string) as T,\n updatedAt: row.updated_at as number,\n };\n } catch (error) {\n throw new Error(\n `Failed to parse stored value for key \"${row.key}\": ${error.message}`,\n );\n }\n });\n }\n}\n\nexport const kv: KvStore = new SqliteKVStore();","deleted","label",[99],"permalink","https://www.val.town/x/ericc/kv/code/main.ts","extension","actionData","errors"]