[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_195":196,"_197":198},"routes/_app.x.$handle.$name",{"_94":93,"_31":44,"_102":84,"_26":103,"_13":14,"_104":-5,"_11":105,"_106":107,"_108":109,"_110":111,"_112":113,"_20":-5,"_114":-5,"_115":-5,"_116":24,"_117":118,"_119":24,"_120":-5,"_121":-5,"_122":123},"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":30,"_55":56,"_57":56,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":77,"_78":79,"_80":81,"_82":24},"version",4,"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","backend/index.ts","latestPath","fileId","224147cc-31e2-11f0-997f-569c3dd06744","name","index.ts","fileType","script","content","import { Hono } from \"https://esm.sh/hono@3.12.6\";\nimport { cors } from \"https://esm.sh/hono@3.12.6/cors\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { initDatabase } from \"./database/migrations.ts\";\nimport { \n getAllJobs, \n createJob, \n getRecentMessages, \n createMessage \n} from \"./database/queries.ts\";\n\n// Initialize the app\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Enable CORS\napp.use(\"*\", cors());\n\n// Initialize database on startup\nawait initDatabase();\n\n// API Routes\napp.get(\"/api/jobs\", async (c) => {\n const jobs = await getAllJobs();\n return c.json(jobs);\n});\n\napp.post(\"/api/jobs\", async (c) => {\n const body = await c.req.json();\n \n // Validate required fields\n if (!body.title || !body.company || !body.description || !body.contact) {\n return c.json({ error: \"Missing required fields\" }, 400);\n }\n \n const job = await createJob({\n title: body.title,\n company: body.company,\n description: body.description,\n contact: body.contact\n });\n \n return c.json(job, 201);\n});\n\napp.get(\"/api/messages\", async (c) => {\n const messages = await getRecentMessages();\n return c.json(messages);\n});\n\napp.post(\"/api/messages\", async (c) => {\n const body = await c.req.json();\n \n // Validate required fields\n if (!body.username || !body.content) {\n return c.json({ error: \"Missing required fields\" }, 400);\n }\n \n const message = await createMessage({\n username: body.username,\n content: body.content\n });\n \n return c.json(message, 201);\n});\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 index.html for the root path\napp.get(\"/\", async (c) => {\n const html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n});\n\n// This is the entry point for HTTP vals\nexport default app.fetch;","createdAt",["D",1747350775548],"branchVersion","branchId","0596f824-31e2-11f0-82d1-569c3dd06744","id","0595b72a-31e2-11f0-82d1-569c3dd06744","zay",["D",1747350727452],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","e5091e30-2cb8-11f0-8b3c-8566c5f34604","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","788ca030-1c76-430d-8973-cb5112a92588","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_94":93,"_101":97},"org",{"_94":93,"_95":-5,"_96":97,"_18":53,"_98":99,"_100":24},"branch",{"_13":83,"_31":84,"_42":41,"_85":43,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":44,"_92":93},"isOwned",13,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","zaaynaah","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ3cXlGNGdHR3o4ZzFmdm1xd3Y5T0FYRVU4biJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_31":44,"_37":191,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":30,"_55":56,"_57":56,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":192,"_78":193,"_80":194,"_82":24},"tree",[153,158],"files",[153,154,155,156,157,158],"counts",{"_143":60,"_144":130,"_145":60,"_146":147,"_148":149},"contents",[124,125],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":136,"_31":137,"_29":138,"_129":-5,"_40":41,"_39":139,"_131":56,"_37":140,"_13":60,"_33":141,"_35":-5,"_23":24,"_134":-5,"_26":142},{"_42":126,"_31":127,"_29":128,"_129":-5,"_40":41,"_39":130,"_131":56,"_37":132,"_13":60,"_33":20,"_35":133,"_23":24,"_134":-5,"_26":135},"1329a3ba-31e2-11f0-a80a-569c3dd06744","README.md","1329a46e-31e2-11f0-a80a-569c3dd06744","parentId",1,"latest",["D",1747350750227],"# Job Board with Chat\n\nA simple application that allows users to:\n- Post job opportunities\n- View job listings\n- Participate in a public chat room to discuss opportunities\n\n## Features\n\n- Job posting creation and listing\n- Real-time public chat room\n- Simple username-based authentication\n- Mobile-responsive design\n\n## Project Structure\n\n- `/backend` - Hono API server with SQLite database\n- `/frontend` - HTML/JS frontend with Tailwind CSS\n- `/shared` - Shared types and utilities\n\n## Technologies Used\n\n- Backend: Hono, SQLite\n- Frontend: HTML, JavaScript, Tailwind CSS\n- Shared: TypeScript\n\n## Getting Started\n\nVisit the app and start by entering a username to access the job board and chat functionality.","label",[127],"16516d66-31e2-11f0-87b4-569c3dd06744","backend","68626bad-e95a-4ef2-8691-d49175d38d7f",2,["D",1747350755519],"directory",[137],"pulls","branches","forks","envVars",{"_150":60,"_152":60},"connections",{"_150":60,"_151":60},"count","unfilledCount","emptyCount",{"_42":136,"_31":137,"_29":138,"_129":-5,"_40":41,"_39":139,"_131":56,"_37":188,"_13":60,"_33":141,"_35":-5,"_23":24,"_134":-5,"_160":189,"_26":190},{"_42":184,"_31":176,"_29":170,"_129":138,"_40":41,"_39":139,"_131":56,"_37":185,"_13":60,"_33":141,"_35":-5,"_23":24,"_134":-5,"_160":186,"_26":187},{"_42":177,"_31":178,"_29":179,"_129":170,"_40":41,"_39":139,"_131":56,"_37":180,"_13":60,"_33":34,"_35":181,"_23":24,"_134":-5,"_160":182,"_26":183},{"_42":167,"_31":168,"_29":169,"_129":170,"_40":41,"_39":171,"_131":56,"_37":172,"_13":60,"_33":34,"_35":173,"_23":24,"_134":-5,"_160":174,"_26":175},{"_42":163,"_31":32,"_29":30,"_129":138,"_40":41,"_39":14,"_131":24,"_37":164,"_13":60,"_33":34,"_35":36,"_23":24,"_134":-5,"_160":165,"_26":166},{"_42":126,"_31":127,"_29":128,"_129":-5,"_40":41,"_39":130,"_131":56,"_37":159,"_13":60,"_33":20,"_35":133,"_23":24,"_134":-5,"_160":161,"_26":162},["D",1747350750227],"children",[],[127],"22414722-31e2-11f0-997f-569c3dd06744",["D",1747350775548],[],[137,32],"1bad031a-31e2-11f0-997f-569c3dd06744","queries.ts","1bad03e2-31e2-11f0-997f-569c3dd06744","16bfafca-4754-4171-9c1c-87d8d447fc5d",3,["D",1747350764497],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { JOBS_TABLE, MESSAGES_TABLE } from \"./migrations.ts\";\n\n// Types\nexport interface Job {\n id: number;\n title: string;\n company: string;\n description: string;\n contact: string;\n created_at: number;\n}\n\nexport interface Message {\n id: number;\n username: string;\n content: string;\n created_at: number;\n}\n\n// Job queries\nexport async function getAllJobs(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${JOBS_TABLE} ORDER BY created_at DESC`\n );\n return result.rows;\n}\n\nexport async function createJob(job: Omit): Promise {\n const created_at = Date.now();\n const result = await sqlite.execute<{ id: number }>(\n `INSERT INTO ${JOBS_TABLE} (title, company, description, contact, created_at)\n VALUES (?, ?, ?, ?, ?)\n RETURNING id`,\n [job.title, job.company, job.description, job.contact, created_at]\n );\n \n return {\n id: result.rows[0].id,\n ...job,\n created_at\n };\n}\n\n// Message queries\nexport async function getRecentMessages(limit = 50): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${MESSAGES_TABLE} \n ORDER BY created_at DESC \n LIMIT ?`,\n [limit]\n );\n return result.rows;\n}\n\nexport async function createMessage(message: Omit): Promise {\n const created_at = Date.now();\n const result = await sqlite.execute<{ id: number }>(\n `INSERT INTO ${MESSAGES_TABLE} (username, content, created_at)\n VALUES (?, ?, ?)\n RETURNING id`,\n [message.username, message.content, created_at]\n );\n \n return {\n id: result.rows[0].id,\n ...message,\n created_at\n };\n}",[],[137,176,168],"database","16514958-31e2-11f0-87b4-569c3dd06744","migrations.ts","16514a16-31e2-11f0-87b4-569c3dd06744",["D",1747350755519],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Table names - use versioning for schema changes\nexport const JOBS_TABLE = \"jobs_v1\";\nexport const MESSAGES_TABLE = \"messages_v1\";\n\n/**\n * Initialize database tables\n */\nexport async function initDatabase() {\n // Create jobs table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${JOBS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n company TEXT NOT NULL,\n description TEXT NOT NULL,\n contact TEXT NOT NULL,\n created_at INTEGER NOT NULL\n )\n `);\n\n // Create messages table for chat\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${MESSAGES_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT NOT NULL,\n content TEXT NOT NULL,\n created_at INTEGER NOT NULL\n )\n `);\n}",[],[137,176,178],"16516f5a-31e2-11f0-87b4-569c3dd06744",["D",1747350755519],[155,156],[137,176],["D",1747350755519],[154,157],[137],["D",1747350727452],{"_94":93,"_101":97},{"_94":93,"_95":-5,"_96":97,"_18":53,"_98":99,"_100":24},{"_13":83,"_31":84,"_42":41,"_85":43,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":44,"_92":93},"ctx",{"_76":-5,"_121":228,"_229":230,"_231":232,"_233":24,"_234":24,"_235":24,"_236":56,"_237":-5,"_238":-7,"_239":-7,"_240":60,"_241":24,"_242":24,"_243":-5,"_244":24,"_245":24,"_246":24,"_247":-5},"ENV",{"_199":200,"_201":202,"_203":84,"_204":205,"_206":207,"_208":209,"_210":211,"_212":213,"_214":215,"_216":217,"_218":219,"_220":221,"_222":223,"_224":225,"_226":227},"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 · v4