[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_177":178,"_179":180},"routes/_app.x.$handle.$name",{"_98":97,"_32":45,"_106":85,"_27":107,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":119,"_120":121,"_122":25,"_123":124,"_125":49,"_126":-5,"_127":-5,"_128":129},"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":31,"_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",34,"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","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};","/** @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

{data.columns.map(c =>	{c}
{d?.toString ? d.toString() : JSON.stringify(d)}

\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",1701796480510],"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",{"_98":97,"_105":101},"org",{"_98":97,"_99":-5,"_100":101,"_18":55,"_102":103,"_104":25},"branch",{"_13":84,"_32":85,"_43":42,"_86":44,"_87":88,"_89":90,"_91":51,"_92":93,"_94":63,"_95":45,"_96":97},"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",{"_43":44,"_32":45,"_38":173,"_47":-5,"_48":49,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":31,"_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":174,"_79":175,"_81":176,"_83":25},"tree",[164,165],"files",[164,165],"counts",{"_153":90,"_154":133,"_155":156,"_157":158,"_159":160},"contents",[138,139],"upstreamProject",{"_43":93,"_32":136,"_53":-5,"_54":-5,"_50":51,"_77":137},"upstreamBranch",{"_43":88,"_38":130,"_131":132,"_32":85,"_86":93,"_13":133,"_87":-5,"_89":-5,"_134":135,"_47":-5,"_83":25,"_50":51,"_96":97,"_62":63,"_95":136},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1746037605942],"updatedAt",["D",1698165726794],1,"lockfileKey","1746074490620-esm.town_v_stevekrouse_reactExample@1-main","reactExample",{"_98":97,"_105":101},{"_43":147,"_32":148,"_30":149,"_141":-5,"_41":42,"_40":133,"_142":49,"_38":150,"_13":90,"_33":20,"_35":151,"_24":25,"_145":-5,"_27":152},{"_43":140,"_32":28,"_30":31,"_141":-5,"_41":42,"_40":14,"_142":25,"_38":143,"_13":144,"_33":34,"_35":37,"_24":25,"_145":-5,"_27":146},"df74a5e8-25f1-11f0-ad23-569c3dd06744","parentId","latest",["D",1701796480510],33,"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",[148],"pulls","branches","forks",20,"envVars",{"_161":90,"_163":90},"connections",{"_161":90,"_162":90},"count","unfilledCount","emptyCount",{"_43":147,"_32":148,"_30":149,"_141":-5,"_41":42,"_40":133,"_142":49,"_38":170,"_13":90,"_33":20,"_35":151,"_24":25,"_145":-5,"_167":171,"_27":172},{"_43":140,"_32":28,"_30":31,"_141":-5,"_41":42,"_40":14,"_142":25,"_38":166,"_13":144,"_33":34,"_35":37,"_24":25,"_145":-5,"_167":168,"_27":169},["D",1701796480510],"children",[],[28],["D",1700253305046],[],[148],["D",1746038120657],{"_98":97,"_105":101},{"_98":97,"_99":-5,"_100":101,"_18":55,"_102":103,"_104":25},{"_13":84,"_32":85,"_43":42,"_86":44,"_87":88,"_89":90,"_91":51,"_92":93,"_94":63,"_95":45,"_96":97},"ctx",{"_77":-5,"_127":210,"_211":212,"_213":214,"_215":25,"_216":25,"_217":25,"_218":49,"_219":-5,"_220":-7,"_221":-7,"_222":90,"_223":25,"_224":25,"_225":-5,"_226":25,"_227":25,"_228":25,"_229":-5},"ENV",{"_181":182,"_183":184,"_185":85,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195,"_196":197,"_198":199,"_200":201,"_202":203,"_204":205,"_206":207,"_208":209},"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 · v34