📋 Job Board

\n setNewJob({...newJob, title: e.target.value})}\n required \n />\n setNewJob({...newJob, company: e.target.value})}\n required \n />\n

setNewJob({...newJob, description: e.target.value})}\n            required \n          />\n          <input \n            type=\"text\" \n            placeholder=\"Location\" \n            value={newJob.location}\n            onChange={(e) => setNewJob({...newJob, location: e.target.value})}\n            required \n          />\n          <button type=\"submit\">Post Job 🚀</button>\n        </form>\n\n        <div className=\"job-list\">\n          {jobs.map((job, index) => (\n            <div key={index} className=\"job-item\">\n              <h3>{job.title}</h3>\n              <p>{job.company} - {job.location}</p>\n              <p>{job.description}</p>\n            </div>\n          ))}\n        </div>\n      </div>\n\n      <div className=\"chat-room\">\n        <h2>💬 Chat Room</h2>\n        <div className=\"message-list\">\n          {messages.map((msg, index) => (\n            <div key={index} className=\"message\">\n              {msg.text}\n            </div>\n          ))}\n        </div>\n        <form onSubmit={sendMessage} className=\"message-form\">\n          <input \n            type=\"text\" \n            placeholder=\"Type a message\" \n            value={newMessage}\n            onChange={(e) => setNewMessage(e.target.value)}\n            required \n          />\n          <button type=\"submit\">Send</button>\n        </form>\n      </div>\n\n      <a \n        href={import.meta.url.replace(\"esm.town\", \"val.town\")} \n        target=\"_top\" \n        className=\"source-link\"\n      >\n        View Source\n      </a>\n    </div>\n  );\n}\n\nfunction client() {\n  createRoot(document.getElementById(\"root\")).render(<JobBoard />);\n}\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function server(request: Request): Promise<Response> {\n  const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n  const KEY = new URL(import.meta.url).pathname.split(\"/\").at(-1);\n  const SCHEMA_VERSION = 1;\n\n  // Create tables for jobs and messages\n  await sqlite.execute(`\n    CREATE TABLE IF NOT EXISTS ${KEY}_jobs_${SCHEMA_VERSION} (\n      id INTEGER PRIMARY KEY AUTOINCREMENT,\n      title TEXT NOT NULL,\n      company TEXT NOT NULL,\n      description TEXT NOT NULL,\n      location TEXT NOT NULL,\n      created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n    )\n  `);\n\n  await sqlite.execute(`\n    CREATE TABLE IF NOT EXISTS ${KEY}_messages_${SCHEMA_VERSION} (\n      id INTEGER PRIMARY KEY AUTOINCREMENT,\n      text TEXT NOT NULL,\n      created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n    )\n  `);\n\n  // Handle different routes\n  if (request.method === 'GET') {\n    const url = new URL(request.url);\n    \n    if (url.pathname === '/jobs') {\n      const jobs = await sqlite.execute(`SELECT * FROM ${KEY}_jobs_${SCHEMA_VERSION} ORDER BY created_at DESC LIMIT 20`);\n      return new Response(JSON.stringify(jobs.rows), {\n        headers: { 'Content-Type': 'application/json' }\n      });\n    }\n\n    if (url.pathname === '/messages') {\n      const messages = await sqlite.execute(`SELECT * FROM ${KEY}_messages_${SCHEMA_VERSION} ORDER BY created_at DESC LIMIT 50`);\n      return new Response(JSON.stringify(messages.rows), {\n        headers: { 'Content-Type': 'application/json' }\n      });\n    }\n  }\n\n  if (request.method === 'POST') {\n    const body = await request.json();\n    \n    if (request.url.includes('/jobs')) {\n      await sqlite.execute(`\n        INSERT INTO ${KEY}_jobs_${SCHEMA_VERSION} \n        (title, company, description, location) \n        VALUES (?, ?, ?, ?)\n      `, [body.title, body.company, body.description, body.location]);\n      return new Response('Job posted', { status: 200 });\n    }\n\n    if (request.url.includes('/messages')) {\n      await sqlite.execute(`\n        INSERT INTO ${KEY}_messages_${SCHEMA_VERSION} \n        (text) \n        VALUES (?)\n      `, [body.text]);\n      return new Response('Message sent', { status: 200 });\n    }\n  }\n\n  return new Response(`\n    <html>\n      <head>\n        <title>Job Board & Chat</title>\n        <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\n        <style>${css}</style>\n      </head>\n      <body>\n        <div id=\"root\"></div>\n        <script src=\"https://esm.town/v/std/catch\"></script>\n        <script type=\"module\" src=\"${import.meta.url}\"></script>\n      </body>\n    </html>\n  `, {\n    headers: { \"content-type\": \"text/html\" }\n  });\n}\n\nconst css = `\nbody {\n  font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Oxygen, Ubuntu, Cantarell, 'Open Sans', 'Helvetica Neue', sans-serif;\n  background-color: #f4f4f4;\n  margin: 0;\n  padding: 20px;\n  box-sizing: border-box;\n}\n\n.container {\n  display: flex;\n  gap: 20px;\n  max-width: 1200px;\n  margin: 0 auto;\n}\n\n.job-board, .chat-room {\n  background-color: white;\n  border-radius: 15px;\n  box-shadow: 0 4px 6px rgba(0,0,0,0.1);\n  padding: 20px;\n  width: 50%;\n}\n\n.job-form, .message-form {\n  display: flex;\n  flex-direction: column;\n  gap: 10px;\n  margin-bottom: 20px;\n}\n\n.job-form input, \n.job-form textarea, \n.message-form input {\n  padding: 10px;\n  border: 1px solid #ddd;\n  border-radius: 5px;\n}\n\n.job-form button, \n.message-form button {\n  background-color: #4CAF50;\n  color: white;\n  border: none;\n  padding: 10px;\n  border-radius: 5px;\n  cursor: pointer;\n}\n\n.job-list, .message-list {\n  max-height: 400px;\n  overflow-y: auto;\n}\n\n.job-item {\n  border-bottom: 1px solid #eee;\n  padding: 10px 0;\n}\n\n.message {\n  background-color: #f0f0f0;\n  margin: 5px 0;\n  padding: 10px;\n  border-radius: 5px;\n}\n\n.source-link {\n  display: block;\n  text-align: center;\n  margin-top: 20px;\n  color: #888;\n  text-decoration: none;\n}\n\n@media (max-width: 768px) {\n  .container {\n    flex-direction: column;\n  }\n  .job-board, .chat-room {\n    width: 100%;\n  }\n}\n`;","createdAt",["D",1739817154754],"version","currentUserHasLiked","likeCount",1,"forkCount","referenceCount","dependencyCount","commentCount","prCount","mergedPr",{"_128":129,"_130":131},"handle","Maranatha","profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ0QkRZTDRyZFVIcUZOMVFjQWo5RW5lOEl6MyJ9","forkedVal","interval","slug","Maranatha/jobBoardAndChatApp","description","@jsxImportSource https://esm.sh/react@18.2.0","versions",[140],{"_117":31,"_141":-5,"_115":142,"_112":110},"prId",["D",1739817154754],"recentThread","breadcrumbs","comments",[147],{"_112":148,"_149":150,"_115":151,"_152":-5,"_153":26,"_154":26,"_20":155},"ace10a76-ed5d-11ef-a6ec-e6cdfca9ef9f","body","I love that app",["D",1739817205994],"updatedAt","canDelete","canEdit",{"_128":129,"_130":131},"isOwner","routes/_app.v.$handle.$name.versions.$(version)",{"_93":159,"_128":129,"_98":99,"_20":160,"_156":26,"_94":163,"_138":170,"_117":-5,"_183":31,"_184":185,"_186":120,"_187":-5},"list",{"_112":96,"_128":129,"_115":161,"_162":-5,"_130":131},["D",1739815648373],"bio",{"_98":99,"_95":96,"_100":101,"_102":-5,"_103":164,"_104":105,"_106":-5,"_107":108,"_109":110,"_111":26,"_112":110,"_113":114,"_115":165,"_117":31,"_118":164,"_119":120,"_121":90,"_122":31,"_123":120,"_124":120,"_125":31,"_126":-5,"_20":166,"_132":-5,"_133":-7,"_134":135,"_136":137,"_138":167},true,["D",1739817154754],{"_128":129,"_130":131},[168],{"_117":31,"_141":-5,"_115":169,"_112":110},["D",1739817154754],[171],{"_112":110,"_113":114,"_117":31,"_115":172,"_173":99,"_100":101,"_107":108,"_128":129,"_11":96,"_174":-5,"_175":-5,"_176":-5,"_156":26,"_134":135,"_177":-5,"_178":179},["D",1739817154754],"valName","deletedAt","messageId","threadId","previous","stats",{"_180":181,"_182":31},"additions",324,"deletions","page","pageSize",8,"total","redirect","routes/_app","actionData","errors"]
</article></body></html>

jobBoardAndChatApp

Versions

v0