📋 Post a Job

\n setJobTitle(e.target.value)}\n style={inputStyle}\n />\n setJobCompany(e.target.value)}\n style={inputStyle}\n />\n

setJobDescription(e.target.value)}\n        style={{...inputStyle, height: '150px'}}\n      />\n      <button \n        onClick={submitJob}\n        style={buttonStyle}\n      >\n        Post Job\n      </button>\n    </div>\n  );\n\n  const renderJobList = () => (\n    <div>\n      <h2>💼 Job Listings</h2>\n      {jobs.length === 0 ? (\n        <p>No job listings yet</p>\n      ) : (\n        jobs.map((job, index) => (\n          <div \n            key={index} \n            style={{\n              border: '1px solid #e0e0e0', \n              borderRadius: '5px', \n              padding: '15px', \n              marginBottom: '10px'\n            }}\n          >\n            <h3>{job.title}</h3>\n            <p><strong>Company:</strong> {job.company}</p>\n            <p>{job.description}</p>\n            <small>Posted on {new Date(job.timestamp).toLocaleString()}</small>\n          </div>\n        ))\n      )}\n    </div>\n  );\n\n  const renderChatRoom = () => (\n    <div style={{ display: 'flex', flexDirection: 'column', height: '500px' }}>\n      <div \n        style={{ \n          flexGrow: 1, \n          overflowY: 'auto', \n          border: '1px solid #e0e0e0', \n          padding: '10px' \n        }}\n      >\n        {chatMessages.map((msg, index) => (\n          <div \n            key={index} \n            style={{ \n              marginBottom: '10px', \n              padding: '5px', \n              backgroundColor: '#f0f0f0', \n              borderRadius: '5px' \n            }}\n          >\n            <strong>{msg.username || 'Anonymous'}</strong>\n            <p>{msg.message}</p>\n            <small>{new Date(msg.timestamp).toLocaleTimeString()}</small>\n          </div>\n        ))}\n        <div ref={chatEndRef} />\n      </div>\n      <div style={{ display: 'flex', marginTop: '10px' }}>\n        <input \n          type=\"text\" \n          placeholder=\"Type a message...\" \n          value={chatMessage}\n          onChange={(e) => setChatMessage(e.target.value)}\n          onKeyPress={(e) => e.key === 'Enter' && sendChatMessage()}\n          style={{...inputStyle, flexGrow: 1, marginRight: '10px'}}\n        />\n        <button \n          onClick={sendChatMessage}\n          style={buttonStyle}\n        >\n          Send\n        </button>\n      </div>\n    </div>\n  );\n\n  const renderGoogleForm = () => (\n    <div>\n      <h2>📝 Community Survey</h2>\n      <iframe \n        src=\"https://docs.google.com/forms/d/e/1FAIpQLSdJNHxhOKqLWfNj4dZQg7ydmVkJDrVVVRQVqQJNmEF3fmTOUQ/viewform?embedded=true\" \n        width=\"100%\" \n        height=\"600\" \n        frameBorder=\"0\" \n        marginHeight=\"0\" \n        marginWidth=\"0\"\n        style={{\n          border: '1px solid #e0e0e0',\n          borderRadius: '5px'\n        }}\n      >\n        Loading…\n      </iframe>\n      <p style={{ textAlign: 'center', marginTop: '10px' }}>\n        <a \n          href=\"https://docs.google.com/forms/d/1-8DTHn8ArVRUQ-FR-cx8n6i8aPAgJbytVFqJINmd1i0/edit\" \n          target=\"_blank\" \n          rel=\"noopener noreferrer\"\n          style={{\n            color: '#4CAF50',\n            textDecoration: 'none',\n            fontWeight: 'bold'\n          }}\n        >\n          Open Form in New Tab\n        </a>\n      </p>\n    </div>\n  );\n\n  return (\n    <div style={{ maxWidth: '800px', margin: 'auto', padding: '20px', fontFamily: 'Arial' }}>\n      <h1>🚀 Job Opportunities Network</h1>\n      <div style={{ \n        display: 'flex', \n        marginBottom: '20px', \n        justifyContent: 'center',\n        flexWrap: 'wrap'\n      }}>\n        <button \n          onClick={() => setView('jobs')}\n          style={{...buttonStyle, margin: '0 10px 10px 10px'}}\n        >\n          Job Listings\n        </button>\n        <button \n          onClick={() => setView('post')}\n          style={{...buttonStyle, margin: '0 10px 10px 10px'}}\n        >\n          Post Job\n        </button>\n        <button \n          onClick={() => setView('chat')}\n          style={{...buttonStyle, margin: '0 10px 10px 10px'}}\n        >\n          Chat Room\n        </button>\n        <button \n          onClick={() => setView('survey')}\n          style={{...buttonStyle, margin: '0 10px 10px 10px'}}\n        >\n          Community Survey\n        </button>\n      </div>\n\n      {view === 'jobs' && renderJobList()}\n      {view === 'post' && renderJobPosting()}\n      {view === 'chat' && renderChatRoom()}\n      {view === 'survey' && renderGoogleForm()}\n\n      <a \n        href={import.meta.url.replace(\"esm.town\", \"val.town\")} \n        target=\"_top\" \n        style={{ color: '#888', fontSize: '0.8em', textDecoration: 'none', display: 'block', marginTop: '20px' }}\n      >\n        View Source\n      </a>\n    </div>\n  );\n}\n\nconst inputStyle = {\n  width: '100%', \n  padding: '10px', \n  marginBottom: '10px', \n  border: '1px solid #ccc', \n  borderRadius: '5px'\n};\n\nconst buttonStyle = {\n  padding: '10px 15px', \n  background: '#4CAF50', \n  color: 'white', \n  border: 'none', \n  borderRadius: '5px',\n  cursor: 'pointer'\n};\n\nfunction client() {\n  createRoot(document.getElementById(\"root\")).render(<App />);\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  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      description TEXT NOT NULL,\n      company TEXT NOT NULL,\n      timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n    )\n  `);\n\n  await sqlite.execute(`\n    CREATE TABLE IF NOT EXISTS ${KEY}_chat_${SCHEMA_VERSION} (\n      id INTEGER PRIMARY KEY AUTOINCREMENT,\n      username TEXT,\n      message TEXT NOT NULL,\n      timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n    )\n  `);\n\n  const url = new URL(request.url);\n\n  if (request.method === 'POST' && url.pathname === '/submit-job') {\n    const { title, description, company } = await request.json();\n    await sqlite.execute(`\n      INSERT INTO ${KEY}_jobs_${SCHEMA_VERSION} (title, description, company) \n      VALUES (?, ?, ?)\n    `, [title, description, company]);\n    return new Response(JSON.stringify({ success: true }), { \n      headers: { 'Content-Type': 'application/json' } \n    });\n  }\n\n  if (request.method === 'POST' && url.pathname === '/send-chat') {\n    const { message } = await request.json();\n    await sqlite.execute(`\n      INSERT INTO ${KEY}_chat_${SCHEMA_VERSION} (message, username) \n      VALUES (?, ?)\n    `, [message, 'Anonymous']);\n    return new Response(JSON.stringify({ success: true }), { \n      headers: { 'Content-Type': 'application/json' } \n    });\n  }\n\n  if (request.method === 'GET' && url.pathname === '/get-jobs') {\n    const result = await sqlite.execute(`\n      SELECT title, description, company, timestamp \n      FROM ${KEY}_jobs_${SCHEMA_VERSION} \n      ORDER BY timestamp DESC \n      LIMIT 20\n    `);\n    return new Response(JSON.stringify(result.rows), { \n      headers: { 'Content-Type': 'application/json' } \n    });\n  }\n\n  if (request.method === 'GET' && url.pathname === '/get-chat') {\n    const result = await sqlite.execute(`\n      SELECT username, message, timestamp \n      FROM ${KEY}_chat_${SCHEMA_VERSION} \n      ORDER BY timestamp DESC \n      LIMIT 50\n    `);\n    return new Response(JSON.stringify(result.rows.reverse()), { \n      headers: { 'Content-Type': 'application/json' } \n    });\n  }\n\n  return new Response(`\n    <html>\n      <head>\n        <title>Job Opportunities Network</title>\n        <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\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}","createdAt",["D",1739814901233],"version","currentUserHasLiked","likeCount","forkCount","referenceCount","dependencyCount",1,"commentCount","prCount","mergedPr",{"_128":129,"_130":131},"handle","Sindy04","profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ydEI1SThlUEhQNEY4MjJDa1VSMUJ4M0tjRU4ifQ","forkedVal","interval","slug","Sindy04/moodTracker","description","@jsxImportSource https://esm.sh/react@18.2.0","versions",[140,143,146],{"_117":90,"_141":-5,"_115":142,"_112":110},"prId",["D",1739814901233],{"_117":123,"_141":-5,"_115":144,"_112":145},["D",1739814235830],"c287d578-ed56-11ef-9de4-e6cdfca9ef9f",{"_117":31,"_141":-5,"_115":147,"_112":148},["D",1739813879623],"ee379312-ed55-11ef-ba3e-e6cdfca9ef9f","recentThread","breadcrumbs","comments",[],"isOwner","routes/_app.v.$handle.$name.dependencies",{"_156":157,"_224":123,"_225":135,"_226":31,"_94":227},"dependenciesList",[158],{"_100":159,"_160":161},"08f95904-3584-11ef-8995-0e10024e3b32","initialData",{"_98":162,"_95":163,"_100":159,"_102":164,"_103":-5,"_104":105,"_106":165,"_107":166,"_109":167,"_111":26,"_112":167,"_113":168,"_115":169,"_117":170,"_118":26,"_119":171,"_121":172,"_122":123,"_124":123,"_120":173,"_125":31,"_126":-5,"_20":174,"_132":177,"_133":-7,"_136":182,"_183":-5,"_134":184,"_138":185},"sqlite","a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18","76a8911e-393e-11ef-8e71-de64eea55b61","# LLM-Safe Fork of @std/sqlite\n\nWe found that LLMs have trouble with the inputs and outputs of our @std/sqlite method.\n\n1. It expects the input to be `(sql: string, args: any[])` but it's `{ sql: string, args: any[] }`\n2. It expects the output to be objects, but they are arrays\n\nInstead of struggling to teach it, we built this val to be a wrapper around @std/sqlite that adheres to what the LLMs expect. \n\nThis val is also backwards-compatible with @std/sqlite, so we're considering merging it in.","script","5631f2d0-dcb9-11ef-80ec-e6cdfca9ef9f","import { API_URL } from \"https://esm.town/v/std/API_URL\";\nimport { LibsqlError, type ResultSet, type Row, type TransactionMode } from \"npm:@libsql/client\";\nimport { z } from \"npm:zod\";\n\n/**\n * Every Val Town account comes with its own private\n * [SQLite database](https://www.sqlite.org/) that\n * is accessible from any of your vals.\n * ([Docs ↗](https://docs.val.town/std/sqlite))\n */\nexport const sqlite = {\n  /**\n   * Executes a SQLite statement.\n   *\n   * @param {InStatement} statement - The SQLite statement to execute.\n   * @example String query:\n   * `sqlite.execute(\"SELECT 1;\")`\n   * @example Query with arguments:\n   * `sqlite.execute({sql: \"SELECT * from books WHERE year > ?;\", args: [2020]})`\n   */\n  execute,\n\n  /**\n   * Executes a batch of SQLite statements.\n   *\n   * @param {InStatement[]} statements - An array of SQLite statements to execute.\n   * @param {TransactionMode} [mode] - The transaction mode for the batch execution.\n   */\n  batch,\n};\n\n// ------------\n// Functions\n// ------------\n\nasync function execute(statement: InStatement, args?: InArgs): Promise<ResultSet> {\n  const res = await fetch(`${API_URL}/v1/sqlite/execute`, {\n    method: \"POST\",\n    headers: {\n      Authorization: `Bearer ${Deno.env.get(\"valtown\")}`,\n    },\n    body: JSON.stringify({ statement: normalizeStatement(statement, args) }),\n  });\n  if (!res.ok) {\n    throw createResError(await res.text());\n  }\n  const resultSet = await res.json();\n  return upgradeResultSet(resultSet);\n}\n\nasync function batch(statements: InStatement[], mode?: TransactionMode): Promise<ResultSet[]> {\n  if (mode && ![\"write\", \"read\", \"deferred\"].includes(mode)) {\n    throw new Error(\"Invalid transaction mode provided to sqlite.batch. Must be 'write', 'read', or 'deferred.\");\n  }\n  const res = await fetch(`${API_URL}/v1/sqlite/batch`, {\n    method: \"POST\",\n    headers: {\n      Authorization: `Bearer ${Deno.env.get(\"valtown\")}`,\n    },\n    body: JSON.stringify({ statements: statements.map(s => normalizeStatement(s)), mode }),\n  });\n  if (!res.ok) {\n    throw createResError(await res.text());\n  }\n  const resultSets = await res.json();\n  return resultSets.map(upgradeResultSet);\n}\n\nfunction createResError(body: string) {\n  try {\n    const e = zLibsqlError.parse(JSON.parse(body));\n    // e.message already contains the code, and LibsqlError adds the\n    // code to the beginning, so we remove it here\n    const msg = e.message.replace(e.code, \"\").replace(/^:\\s+/, \"\");\n    return new LibsqlError(msg, e.code, e.rawCode);\n  } catch (_) {\n    // Failed to parse libsql error\n  }\n  return new Error(body);\n}\n\n/* Val Town's Turso Proxy returns rows as an array of values\n * Yet the LibSQL API has a Row type which behave as an array or object,\n * ie you can access it via numerical index or string\n */\ninterface ImpoverishedResultSet extends ResultSet {\n  rows: any[];\n}\n\nfunction normalizeStatement(statement: InStatement, args?: InArgs) {\n  if (Array.isArray(statement)) {\n    // for the case of an array of arrays\n    return normalizeStatement(statement[0], statement[1]);\n  }\n  if (typeof statement === \"string\") {\n    if (args) {\n      return { sql: statement, args };\n    } else return statement;\n  }\n  else if (typeof statement === \"object\") {\n    if (statement.args) {\n      return statement;\n    }\n    if (args) {\n      return { sql: statement.sql, args };\n    }\n    return statement.sql;\n  }\n  else throw new Error(\"Error normalizing sql input\");\n}\n\nfunction upgradeResultSet(results: ImpoverishedResultSet): ResultSet {\n  return {\n    ...results,\n    rows: results.rows.map(row => rowFromSql(row, results.columns)),\n  };\n}\n\n// adapted from\n// https://github.com/tursodatabase/libsql-client-ts/blob/17dd996b840c950dd22b871adfe4ba0eb4a5ead3/packages/libsql-client/src/sqlite3.ts#L314C1-L337C2\nfunction rowFromSql(\n  sqlRow: Array<unknown>,\n  columns: Array<string>,\n): Row {\n  const row = {};\n  // make sure that the \"length\" property is not enumerable\n  Object.defineProperty(row, \"length\", { value: sqlRow.length });\n  for (let i = 0; i < sqlRow.length; ++i) {\n    const value = sqlRow[i];\n    Object.defineProperty(row, i, { value });\n\n    const column = columns[i];\n    if (!Object.hasOwn(row, column)) {\n      Object.defineProperty(row, column, {\n        value,\n        enumerable: true,\n        configurable: true,\n        writable: true,\n      });\n    }\n  }\n  return row as Row;\n}\n\n// ------------\n// Helpers\n// ------------\n\nconst zLibsqlError = z.object({\n  message: z.string(),\n  code: z.string(),\n  rawCode: z.number().optional(),\n});\n\n// We patch these types to only support JSON values\nexport type InValue = null | string | number | boolean;\nexport type InArgs = Array<InValue> | Record<string, InValue>;\nexport type InStatement = {\n  /**\n   * The SQL statement to execute.\n   */\n  sql: string;\n\n  /**\n   * The arguments to bind to the SQL statement.\n   */\n  args: InArgs;\n} | string;",["D",1737987404484],13,10,15093,21,{"_128":175,"_130":176},"stevekrouse","https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg",{"_112":178,"_128":179,"_98":162,"_117":180,"_181":-5},"56c849ee-f1f8-11ee-9b87-cab58f78796a","std",6,"prDisabledHint","LLM-Safe Fork of @std/sqlite We found that LLMs have trouble with the inputs and outputs of our @std/sqlite method. It expects the input to be  (sql: string, args: any[])  but it's  { sql: string, args: any[] } It expects the output to be objects, but they are arrays Instead of struggling to teach it, we built this val to be a wrapper around @std/sqlite that adheres to what the LLMs expect. This val is also backwards-compatible with @std/sqlite, so we're considering merging it in.","latestEvaluation","stevekrouse/sqlite",[186,190,194,198,201,205,209,213,216,220],{"_115":187,"_117":170,"_188":189},["D",1737987404484],"n","1",{"_115":191,"_117":192,"_188":193},["D",1724087412304],12,"2",{"_115":195,"_117":196,"_188":197},["D",1724087404512],11,"3",{"_115":199,"_117":171,"_188":200},["D",1723494410142],"4",{"_115":202,"_117":203,"_188":204},["D",1723494389876],9,"5",{"_115":206,"_117":207,"_188":208},["D",1723494345363],8,"6",{"_115":210,"_117":211,"_188":212},["D",1723494323065],7,"7",{"_115":214,"_117":180,"_188":215},["D",1719604370206],"8",{"_115":217,"_117":218,"_188":219},["D",1719604260994],5,"9",{"_115":221,"_117":222,"_188":223},["D",1719604144103],4,"10","dependenciesCount","valname","page",{"_112":110,"_98":99,"_128":129,"_11":96,"_117":90,"_100":101,"_113":114,"_104":105,"_111":26,"_134":135},"routes/_app","actionData","errors"]
</article></body></html>