Persistent Job Board

\n {userId ? (\n // Existing app content\n <>\n {/* Existing JSX remains the same */}\n

\n ✅ Logged in as User {userId}\n

\n \n ) : (\n

Loading... Please wait

\n )}\n

\n );\n}\n\n// Rest of the client-side code remains the same\n\nexport default async function server(request: Request): Promise {\n try {\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 = 12; // Incrementing for user-specific data\n\n // Enhanced table creation with user-specific tables\n const createTablesWithRetry = async () => {\n const tableCreationQueries = [\n // Existing job, message, and applicant tables\n {\n name: 'users',\n query: `CREATE TABLE IF NOT EXISTS ${KEY}_users_${SCHEMA_VERSION} (\n id TEXT PRIMARY KEY,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`\n },\n {\n name: 'user_data',\n query: `CREATE TABLE IF NOT EXISTS ${KEY}_user_data_${SCHEMA_VERSION} (\n user_id TEXT NOT NULL,\n data_key TEXT NOT NULL,\n data_value TEXT NOT NULL,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n PRIMARY KEY (user_id, data_key)\n )`\n }\n ];\n\n // Existing table creation logic\n // ... (keep the previous implementation)\n };\n\n // New authentication route\n if (request.method === 'POST' && new URL(request.url).pathname === '/auth') {\n try {\n // Generate or retrieve user ID\n const userId = crypto.randomUUID(); // Generates a unique identifier\n \n // Store user in database\n await sqlite.execute(\n `INSERT OR IGNORE INTO ${KEY}_users_${SCHEMA_VERSION} (id) VALUES (?)`,\n [userId]\n );\n\n return new Response(JSON.stringify({ userId }), {\n headers: { 'Content-Type': 'application/json' }\n });\n } catch (authError) {\n console.error('Authentication error:', authError);\n return new Response(JSON.stringify({ error: 'Authentication failed' }), { \n status: 500,\n headers: { 'Content-Type': 'application/json' } \n });\n }\n }\n\n // Data saving route\n if (request.method === 'POST' && new URL(request.url).pathname === '/save-data') {\n try {\n const { userId, key, value } = await request.json();\n \n // Upsert user data\n await sqlite.execute(\n `INSERT OR REPLACE INTO ${KEY}_user_data_${SCHEMA_VERSION} \n (user_id, data_key, data_value) VALUES (?, ?, ?)`,\n [userId, key, value]\n );\n\n return new Response(JSON.stringify({ success: true }), {\n headers: { 'Content-Type': 'application/json' }\n });\n } catch (saveError) {\n console.error('Data save error:', saveError);\n return new Response(JSON.stringify({ error: 'Failed to save data' }), { \n status: 500,\n headers: { 'Content-Type': 'application/json' } \n });\n }\n }\n\n // Data retrieval route\n if (request.method === 'GET' && new URL(request.url).pathname === '/data') {\n try {\n const url = new URL(request.url);\n const userId = url.searchParams.get('userId');\n const key = url.searchParams.get('key');\n\n const result = await sqlite.execute(\n `SELECT data_value FROM ${KEY}_user_data_${SCHEMA_VERSION} \n WHERE user_id = ? AND data_key = ?`,\n [userId, key]\n );\n\n if (result.rows.length > 0) {\n return new Response(JSON.stringify({ \n value: result.rows[0].data_value \n }), {\n headers: { 'Content-Type': 'application/json' }\n });\n }\n\n return new Response(JSON.stringify({ value: null }), {\n headers: { 'Content-Type': 'application/json' }\n });\n } catch (retrieveError) {\n console.error('Data retrieval error:', retrieveError);\n return new Response(JSON.stringify({ error: 'Failed to retrieve data' }), { \n status: 500,\n headers: { 'Content-Type': 'application/json' } \n });\n }\n }\n\n // Existing routes for jobs, messages, and applications\n // ... (keep previous route handlers)\n\n return new Response(`\n \n \n Persistent Job Board\n \n \n \n

\n \n \n \n \n `, {\n headers: { 'Content-Type': 'text/html' }\n });\n } catch (globalError) {\n console.error('Global server error:', globalError);\n return new Response(JSON.stringify({ \n error: 'Unexpected server error', \n details: globalError.toString() \n }), { \n status: 500,\n headers: { 'Content-Type': 'application/json' } \n });\n }\n}\n\n// CSS remains the same as in the previous implementation\nconst css = `\n /* Previous CSS remains unchanged */\n`;","createdAt",["D",1739852383452],"version",15,"currentUserHasLiked","likeCount","forkCount","referenceCount","dependencyCount",1,"commentCount","prCount","mergedPr",{"_130":131,"_132":133},"handle","Marcyatieno","profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ0OXZ1Q1hFeG9ROTJGSkRJTzlJczcwYXRHbCJ9","forkedVal","interval","slug","Marcyatieno/jobPostingApp","description","@jsxImportSource https://esm.sh/react@18.2.0","versions",[142,145,149,153,157,161,165,169,173,177,181,185,189,193,196,199],{"_118":119,"_143":-5,"_116":144,"_113":111},"prId",["D",1739852383452],{"_118":146,"_143":-5,"_116":147,"_113":148},14,["D",1739852340776],"7ad9d808-edaf-11ef-b953-e6cdfca9ef9f",{"_118":150,"_143":-5,"_116":151,"_113":152},13,["D",1739851577910],"b425506c-edad-11ef-89ec-e6cdfca9ef9f",{"_118":154,"_143":-5,"_116":155,"_113":156},12,["D",1739827817721],"61f86e8c-ed76-11ef-8abb-e6cdfca9ef9f",{"_118":158,"_143":-5,"_116":159,"_113":160},11,["D",1739827748980],"38fed106-ed76-11ef-8a84-e6cdfca9ef9f",{"_118":162,"_143":-5,"_116":163,"_113":164},10,["D",1739827096776],"b440422a-ed74-11ef-b795-e6cdfca9ef9f",{"_118":166,"_143":-5,"_116":167,"_113":168},9,["D",1739826788862],"fcb9626c-ed73-11ef-9dbd-e6cdfca9ef9f",{"_118":170,"_143":-5,"_116":171,"_113":172},8,["D",1739825817772],"b9ecf4e6-ed71-11ef-9a89-e6cdfca9ef9f",{"_118":174,"_143":-5,"_116":175,"_113":176},7,["D",1739825118192],"18ec67bc-ed70-11ef-9177-e6cdfca9ef9f",{"_118":178,"_143":-5,"_116":179,"_113":180},6,["D",1739824783412],"51611d00-ed6f-11ef-ba59-e6cdfca9ef9f",{"_118":182,"_143":-5,"_116":183,"_113":184},5,["D",1739824454489],"8d54d5e6-ed6e-11ef-886f-e6cdfca9ef9f",{"_118":186,"_143":-5,"_116":187,"_113":188},4,["D",1739822688559],"70c57312-ed6a-11ef-8cf8-e6cdfca9ef9f",{"_118":190,"_143":-5,"_116":191,"_113":192},3,["D",1739822562594],"25ac0594-ed6a-11ef-958f-e6cdfca9ef9f",{"_118":90,"_143":-5,"_116":194,"_113":195},["D",1739822491283],"fb2df2a0-ed69-11ef-bf47-e6cdfca9ef9f",{"_118":125,"_143":-5,"_116":197,"_113":198},["D",1739822397158],"c30fc088-ed69-11ef-8828-e6cdfca9ef9f",{"_118":31,"_143":-5,"_116":200,"_113":201},["D",1739822107149],"16351fd4-ed69-11ef-9c26-e6cdfca9ef9f","recentThread","breadcrumbs","comments",[],"isOwner","routes/_app.v.$handle.$name.dependencies",{"_209":210,"_267":125,"_268":137,"_269":31,"_94":270},"dependenciesList",[211],{"_100":212,"_213":214},"08f95904-3584-11ef-8995-0e10024e3b32","initialData",{"_98":215,"_95":216,"_100":212,"_102":217,"_104":-5,"_105":106,"_107":218,"_108":219,"_110":220,"_112":26,"_113":220,"_114":221,"_116":222,"_118":150,"_120":26,"_121":162,"_123":223,"_124":125,"_126":125,"_122":224,"_127":31,"_128":-5,"_20":225,"_134":228,"_135":-7,"_138":232,"_233":-5,"_136":234,"_140":235},"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 {\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 {\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,\n columns: Array,\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 | Record;\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],13491,21,{"_130":226,"_132":227},"stevekrouse","https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg",{"_113":229,"_130":230,"_98":215,"_118":178,"_231":-5},"56c849ee-f1f8-11ee-9b87-cab58f78796a","std","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",[236,240,243,246,249,252,255,258,261,264],{"_116":237,"_118":150,"_238":239},["D",1737987404484],"n","1",{"_116":241,"_118":154,"_238":242},["D",1724087412304],"2",{"_116":244,"_118":158,"_238":245},["D",1724087404512],"3",{"_116":247,"_118":162,"_238":248},["D",1723494410142],"4",{"_116":250,"_118":166,"_238":251},["D",1723494389876],"5",{"_116":253,"_118":170,"_238":254},["D",1723494345363],"6",{"_116":256,"_118":174,"_238":257},["D",1723494323065],"7",{"_116":259,"_118":178,"_238":260},["D",1719604370206],"8",{"_116":262,"_118":182,"_238":263},["D",1719604260994],"9",{"_116":265,"_118":186,"_238":266},["D",1719604144103],"10","dependenciesCount","valname","page",{"_113":111,"_98":99,"_130":131,"_11":96,"_118":119,"_100":101,"_114":115,"_105":106,"_112":26,"_136":137},"routes/_app","actionData","errors"]