Community AI Project Showcase

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_252":253,"_254":255},"routes/_app.x.$handle.$name",{"_100":99,"_32":49,"_108":90,"_27":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_21":-5,"_120":-5,"_121":-5,"_122":25,"_123":124,"_125":25,"_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",{"_47":48,"_32":49,"_36":50,"_51":-5,"_52":25,"_53":54,"_55":54,"_56":-5,"_57":-5,"_18":58,"_59":60,"_61":62,"_63":62,"_64":-5,"_65":66,"_67":68,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",7,"changes",[19,20],"aiChatInfo","userId",{"_21":41,"_23":-7,"_24":25,"_26":25,"_27":42,"_29":42},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":-5,"_36":37,"_38":14,"_39":40,"_24":25},"previous","deleted",false,"deletedHere","path","frontend","latestPath","fileId","d2cd8fb5-e6af-40b2-b90c-7585b076bf97","name","fileType","directory","content","createdAt",["D",1748871664476],"branchVersion","branchId","0db0f680-3fb7-11f0-a1a7-76b3cceeab13",{"_30":43,"_32":44,"_33":21,"_35":45,"_36":46,"_38":14,"_39":40,"_24":25},"frontend/index.html","3ab355ce-3fb7-11f0-8505-76b3cceeab13","index.html","\n\n\n \n \n Community AI Project Showcase\n \n \n \n\n\n

\n \n\n",["D",1748871664476],"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",{"_100":99,"_107":103},"org",{"_100":99,"_101":-5,"_102":103,"_18":58,"_104":105,"_106":25},"branch",{"_13":89,"_32":90,"_47":40,"_91":48,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":49,"_98":99},"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",{"_47":48,"_32":49,"_36":248,"_51":-5,"_52":25,"_53":54,"_55":54,"_56":-5,"_57":-5,"_18":58,"_59":60,"_61":62,"_63":62,"_64":-5,"_65":66,"_67":68,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":249,"_84":250,"_86":251,"_88":25},"tree",[169,176,178,180],"files",[169,170,171,172,173,174,175,176,177,178,179,180],"counts",{"_159":66,"_160":138,"_161":66,"_162":163,"_164":165},"contents",[130,131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_47":153,"_32":154,"_30":155,"_137":-5,"_39":40,"_38":156,"_139":62,"_36":157,"_13":66,"_33":34,"_35":-5,"_24":25,"_142":-5,"_27":158},{"_47":150,"_32":28,"_30":31,"_137":-5,"_39":40,"_38":14,"_139":62,"_36":151,"_13":66,"_33":34,"_35":-5,"_24":25,"_142":-5,"_27":152},{"_47":144,"_32":145,"_30":146,"_137":-5,"_39":40,"_38":147,"_139":62,"_36":148,"_13":66,"_33":34,"_35":-5,"_24":25,"_142":-5,"_27":149},{"_47":134,"_32":135,"_30":136,"_137":-5,"_39":40,"_38":138,"_139":62,"_36":140,"_13":66,"_33":21,"_35":141,"_24":25,"_142":-5,"_27":143},"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",[135],"238553d4-3fb7-11f0-ac23-76b3cceeab13","shared","6357d12e-f17b-4685-a713-10bfc7c8cbaa",2,["D",1748871625588],[145],"3ab36fe6-3fb7-11f0-8505-76b3cceeab13",["D",1748871664476],[28],"26e72692-3fb7-11f0-8003-76b3cceeab13","backend","425b74b6-334b-4f5d-b568-679b4d6dd0da",3,["D",1748871631266],[154],"pulls","branches","forks","envVars",{"_166":66,"_168":66},"connections",{"_166":66,"_167":66},"count","unfilledCount","emptyCount",{"_47":153,"_32":154,"_30":155,"_137":-5,"_39":40,"_38":156,"_139":62,"_36":245,"_13":66,"_33":34,"_35":-5,"_24":25,"_142":-5,"_182":246,"_27":247},{"_47":241,"_32":233,"_30":227,"_137":155,"_39":40,"_38":156,"_139":62,"_36":242,"_13":66,"_33":34,"_35":-5,"_24":25,"_142":-5,"_182":243,"_27":244},{"_47":234,"_32":235,"_30":236,"_137":227,"_39":40,"_38":156,"_139":62,"_36":237,"_13":66,"_33":189,"_35":238,"_24":25,"_142":-5,"_182":239,"_27":240},{"_47":224,"_32":225,"_30":226,"_137":227,"_39":40,"_38":228,"_139":25,"_36":229,"_13":66,"_33":189,"_35":230,"_24":25,"_142":-5,"_182":231,"_27":232},{"_47":220,"_32":219,"_30":213,"_137":155,"_39":40,"_38":214,"_139":62,"_36":221,"_13":66,"_33":34,"_35":-5,"_24":25,"_142":-5,"_182":222,"_27":223},{"_47":210,"_32":211,"_30":212,"_137":213,"_39":40,"_38":214,"_139":25,"_36":215,"_13":66,"_33":189,"_35":216,"_24":25,"_142":-5,"_182":217,"_27":218},{"_47":203,"_32":204,"_30":60,"_137":155,"_39":40,"_38":205,"_139":25,"_36":206,"_13":66,"_33":189,"_35":207,"_24":25,"_142":-5,"_182":208,"_27":209},{"_47":150,"_32":28,"_30":31,"_137":-5,"_39":40,"_38":14,"_139":62,"_36":200,"_13":66,"_33":34,"_35":-5,"_24":25,"_142":-5,"_182":201,"_27":202},{"_47":196,"_32":44,"_30":43,"_137":31,"_39":40,"_38":14,"_139":62,"_36":197,"_13":66,"_33":21,"_35":45,"_24":25,"_142":-5,"_182":198,"_27":199},{"_47":144,"_32":145,"_30":146,"_137":-5,"_39":40,"_38":147,"_139":62,"_36":193,"_13":66,"_33":34,"_35":-5,"_24":25,"_142":-5,"_182":194,"_27":195},{"_47":185,"_32":186,"_30":187,"_137":146,"_39":40,"_38":147,"_139":62,"_36":188,"_13":66,"_33":189,"_35":190,"_24":25,"_142":-5,"_182":191,"_27":192},{"_47":134,"_32":135,"_30":136,"_137":-5,"_39":40,"_38":138,"_139":62,"_36":181,"_13":66,"_33":21,"_35":141,"_24":25,"_142":-5,"_182":183,"_27":184},["D",1748871620610],"children",[],[135],"238537e6-3fb7-11f0-ac23-76b3cceeab13","types.ts","238538b8-3fb7-11f0-ac23-76b3cceeab13",["D",1748871625588],"script","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];",[],[145,186],["D",1748871625588],[179],[145],"3ab354f2-3fb7-11f0-8505-76b3cceeab13",["D",1748871664476],[],[28,44],["D",1748871664476],[177],[28],"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;",[],[154,204],"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;",[],[154,219,211],"routes","30f9fd4e-3fb7-11f0-b953-76b3cceeab13",["D",1748871648167],[174],[154,219],"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}",[],[154,233,225],"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 };",[],[154,233,235],"26e72886-3fb7-11f0-8003-76b3cceeab13",["D",1748871631266],[171,172],[154,233],["D",1748871631266],[170,173,175],[154],["D",1748871588946],{"_100":99,"_107":103},{"_100":99,"_101":-5,"_102":103,"_18":58,"_104":105,"_106":25},{"_13":89,"_32":90,"_47":40,"_91":48,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":49,"_98":99},"ctx",{"_82":-5,"_127":285,"_286":287,"_288":289,"_290":25,"_291":25,"_292":25,"_293":62,"_294":-5,"_295":-7,"_296":-7,"_297":66,"_298":25,"_299":25,"_300":-5,"_301":25,"_302":25,"_303":25,"_304":-5},"ENV",{"_256":257,"_258":259,"_260":90,"_261":262,"_263":264,"_265":266,"_267":268,"_269":270,"_271":272,"_273":274,"_275":276,"_277":278,"_279":280,"_281":282,"_283":284},"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 · v7