[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_237":238,"_239":240},"routes/_app.x.$handle.$name",{"_97":96,"_32":46,"_105":87,"_27":106,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":-5,"_118":-5,"_119":25,"_120":121,"_122":25,"_123":-5,"_124":-5,"_125":126},"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":54,"_55":-5,"_18":56,"_57":31,"_58":59,"_60":59,"_61":-5,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":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":35,"_36":38,"_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","635ddb04-3443-11f0-b77c-9e149126039e","name","index.ts","fileType","email","content","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { cors } from \"https://esm.sh/hono@3.11.7/middleware\";\n// import { cors } from \"https://esm.town/v/stevekrouse/hono@3.11.7/middleware\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n\n// Initialize Hono 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// Database setup\nconst JOBS_TABLE = \"job_postings\";\nconst CHAT_TABLE = \"chat_messages\";\n\nasync function setupDatabase() {\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 description TEXT NOT NULL,\n company TEXT NOT NULL,\n location TEXT NOT NULL,\n salary TEXT,\n contact TEXT NOT NULL,\n created_at TEXT NOT NULL\n )\n `);\n\n // Create chat messages table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${CHAT_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT NOT NULL,\n message TEXT NOT NULL,\n created_at TEXT NOT NULL\n )\n `);\n}\n\n// Run database setup\nsetupDatabase().catch(console.error);\n\n// API Routes\n\n// Get all job postings\napp.get(\"/api/jobs\", async (c) => {\n const jobs = await sqlite.execute(`SELECT * FROM ${JOBS_TABLE} ORDER BY created_at DESC`);\n return c.json(jobs);\n});\n\n// Create a new job posting\napp.post(\"/api/jobs\", async (c) => {\n const body = await c.req.json();\n const { title, description, company, location, salary, contact } = body;\n \n if (!title || !description || !company || !location || !contact) {\n return c.json({ error: \"Missing required fields\" }, 400);\n }\n \n const created_at = new Date().toISOString();\n \n await sqlite.execute(\n `INSERT INTO ${JOBS_TABLE} (title, description, company, location, salary, contact, created_at) \n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n [title, description, company, location, salary || \"\", contact, created_at]\n );\n \n return c.json({ success: true });\n});\n\n// Get chat messages\napp.get(\"/api/chat\", async (c) => {\n const messages = await sqlite.execute(\n `SELECT * FROM ${CHAT_TABLE} ORDER BY created_at DESC LIMIT 100`\n );\n return c.json(messages.reverse()); // Return in chronological order\n});\n\n// Post a chat message\napp.post(\"/api/chat\", async (c) => {\n const body = await c.req.json();\n const { username, message } = body;\n \n if (!username || !message) {\n return c.json({ error: \"Username and message are required\" }, 400);\n }\n \n const created_at = new Date().toISOString();\n \n await sqlite.execute(\n `INSERT INTO ${CHAT_TABLE} (username, message, created_at) VALUES (?, ?, ?)`,\n [username, message, created_at]\n );\n \n return c.json({ success: true });\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// Export the Hono app\nexport default app.fetch;","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { cors } from \"https://esm.sh/@hono/cors@1.2.0\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n\n// Initialize Hono 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// Database setup\nconst JOBS_TABLE = \"job_postings\";\nconst CHAT_TABLE = \"chat_messages\";\n\nasync function setupDatabase() {\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 description TEXT NOT NULL,\n company TEXT NOT NULL,\n location TEXT NOT NULL,\n salary TEXT,\n contact TEXT NOT NULL,\n created_at TEXT NOT NULL\n )\n `);\n\n // Create chat messages table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${CHAT_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT NOT NULL,\n message TEXT NOT NULL,\n created_at TEXT NOT NULL\n )\n `);\n}\n\n// Run database setup\nsetupDatabase().catch(console.error);\n\n// API Routes\n\n// Get all job postings\napp.get(\"/api/jobs\", async (c) => {\n const jobs = await sqlite.execute(`SELECT * FROM ${JOBS_TABLE} ORDER BY created_at DESC`);\n return c.json(jobs);\n});\n\n// Create a new job posting\napp.post(\"/api/jobs\", async (c) => {\n const body = await c.req.json();\n const { title, description, company, location, salary, contact } = body;\n \n if (!title || !description || !company || !location || !contact) {\n return c.json({ error: \"Missing required fields\" }, 400);\n }\n \n const created_at = new Date().toISOString();\n \n await sqlite.execute(\n `INSERT INTO ${JOBS_TABLE} (title, description, company, location, salary, contact, created_at) \n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n [title, description, company, location, salary || \"\", contact, created_at]\n );\n \n return c.json({ success: true });\n});\n\n// Get chat messages\napp.get(\"/api/chat\", async (c) => {\n const messages = await sqlite.execute(\n `SELECT * FROM ${CHAT_TABLE} ORDER BY created_at DESC LIMIT 100`\n );\n return c.json(messages.reverse()); // Return in chronological order\n});\n\n// Post a chat message\napp.post(\"/api/chat\", async (c) => {\n const body = await c.req.json();\n const { username, message } = body;\n \n if (!username || !message) {\n return c.json({ error: \"Username and message are required\" }, 400);\n }\n \n const created_at = new Date().toISOString();\n \n await sqlite.execute(\n `INSERT INTO ${CHAT_TABLE} (username, message, created_at) VALUES (?, ?, ?)`,\n [username, message, created_at]\n );\n \n return c.json({ success: true });\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// Export the Hono app\nexport default app.fetch;","createdAt",["D",1747613785701],"branchVersion","branchId","fdd0be32-3442-11f0-b570-9e149126039e","id","fdd084bc-3442-11f0-b570-9e149126039e","JobApp",["D",1747612277925],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Creating a job app with chat forum","imageUrl","dcf86e80-3442-11f0-b519-ff88f6bc2fe6","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",1,"orgId","d12e9468-0713-4b2e-926d-7ccecb147081","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_97":96,"_104":100},"org",{"_97":96,"_98":-5,"_99":100,"_18":56,"_101":102,"_103":25},"branch",{"_13":86,"_32":87,"_44":43,"_88":45,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":46,"_95":96},"isOwned",15,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","excel","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yeEk0TXdTZ1pDYmt1Y0FqSmFkNWwxMUx6UkMifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_44":45,"_32":46,"_39":233,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":31,"_58":59,"_60":59,"_61":-5,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":234,"_81":235,"_83":236,"_85":25},"tree",[170,173,176,179],"files",[170,171,172,173,174,175,176,177,178,179],"counts",{"_160":137,"_161":63,"_162":137,"_163":164,"_165":166},"contents",[127,128,129,130],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":154,"_32":155,"_30":156,"_134":-5,"_42":43,"_41":157,"_135":59,"_39":158,"_13":137,"_34":146,"_36":-5,"_24":25,"_139":-5,"_27":159},{"_44":148,"_32":149,"_30":150,"_134":-5,"_42":43,"_41":151,"_135":59,"_39":152,"_13":137,"_34":146,"_36":-5,"_24":25,"_139":-5,"_27":153},{"_44":141,"_32":142,"_30":143,"_134":-5,"_42":43,"_41":144,"_135":59,"_39":145,"_13":137,"_34":146,"_36":-5,"_24":25,"_139":-5,"_27":147},{"_44":131,"_32":132,"_30":133,"_134":-5,"_42":43,"_41":63,"_135":59,"_39":136,"_13":137,"_34":20,"_36":138,"_24":25,"_139":-5,"_27":140},"58c02b5c-3443-11f0-8796-9e149126039e","README.md","58c02c6a-3443-11f0-8796-9e149126039e","parentId","latest",["D",1747612430487],0,"# 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- Create and view job postings\n- Real-time public chat room\n- Simple, responsive UI with Tailwind CSS\n\n## Project Structure\n\n- `/backend` - Hono API server and SQLite database\n- `/frontend` - HTML, CSS, and JavaScript for the client-side application\n- `/shared` - Shared types and utilities\n\n## Technologies Used\n\n- Backend: Hono, SQLite\n- Frontend: HTML, JavaScript, Tailwind CSS\n- Data Storage: SQLite\n\n## How to Use\n\n1. Visit the main page to see job listings and the chat room\n2. Use the \"Post a Job\" form to create new job listings\n3. Enter your name and message in the chat form to participate in discussions","label",[132],"8f8a671a-3443-11f0-a427-9e149126039e","shared","1543430e-3ffa-4643-871f-4daef9042a7e",5,["D",1747612522409],"directory",[142],"855016aa-3443-11f0-baca-9e149126039e","frontend","2c0cdac2-d296-4fc1-a942-1f5ea8a9dc8f",3,["D",1747612505246],[149],"635dffbc-3443-11f0-b77c-9e149126039e","backend","d90fca17-6935-40e6-aa6e-b0f77c646c1b",2,["D",1747612448297],[155],"pulls","branches","forks","envVars",{"_167":137,"_169":137},"connections",{"_167":137,"_168":137},"count","unfilledCount","emptyCount",{"_44":154,"_32":155,"_30":156,"_134":-5,"_42":43,"_41":157,"_135":59,"_39":230,"_13":137,"_34":146,"_36":-5,"_24":25,"_139":-5,"_181":231,"_27":232},{"_44":223,"_32":132,"_30":224,"_134":156,"_42":43,"_41":225,"_135":59,"_39":226,"_13":137,"_34":20,"_36":227,"_24":25,"_139":-5,"_181":228,"_27":229},{"_44":219,"_32":33,"_30":31,"_134":156,"_42":43,"_41":14,"_135":25,"_39":220,"_13":144,"_34":35,"_36":38,"_24":25,"_139":-5,"_181":221,"_27":222},{"_44":148,"_32":149,"_30":150,"_134":-5,"_42":43,"_41":151,"_135":59,"_39":216,"_13":137,"_34":146,"_36":-5,"_24":25,"_139":-5,"_181":217,"_27":218},{"_44":209,"_32":132,"_30":210,"_134":150,"_42":43,"_41":211,"_135":59,"_39":212,"_13":137,"_34":20,"_36":213,"_24":25,"_139":-5,"_181":214,"_27":215},{"_44":202,"_32":203,"_30":204,"_134":150,"_42":43,"_41":151,"_135":59,"_39":205,"_13":137,"_34":20,"_36":206,"_24":25,"_139":-5,"_181":207,"_27":208},{"_44":141,"_32":142,"_30":143,"_134":-5,"_42":43,"_41":144,"_135":59,"_39":199,"_13":137,"_34":146,"_36":-5,"_24":25,"_139":-5,"_181":200,"_27":201},{"_44":192,"_32":132,"_30":193,"_134":143,"_42":43,"_41":194,"_135":59,"_39":195,"_13":137,"_34":20,"_36":196,"_24":25,"_139":-5,"_181":197,"_27":198},{"_44":184,"_32":185,"_30":186,"_134":143,"_42":43,"_41":144,"_135":59,"_39":187,"_13":137,"_34":188,"_36":189,"_24":25,"_139":-5,"_181":190,"_27":191},{"_44":131,"_32":132,"_30":133,"_134":-5,"_42":43,"_41":63,"_135":59,"_39":180,"_13":137,"_34":20,"_36":138,"_24":25,"_139":-5,"_181":182,"_27":183},["D",1747612430487],"children",[],[132],"8f8a458c-3443-11f0-a427-9e149126039e","types.ts","8f8a464a-3443-11f0-a427-9e149126039e",["D",1747612522409],"script","// Job posting type\nexport interface JobPosting {\n id: number;\n title: string;\n description: string;\n company: string;\n location: string;\n salary: string | null;\n contact: string;\n created_at: string;\n}\n\n// Chat message type\nexport interface ChatMessage {\n id: number;\n username: string;\n message: string;\n created_at: string;\n}\n\n// Job posting form data\nexport interface JobPostingFormData {\n title: string;\n description: string;\n company: string;\n location: string;\n salary?: string;\n contact: string;\n}\n\n// Chat message form data\nexport interface ChatMessageFormData {\n username: string;\n message: string;\n}",[],[142,185],"a10c1db2-3443-11f0-b270-9e149126039e","a10c1e7a-3443-11f0-b270-9e149126039e",8,["D",1747612551781],"# Shared\n\nThis directory contains code and types that are shared between the frontend and backend.\n\n## Files\n\n- `types.ts` - TypeScript interfaces for data models used throughout the application\n\n## Types\n\n- `JobPosting` - Interface for job posting data\n- `ChatMessage` - Interface for chat message data\n- `JobPostingFormData` - Interface for job posting form data\n- `ChatMessageFormData` - Interface for chat message form data",[],[142,132],["D",1747612522409],[177,178],[142],"854f5af8-3443-11f0-baca-9e149126039e","index.html","854f5bac-3443-11f0-baca-9e149126039e",["D",1747612505246],"\n\n\n \n \n Job Board with Chat\n \n \n \n\n\n

Job Board with Chat

Find opportunities and discuss them with others

\n\n

\n \n

Job Listings

Loading job listings...

\n\n \n

Post a Job

\n \n

\n\n \n

Opportunity Chat

Loading chat messages...

\n \n

\n\n \n

\n\n \n\n",[],[149,203],"9d739838-3443-11f0-baca-9e149126039e","9d73990a-3443-11f0-baca-9e149126039e",7,["D",1747612545750],"# Frontend\n\nThis directory contains the client-side code for the Job Board with Chat application.\n\n## Structure\n\n- `index.html` - Main HTML file containing the entire frontend application\n\n## Features\n\n- Job listing display\n- Job posting form\n- Real-time chat interface\n- Responsive design with Tailwind CSS\n\n## Implementation Details\n\nThe frontend is built as a single HTML file with inline JavaScript for simplicity. It uses:\n\n- Tailwind CSS for styling\n- Fetch API for communication with the backend\n- Polling for real-time chat updates (every 5 seconds)\n\n## User Interface\n\nThe UI is divided into three main sections:\n\n1. Job Listings - Displays all posted jobs\n2. Post a Job Form - Allows users to create new job listings\n3. Chat Room - Enables real-time discussion about opportunities",[],[149,132],["D",1747612505246],[174,175],[149],"80856870-3446-11f0-9a63-9e149126039e",["D",1747613785701],[],[155,33],"956d6f92-3443-11f0-bbf6-9e149126039e","956d7046-3443-11f0-bbf6-9e149126039e",6,["D",1747612532284],"# Backend\n\nThis directory contains the server-side code for the Job Board with Chat application.\n\n## Structure\n\n- `index.ts` - Main entry point for the Hono API server\n- Database tables:\n - `job_postings` - Stores job listings\n - `chat_messages` - Stores chat messages\n\n## API Endpoints\n\n### Jobs\n\n- `GET /api/jobs` - Get all job postings\n- `POST /api/jobs` - Create a new job posting\n\n### Chat\n\n- `GET /api/chat` - Get chat messages (most recent 100)\n- `POST /api/chat` - Post a new chat message\n\n## Database Schema\n\n### job_postings\n\n- `id` - INTEGER PRIMARY KEY\n- `title` - TEXT\n- `description` - TEXT\n- `company` - TEXT\n- `location` - TEXT\n- `salary` - TEXT (optional)\n- `contact` - TEXT\n- `created_at` - TEXT (ISO date string)\n\n### chat_messages\n\n- `id` - INTEGER PRIMARY KEY\n- `username` - TEXT\n- `message` - TEXT\n- `created_at` - TEXT (ISO date string)",[],[155,132],["D",1747612448297],[171,172],[155],["D",1747612277925],{"_97":96,"_104":100},{"_97":96,"_98":-5,"_99":100,"_18":56,"_101":102,"_103":25},{"_13":86,"_32":87,"_44":43,"_88":45,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":46,"_95":96},"ctx",{"_79":-5,"_124":270,"_271":272,"_273":274,"_275":25,"_276":25,"_277":25,"_278":59,"_279":-5,"_280":-7,"_281":-7,"_282":137,"_283":25,"_284":25,"_285":-5,"_286":25,"_287":25,"_288":25,"_289":-5},"ENV",{"_241":242,"_243":244,"_245":87,"_246":247,"_248":249,"_250":251,"_252":253,"_254":255,"_256":257,"_258":259,"_260":261,"_262":263,"_264":265,"_266":267,"_268":269},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e8c4b7030cb7600e4eb0736b15f422c8b8bd130f","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