[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_176":177,"_178":179},"routes/_app.x.$handle.$name",{"_97":96,"_32":44,"_105":84,"_27":106,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":118,"_119":120,"_121":25,"_122":123,"_124":48,"_125":-5,"_126":-5,"_127":128},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_32":44,"_37":45,"_46":-5,"_47":48,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":31,"_56":48,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":77,"_78":79,"_80":81,"_82":25},"version",30,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.tsx","latestPath","fileId","def9b9f0-25f1-11f0-ad23-569c3dd06744","name","fileType","http","content","/** @jsxImportSource https://esm.sh/react */\nimport { sqlite } from \"https://esm.town/v/std/sqlite?v=4\";\nimport { html } from \"https://esm.town/v/stevekrouse/html\";\nimport { renderToString } from \"npm:react-dom/server\";\n\nasync function listTables() {\n let data = await sqlite.execute(`SELECT \n name\nFROM \n sqlite_schema\nWHERE \n type ='table' AND \n name NOT LIKE 'sqlite_%';`);\n return data.rows;\n}\n\nasync function list() {\n let tables = await listTables();\n return (\n

\n {tables.map(t => (\n

\n {t.toString()}\n

\n ))}\n

\n );\n}\n\nasync function table(name: string) {\n if (!name.match(/^[A-Za-z_][A-Za-z0-9_]*$/)) return <>Invalid table name;\n let data = await sqlite.execute(`SELECT * FROM ${name}`);\n return (\n \n )}\n \n {data.rows.map(r => (\n \n {r.map(d => )}\n \n ))}\n \n

{data.columns.map(c =>	{c}
{d.toString()}

\n );\n}\n\nexport const sqliteViewer = async (req: Request) => {\n let url = new URL(req.url);\n let component = await (url.pathname === \"/\" ? list() : table(url.pathname.slice(1)));\n return html(\n renderToString(\n component,\n ),\n );\n};","createdAt",["D",1701093567666],"branchVersion","branchId","def7b2ea-25f1-11f0-ad23-569c3dd06744","id","def77bcc-25f1-11f0-ad23-569c3dd06744","sqlite_admin",["D",1746038120657],"deletedAt","legacyEnvVars",true,"privacy","public","httpPrivacy","description","imageUrl","a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",5,"orgId","e81e7335-6d4c-4764-a902-d0962bbfa9f7","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_97":96,"_104":100},"org",{"_97":96,"_98":-5,"_99":100,"_18":54,"_101":102,"_103":25},"branch",{"_13":83,"_32":84,"_42":41,"_85":43,"_86":87,"_88":89,"_90":50,"_91":92,"_93":62,"_94":44,"_95":96},"isOwned",52,"main","projectId","forkedBranchId","ac2c5f7e-25f0-11f0-ad23-569c3dd06744","forkedBranchVersion",0,"forkedProjectPrivacy","forkedProjectId","ac2c19ec-25f0-11f0-ad23-569c3dd06744","forkedProjectOrgId","projectName","userHandle","stevekrouse","handle","displayName","avatar","https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_32":44,"_37":172,"_46":-5,"_47":48,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":31,"_56":48,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":173,"_78":174,"_80":175,"_82":25},"tree",[163,164],"files",[163,164],"counts",{"_152":89,"_153":132,"_154":155,"_156":157,"_158":159},"contents",[137,138],"upstreamProject",{"_42":92,"_32":135,"_52":-5,"_53":-5,"_49":50,"_76":136},"upstreamBranch",{"_42":87,"_37":129,"_130":131,"_32":84,"_85":92,"_13":132,"_86":-5,"_88":-5,"_133":134,"_46":-5,"_82":25,"_49":50,"_95":96,"_61":62,"_94":135},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1746037605942],"updatedAt",["D",1698165726794],1,"lockfileKey","1746074490620-esm.town_v_stevekrouse_reactExample@1-main","reactExample",{"_97":96,"_104":100},{"_42":146,"_32":147,"_30":148,"_140":-5,"_40":41,"_39":132,"_141":48,"_37":149,"_13":89,"_33":20,"_35":150,"_24":25,"_144":-5,"_27":151},{"_42":139,"_32":28,"_30":31,"_140":-5,"_40":41,"_39":14,"_141":25,"_37":142,"_13":143,"_33":34,"_35":36,"_24":25,"_144":-5,"_27":145},"df675fc8-25f1-11f0-ad23-569c3dd06744","parentId","latest",["D",1701093567666],29,"label",[28],"def9bd88-25f1-11f0-ad23-569c3dd06744","README.md","def9be0a-25f1-11f0-ad23-569c3dd06744",["D",1700253305046],"# SQLite Admin\n\nThis is a lightweight SQLite Admin interface to view and debug your SQLite data.\n\n![Screenshot 2023-12-08 at 13.35.04.gif](https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/ee9a9237-96a0-4276-60b5-aa8c56e49800/public)\n\nIt's currently super limited (no pagination, editing data, data-type specific viewers), and is just a couple dozens lines of code over a couple different vals. Forks encouraged! Just comment on the val if you add any features that you want to share.\n\nTo use it on your own Val Town SQLite database, [fork it](https://www.val.town/v/stevekrouse/sqlite_admin/fork) to your account.\n\nIt uses [basic authentication](https://www.val.town/v/pomdtr/basicAuth) with your [Val Town API Token](https://www.val.town/settings/api) as the password (leave the username field blank).\n\nMigrated from folder: utils/sqlite_admin/sqlite_admin",[147],"pulls","branches","forks",20,"envVars",{"_160":89,"_162":89},"connections",{"_160":89,"_161":89},"count","unfilledCount","emptyCount",{"_42":146,"_32":147,"_30":148,"_140":-5,"_40":41,"_39":132,"_141":48,"_37":169,"_13":89,"_33":20,"_35":150,"_24":25,"_144":-5,"_166":170,"_27":171},{"_42":139,"_32":28,"_30":31,"_140":-5,"_40":41,"_39":14,"_141":25,"_37":165,"_13":143,"_33":34,"_35":36,"_24":25,"_144":-5,"_166":167,"_27":168},["D",1701093567666],"children",[],[28],["D",1700253305046],[],[147],["D",1746038120657],{"_97":96,"_104":100},{"_97":96,"_98":-5,"_99":100,"_18":54,"_101":102,"_103":25},{"_13":83,"_32":84,"_42":41,"_85":43,"_86":87,"_88":89,"_90":50,"_91":92,"_93":62,"_94":44,"_95":96},"ctx",{"_76":-5,"_126":209,"_210":211,"_212":213,"_214":25,"_215":25,"_216":25,"_217":48,"_218":-5,"_219":-7,"_220":-7,"_221":89,"_222":25,"_223":25,"_224":-5,"_225":25,"_226":25,"_227":25,"_228":-5},"ENV",{"_180":181,"_182":183,"_184":84,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208},"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 · v30