[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_294":295,"_296":297},"routes/_app.x.$handle.$name",{"_96":95,"_32":46,"_104":86,"_27":105,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":25,"_119":120,"_121":58,"_122":-5,"_123":-5,"_124":125},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":58,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":25},"version",12,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":38,"_36":37,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","backend/index.ts","latestPath","fileId","371aa552-3fb7-11f0-9480-76b3cceeab13","name","index.ts","fileType","script","content","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;","http","createdAt",["D",1748871727628],"branchVersion","branchId","0db0f680-3fb7-11f0-a1a7-76b3cceeab13","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","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",{"_96":95,"_103":99},"org",{"_96":95,"_97":-5,"_98":99,"_18":55,"_100":101,"_102":25},"branch",{"_13":85,"_32":86,"_44":43,"_87":45,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":46,"_94":95},"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",{"_44":45,"_32":46,"_39":290,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":58,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":291,"_80":292,"_82":293,"_84":25},"tree",[169,176,183,185],"files",[169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185],"counts",{"_159":62,"_160":134,"_161":62,"_162":163,"_164":165},"contents",[126,127,128,129],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":153,"_32":154,"_30":155,"_133":-5,"_42":43,"_41":156,"_135":58,"_39":157,"_13":62,"_34":145,"_36":-5,"_24":25,"_138":-5,"_27":158},{"_44":147,"_32":148,"_30":149,"_133":-5,"_42":43,"_41":150,"_135":58,"_39":151,"_13":62,"_34":145,"_36":-5,"_24":25,"_138":-5,"_27":152},{"_44":140,"_32":141,"_30":142,"_133":-5,"_42":43,"_41":143,"_135":58,"_39":144,"_13":62,"_34":145,"_36":-5,"_24":25,"_138":-5,"_27":146},{"_44":130,"_32":131,"_30":132,"_133":-5,"_42":43,"_41":134,"_135":58,"_39":136,"_13":62,"_34":20,"_36":137,"_24":25,"_138":-5,"_27":139},"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",[131],"238553d4-3fb7-11f0-ac23-76b3cceeab13","shared","6357d12e-f17b-4685-a713-10bfc7c8cbaa",2,["D",1748871625588],"directory",[141],"3ab36fe6-3fb7-11f0-8505-76b3cceeab13","frontend","d2cd8fb5-e6af-40b2-b90c-7585b076bf97",7,["D",1748871664476],[148],"26e72692-3fb7-11f0-8003-76b3cceeab13","backend","425b74b6-334b-4f5d-b568-679b4d6dd0da",3,["D",1748871631266],[154],"pulls","branches","forks","envVars",{"_166":62,"_168":62},"connections",{"_166":62,"_167":62},"count","unfilledCount","emptyCount",{"_44":153,"_32":154,"_30":155,"_133":-5,"_42":43,"_41":156,"_135":58,"_39":287,"_13":62,"_34":145,"_36":-5,"_24":25,"_138":-5,"_187":288,"_27":289},{"_44":283,"_32":275,"_30":269,"_133":155,"_42":43,"_41":156,"_135":58,"_39":284,"_13":62,"_34":145,"_36":-5,"_24":25,"_138":-5,"_187":285,"_27":286},{"_44":276,"_32":277,"_30":278,"_133":269,"_42":43,"_41":156,"_135":58,"_39":279,"_13":62,"_34":35,"_36":280,"_24":25,"_138":-5,"_187":281,"_27":282},{"_44":266,"_32":267,"_30":268,"_133":269,"_42":43,"_41":270,"_135":25,"_39":271,"_13":62,"_34":35,"_36":272,"_24":25,"_138":-5,"_187":273,"_27":274},{"_44":262,"_32":261,"_30":255,"_133":155,"_42":43,"_41":256,"_135":58,"_39":263,"_13":62,"_34":145,"_36":-5,"_24":25,"_138":-5,"_187":264,"_27":265},{"_44":252,"_32":253,"_30":254,"_133":255,"_42":43,"_41":256,"_135":25,"_39":257,"_13":62,"_34":35,"_36":258,"_24":25,"_138":-5,"_187":259,"_27":260},{"_44":248,"_32":33,"_30":31,"_133":155,"_42":43,"_41":14,"_135":58,"_39":249,"_13":134,"_34":38,"_36":37,"_24":25,"_138":-5,"_187":250,"_27":251},{"_44":147,"_32":148,"_30":149,"_133":-5,"_42":43,"_41":150,"_135":58,"_39":245,"_13":62,"_34":145,"_36":-5,"_24":25,"_138":-5,"_187":246,"_27":247},{"_44":241,"_32":224,"_30":218,"_133":149,"_42":43,"_41":236,"_135":58,"_39":242,"_13":62,"_34":145,"_36":-5,"_24":25,"_138":-5,"_187":243,"_27":244},{"_44":233,"_32":234,"_30":235,"_133":218,"_42":43,"_41":236,"_135":58,"_39":237,"_13":62,"_34":35,"_36":238,"_24":25,"_138":-5,"_187":239,"_27":240},{"_44":225,"_32":226,"_30":227,"_133":218,"_42":43,"_41":228,"_135":58,"_39":229,"_13":62,"_34":35,"_36":230,"_24":25,"_138":-5,"_187":231,"_27":232},{"_44":215,"_32":216,"_30":217,"_133":218,"_42":43,"_41":219,"_135":58,"_39":220,"_13":62,"_34":35,"_36":221,"_24":25,"_138":-5,"_187":222,"_27":223},{"_44":208,"_32":209,"_30":210,"_133":149,"_42":43,"_41":150,"_135":58,"_39":211,"_13":62,"_34":20,"_36":212,"_24":25,"_138":-5,"_187":213,"_27":214},{"_44":200,"_32":201,"_30":202,"_133":149,"_42":43,"_41":203,"_135":58,"_39":204,"_13":62,"_34":35,"_36":205,"_24":25,"_138":-5,"_187":206,"_27":207},{"_44":140,"_32":141,"_30":142,"_133":-5,"_42":43,"_41":143,"_135":58,"_39":197,"_13":62,"_34":145,"_36":-5,"_24":25,"_138":-5,"_187":198,"_27":199},{"_44":190,"_32":191,"_30":192,"_133":142,"_42":43,"_41":143,"_135":58,"_39":193,"_13":62,"_34":35,"_36":194,"_24":25,"_138":-5,"_187":195,"_27":196},{"_44":130,"_32":131,"_30":132,"_133":-5,"_42":43,"_41":134,"_135":58,"_39":186,"_13":62,"_34":20,"_36":137,"_24":25,"_138":-5,"_187":188,"_27":189},["D",1748871620610],"children",[],[131],"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];",[],[141,191],["D",1748871625588],[184],[141],"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();",[],[148,201],"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",[],[148,209],"54a04492-3fb7-11f0-a902-76b3cceeab13","ProjectForm.tsx","54a04532-3fb7-11f0-a902-76b3cceeab13","b75bff5b-ce06-4bc4-9f42-ba40ac731846",10,["D",1748871707977],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { Project, ProjectCategory } from \"../../shared/types.ts\";\nimport { PROJECT_CATEGORIES } from \"../../shared/types.ts\";\n\ninterface ProjectFormProps {\n onProjectSubmitted: (project: Project) => void;\n}\n\nexport default function ProjectForm({ onProjectSubmitted }: ProjectFormProps) {\n const [formData, setFormData] = useState({\n title: \"\",\n description: \"\",\n link: \"\",\n category: \"\" as ProjectCategory | \"\"\n });\n const [isSubmitting, setIsSubmitting] = useState(false);\n const [error, setError] = useState(\"\");\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n setError(\"\");\n \n if (!formData.title.trim() || !formData.description.trim() || !formData.category) {\n setError(\"Please fill in all required fields\");\n return;\n }\n\n setIsSubmitting(true);\n \n try {\n const response = await fetch(\"/api/projects\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({\n title: formData.title.trim(),\n description: formData.description.trim(),\n link: formData.link.trim() || undefined,\n category: formData.category\n }),\n });\n\n if (response.ok) {\n const newProject = await response.json();\n onProjectSubmitted(newProject);\n setFormData({ title: \"\", description: \"\", link: \"\", category: \"\" });\n } else {\n const errorData = await response.json();\n setError(errorData.error || \"Failed to submit project\");\n }\n } catch (error) {\n console.error(\"Error submitting project:\", error);\n setError(\"Failed to submit project. Please try again.\");\n } finally {\n setIsSubmitting(false);\n }\n };\n\n const handleChange = (e: React.ChangeEvent) => {\n const { name, value } = e.target;\n setFormData(prev => ({ ...prev, [name]: value }));\n };\n\n return (\n

Submit Your AI Project

\n \n {error && (\n

\n {error}\n

\n )}\n\n

\n {/* Project Title */}\n

\n \n Project Title *\n \n \n

\n\n {/* Project Description */}\n

\n \n Short Project Description *\n \n \n

\n\n {/* Project Link */}\n

\n \n Link to Project (optional)\n \n \n

\n\n {/* Category */}\n

\n \n Category *\n \n \n \n {PROJECT_CATEGORIES.map((category) => (\n \n ))}\n \n

\n\n {/* Submit Button */}\n

\n \n {isSubmitting ? \"Submitting...\" : \"Submit Project\"}\n \n

\n );\n}",[],[148,224,216],"components","5d2fabf2-3fb7-11f0-895c-76b3cceeab13","ProjectCard.tsx","5d2facc4-3fb7-11f0-895c-76b3cceeab13",11,["D",1748871722331],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport type { Project } from \"../../shared/types.ts\";\n\ninterface ProjectCardProps {\n project: Project;\n}\n\nconst categoryEmojis: Record = {\n \"Machine Learning\": \"🤖\",\n \"NLP\": \"💬\",\n \"Computer Vision\": \"👁️\",\n \"Generative AI\": \"✨\",\n \"Data Science\": \"📊\",\n \"Robotics\": \"🦾\",\n \"Other AI\": \"🧠\"\n};\n\nexport default function ProjectCard({ project }: ProjectCardProps) {\n const formatDate = (dateString: string) => {\n return new Date(dateString).toLocaleDateString('en-US', {\n year: 'numeric',\n month: 'short',\n day: 'numeric'\n });\n };\n\n return (\n

\n {/* Category Badge */}\n

\n \n {categoryEmojis[project.category] || \"🧠\"}\n {project.category}\n \n {project.created_at && (\n \n {formatDate(project.created_at)}\n \n )}\n

\n\n {/* Project Title */}\n

\n {project.title}\n

\n\n {/* Project Description */}\n

\n {project.description}\n

\n\n {/* Project Link */}\n {project.link && (\n

\n \n View Project\n \n \n

\n )}\n

\n );\n}",[],[148,224,226],"4801dac0-3fb7-11f0-af77-76b3cceeab13","App.tsx","4801dc5a-3fb7-11f0-af77-76b3cceeab13",9,["D",1748871686783],"/** @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}",[],[148,224,234],"4801fd2a-3fb7-11f0-af77-76b3cceeab13",["D",1748871686783],[178,179,180],[148,224],["D",1748871664476],[177,181,182],[148],"6057e434-3fb7-11f0-8dfe-76b3cceeab13",["D",1748871727628],[],[154,33],"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,261,253],"routes","30f9fd4e-3fb7-11f0-b953-76b3cceeab13",["D",1748871648167],[174],[154,261],"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,275,267],"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,275,277],"26e72886-3fb7-11f0-8003-76b3cceeab13",["D",1748871631266],[171,172],[154,275],["D",1748871631266],[170,173,175],[154],["D",1748871588946],{"_96":95,"_103":99},{"_96":95,"_97":-5,"_98":99,"_18":55,"_100":101,"_102":25},{"_13":85,"_32":86,"_44":43,"_87":45,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":46,"_94":95},"ctx",{"_78":-5,"_123":327,"_328":329,"_330":331,"_332":25,"_333":25,"_334":25,"_335":58,"_336":-5,"_337":-7,"_338":-7,"_339":62,"_340":25,"_341":25,"_342":-5,"_343":25,"_344":25,"_345":25,"_346":-5},"ENV",{"_298":299,"_300":301,"_302":86,"_303":304,"_305":306,"_307":308,"_309":310,"_311":312,"_313":314,"_315":316,"_317":318,"_319":320,"_321":322,"_323":324,"_325":326},"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 · v12