[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_278":279,"_280":281},"routes/_app.x.$handle.$name",{"_102":101,"_32":51,"_110":92,"_27":111,"_13":14,"_112":-5,"_11":113,"_114":115,"_116":117,"_118":119,"_120":121,"_21":-5,"_122":-5,"_123":-5,"_124":25,"_125":126,"_127":25,"_128":-5,"_129":-5,"_130":131},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_49":50,"_32":51,"_37":52,"_53":-5,"_54":25,"_55":56,"_57":56,"_58":-5,"_59":-5,"_18":60,"_61":62,"_63":64,"_65":64,"_66":-5,"_67":68,"_69":70,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":85,"_86":87,"_88":89,"_90":25},"version",9,"changes",[19,20],"aiChatInfo","userId",{"_21":42,"_23":-7,"_24":25,"_26":25,"_27":43,"_29":43},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":-5,"_37":38,"_39":14,"_40":41,"_24":25},"previous","deleted",false,"deletedHere","path","frontend/components","latestPath","fileId","b75bff5b-ce06-4bc4-9f42-ba40ac731846","name","components","fileType","directory","content","createdAt",["D",1748871686783],"branchVersion","branchId","0db0f680-3fb7-11f0-a1a7-76b3cceeab13",{"_30":44,"_32":45,"_34":46,"_36":47,"_37":48,"_39":14,"_40":41,"_24":25},"frontend/components/App.tsx","4801dc5a-3fb7-11f0-af77-76b3cceeab13","App.tsx","script","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport ProjectForm from \"./ProjectForm.tsx\";\nimport ProjectCard from \"./ProjectCard.tsx\";\nimport type { Project } from \"../../shared/types.ts\";\n\ndeclare global {\n interface Window {\n __INITIAL_PROJECTS__?: Project[];\n }\n}\n\nexport default function App() {\n const [projects, setProjects] = useState([]);\n const [showForm, setShowForm] = useState(false);\n const [loading, setLoading] = useState(false);\n\n useEffect(() => {\n // Use initial data if available, otherwise fetch\n if (window.__INITIAL_PROJECTS__) {\n setProjects(window.__INITIAL_PROJECTS__);\n } else {\n fetchProjects();\n }\n }, []);\n\n const fetchProjects = async () => {\n try {\n setLoading(true);\n const response = await fetch(\"/api/projects\");\n if (response.ok) {\n const data = await response.json();\n setProjects(data);\n }\n } catch (error) {\n console.error(\"Error fetching projects:\", error);\n } finally {\n setLoading(false);\n }\n };\n\n const handleProjectSubmitted = (newProject: Project) => {\n setProjects(prev => [newProject, ...prev]);\n setShowForm(false);\n };\n\n return (\n

\n {/* Header */}\n

\n 🤖 Community AI Project Showcase\n

\n Discover and share amazing AI projects from the community\n

\n setShowForm(!showForm)}\n className=\"bg-blue-600 hover:bg-blue-700 text-white px-6 py-3 rounded-lg font-medium transition-colors\"\n >\n {showForm ? \"Cancel\" : \"Submit Project\"}\n \n

\n\n

\n {/* Project Submission Form */}\n {showForm && (\n

\n \n

\n )}\n\n {/* Projects Grid */}\n

\n Featured Projects ({projects.length})\n

\n {loading && (\n

\n )}\n

\n\n {projects.length === 0 && !loading ? (\n

🚀

\n No projects yet\n

\n Be the first to share your AI project with the community!\n

\n setShowForm(true)}\n className=\"bg-blue-600 hover:bg-blue-700 text-white px-6 py-3 rounded-lg font-medium transition-colors\"\n >\n Submit First Project\n \n

\n ) : (\n

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

\n )}\n

\n\n {/* Footer */}\n \n

\n );\n}",["D",1748871686783],"id","0dad7eec-3fb7-11f0-a1a7-76b3cceeab13","Community_AI_Project_Showcase",["D",1748871588946],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","ebddac60-3fb1-11f0-ad5b-814c56c8abb0","pinnedFileId","371aa552-3fb7-11f0-9480-76b3cceeab13","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","bbdb79e9-4641-405b-b31c-3766f4f8592e","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_102":101,"_109":105},"org",{"_102":101,"_103":-5,"_104":105,"_18":60,"_106":107,"_108":25},"branch",{"_13":91,"_32":92,"_49":41,"_93":50,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":51,"_100":101},"isOwned",18,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","ianochieng","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yeHhBVFdpc3RiNHFHZVZ1Um1CVHluTUpkenMifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_49":50,"_32":51,"_37":274,"_53":-5,"_54":25,"_55":56,"_57":56,"_58":-5,"_59":-5,"_18":60,"_61":62,"_63":64,"_65":64,"_66":-5,"_67":68,"_69":70,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":275,"_86":276,"_88":277,"_90":25},"tree",[174,181,186,188],"files",[174,175,176,177,178,179,180,181,182,183,184,185,186,187,188],"counts",{"_164":68,"_165":140,"_166":68,"_167":168,"_169":170},"contents",[132,133,134,135],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_49":158,"_32":159,"_30":160,"_139":-5,"_40":41,"_39":161,"_141":64,"_37":162,"_13":68,"_34":35,"_36":-5,"_24":25,"_144":-5,"_27":163},{"_49":152,"_32":153,"_30":154,"_139":-5,"_40":41,"_39":155,"_141":64,"_37":156,"_13":68,"_34":35,"_36":-5,"_24":25,"_144":-5,"_27":157},{"_49":146,"_32":147,"_30":148,"_139":-5,"_40":41,"_39":149,"_141":64,"_37":150,"_13":68,"_34":35,"_36":-5,"_24":25,"_144":-5,"_27":151},{"_49":136,"_32":137,"_30":138,"_139":-5,"_40":41,"_39":140,"_141":64,"_37":142,"_13":68,"_34":21,"_36":143,"_24":25,"_144":-5,"_27":145},"208d071c-3fb7-11f0-a5e5-76b3cceeab13","README.md","208d07c6-3fb7-11f0-a5e5-76b3cceeab13","parentId",1,"latest",["D",1748871620610],"# Community AI Project Showcase\n\nA web application for showcasing AI projects from the community. Users can submit their AI projects and browse through all submitted projects.\n\n## Features\n\n- Submit AI projects with title, description, link, and category\n- Browse all submitted projects in a card-based layout\n- Categories include: Machine Learning, NLP, Computer Vision, Generative AI, Data Science, Robotics, Other AI\n- Responsive design with TailwindCSS\n\n## Project Structure\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Database schema\n│ │ └── queries.ts # Database operations\n│ ├── routes/\n│ │ └── projects.ts # Project API routes\n│ └── index.ts # Main Hono server\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx # Main React app\n│ │ ├── ProjectForm.tsx # Project submission form\n│ │ └── ProjectCard.tsx # Individual project display\n│ ├── index.html # HTML template\n│ └── index.tsx # React entry point\n└── shared/\n └── types.ts # Shared TypeScript types\n```\n\n## API Endpoints\n\n- `GET /` - Serves the main application\n- `GET /api/projects` - Get all projects\n- `POST /api/projects` - Submit a new project\n\n## Tech Stack\n\n- Backend: Hono + SQLite\n- Frontend: React + TailwindCSS\n- Database: SQLite\n- Styling: TailwindCSS via Twind","label",[137],"238553d4-3fb7-11f0-ac23-76b3cceeab13","shared","6357d12e-f17b-4685-a713-10bfc7c8cbaa",2,["D",1748871625588],[147],"3ab36fe6-3fb7-11f0-8505-76b3cceeab13","frontend","d2cd8fb5-e6af-40b2-b90c-7585b076bf97",7,["D",1748871664476],[153],"26e72692-3fb7-11f0-8003-76b3cceeab13","backend","425b74b6-334b-4f5d-b568-679b4d6dd0da",3,["D",1748871631266],[159],"pulls","branches","forks","envVars",{"_171":68,"_173":68},"connections",{"_171":68,"_172":68},"count","unfilledCount","emptyCount",{"_49":158,"_32":159,"_30":160,"_139":-5,"_40":41,"_39":161,"_141":64,"_37":271,"_13":68,"_34":35,"_36":-5,"_24":25,"_144":-5,"_190":272,"_27":273},{"_49":267,"_32":259,"_30":253,"_139":160,"_40":41,"_39":161,"_141":64,"_37":268,"_13":68,"_34":35,"_36":-5,"_24":25,"_144":-5,"_190":269,"_27":270},{"_49":260,"_32":261,"_30":262,"_139":253,"_40":41,"_39":161,"_141":64,"_37":263,"_13":68,"_34":46,"_36":264,"_24":25,"_144":-5,"_190":265,"_27":266},{"_49":250,"_32":251,"_30":252,"_139":253,"_40":41,"_39":254,"_141":25,"_37":255,"_13":68,"_34":46,"_36":256,"_24":25,"_144":-5,"_190":257,"_27":258},{"_49":246,"_32":245,"_30":239,"_139":160,"_40":41,"_39":240,"_141":64,"_37":247,"_13":68,"_34":35,"_36":-5,"_24":25,"_144":-5,"_190":248,"_27":249},{"_49":236,"_32":237,"_30":238,"_139":239,"_40":41,"_39":240,"_141":25,"_37":241,"_13":68,"_34":46,"_36":242,"_24":25,"_144":-5,"_190":243,"_27":244},{"_49":229,"_32":230,"_30":62,"_139":160,"_40":41,"_39":231,"_141":25,"_37":232,"_13":68,"_34":46,"_36":233,"_24":25,"_144":-5,"_190":234,"_27":235},{"_49":152,"_32":153,"_30":154,"_139":-5,"_40":41,"_39":155,"_141":64,"_37":226,"_13":68,"_34":35,"_36":-5,"_24":25,"_144":-5,"_190":227,"_27":228},{"_49":222,"_32":33,"_30":31,"_139":154,"_40":41,"_39":14,"_141":64,"_37":223,"_13":68,"_34":35,"_36":-5,"_24":25,"_144":-5,"_190":224,"_27":225},{"_49":218,"_32":45,"_30":44,"_139":31,"_40":41,"_39":14,"_141":64,"_37":219,"_13":68,"_34":46,"_36":47,"_24":25,"_144":-5,"_190":220,"_27":221},{"_49":211,"_32":212,"_30":213,"_139":154,"_40":41,"_39":155,"_141":64,"_37":214,"_13":68,"_34":21,"_36":215,"_24":25,"_144":-5,"_190":216,"_27":217},{"_49":203,"_32":204,"_30":205,"_139":154,"_40":41,"_39":206,"_141":64,"_37":207,"_13":68,"_34":46,"_36":208,"_24":25,"_144":-5,"_190":209,"_27":210},{"_49":146,"_32":147,"_30":148,"_139":-5,"_40":41,"_39":149,"_141":64,"_37":200,"_13":68,"_34":35,"_36":-5,"_24":25,"_144":-5,"_190":201,"_27":202},{"_49":193,"_32":194,"_30":195,"_139":148,"_40":41,"_39":149,"_141":64,"_37":196,"_13":68,"_34":46,"_36":197,"_24":25,"_144":-5,"_190":198,"_27":199},{"_49":136,"_32":137,"_30":138,"_139":-5,"_40":41,"_39":140,"_141":64,"_37":189,"_13":68,"_34":21,"_36":143,"_24":25,"_144":-5,"_190":191,"_27":192},["D",1748871620610],"children",[],[137],"238537e6-3fb7-11f0-ac23-76b3cceeab13","types.ts","238538b8-3fb7-11f0-ac23-76b3cceeab13",["D",1748871625588],"export interface Project {\n id?: number;\n title: string;\n description: string;\n link?: string;\n category: ProjectCategory;\n created_at?: string;\n}\n\nexport type ProjectCategory = \n | \"Machine Learning\"\n | \"NLP\" \n | \"Computer Vision\"\n | \"Generative AI\"\n | \"Data Science\"\n | \"Robotics\"\n | \"Other AI\";\n\nexport const PROJECT_CATEGORIES: ProjectCategory[] = [\n \"Machine Learning\",\n \"NLP\",\n \"Computer Vision\", \n \"Generative AI\",\n \"Data Science\",\n \"Robotics\",\n \"Other AI\"\n];",[],[147,194],["D",1748871625588],[187],[147],"3d023f84-3fb7-11f0-96f2-76b3cceeab13","index.tsx","3d02404c-3fb7-11f0-96f2-76b3cceeab13",8,["D",1748871668351],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport App from \"./components/App.tsx\";\n\nconst root = createRoot(document.getElementById(\"root\")!);\nroot.render();",[],[153,204],"3ab354f2-3fb7-11f0-8505-76b3cceeab13","index.html","3ab355ce-3fb7-11f0-8505-76b3cceeab13",["D",1748871664476],"\n\n\n \n \n Community AI Project Showcase\n \n \n \n\n\n

\n \n\n",[],[153,212],"4801dac0-3fb7-11f0-af77-76b3cceeab13",["D",1748871686783],[],[153,33,45],"4801fd2a-3fb7-11f0-af77-76b3cceeab13",["D",1748871686783],[183],[153,33],["D",1748871664476],[182,184,185],[153],"371aa4a8-3fb7-11f0-9480-76b3cceeab13","index.ts",6,["D",1748871658446],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { createProjectsTable } from \"./database/migrations.ts\";\nimport { getAllProjects } from \"./database/queries.ts\";\nimport projects from \"./routes/projects.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Initialize database\nawait createProjectsTable();\n\n// API routes\napp.route(\"/api/projects\", projects);\n\n// Serve static files\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Serve main page with initial data\napp.get(\"/\", async (c) => {\n try {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Inject initial projects data to avoid extra round-trip\n const initialProjects = await getAllProjects();\n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n } catch (error) {\n console.error(\"Error serving main page:\", error);\n return c.text(\"Error loading page\", 500);\n }\n});\n\nexport default app.fetch;",[],[159,230],"30f9f70e-3fb7-11f0-b953-76b3cceeab13","projects.ts","30f9f7b8-3fb7-11f0-b953-76b3cceeab13","12147416-49ee-4c2d-b596-a617e15ebb83",5,["D",1748871648167],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { getAllProjects, createProject } from \"../database/queries.ts\";\nimport type { Project } from \"../../shared/types.ts\";\n\nconst projects = new Hono();\n\n// Get all projects\nprojects.get(\"/\", async (c) => {\n try {\n const allProjects = await getAllProjects();\n return c.json(allProjects);\n } catch (error) {\n console.error(\"Error fetching projects:\", error);\n return c.json({ error: \"Failed to fetch projects\" }, 500);\n }\n});\n\n// Create a new project\nprojects.post(\"/\", async (c) => {\n try {\n const body = await c.req.json();\n \n // Validate required fields\n if (!body.title || !body.description || !body.category) {\n return c.json({ \n error: \"Missing required fields: title, description, and category are required\" \n }, 400);\n }\n \n // Validate category\n const validCategories = [\n \"Machine Learning\", \"NLP\", \"Computer Vision\", \n \"Generative AI\", \"Data Science\", \"Robotics\", \"Other AI\"\n ];\n \n if (!validCategories.includes(body.category)) {\n return c.json({ error: \"Invalid category\" }, 400);\n }\n \n const projectData: Omit = {\n title: body.title.trim(),\n description: body.description.trim(),\n link: body.link?.trim() || undefined,\n category: body.category\n };\n \n const newProject = await createProject(projectData);\n return c.json(newProject, 201);\n } catch (error) {\n console.error(\"Error creating project:\", error);\n return c.json({ error: \"Failed to create project\" }, 500);\n }\n});\n\nexport default projects;",[],[159,245,237],"routes","30f9fd4e-3fb7-11f0-b953-76b3cceeab13",["D",1748871648167],[179],[159,245],"2bceba80-3fb7-11f0-8c3f-76b3cceeab13","queries.ts","2bcebb48-3fb7-11f0-8c3f-76b3cceeab13","77524f03-3970-47f1-8f85-fff33de43764",4,["D",1748871639495],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLE_NAME } from \"./migrations.ts\";\nimport type { Project } from \"../../shared/types.ts\";\n\nexport async function getAllProjects(): Promise {\n const result = await sqlite.execute(`\n SELECT id, title, description, link, category, created_at \n FROM ${TABLE_NAME} \n ORDER BY created_at DESC\n `);\n \n return result.rows.map(row => ({\n id: row[0] as number,\n title: row[1] as string,\n description: row[2] as string,\n link: row[3] as string | null,\n category: row[4] as Project['category'],\n created_at: row[5] as string\n }));\n}\n\nexport async function createProject(project: Omit): Promise {\n const result = await sqlite.execute(`\n INSERT INTO ${TABLE_NAME} (title, description, link, category)\n VALUES (?, ?, ?, ?)\n `, [project.title, project.description, project.link || null, project.category]);\n \n const insertId = result.meta.last_row_id;\n \n // Get the created project\n const createdProject = await sqlite.execute(`\n SELECT id, title, description, link, category, created_at \n FROM ${TABLE_NAME} \n WHERE id = ?\n `, [insertId]);\n \n const row = createdProject.rows[0];\n return {\n id: row[0] as number,\n title: row[1] as string,\n description: row[2] as string,\n link: row[3] as string | null,\n category: row[4] as Project['category'],\n created_at: row[5] as string\n };\n}",[],[159,259,251],"database","26e71ff8-3fb7-11f0-8003-76b3cceeab13","migrations.ts","26e72098-3fb7-11f0-8003-76b3cceeab13",["D",1748871631266],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst TABLE_NAME = 'ai_projects_v1';\n\nexport async function createProjectsTable() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n description TEXT NOT NULL,\n link TEXT,\n category TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n}\n\nexport { TABLE_NAME };",[],[159,259,261],"26e72886-3fb7-11f0-8003-76b3cceeab13",["D",1748871631266],[176,177],[159,259],["D",1748871631266],[175,178,180],[159],["D",1748871588946],{"_102":101,"_109":105},{"_102":101,"_103":-5,"_104":105,"_18":60,"_106":107,"_108":25},{"_13":91,"_32":92,"_49":41,"_93":50,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":51,"_100":101},"ctx",{"_84":-5,"_129":311,"_312":313,"_314":315,"_316":25,"_317":25,"_318":25,"_319":64,"_320":-5,"_321":-7,"_322":-7,"_323":68,"_324":25,"_325":25,"_326":-5,"_327":25,"_328":25,"_329":25,"_330":-5},"ENV",{"_282":283,"_284":285,"_286":92,"_287":288,"_289":290,"_291":292,"_293":294,"_295":296,"_297":298,"_299":300,"_301":302,"_303":304,"_305":306,"_307":308,"_309":310},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","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 · v9