🗃️ 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}",[],[172],"files",[151,170],"counts",{"_183":32,"_184":173,"_185":32,"_186":32},"pulls","branches","forks","envVars","contents",[],{"_103":152,"_95":99,"_153":154,"_155":-5,"_156":139,"_157":138,"_158":109,"_105":190,"_100":160,"_161":162,"_163":164,"_165":22,"_166":-5,"_98":191},["D",1749726884848],[99],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.code.$",{"_93":94,"_95":96,"_97":43,"_100":-7,"_98":99,"_101":200,"_149":205,"_179":212,"_162":213,"_187":215,"_216":-5,"_217":22,"_218":-5,"_219":-5,"_220":-5,"_221":222},{"_103":104,"_95":96,"_105":201,"_107":-5,"_108":109,"_110":111,"_112":-5,"_113":-5,"_14":114,"_115":116,"_117":109,"_118":-5,"_119":32,"_16":120,"_121":122,"_123":122,"_124":125,"_126":125,"_127":125,"_128":122,"_129":122,"_23":202,"_133":203,"_136":204,"_148":22},["D",1746232597847],{"_93":94,"_131":132},{"_93":94,"_135":132},{"_100":138,"_95":43,"_103":139,"_140":104,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":96,"_147":94},[206,209],{"_103":152,"_95":99,"_153":154,"_155":-5,"_156":139,"_157":138,"_158":109,"_105":159,"_100":160,"_161":162,"_163":164,"_165":22,"_166":-5,"_167":207,"_98":208},[],[99],{"_103":171,"_95":172,"_153":116,"_155":-5,"_156":139,"_157":173,"_158":109,"_105":174,"_100":32,"_161":175,"_163":176,"_165":22,"_166":-5,"_167":210,"_98":211},[],[172],[206,209],{"_103":152,"_95":99,"_153":154,"_155":-5,"_156":139,"_157":138,"_158":109,"_105":190,"_100":160,"_161":162,"_163":164,"_165":22,"_166":-5,"_98":214},[99],[],"upstream","showCompareCallout","pull","ahead","behind","templates",[],"actionData","errors"]
</article></body></html>

ValBase (WIP 🚧)