${escapeHtml(job.title)}

\n #${job.id}\n

${escapeHtml(job.company)}

${escapeHtml(job.description)}

\n ${job.location ? `

📍 ${escapeHtml(job.location)}

` : ''}\n ${job.salary ? `

💰 ${escapeHtml(job.salary)}

` : ''}\n

\n ${formatDate(job.createdAt)}\n Contact\n

\n `).join('');\n } else {\n jobsList.innerHTML = '

No jobs posted yet

';\n }\n } catch (error) {\n document.getElementById('jobsList').innerHTML = \n '

Failed to load jobs

';\n }\n}\n\n// Load chat messages function\nasync function loadChatMessages() {\n try {\n const response = await fetch('/api/chat?limit=30');\n const data = await response.json();\n \n const chatMessages = document.getElementById('chatMessages');\n \n if (data.messages && data.messages.length > 0) {\n chatMessages.innerHTML = data.messages.reverse().map(msg => `\n

\n ${escapeHtml(msg.username)}\n ${formatDate(msg.createdAt)}\n

${escapeHtml(msg.message)}

\n `).join('');\n \n // Scroll to bottom\n chatMessages.scrollTop = chatMessages.scrollHeight;\n } else {\n chatMessages.innerHTML = '

No messages yet. Be the first to chat!

';\n }\n } catch (error) {\n document.getElementById('chatMessages').innerHTML = \n '

Failed to load messages

';\n }\n}\n\n// Utility functions\nfunction escapeHtml(text) {\n const div = document.createElement('div');\n div.textContent = text;\n return div.innerHTML;\n}\n\nfunction formatDate(dateString) {\n const date = new Date(dateString);\n return date.toLocaleString();\n}\n\n// Event listeners for refresh buttons\ndocument.getElementById('refreshJobs').addEventListener('click', loadJobs);\ndocument.getElementById('refreshChat').addEventListener('click', loadChatMessages);\n\n// Load initial data\nloadJobs();\nloadChatMessages();\n\n// Auto-refresh chat every 30 seconds\nsetInterval(loadChatMessages, 30000);",[],[208,214],{"_104":221,"_95":222,"_157":223,"_159":209,"_160":138,"_161":101,"_162":22,"_106":224,"_100":32,"_165":225,"_167":226,"_168":22,"_169":-5,"_170":227,"_98":228},"95095830-3f9d-11f0-b77f-76b3cceeab13","index.html","e0a16bfc-4d51-466e-a0b2-2f56b9271bba",["D",1748860649084],"file","\n\n \n \n \n Job Board & Chat API\n \n \n \n \n

\n Job Board & Chat API\n

By Ahmed Ashraf

\n\n

\n \n

\n 📋 Job Listings\n

\n\n \n

Post a Job

\n\n \n

Recent Jobs

\n \n 🔄 Refresh\n \n

\n \n

\n\n \n

\n 💬 Public Chat\n

\n\n \n \n \n

\n\n \n

\n 📚 API Documentation\n

Job Listings Endpoints

\n POST /api/jobs - Create job\n listing\n

\n GET /api/jobs - Get all jobs\n

\n GET /api/jobs/:id - Get\n specific job\n

Chat Endpoints

\n POST /api/chat - Post\n message\n

\n GET /api/chat - Get messages\n

\n GET /api - Full API\n documentation\n

\n \n\n \n \n",[],[208,222],[208],{"_104":231,"_95":232,"_157":233,"_159":-5,"_160":138,"_161":101,"_162":163,"_106":234,"_100":32,"_165":183,"_167":235,"_168":22,"_169":-5,"_170":236,"_98":237},"95095e34-3f9d-11f0-b77f-76b3cceeab13","01_script.tsx","60624071-6994-4afe-b2b6-93ad0b6ee25d",["D",1748860649084],"// This script returns a random fun fact\n// You can run scripts manually in this view or call it from other vals.\nexport default function getRandomFact() {\n const funFacts = [\n \"Honey never spoils.\",\n \"Bananas are actually berries, but strawberries are not.\",\n \"Val Town has a citizen Juicy Bear. 🐻\",\n ];\n const fact = funFacts[Math.floor(Math.random() * funFacts.length)];\n return fact;\n}\nconsole.log(\"Fun fact:\", getRandomFact());\n",[],[232],{"_104":239,"_95":99,"_157":240,"_159":-5,"_160":138,"_161":101,"_162":163,"_106":241,"_100":32,"_165":201,"_167":242,"_168":22,"_169":-5,"_170":243,"_98":244},"95095fba-3f9d-11f0-b77f-76b3cceeab13","b73b1004-d4d6-4771-b93d-46b32b9590f2",["D",1748860649084],"// This code responds to HTTP web requests.\n// Access it via its public URL (you can also pick a nicer subdomain).\n// Try adding ?name=YourName to the URL!\nexport default function httpHandler(req: Request): Response {\n const url = new URL(req.url);\n const name = url.searchParams.get(\"name\") || \"Friend\";\n console.log(`Greeted ${name} via HTTP`);\n return new Response(`Hello, ${name}! Welcome to Val Town.`);\n}",[],[99],{"_104":246,"_95":247,"_157":248,"_159":-5,"_160":138,"_161":101,"_162":163,"_106":249,"_100":32,"_165":250,"_167":251,"_168":22,"_169":-5,"_170":252,"_98":253},"9509610e-3f9d-11f0-b77f-76b3cceeab13","03_cron.tsx","3892604f-c10c-4805-940c-c7ac03fdf09d",["D",1748860649084],"interval","// This cron runs on a schedule (e.g. every hour, day).\n// Configure the timer with the 🕒 icon in the top right.\n// This example just logs the current time.\nexport function scheduledHandler() {\n const timestamp = new Date().toISOString();\n console.log(`Cron val executed at: ${timestamp}`);\n return `Executed at ${timestamp}`;\n}",[],[247],{"_104":255,"_95":256,"_157":257,"_159":-5,"_160":138,"_161":101,"_162":163,"_106":258,"_100":32,"_165":259,"_167":260,"_168":22,"_169":-5,"_170":261,"_98":262},"95096398-3f9d-11f0-b77f-76b3cceeab13","04_email.tsx","6df629a9-d1f7-4ee9-9e2c-5f29eaf736b1",["D",1748860649084],"email","// This code is triggered when an email is sent to its unique address.\n// Click \"Run\", copy and paste the email address and send an email to it.\n// This example will log the email details received.\nexport default async function emailHandler(email: Email){\n console.log(\"Email received!\", email.from, email.subject, email.text);\n for (const file of email.attachments) {\n console.log(`Filename: ${file.name}`);\n console.log(`Content Type: ${file.type}`);\n console.log(`Content: ${await file.text()}`);\n }\n}",[],[256],{"_104":264,"_95":265,"_157":266,"_159":-5,"_160":138,"_161":101,"_162":163,"_106":267,"_100":32,"_165":225,"_167":268,"_168":22,"_169":-5,"_170":269,"_98":270},"9509665e-3f9d-11f0-b77f-76b3cceeab13","README.md","f39b3abb-176a-4c9c-96df-7da13837c893",["D",1748860649084],"# Job Board & Chat API 🚀\n\nA REST API built with Hono that provides job listing management and a public chat room functionality.\n\n## Features\n\n- **Job Listings API**: Post and retrieve job listings\n- **Public Chat**: Real-time chat room for public discussions\n- **Web Interface**: Simple frontend to interact with the API\n- **SQLite Storage**: Persistent data storage using Val Town's SQLite\n\n## Project Structure\n\n```\n├── backend/\n│ ├── index.ts # Main API server (HTTP endpoint)\n│ └── database/\n│ ├── migrations.ts # Database schema definitions\n│ └── queries.ts # Database query functions\n├── frontend/\n│ ├── index.html # Web interface\n│ └── app.js # Frontend JavaScript\n└── README.md\n```\n\n## API Endpoints\n\n### Job Listings\n\n- **POST /api/jobs** - Create a new job listing\n ```json\n {\n \"title\": \"Software Engineer\",\n \"company\": \"Tech Corp\",\n \"description\": \"We're looking for...\",\n \"location\": \"Remote\", // optional\n \"salary\": \"$80k-120k\", // optional\n \"contactEmail\": \"hr@techcorp.com\"\n }\n ```\n\n- **GET /api/jobs** - Get all job listings\n- **GET /api/jobs/:id** - Get a specific job by ID\n\n### Public Chat\n\n- **POST /api/chat** - Post a message to the chat\n ```json\n {\n \"username\": \"john_doe\",\n \"message\": \"Hello everyone!\"\n }\n ```\n\n- **GET /api/chat** - Get recent chat messages\n - Optional query parameter: `?limit=N` (default: 50)\n\n### Documentation\n\n- **GET /api** - Get full API documentation with schemas\n\n## Usage\n\n1. **Web Interface**: Visit the main URL to use the interactive web interface\n2. **API Access**: Make HTTP requests to the endpoints listed above\n3. **Testing**: Use tools like curl, Postman, or the built-in web interface\n\n## Example API Calls\n\n### Post a Job\n```bash\ncurl -X POST /api/jobs \\\n -H \"Content-Type: application/json\" \\\n -d '{\n \"title\": \"Frontend Developer\",\n \"company\": \"StartupXYZ\",\n \"description\": \"Looking for a React developer...\",\n \"location\": \"San Francisco\",\n \"salary\": \"$90k-130k\",\n \"contactEmail\": \"jobs@startupxyz.com\"\n }'\n```\n\n### Get All Jobs\n```bash\ncurl /api/jobs\n```\n\n### Post a Chat Message\n```bash\ncurl -X POST /api/chat \\\n -H \"Content-Type: application/json\" \\\n -d '{\n \"username\": \"developer123\",\n \"message\": \"Anyone hiring React developers?\"\n }'\n```\n\n### Get Chat Messages\n```bash\ncurl /api/chat?limit=20\n```\n\n## Database Schema\n\n### Job Listings Table\n- `id` - Auto-incrementing primary key\n- `title` - Job title (required)\n- `company` - Company name (required)\n- `description` - Job description (required)\n- `location` - Job location (optional)\n- `salary` - Salary information (optional)\n- `contact_email` - Contact email (required)\n- `created_at` - Timestamp\n- `updated_at` - Timestamp\n\n### Chat Messages Table\n- `id` - Auto-incrementing primary key\n- `username` - Username (required, max 50 chars)\n- `message` - Message content (required, max 500 chars)\n- `created_at` - Timestamp\n\n## Development\n\nThe API is built using:\n- **Hono** - Fast web framework\n- **SQLite** - Database storage\n- **TypeScript** - Type safety\n- **Val Town Utils** - File serving utilities\n\n## Error Handling\n\nThe API returns appropriate HTTP status codes:\n- `200` - Success\n- `201` - Created\n- `400` - Bad Request (validation errors)\n- `404` - Not Found\n- `500` - Internal Server Error",[],[265],"files",[154,172,178,187,196,206,212,220,230,238,245,254,263],"counts",{"_275":32,"_276":101,"_277":32,"_278":279},"pulls","branches","forks","envVars",{"_280":32,"_281":32},"count","emptyCount","contents",[],{"_104":239,"_95":99,"_157":240,"_159":-5,"_160":138,"_161":101,"_162":163,"_106":285,"_100":32,"_165":201,"_167":242,"_168":22,"_169":-5,"_98":286},["D",1748860649084],[99],"upstreamProject","upstreamBranch",{"_104":141,"_106":290,"_291":292,"_95":43,"_139":147,"_100":143,"_140":-5,"_142":-5,"_293":294,"_108":-5,"_151":22,"_110":145,"_150":94,"_16":119,"_149":295},["D",1748858460267],"updatedAt",["D",1748860024551],"lockfileKey","1748860027145-esm.town_v_ahmed33_my-first-val@13-main","my-first-val","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.version.$version.code.$",{"_93":94,"_95":96,"_97":43,"_100":101,"_98":99,"_102":302,"_152":307,"_271":347,"_225":348,"_282":350,"_351":352,"_355":-5,"_356":101,"_357":32,"_358":359},{"_104":105,"_95":96,"_106":303,"_108":-5,"_109":22,"_110":111,"_112":-5,"_113":-5,"_14":114,"_115":-5,"_116":22,"_117":-5,"_118":32,"_16":119,"_120":121,"_122":121,"_123":124,"_125":124,"_126":124,"_127":121,"_128":121,"_23":304,"_132":305,"_135":306,"_151":22},["D",1748860649084],{"_93":94,"_130":131},{"_93":94,"_134":131,"_14":114},{"_100":137,"_95":43,"_104":138,"_139":105,"_140":141,"_142":143,"_144":145,"_146":147,"_148":119,"_149":96,"_150":94},[308,323,332,335,338,341,344],{"_104":155,"_95":156,"_157":158,"_159":-5,"_160":138,"_161":101,"_162":163,"_106":164,"_100":32,"_165":166,"_167":-5,"_168":22,"_169":-5,"_170":309,"_98":322},[310,319],{"_104":173,"_95":174,"_157":175,"_159":158,"_160":138,"_161":101,"_162":163,"_106":176,"_100":32,"_165":166,"_167":-5,"_168":22,"_169":-5,"_170":311,"_98":318},[312,315],{"_104":179,"_95":180,"_157":181,"_159":175,"_160":138,"_161":101,"_162":163,"_106":182,"_100":32,"_165":183,"_167":184,"_168":22,"_169":-5,"_170":313,"_98":314},[],[156,174,180],{"_104":188,"_95":189,"_157":190,"_159":175,"_160":138,"_161":101,"_162":163,"_106":191,"_100":32,"_165":183,"_167":192,"_168":22,"_169":-5,"_170":316,"_98":317},[],[156,174,189],[156,174],{"_104":197,"_95":198,"_157":199,"_159":158,"_160":138,"_161":101,"_162":163,"_106":200,"_100":32,"_165":201,"_167":202,"_168":22,"_169":-5,"_170":320,"_98":321},[],[156,198],[156],{"_104":207,"_95":208,"_157":209,"_159":-5,"_160":138,"_161":101,"_162":163,"_106":210,"_100":32,"_165":166,"_167":-5,"_168":22,"_169":-5,"_170":324,"_98":331},[325,328],{"_104":213,"_95":214,"_157":215,"_159":209,"_160":138,"_161":101,"_162":163,"_106":216,"_100":32,"_165":183,"_167":217,"_168":22,"_169":-5,"_170":326,"_98":327},[],[208,214],{"_104":221,"_95":222,"_157":223,"_159":209,"_160":138,"_161":101,"_162":22,"_106":224,"_100":32,"_165":225,"_167":226,"_168":22,"_169":-5,"_170":329,"_98":330},[],[208,222],[208],{"_104":231,"_95":232,"_157":233,"_159":-5,"_160":138,"_161":101,"_162":163,"_106":234,"_100":32,"_165":183,"_167":235,"_168":22,"_169":-5,"_170":333,"_98":334},[],[232],{"_104":239,"_95":99,"_157":240,"_159":-5,"_160":138,"_161":101,"_162":163,"_106":241,"_100":32,"_165":201,"_167":242,"_168":22,"_169":-5,"_170":336,"_98":337},[],[99],{"_104":246,"_95":247,"_157":248,"_159":-5,"_160":138,"_161":101,"_162":163,"_106":249,"_100":32,"_165":250,"_167":251,"_168":22,"_169":-5,"_170":339,"_98":340},[],[247],{"_104":255,"_95":256,"_157":257,"_159":-5,"_160":138,"_161":101,"_162":163,"_106":258,"_100":32,"_165":259,"_167":260,"_168":22,"_169":-5,"_170":342,"_98":343},[],[256],{"_104":264,"_95":265,"_157":266,"_159":-5,"_160":138,"_161":101,"_162":163,"_106":267,"_100":32,"_165":225,"_167":268,"_168":22,"_169":-5,"_170":345,"_98":346},[],[265],[308,310,312,315,319,323,325,328,332,335,338,341,344],{"_104":239,"_95":99,"_157":240,"_159":-5,"_160":138,"_161":101,"_162":163,"_106":285,"_100":32,"_165":201,"_167":242,"_168":22,"_169":-5,"_98":349},[99],[],"upstream",{"_104":141,"_106":353,"_291":354,"_95":43,"_139":147,"_100":143,"_140":-5,"_142":-5,"_293":294,"_108":-5,"_151":22,"_110":145,"_150":94,"_16":119,"_149":295},["D",1748858460267],["D",1748860024551],"pull","ahead","behind","templates",[],"actionData","errors"]

ahmed33

my-first-val54