[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_292":293,"_294":295},"routes/_app.x.$handle.$name",{"_95":94,"_31":44,"_103":85,"_26":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":24,"_118":119,"_120":24,"_121":-5,"_122":-5,"_123":124},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":24},"version",11,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","frontend/components/ProjectCard.tsx","latestPath","fileId","5d2facc4-3fb7-11f0-895c-76b3cceeab13","name","ProjectCard.tsx","fileType","script","content","/** @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}","createdAt",["D",1748871722331],"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","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",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":53,"_99":100,"_101":24},"branch",{"_13":84,"_31":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"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",{"_42":43,"_31":44,"_37":288,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":289,"_79":290,"_81":291,"_83":24},"tree",[168,175,182,184],"files",[168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184],"counts",{"_158":61,"_159":133,"_160":61,"_161":162,"_163":164},"contents",[125,126,127,128],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":152,"_31":153,"_29":154,"_132":-5,"_40":41,"_39":155,"_134":57,"_37":156,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_26":157},{"_42":146,"_31":147,"_29":148,"_132":-5,"_40":41,"_39":149,"_134":57,"_37":150,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_26":151},{"_42":139,"_31":140,"_29":141,"_132":-5,"_40":41,"_39":142,"_134":57,"_37":143,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_26":145},{"_42":129,"_31":130,"_29":131,"_132":-5,"_40":41,"_39":133,"_134":57,"_37":135,"_13":61,"_33":20,"_35":136,"_23":24,"_137":-5,"_26":138},"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",[130],"238553d4-3fb7-11f0-ac23-76b3cceeab13","shared","6357d12e-f17b-4685-a713-10bfc7c8cbaa",2,["D",1748871625588],"directory",[140],"3ab36fe6-3fb7-11f0-8505-76b3cceeab13","frontend","d2cd8fb5-e6af-40b2-b90c-7585b076bf97",7,["D",1748871664476],[147],"26e72692-3fb7-11f0-8003-76b3cceeab13","backend","425b74b6-334b-4f5d-b568-679b4d6dd0da",3,["D",1748871631266],[153],"pulls","branches","forks","envVars",{"_165":61,"_167":61},"connections",{"_165":61,"_166":61},"count","unfilledCount","emptyCount",{"_42":152,"_31":153,"_29":154,"_132":-5,"_40":41,"_39":155,"_134":57,"_37":285,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_186":286,"_26":287},{"_42":281,"_31":273,"_29":267,"_132":154,"_40":41,"_39":155,"_134":57,"_37":282,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_186":283,"_26":284},{"_42":274,"_31":275,"_29":276,"_132":267,"_40":41,"_39":155,"_134":57,"_37":277,"_13":61,"_33":34,"_35":278,"_23":24,"_137":-5,"_186":279,"_26":280},{"_42":264,"_31":265,"_29":266,"_132":267,"_40":41,"_39":268,"_134":24,"_37":269,"_13":61,"_33":34,"_35":270,"_23":24,"_137":-5,"_186":271,"_26":272},{"_42":260,"_31":259,"_29":253,"_132":154,"_40":41,"_39":254,"_134":57,"_37":261,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_186":262,"_26":263},{"_42":250,"_31":251,"_29":252,"_132":253,"_40":41,"_39":254,"_134":24,"_37":255,"_13":61,"_33":34,"_35":256,"_23":24,"_137":-5,"_186":257,"_26":258},{"_42":243,"_31":244,"_29":55,"_132":154,"_40":41,"_39":245,"_134":24,"_37":246,"_13":61,"_33":34,"_35":247,"_23":24,"_137":-5,"_186":248,"_26":249},{"_42":146,"_31":147,"_29":148,"_132":-5,"_40":41,"_39":149,"_134":57,"_37":240,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_186":241,"_26":242},{"_42":236,"_31":223,"_29":217,"_132":148,"_40":41,"_39":231,"_134":57,"_37":237,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_186":238,"_26":239},{"_42":228,"_31":229,"_29":230,"_132":217,"_40":41,"_39":231,"_134":57,"_37":232,"_13":61,"_33":34,"_35":233,"_23":24,"_137":-5,"_186":234,"_26":235},{"_42":224,"_31":32,"_29":30,"_132":217,"_40":41,"_39":14,"_134":57,"_37":225,"_13":61,"_33":34,"_35":36,"_23":24,"_137":-5,"_186":226,"_26":227},{"_42":214,"_31":215,"_29":216,"_132":217,"_40":41,"_39":218,"_134":57,"_37":219,"_13":61,"_33":34,"_35":220,"_23":24,"_137":-5,"_186":221,"_26":222},{"_42":207,"_31":208,"_29":209,"_132":148,"_40":41,"_39":149,"_134":57,"_37":210,"_13":61,"_33":20,"_35":211,"_23":24,"_137":-5,"_186":212,"_26":213},{"_42":199,"_31":200,"_29":201,"_132":148,"_40":41,"_39":202,"_134":57,"_37":203,"_13":61,"_33":34,"_35":204,"_23":24,"_137":-5,"_186":205,"_26":206},{"_42":139,"_31":140,"_29":141,"_132":-5,"_40":41,"_39":142,"_134":57,"_37":196,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_186":197,"_26":198},{"_42":189,"_31":190,"_29":191,"_132":141,"_40":41,"_39":142,"_134":57,"_37":192,"_13":61,"_33":34,"_35":193,"_23":24,"_137":-5,"_186":194,"_26":195},{"_42":129,"_31":130,"_29":131,"_132":-5,"_40":41,"_39":133,"_134":57,"_37":185,"_13":61,"_33":20,"_35":136,"_23":24,"_137":-5,"_186":187,"_26":188},["D",1748871620610],"children",[],[130],"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];",[],[140,190],["D",1748871625588],[183],[140],"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();",[],[147,200],"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",[],[147,208],"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}",[],[147,223,215],"components","5d2fabf2-3fb7-11f0-895c-76b3cceeab13",["D",1748871722331],[],[147,223,32],"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}",[],[147,223,229],"4801fd2a-3fb7-11f0-af77-76b3cceeab13",["D",1748871686783],[177,178,179],[147,223],["D",1748871664476],[176,180,181],[147],"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;",[],[153,244],"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;",[],[153,259,251],"routes","30f9fd4e-3fb7-11f0-b953-76b3cceeab13",["D",1748871648167],[173],[153,259],"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}",[],[153,273,265],"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 };",[],[153,273,275],"26e72886-3fb7-11f0-8003-76b3cceeab13",["D",1748871631266],[170,171],[153,273],["D",1748871631266],[169,172,174],[153],["D",1748871588946],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":53,"_99":100,"_101":24},{"_13":84,"_31":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"ctx",{"_77":-5,"_122":325,"_326":327,"_328":329,"_330":24,"_331":24,"_332":24,"_333":57,"_334":-5,"_335":-7,"_336":-7,"_337":61,"_338":24,"_339":24,"_340":-5,"_341":24,"_342":24,"_343":24,"_344":-5},"ENV",{"_296":297,"_298":299,"_300":85,"_301":302,"_303":304,"_305":306,"_307":308,"_309":310,"_311":312,"_313":314,"_315":316,"_317":318,"_319":320,"_321":322,"_323":324},"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 · v11