🗃️ 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","label",[115],"71c3b72e-477e-11f0-b1ec-76b3cceeab13","README.md","cf2fd696-477d-11f0-ba02-76b3cceeab13",["D",1749726884848],4,"# ValBase (WIP 🚧)\nA slimmed down, serverless, val-hosted (like self-hosted, but val haha), and easily extendable Supabase alternative.",[131],"pulls","forks","envVars",{"_143":52,"_145":52},"connections",{"_143":52,"_144":52},"count","unfilledCount","emptyCount",{"_20":130,"_13":131,"_116":132,"_117":-5,"_118":21,"_119":30,"_121":38,"_22":152,"_29":134,"_123":101,"_125":135,"_127":75,"_128":-5,"_149":153,"_89":154},{"_20":114,"_13":115,"_116":47,"_117":-5,"_118":21,"_119":120,"_121":38,"_22":148,"_29":52,"_123":124,"_125":126,"_127":75,"_128":-5,"_149":150,"_89":151},["D",1738970087001],"children",[],[115],["D",1749726884848],[],[131],["D",1746232597847],{"_11":12,"_87":83},{"_11":12,"_81":-5,"_82":83,"_44":45,"_84":85,"_86":75},{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_76":-5,"_77":-5,"_78":-5,"_79":14,"_80":12},"ctx",{"_68":-5,"_109":192,"_193":194,"_195":196,"_197":75,"_198":75,"_199":75,"_200":38,"_201":-5,"_202":-7,"_203":-7,"_204":52,"_205":75,"_206":75,"_207":-5,"_208":75,"_209":75,"_210":75,"_211":-5},"ENV",{"_163":164,"_165":166,"_167":26,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","5015b8df46402d8bba4f485ecc37aec202b0e06b","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>

Branches1

Branches
1