[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_168":169,"_170":171},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_127":-5,"_20":128,"_22":129,"_130":131,"_132":133,"_25":134,"_24":-5,"_135":-5,"_136":-5,"_137":54,"_138":139,"_140":45,"_141":-5,"_142":-5,"_143":144},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","kvrt","name","ValBase","branchName","main","version","path","","project",{"_34":74,"_13":14,"_46":75,"_76":-5,"_77":45,"_78":79,"_80":79,"_81":-5,"_82":-5,"_83":84,"_85":38,"_86":45,"_87":-5,"_88":-5,"_89":48,"_90":91,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":97,"_98":97,"_99":100,"_101":100,"_102":100,"_103":97,"_104":97,"_105":106,"_107":108,"_109":110,"_111":54},"tree",[65,66],"file","contents",[32,33],"upstream","pull","ahead","behind","envVars",{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":61,"_17":62,"_49":24,"_51":63,"_53":54,"_55":-5,"_18":64},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_18":56},"id","ac6ae178-27b6-11f0-aecd-569c3dd06744","main.tsx","fileId","ac6ae236-27b6-11f0-aecd-569c3dd06744","parentId","branchId","ac67d79e-27b6-11f0-aecd-569c3dd06744","branchVersion",1,"latest",true,"createdAt",["D",1738970087001],0,"fileType","http","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\n\n// Utility for generating unique project IDs\nconst generateProjectId = () => {\n return Math.random().toString(36).substring(2, 10);\n};\n\nfunction App() {\n const [projects, setProjects] = useState([]);\n const [selectedProject, setSelectedProject] = useState(null);\n const [newProjectName, setNewProjectName] = useState('');\n const [tables, setTables] = useState([]);\n const [newTableName, setNewTableName] = useState('');\n const [newTableSchema, setNewTableSchema] = useState('');\n\n // Fetch projects on load\n useEffect(() => {\n fetchProjects();\n }, []);\n\n const fetchProjects = async () => {\n try {\n const response = await fetch('/list-projects');\n const data = await response.json();\n setProjects(data);\n } catch (error) {\n console.error('Failed to fetch projects:', error);\n }\n };\n\n const createProject = async (e: React.FormEvent) => {\n e.preventDefault();\n try {\n const response = await fetch('/create-project', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ name: newProjectName })\n });\n const project = await response.json();\n setProjects(prev => [...prev, project]);\n setNewProjectName('');\n } catch (error) {\n console.error('Failed to create project:', error);\n }\n };\n\n const selectProject = async (projectId: string) => {\n try {\n const response = await fetch(`/list-tables?projectId=${projectId}`);\n const data = await response.json();\n setSelectedProject(projectId);\n setTables(data);\n } catch (error) {\n console.error('Failed to list tables:', error);\n }\n };\n\n const createTable = async (e: React.FormEvent) => {\n e.preventDefault();\n try {\n const response = await fetch('/create-table', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ \n projectId: selectedProject, \n tableName: newTableName, \n schema: newTableSchema \n })\n });\n const table = await response.json();\n setTables(prev => [...prev, table]);\n setNewTableName('');\n setNewTableSchema('');\n } catch (error) {\n console.error('Failed to create table:', error);\n }\n };\n\n return (\n

🗃️ ValBase - Lightweight Database Management

\n \n {/* Project Creation Section */}\n

Create New Project

\n \n

\n\n {/* Project List */}\n

Projects

\n {projects.map(project => (\n

selectProject(project.id)}\n style={{ \n cursor: 'pointer', \n padding: '10px', \n backgroundColor: selectedProject === project.id ? '#e0e0e0' : '#f5f5f5',\n margin: '5px 0'\n }}\n >\n {project.name}\n

\n ))}\n

\n\n {/* Table Creation Section */}\n {selectedProject && (\n

Create Table in Project

\n setNewTableName(e.target.value)}\n placeholder=\"Table Name\"\n required\n />\n

setNewTableSchema(e.target.value)}\n              placeholder=\"Table Schema (SQL CREATE TABLE syntax)\"\n              rows={4}\n              required\n            />\n            <button type=\"submit\">Create Table</button>\n          </form>\n\n          {/* Table List */}\n          <div>\n            <h2>Tables in Project</h2>\n            {tables.map(table => (\n              <div \n                key={table.name}\n                style={{ \n                  padding: '10px', \n                  backgroundColor: '#f0f0f0',\n                  margin: '5px 0'\n                }}\n              >\n                {table.name}\n              </div>\n            ))}\n          </div>\n        </div>\n      )}\n    </div>\n  );\n}\n\nfunction client() {\n  createRoot(document.getElementById(\"root\")).render(<App />);\n}\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function server(request: Request): Promise<Response> {\n  const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n  const KEY = \"ValBase\";\n\n  // Ensure projects table exists\n  await sqlite.execute(`\n    CREATE TABLE IF NOT EXISTS ${KEY}_projects (\n      id TEXT PRIMARY KEY,\n      name TEXT NOT NULL,\n      created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n    )\n  `);\n\n  // Projects management routes\n  const url = new URL(request.url);\n  \n  // List Projects\n  if (url.pathname === '/list-projects') {\n    const projects = await sqlite.execute(`SELECT * FROM ${KEY}_projects`);\n    return new Response(JSON.stringify(projects.rows), {\n      headers: { 'Content-Type': 'application/json' }\n    });\n  }\n\n  // Create Project\n  if (url.pathname === '/create-project' && request.method === 'POST') {\n    const { name } = await request.json();\n    const projectId = generateProjectId();\n    \n    await sqlite.execute(\n      `INSERT INTO ${KEY}_projects (id, name) VALUES (?, ?)`, \n      [projectId, name]\n    );\n\n    return new Response(JSON.stringify({ id: projectId, name }), {\n      headers: { 'Content-Type': 'application/json' }\n    });\n  }\n\n  // List Tables for a Project\n  if (url.pathname === '/list-tables') {\n    const projectId = url.searchParams.get('projectId');\n    \n    // Dynamic table listing for a specific project\n    const tables = await sqlite.execute(`\n      SELECT name FROM sqlite_master \n      WHERE type='table' AND name LIKE '${KEY}_project_${projectId}_%'\n    `);\n\n    return new Response(JSON.stringify(tables.rows), {\n      headers: { 'Content-Type': 'application/json' }\n    });\n  }\n\n  // Create Table in Project\n  if (url.pathname === '/create-table' && request.method === 'POST') {\n    const { projectId, tableName, schema } = await request.json();\n    const fullTableName = `${KEY}_project_${projectId}_${tableName}`;\n\n    try {\n      // Sanitize and validate schema\n      const sanitizedSchema = schema.replace(/[;'\"]/g, '');\n      \n      await sqlite.execute(`\n        CREATE TABLE IF NOT EXISTS ${fullTableName} (\n          ${sanitizedSchema}\n        )\n      `);\n\n      return new Response(JSON.stringify({ name: fullTableName }), {\n        headers: { 'Content-Type': 'application/json' }\n      });\n    } catch (error) {\n      return new Response(JSON.stringify({ error: error.message }), {\n        status: 400,\n        headers: { 'Content-Type': 'application/json' }\n      });\n    }\n  }\n\n  // Default HTML response\n  return new Response(`\n    <html>\n      <head>\n        <title>ValBase - Database Management</title>\n        <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\n        <script src=\"https://esm.town/v/std/catch\"></script>\n      </head>\n      <body>\n        <div id=\"root\"></div>\n        <script type=\"module\" src=\"${import.meta.url}\"></script>\n      </body>\n    </html>\n  `, {\n    headers: { 'Content-Type': 'text/html' }\n  });\n}","deleted",false,"label",[36],"71c3b72e-477e-11f0-b1ec-76b3cceeab13","README.md","cf2fd696-477d-11f0-ba02-76b3cceeab13",6,["D",1749726884848],4,"# ValBase (WIP 🚧)\nA slimmed down, serverless, val-hosted (like self-hosted, but val haha), and easily extendable Supabase alternative.",[58],{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":71,"_17":62,"_49":24,"_51":63,"_53":54,"_55":-5,"_68":72,"_18":73},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":67,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_68":69,"_18":70},["D",1738970087001],"children",[],[36],["D",1749726884848],[],[58],"ac679ae0-27b6-11f0-aecd-569c3dd06744",["D",1746232597847],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","f2200a7e-17a7-4960-8b5f-db038d939a4a","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","65803414-f145-46ee-bb85-fe0888ce30ea","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_126":122},"org",{"_11":12,"_120":-5,"_121":122,"_83":84,"_123":124,"_125":54},"branch",{"_17":60,"_13":16,"_34":41,"_112":74,"_113":-5,"_114":-5,"_115":-5,"_116":-5,"_117":-5,"_118":14,"_119":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJyYzFDNkhQSDFFRVVzZ3Z4b1lNRjZVTzdHVyJ9","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_34":74,"_13":14,"_46":164,"_76":-5,"_77":45,"_78":79,"_80":79,"_81":-5,"_82":-5,"_83":84,"_85":38,"_86":45,"_87":-5,"_88":-5,"_89":48,"_90":91,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":97,"_98":97,"_99":100,"_101":100,"_102":100,"_103":97,"_104":97,"_105":165,"_107":166,"_109":167,"_111":54},[158,159],"files",[158,159],"counts",{"_149":48,"_150":43,"_151":48,"_31":152,"_153":154},[145,146],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":61,"_17":62,"_49":24,"_51":63,"_53":54,"_55":-5,"_18":148},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_18":147},[36],[58],"pulls","branches","forks",{"_155":48,"_157":48},"connections",{"_155":48,"_156":48},"count","unfilledCount","emptyCount",{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":71,"_17":62,"_49":24,"_51":63,"_53":54,"_55":-5,"_68":162,"_18":163},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":67,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_68":160,"_18":161},[],[36],[],[58],["D",1746232597847],{"_11":12,"_126":122},{"_11":12,"_120":-5,"_121":122,"_83":84,"_123":124,"_125":54},{"_17":60,"_13":16,"_34":41,"_112":74,"_113":-5,"_114":-5,"_115":-5,"_116":-5,"_117":-5,"_118":14,"_119":12},"ctx",{"_105":-5,"_142":201,"_202":203,"_204":205,"_206":54,"_207":54,"_208":54,"_209":45,"_210":-5,"_211":-7,"_212":-7,"_213":48,"_214":54,"_215":54,"_216":-5,"_217":54,"_218":54,"_219":54,"_220":-5},"ENV",{"_172":173,"_174":175,"_176":16,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","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"]
</article></body></html>

Code