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",[],[66,111],"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",[],[66,38],["D",1747612448297],[127,128],[72],{"_36":138,"_13":38,"_39":139,"_41":73,"_42":43,"_44":140,"_46":47,"_48":141,"_17":50,"_51":24,"_52":142,"_54":55,"_56":-5,"_82":143,"_18":144},{"_36":129,"_13":130,"_39":131,"_41":73,"_42":43,"_44":132,"_46":47,"_48":133,"_17":100,"_51":134,"_52":135,"_54":55,"_56":-5,"_82":136,"_18":137},"d4b86b36-3446-11f0-962e-9e149126039e","index.ts","635ddb04-3443-11f0-b77c-9e149126039e",15,["D",1747613926960],"http","import { Hono } from \"https://esm.sh/hono@3.11.7\";\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// Simple CORS middleware\napp.use(\"*\", async (c, next) => {\n await next();\n c.header(\"Access-Control-Allow-Origin\", \"*\");\n c.header(\"Access-Control-Allow-Methods\", \"GET, POST, PUT, DELETE, OPTIONS\");\n c.header(\"Access-Control-Allow-Headers\", \"Content-Type\");\n \n if (c.req.method === \"OPTIONS\") {\n return new Response(null, { status: 204 });\n }\n});\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;",[],[72,130],"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)",[],[72,38],"fdd084bc-3442-11f0-b570-9e149126039e",["D",1747612277925],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Creating a job app with chat forum","imageUrl","userId","dcf86e80-3442-11f0-b519-ff88f6bc2fe6","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","d12e9468-0713-4b2e-926d-7ccecb147081","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_198":194},"org",{"_11":12,"_192":-5,"_193":194,"_155":156,"_195":196,"_197":55},"branch",{"_17":132,"_13":16,"_36":43,"_184":145,"_185":-5,"_186":-5,"_187":-5,"_188":-5,"_189":-5,"_190":14,"_191":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yeEk0TXdTZ1pDYmt1Y0FqSmFkNWwxMUx6UkMifQ","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":145,"_13":14,"_48":264,"_147":-5,"_148":55,"_149":150,"_151":150,"_152":153,"_154":-5,"_155":156,"_157":131,"_158":47,"_159":47,"_160":-5,"_161":45,"_162":163,"_164":-5,"_165":-5,"_166":-5,"_167":-5,"_168":169,"_170":169,"_171":172,"_173":172,"_174":172,"_175":169,"_176":169,"_177":265,"_179":266,"_181":267,"_183":55},[234,237,240,243],"files",[234,235,236,237,238,239,240,241,242,243],"counts",{"_225":50,"_226":45,"_227":50,"_31":228,"_229":230},[217,218,219,220],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_36":71,"_13":72,"_39":73,"_41":-5,"_42":43,"_44":74,"_46":47,"_48":75,"_17":50,"_51":63,"_52":-5,"_54":55,"_56":-5,"_18":224},{"_36":65,"_13":66,"_39":67,"_41":-5,"_42":43,"_44":68,"_46":47,"_48":69,"_17":50,"_51":63,"_52":-5,"_54":55,"_56":-5,"_18":223},{"_36":58,"_13":59,"_39":60,"_41":-5,"_42":43,"_44":61,"_46":47,"_48":62,"_17":50,"_51":63,"_52":-5,"_54":55,"_56":-5,"_18":222},{"_36":37,"_13":38,"_39":40,"_41":-5,"_42":43,"_44":45,"_46":47,"_48":49,"_17":50,"_51":24,"_52":53,"_54":55,"_56":-5,"_18":221},[38],[59],[66],[72],"pulls","branches","forks",{"_231":50,"_233":50},"connections",{"_231":50,"_232":50},"count","unfilledCount","emptyCount",{"_36":71,"_13":72,"_39":73,"_41":-5,"_42":43,"_44":74,"_46":47,"_48":124,"_17":50,"_51":63,"_52":-5,"_54":55,"_56":-5,"_82":262,"_18":263},{"_36":138,"_13":38,"_39":139,"_41":73,"_42":43,"_44":140,"_46":47,"_48":141,"_17":50,"_51":24,"_52":142,"_54":55,"_56":-5,"_82":260,"_18":261},{"_36":129,"_13":130,"_39":131,"_41":73,"_42":43,"_44":132,"_46":47,"_48":133,"_17":100,"_51":134,"_52":135,"_54":55,"_56":-5,"_82":258,"_18":259},{"_36":65,"_13":66,"_39":67,"_41":-5,"_42":43,"_44":68,"_46":47,"_48":105,"_17":50,"_51":63,"_52":-5,"_54":55,"_56":-5,"_82":256,"_18":257},{"_36":117,"_13":38,"_39":118,"_41":67,"_42":43,"_44":119,"_46":47,"_48":120,"_17":50,"_51":24,"_52":121,"_54":55,"_56":-5,"_82":254,"_18":255},{"_36":110,"_13":111,"_39":112,"_41":67,"_42":43,"_44":68,"_46":47,"_48":113,"_17":50,"_51":24,"_52":114,"_54":55,"_56":-5,"_82":252,"_18":253},{"_36":58,"_13":59,"_39":60,"_41":-5,"_42":43,"_44":61,"_46":47,"_48":85,"_17":50,"_51":63,"_52":-5,"_54":55,"_56":-5,"_82":250,"_18":251},{"_36":98,"_13":38,"_39":99,"_41":60,"_42":43,"_44":100,"_46":47,"_48":101,"_17":50,"_51":24,"_52":102,"_54":55,"_56":-5,"_82":248,"_18":249},{"_36":90,"_13":91,"_39":92,"_41":60,"_42":43,"_44":61,"_46":47,"_48":93,"_17":50,"_51":94,"_52":95,"_54":55,"_56":-5,"_82":246,"_18":247},{"_36":37,"_13":38,"_39":40,"_41":-5,"_42":43,"_44":45,"_46":47,"_48":81,"_17":50,"_51":24,"_52":53,"_54":55,"_56":-5,"_82":244,"_18":245},[],[38],[],[59,91],[],[59,38],[241,242],[59],[],[66,111],[],[66,38],[238,239],[66],[],[72,130],[],[72,38],[235,236],[72],["D",1747612277925],{"_11":12,"_198":194},{"_11":12,"_192":-5,"_193":194,"_155":156,"_195":196,"_197":55},{"_17":132,"_13":16,"_36":43,"_184":145,"_185":-5,"_186":-5,"_187":-5,"_188":-5,"_189":-5,"_190":14,"_191":12},"ctx",{"_177":-5,"_214":301,"_302":303,"_304":305,"_306":55,"_307":55,"_308":55,"_309":47,"_310":-5,"_311":-7,"_312":-7,"_313":50,"_314":55,"_315":55,"_316":-5,"_317":55,"_318":55,"_319":55,"_320":-5},"ENV",{"_272":273,"_274":275,"_276":16,"_277":278,"_279":280,"_281":282,"_283":284,"_285":286,"_287":288,"_289":290,"_291":292,"_293":294,"_295":296,"_297":298,"_299":300},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","a3e067d4463eea85f6334f8e583e8516ae58c4f6","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"]

Code