[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_285":286,"_287":288},"routes/_app.x.$handle.$name",{"_100":99,"_32":45,"_108":90,"_27":102,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":-5,"_120":-5,"_121":25,"_122":123,"_124":59,"_125":-5,"_126":-5,"_127":128},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",50,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","db.ts","latestPath","fileId","b921ae02-b2b5-11f1-8aa5-1607ee4eb77e","name","fileType","script","content","/**\n * Data layer for DevFreeStack.\n *\n * Tools live in the val's project-scoped SQLite database. `cats` is stored as a\n * comma-separated string rather than a join table — at directory scale (tens to\n * low hundreds of rows) a join adds ceremony without buying anything, and\n * filtering happens client-side anyway.\n */\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { SEED_TOOLS } from \"./seed-data.ts\";\n\nexport const CATEGORY_IDS = [\"dns\", \"comms\", \"ai\", \"edge\", \"paas\", \"db\"] as const;\nexport const TIERS = [\"Forever Free\", \"Free Tier\", \"Open Source\"] as const;\n\nexport type CategoryId = (typeof CATEGORY_IDS)[number];\n\nexport type ToolInput = {\n name: string;\n cats: string[];\n tier: string;\n icon: string;\n url: string;\n desc: string;\n code?: { label: string; value: string } | null;\n};\n\nexport type Tool = ToolInput & { id: number; sortOrder: number };\n\n/** Thrown for bad input so the HTTP layer can return 400 with a useful message. */\nexport class ValidationError extends Error {}\n\n/* ------------------------------------------------------------------ */\n/* Schema */\n/* ------------------------------------------------------------------ */\n\nlet ready: Promise | null = null;\n\n/** Idempotent schema setup + first-run seeding. Safe to call per request. */\nexport function initDb(): Promise {\n if (!ready) ready = migrate().catch((err) => { ready = null; throw err; });\n return ready;\n}\n\nasync function migrate() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS tools (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n cats TEXT NOT NULL DEFAULT '',\n tier TEXT NOT NULL DEFAULT 'Free Tier',\n icon TEXT NOT NULL DEFAULT 'wrench',\n url TEXT NOT NULL DEFAULT '',\n description TEXT NOT NULL DEFAULT '',\n code_label TEXT,\n code_value TEXT,\n sort_order INTEGER NOT NULL DEFAULT 0,\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n updated_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`);\n\n // Case-insensitive uniqueness on name, so \"Neon\" and \"neon\" can't both exist.\n // Uses COLLATE NOCASE rather than an expression index on lower(name) — the\n // latter is rejected by the backing database with a 500.\n await sqlite.execute(\n `CREATE UNIQUE INDEX IF NOT EXISTS tools_name_unique ON tools (name COLLATE NOCASE)`,\n );\n\n const { rows } = await sqlite.execute(\"SELECT COUNT(*) AS n FROM tools\");\n if (Number(rows[0]?.n ?? 0) === 0) await seed();\n}\n\nasync function seed() {\n await sqlite.batch(\n SEED_TOOLS.map((t, i) => ({\n sql: `INSERT INTO tools (name, cats, tier, icon, url, description, code_label, code_value, sort_order)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n t.name,\n t.cats.join(\",\"),\n t.tier,\n t.icon,\n t.url,\n t.desc,\n t.code?.label ?? null,\n t.code?.value ?? null,\n i,\n ],\n })),\n );\n}\n\n/** Wipe and re-seed from seed-data.ts. Destructive — for development. */\nexport async function resetSeed(): Promise {\n await initDb();\n await sqlite.execute(\"DELETE FROM tools\");\n await sqlite.execute(\"DELETE FROM sqlite_sequence WHERE name = 'tools'\");\n await seed();\n return SEED_TOOLS.length;\n}\n\n/* ------------------------------------------------------------------ */\n/* Row mapping */\n/* ------------------------------------------------------------------ */\n\ntype Row = Record;\n\nfunction toTool(row: Row): Tool {\n const label = row.code_label == null ? \"\" : String(row.code_label);\n const value = row.code_value == null ? \"\" : String(row.code_value);\n return {\n id: Number(row.id),\n name: String(row.name),\n cats: String(row.cats).split(\",\").map((c) => c.trim()).filter(Boolean),\n tier: String(row.tier),\n icon: String(row.icon),\n url: String(row.url),\n desc: String(row.description),\n code: value ? { label: label || \"Code\", value } : null,\n sortOrder: Number(row.sort_order),\n };\n}\n\n/* ------------------------------------------------------------------ */\n/* Validation */\n/* ------------------------------------------------------------------ */\n\nfunction str(value: unknown, field: string, { max = 2000, required = true } = {}): string {\n const s = typeof value === \"string\" ? value.trim() : \"\";\n if (required && !s) throw new ValidationError(`${field} is required`);\n if (s.length > max) throw new ValidationError(`${field} must be ${max} characters or fewer`);\n return s;\n}\n\nexport function validate(input: unknown, partial = false): Partial {\n if (typeof input !== \"object\" || input === null) {\n throw new ValidationError(\"Expected a JSON object\");\n }\n const body = input as Record;\n const out: Partial = {};\n\n if (!partial || \"name\" in body) out.name = str(body.name, \"Name\", { max: 80 });\n if (!partial || \"desc\" in body) out.desc = str(body.desc, \"Description\", { max: 400 });\n\n if (!partial || \"url\" in body) {\n const url = str(body.url, \"URL\", { max: 500 });\n let parsed: URL;\n try {\n parsed = new URL(url);\n } catch {\n throw new ValidationError(\"URL must be a valid absolute URL, e.g. https://example.com\");\n }\n if (parsed.protocol !== \"http:\" && parsed.protocol !== \"https:\") {\n throw new ValidationError(\"URL must start with http:// or https://\");\n }\n out.url = url;\n }\n\n if (!partial || \"tier\" in body) {\n const tier = str(body.tier, \"Tier\", { max: 40 });\n if (!(TIERS as readonly string[]).includes(tier)) {\n throw new ValidationError(`Tier must be one of: ${TIERS.join(\", \")}`);\n }\n out.tier = tier;\n }\n\n if (!partial || \"cats\" in body) {\n const raw = body.cats;\n const cats = Array.isArray(raw)\n ? raw.map((c) => String(c).trim()).filter(Boolean)\n : String(raw ?? \"\").split(\",\").map((c) => c.trim()).filter(Boolean);\n if (cats.length === 0) throw new ValidationError(\"Pick at least one category\");\n const bad = cats.filter((c) => !(CATEGORY_IDS as readonly string[]).includes(c));\n if (bad.length) throw new ValidationError(`Unknown category: ${bad.join(\", \")}`);\n out.cats = [...new Set(cats)];\n }\n\n if (!partial || \"icon\" in body) {\n const icon = str(body.icon, \"Icon\", { required: false, max: 60 });\n out.icon = icon || \"wrench\";\n }\n\n if (!partial || \"code\" in body) {\n const raw = body.code;\n if (raw == null || raw === \"\") {\n out.code = null;\n } else if (typeof raw === \"object\") {\n const c = raw as Record;\n const value = str(c.value, \"Code value\", { required: false, max: 120 });\n out.code = value ? { label: str(c.label, \"Code label\", { required: false, max: 40 }) || \"Code\", value } : null;\n } else {\n out.code = { label: \"Code\", value: str(raw, \"Code value\", { max: 120 }) };\n }\n }\n\n return out;\n}\n\n/* ------------------------------------------------------------------ */\n/* CRUD */\n/* ------------------------------------------------------------------ */\n\nexport async function listTools(): Promise {\n await initDb();\n const { rows } = await sqlite.execute(\n \"SELECT * FROM tools ORDER BY sort_order ASC, lower(name) ASC\",\n );\n return rows.map(toTool);\n}\n\nexport async function getTool(id: number): Promise {\n await initDb();\n const { rows } = await sqlite.execute({ sql: \"SELECT * FROM tools WHERE id = ?\", args: [id] });\n return rows.length ? toTool(rows[0]) : null;\n}\n\nexport async function countTools(): Promise {\n await initDb();\n const { rows } = await sqlite.execute(\"SELECT COUNT(*) AS n FROM tools\");\n return Number(rows[0]?.n ?? 0);\n}\n\nexport async function createTool(input: ToolInput): Promise {\n await initDb();\n const { rows } = await sqlite.execute(\n \"SELECT COALESCE(MAX(sort_order), -1) AS max FROM tools\",\n );\n const nextOrder = Number(rows[0]?.max ?? -1) + 1;\n\n const result = await sqlite.execute({\n sql: `INSERT INTO tools (name, cats, tier, icon, url, description, code_label, code_value, sort_order)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n input.name,\n input.cats.join(\",\"),\n input.tier,\n input.icon,\n input.url,\n input.desc,\n input.code?.label ?? null,\n input.code?.value ?? null,\n nextOrder,\n ],\n });\n\n return (await getTool(Number(result.lastInsertRowid)))!;\n}\n\nexport async function updateTool(id: number, input: ToolInput): Promise {\n await initDb();\n const existing = await getTool(id);\n if (!existing) return null;\n\n await sqlite.execute({\n sql: `UPDATE tools SET name = ?, cats = ?, tier = ?, icon = ?, url = ?, description = ?,\n code_label = ?, code_value = ?, updated_at = datetime('now')\n WHERE id = ?`,\n args: [\n input.name,\n input.cats.join(\",\"),\n input.tier,\n input.icon,\n input.url,\n input.desc,\n input.code?.label ?? null,\n input.code?.value ?? null,\n id,\n ],\n });\n\n return getTool(id);\n}\n\nexport async function deleteTool(id: number): Promise {\n await initDb();\n const existing = await getTool(id);\n if (!existing) return false;\n await sqlite.execute({ sql: \"DELETE FROM tools WHERE id = ?\", args: [id] });\n return true;\n}\n\n/** Translate a SQLite unique-constraint failure into a friendly message. */\nexport function isDuplicateNameError(err: unknown): boolean {\n return err instanceof Error && /UNIQUE constraint failed/i.test(err.message);\n}","/**\n * Data layer for DevFreeStack.\n *\n * Tools live in the val's project-scoped SQLite database. `cats` is stored as a\n * comma-separated string rather than a join table — at directory scale (tens to\n * low hundreds of rows) a join adds ceremony without buying anything, and\n * filtering happens client-side anyway.\n */\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { SEED_TOOLS } from \"./seed-data.ts\";\n\nexport const CATEGORY_IDS = [\"dns\", \"comms\", \"ai\", \"edge\", \"paas\", \"db\"] as const;\nexport const TIERS = [\"Forever Free\", \"Free Tier\", \"Open Source\"] as const;\n\nexport type CategoryId = (typeof CATEGORY_IDS)[number];\n\nexport type ToolInput = {\n name: string;\n cats: string[];\n tier: string;\n icon: string;\n url: string;\n desc: string;\n code?: { label: string; value: string } | null;\n};\n\nexport type Tool = ToolInput & { id: number; sortOrder: number };\n\n/** Thrown for bad input so the HTTP layer can return 400 with a useful message. */\nexport class ValidationError extends Error {}\n\n/* ------------------------------------------------------------------ */\n/* Schema */\n/* ------------------------------------------------------------------ */\n\nlet ready: Promise | null = null;\n\n/** Idempotent schema setup + first-run seeding. Safe to call per request. */\nexport function initDb(): Promise {\n if (!ready) ready = migrate().catch((err) => { ready = null; throw err; });\n return ready;\n}\n\nasync function migrate() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS tools (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n cats TEXT NOT NULL DEFAULT '',\n tier TEXT NOT NULL DEFAULT 'Free Tier',\n icon TEXT NOT NULL DEFAULT 'wrench',\n url TEXT NOT NULL DEFAULT '',\n description TEXT NOT NULL DEFAULT '',\n code_label TEXT,\n code_value TEXT,\n sort_order INTEGER NOT NULL DEFAULT 0,\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n updated_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`);\n\n // Case-insensitive uniqueness on name, so \"Neon\" and \"neon\" can't both exist.\n // Uses COLLATE NOCASE rather than an expression index on lower(name) — the\n // latter is rejected by the backing database with a 500.\n await sqlite.execute(\n `CREATE UNIQUE INDEX IF NOT EXISTS tools_name_unique ON tools (name COLLATE NOCASE)`,\n );\n\n const { rows } = await sqlite.execute(\"SELECT COUNT(*) AS n FROM tools\");\n if (Number(rows[0]?.n ?? 0) === 0) await seed();\n}\n\nasync function seed() {\n await sqlite.batch(\n SEED_TOOLS.map((t, i) => ({\n sql: `INSERT INTO tools (name, cats, tier, icon, url, description, code_label, code_value, sort_order)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n t.name,\n t.cats.join(\",\"),\n t.tier,\n t.icon,\n t.url,\n t.desc,\n t.code?.label ?? null,\n t.code?.value ?? null,\n i,\n ],\n })),\n );\n}\n\n/** Wipe and re-seed from seed-data.ts. Destructive — for development. */\nexport async function resetSeed(): Promise {\n await initDb();\n await sqlite.execute(\"DELETE FROM tools\");\n await sqlite.execute(\"DELETE FROM sqlite_sequence WHERE name = 'tools'\");\n await seed();\n return SEED_TOOLS.length;\n}\n\n/* ------------------------------------------------------------------ */\n/* Row mapping */\n/* ------------------------------------------------------------------ */\n\ntype Row = Record;\n\nfunction toTool(row: Row): Tool {\n const label = row.code_label == null ? \"\" : String(row.code_label);\n const value = row.code_value == null ? \"\" : String(row.code_value);\n return {\n id: Number(row.id),\n name: String(row.name),\n cats: String(row.cats).split(\",\").map((c) => c.trim()).filter(Boolean),\n tier: String(row.tier),\n icon: String(row.icon),\n url: String(row.url),\n desc: String(row.description),\n code: value ? { label: label || \"Code\", value } : null,\n sortOrder: Number(row.sort_order),\n };\n}\n\n/* ------------------------------------------------------------------ */\n/* Validation */\n/* ------------------------------------------------------------------ */\n\nfunction str(value: unknown, field: string, { max = 2000, required = true } = {}): string {\n const s = typeof value === \"string\" ? value.trim() : \"\";\n if (required && !s) throw new ValidationError(`${field} is required`);\n if (s.length > max) throw new ValidationError(`${field} must be ${max} characters or fewer`);\n return s;\n}\n\nexport function validate(input: unknown, partial = false): Partial {\n if (typeof input !== \"object\" || input === null) {\n throw new ValidationError(\"Expected a JSON object\");\n }\n const body = input as Record;\n const out: Partial = {};\n\n if (!partial || \"name\" in body) out.name = str(body.name, \"Name\", { max: 80 });\n if (!partial || \"desc\" in body) out.desc = str(body.desc, \"Description\", { max: 400 });\n\n if (!partial || \"url\" in body) {\n const url = str(body.url, \"URL\", { max: 500 });\n let parsed: URL;\n try {\n parsed = new URL(url);\n } catch {\n throw new ValidationError(\"URL must be a valid absolute URL, e.g. https://example.com\");\n }\n if (parsed.protocol !== \"http:\" && parsed.protocol !== \"https:\") {\n throw new ValidationError(\"URL must start with http:// or https://\");\n }\n out.url = url;\n }\n\n if (!partial || \"tier\" in body) {\n const tier = str(body.tier, \"Tier\", { max: 40 });\n if (!(TIERS as readonly string[]).includes(tier)) {\n throw new ValidationError(`Tier must be one of: ${TIERS.join(\", \")}`);\n }\n out.tier = tier;\n }\n\n if (!partial || \"cats\" in body) {\n const raw = body.cats;\n const cats = Array.isArray(raw)\n ? raw.map((c) => String(c).trim()).filter(Boolean)\n : String(raw ?? \"\").split(\",\").map((c) => c.trim()).filter(Boolean);\n if (cats.length === 0) throw new ValidationError(\"Pick at least one category\");\n const bad = cats.filter((c) => !(CATEGORY_IDS as readonly string[]).includes(c));\n if (bad.length) throw new ValidationError(`Unknown category: ${bad.join(\", \")}`);\n out.cats = [...new Set(cats)];\n }\n\n if (!partial || \"icon\" in body) {\n const icon = str(body.icon, \"Icon\", { required: false, max: 60 });\n out.icon = icon || \"wrench\";\n }\n\n if (!partial || \"code\" in body) {\n const raw = body.code;\n if (raw == null || raw === \"\") {\n out.code = null;\n } else if (typeof raw === \"object\") {\n const c = raw as Record;\n const value = str(c.value, \"Code value\", { required: false, max: 120 });\n out.code = value ? { label: str(c.label, \"Code label\", { required: false, max: 40 }) || \"Code\", value } : null;\n } else {\n out.code = { label: \"Code\", value: str(raw, \"Code value\", { max: 120 }) };\n }\n }\n\n return out;\n}\n\n/* ------------------------------------------------------------------ */\n/* CRUD */\n/* ------------------------------------------------------------------ */\n\nexport async function listTools(): Promise {\n await initDb();\n const { rows } = await sqlite.execute(\n \"SELECT * FROM tools ORDER BY sort_order ASC, lower(name) ASC\",\n );\n return rows.map(toTool);\n}\n\nexport async function getTool(id: number): Promise {\n await initDb();\n const { rows } = await sqlite.execute({ sql: \"SELECT * FROM tools WHERE id = ?\", args: [id] });\n return rows.length ? toTool(rows[0]) : null;\n}\n\nexport async function countTools(): Promise {\n await initDb();\n const { rows } = await sqlite.execute(\"SELECT COUNT(*) AS n FROM tools\");\n return Number(rows[0]?.n ?? 0);\n}\n\nexport async function createTool(input: ToolInput): Promise {\n await initDb();\n const { rows } = await sqlite.execute(\n \"SELECT COALESCE(MAX(sort_order), -1) AS max FROM tools\",\n );\n const nextOrder = Number(rows[0]?.max ?? -1) + 1;\n\n const result = await sqlite.execute({\n sql: `INSERT INTO tools (name, cats, tier, icon, url, description, code_label, code_value, sort_order)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n input.name,\n input.cats.join(\",\"),\n input.tier,\n input.icon,\n input.url,\n input.desc,\n input.code?.label ?? null,\n input.code?.value ?? null,\n nextOrder,\n ],\n });\n\n return (await getTool(Number(result.lastInsertRowid)))!;\n}\n\nexport async function updateTool(\n id: number,\n input: Partial,\n): Promise {\n await initDb();\n const existing = await getTool(id);\n if (!existing) return null;\n\n const fields: string[] = [];\n const args: unknown[] = [];\n\n if (\"name\" in input) {\n fields.push(\"name = ?\");\n args.push(input.name);\n }\n if (\"cats\" in input) {\n fields.push(\"cats = ?\");\n args.push(input.cats!.join(\",\"));\n }\n if (\"tier\" in input) {\n fields.push(\"tier = ?\");\n args.push(input.tier);\n }\n if (\"icon\" in input) {\n fields.push(\"icon = ?\");\n args.push(input.icon);\n }\n if (\"url\" in input) {\n fields.push(\"url = ?\");\n args.push(input.url);\n }\n if (\"desc\" in input) {\n fields.push(\"description = ?\");\n args.push(input.desc);\n }\n if (\"code\" in input) {\n fields.push(\"code_label = ?\", \"code_value = ?\");\n args.push(input.code?.label ?? null, input.code?.value ?? null);\n }\n\n if (fields.length === 0) return existing;\n\n fields.push(\"updated_at = datetime('now')\");\n args.push(id);\n\n await sqlite.execute({\n sql: `UPDATE tools SET ${fields.join(\", \")} WHERE id = ?`,\n args,\n });\n\n return getTool(id);\n}\n\nexport async function deleteTool(id: number): Promise {\n await initDb();\n const existing = await getTool(id);\n if (!existing) return false;\n await sqlite.execute({ sql: \"DELETE FROM tools WHERE id = ?\", args: [id] });\n return true;\n}\n\n/** Translate a SQLite unique-constraint failure into a friendly message. */\nexport function isDuplicateNameError(err: unknown): boolean {\n return err instanceof Error && /UNIQUE constraint failed/i.test(err.message);\n}","createdAt",["D",1789702710923],"branchVersion","branchId","ea30dbbb-1b12-41c5-9f1c-897def008361","id","2a3ea833-fed5-417f-8f38-b60994e76da7","devfreestack",["D",1789660937610],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Curated directory of 100% free developer tools, hosting & APIs","imageUrl","e427e1a1-b1b6-4734-a208-0d1bf9916df4","pinnedFileId","01a0b01a-bdc2-7765-aabb-2fa134886260","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a0b016-4426-714c-b79a-b63740ab43bd","tursoName","2a3ea833fed5417f8f38b60994e76da7","tursoHostname","2a3ea833fed5417f8f38b60994e76da7-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789664470421],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_100":99,"_107":102},"org",{"_100":99,"_101":102,"_103":102,"_18":55,"_104":105,"_106":25},"branch",{"_13":89,"_32":90,"_43":42,"_91":44,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":45,"_98":99},"isOwned",73,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","vijevira","handle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":280,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":281,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":282,"_84":283,"_86":284,"_88":25},"tree",[224,227,228,229,230,231,232,233,234,235],"files",[224,225,226,227,228,229,230,231,232,233,234,235],"counts",{"_213":63,"_214":177,"_215":63,"_216":217,"_218":219},"contents",[129,130,131,132,133,134,135,136,137,138],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":206,"_32":207,"_30":208,"_142":-5,"_41":42,"_40":209,"_144":59,"_38":210,"_13":63,"_33":211,"_35":-5,"_24":25,"_147":-5,"_27":212},{"_43":199,"_32":200,"_30":201,"_142":-5,"_41":42,"_40":202,"_144":59,"_38":203,"_13":63,"_33":20,"_35":204,"_24":25,"_147":-5,"_27":205},{"_43":192,"_32":193,"_30":194,"_142":-5,"_41":42,"_40":195,"_144":25,"_38":196,"_13":154,"_33":20,"_35":197,"_24":25,"_147":-5,"_27":198},{"_43":184,"_32":185,"_30":186,"_142":-5,"_41":42,"_40":187,"_144":25,"_38":188,"_13":189,"_33":20,"_35":190,"_24":25,"_147":-5,"_27":191},{"_43":180,"_32":28,"_30":31,"_142":-5,"_41":42,"_40":14,"_144":59,"_38":181,"_13":182,"_33":34,"_35":37,"_24":25,"_147":-5,"_27":183},{"_43":173,"_32":174,"_30":175,"_142":-5,"_41":42,"_40":154,"_144":59,"_38":176,"_13":177,"_33":20,"_35":178,"_24":25,"_147":-5,"_27":179},{"_43":165,"_32":166,"_30":167,"_142":-5,"_41":42,"_40":168,"_144":25,"_38":169,"_13":170,"_33":20,"_35":171,"_24":25,"_147":-5,"_27":172},{"_43":157,"_32":158,"_30":57,"_142":-5,"_41":42,"_40":159,"_144":25,"_38":160,"_13":161,"_33":162,"_35":163,"_24":25,"_147":45,"_27":164},{"_43":149,"_32":150,"_30":151,"_142":-5,"_41":42,"_40":152,"_144":25,"_38":153,"_13":154,"_33":34,"_35":155,"_24":25,"_147":-5,"_27":156},{"_43":139,"_32":140,"_30":141,"_142":-5,"_41":42,"_40":143,"_144":59,"_38":145,"_13":63,"_33":34,"_35":146,"_24":25,"_147":-5,"_27":148},"ec77bdc2-89ac-4691-9a6f-288a365d90ea","seed-data.ts","aba3d41c-b2b5-11f1-b09e-1607ee4eb77e","parentId",14,"latest",["D",1789662876352],"/**\n * Initial directory contents.\n *\n * Used only to populate an empty `tools` table — once seeded, edits happen\n * through the admin UI at /admin.html. Changing this file will NOT overwrite\n * an already-seeded database; use the admin UI or `resetSeed()` in db.ts.\n *\n * `cats` accepts one or more of: dns, comms, ai, edge, paas, db\n */\nexport type SeedTool = {\n name: string;\n cats: string[];\n tier: string;\n icon: string;\n url: string;\n desc: string;\n code?: { label: string; value: string };\n};\n\nexport const SEED_TOOLS: SeedTool[] = [\n /* ---------------- DNS & Domain ---------------- */\n {\n name: \"Cloudflare\",\n cats: [\"dns\"],\n tier: \"Forever Free\",\n icon: \"cloud\",\n url: \"https://www.cloudflare.com/\",\n desc:\n \"Free DNS, SSL, CDN and email routing for unlimited domains — the default starting point for almost every side project.\",\n },\n {\n name: \"DNSHE\",\n cats: [\"dns\"],\n tier: \"Forever Free\",\n icon: \"network\",\n url: \"https://dnshe.com/\",\n desc:\n \"Free subdomains and dynamic DNS, handy for homelabs, dev environments and hardware that needs a stable hostname. Use the invite code for one extra domain registration slot.\",\n code: { label: \"Invite code\", value: \"ESB9EDBVDE\" },\n },\n\n /* ---------------- Communication & Email ---------------- */\n {\n name: \"Infomaniak\",\n cats: [\"comms\"],\n tier: \"Free Tier\",\n icon: \"mail\",\n url: \"https://www.infomaniak.com/en/hosting/free-email-address\",\n desc:\n \"Free tier with one custom-domain mailbox, plus webmail and IMAP/SMTP access with solid Swiss privacy credentials.\",\n },\n {\n name: \"Cloudflare Email Routing\",\n cats: [\"comms\"],\n tier: \"Forever Free\",\n icon: \"forward\",\n url: \"https://developers.cloudflare.com/email-routing/\",\n desc:\n \"Unlimited email forwarding on your own domain — create catch-all and per-address rules, forward anywhere.\",\n },\n {\n name: \"Zoho Mail\",\n cats: [\"comms\"],\n tier: \"Forever Free\",\n icon: \"inbox\",\n url: \"https://www.zoho.com/mail/\",\n desc:\n \"Forever Free plan: custom-domain mailboxes with webmail, IMAP/POP and mobile apps. No ads, no mailbox expiry.\",\n },\n {\n name: \"Resend\",\n cats: [\"comms\"],\n tier: \"Free Tier\",\n icon: \"send\",\n url: \"https://resend.com/\",\n desc:\n \"Transactional email API built for developers — clean SDKs, React Email templates and a generous monthly free allowance.\",\n },\n {\n name: \"Mailgun\",\n cats: [\"comms\"],\n tier: \"Free Tier\",\n icon: \"send-horizontal\",\n url: \"https://www.mailgun.com/\",\n desc:\n \"Developer free tier for transactional sending with REST APIs, SMTP, webhooks and detailed delivery logs.\",\n },\n {\n name: \"Maileroo\",\n cats: [\"comms\"],\n tier: \"Free Tier\",\n icon: \"mail-check\",\n url: \"https://maileroo.com/?r=endra\",\n desc:\n \"Developer-focused free email sending tier with SMTP and REST API access, templates and analytics.\",\n },\n\n /* ---------------- AI & Coding Assistants ---------------- */\n {\n name: \"Blackbox\",\n cats: [\"ai\"],\n tier: \"Free Tier\",\n icon: \"terminal\",\n url: \"https://www.blackbox.ai/\",\n desc:\n \"AI coding assistant available as a browser extension and IDE plugin — autocomplete, chat and code generation.\",\n },\n {\n name: \"Cursor\",\n cats: [\"ai\"],\n tier: \"Free Tier\",\n icon: \"mouse-pointer\",\n url: \"https://cursor.com/\",\n desc:\n \"AI-first code editor forked from VS Code with tab completion, inline edits and codebase-aware chat.\",\n },\n {\n name: \"Codeium\",\n cats: [\"ai\"],\n tier: \"Free Tier\",\n icon: \"sparkles\",\n url: \"https://codeium.com/\",\n desc:\n \"Free unlimited AI code completion and in-editor chat across 70+ languages and most popular IDEs.\",\n },\n\n /* ---------------- Frontend Hosting & Edge ---------------- */\n {\n name: \"Cloudflare Workers\",\n cats: [\"edge\"],\n tier: \"Free Tier\",\n icon: \"cpu\",\n url: \"https://workers.cloudflare.com/\",\n desc:\n \"Serverless functions running on 300+ edge locations, with KV, R2, D1 and Durable Objects bindings included.\",\n },\n {\n name: \"Vercel\",\n cats: [\"edge\"],\n tier: \"Free Tier\",\n icon: \"triangle\",\n url: \"https://vercel.com/\",\n desc:\n \"Frontend and Jamstack hosting with Git-based deploys, instant preview URLs and a global edge CDN.\",\n },\n {\n name: \"Netlify\",\n cats: [\"edge\"],\n tier: \"Free Tier\",\n icon: \"globe\",\n url: \"https://www.netlify.com/\",\n desc:\n \"Frontend hosting, serverless functions, form handling and CI straight from your repository.\",\n },\n {\n name: \"Zoho Catalyst\",\n cats: [\"edge\"],\n tier: \"Free Tier\",\n icon: \"layers\",\n url: \"https://catalyst.zoho.com/\",\n desc:\n \"Serverless frontend and backend platform — host static apps and run functions, with auth and a data store included.\",\n },\n {\n name: \"Wasmer.io\",\n cats: [\"edge\", \"paas\"],\n tier: \"Free Tier\",\n icon: \"package\",\n url: \"https://wasmer.io/\",\n desc:\n \"WebAssembly hosting and edge deployment — run Wasm packages close to users, or as a backend runtime.\",\n },\n\n /* ---------------- Backend Service & PaaS ---------------- */\n {\n name: \"Render\",\n cats: [\"paas\"],\n tier: \"Free Tier\",\n icon: \"server\",\n url: \"https://render.com/\",\n desc:\n \"Deploy web services, static sites, cron jobs and background workers from Git with no config files required.\",\n },\n {\n name: \"Railway\",\n cats: [\"paas\"],\n tier: \"Free Tier\",\n icon: \"git-branch\",\n url: \"https://railway.com?referralCode=oHqhM6\",\n desc:\n \"PaaS that turns any repo into a running service in seconds, with a developer free tier to get you started.\",\n },\n {\n name: \"Fly.io\",\n cats: [\"paas\"],\n tier: \"Free Tier\",\n icon: \"plane\",\n url: \"https://fly.io/\",\n desc:\n \"Run full-stack apps and Docker containers in regions close to your users, with a free allowance for small VMs.\",\n },\n {\n name: \"Faable\",\n cats: [\"paas\"],\n tier: \"Free Tier\",\n icon: \"cloud-cog\",\n url: \"https://faable.com/\",\n desc:\n \"Cloud hosting free tier aimed at Node and JavaScript apps — push your code and get a URL with zero config.\",\n },\n\n /* ---------------- Databases & Caching ---------------- */\n {\n name: \"Supabase\",\n cats: [\"db\"],\n tier: \"Free Tier\",\n icon: \"database\",\n url: \"https://supabase.com/\",\n desc:\n \"Free PostgreSQL database with auth, row-level security, file storage, realtime subscriptions and an instant API.\",\n },\n {\n name: \"Neon\",\n cats: [\"db\"],\n tier: \"Free Tier\",\n icon: \"zap\",\n url: \"https://neon.tech/\",\n desc:\n \"Serverless Postgres with instant branching, scale-to-zero compute and a database-per-preview workflow.\",\n },\n {\n name: \"Aiven\",\n cats: [\"db\"],\n tier: \"Free Tier\",\n icon: \"hard-drive\",\n url: \"https://aiven.io/\",\n desc:\n \"Managed open-source databases with free plans — PostgreSQL, MySQL, Kafka, Redis and more on real cloud infra.\",\n },\n {\n name: \"Upstash\",\n cats: [\"db\"],\n tier: \"Free Tier\",\n icon: \"gauge\",\n url: \"https://upstash.com/\",\n desc:\n \"Serverless Redis and Kafka with per-request pricing — perfect for rate limiting, caching and queues at the edge.\",\n },\n {\n name: \"Redis.io\",\n cats: [\"db\"],\n tier: \"Free Tier\",\n icon: \"boxes\",\n url: \"https://redis.io/\",\n desc:\n \"Managed Redis Cloud free tier with persistence and monitoring — the classic cache and data-structure store.\",\n },\n {\n name: \"CloudAMQP\",\n cats: [\"db\"],\n tier: \"Free Tier\",\n icon: \"rabbit\",\n url: \"https://www.cloudamqp.com/\",\n desc:\n \"Managed RabbitMQ with a free plan — message queues, workers and pub/sub without running a broker yourself.\",\n },\n];","label",[140],"da2928af-25f4-44e9-8547-e81ec1ffa94d","publish-to-github.ts","82a933e2-b2b8-11f1-b89e-1607ee4eb77e",35,["D",1789665551418],5,"/**\n * Push this val's files to GitHub.\n *\n * Click Run. It walks every file in the val, compares each against the current\n * contents of the repo, and commits only what changed — so it's safe to re-run\n * whenever you edit the directory here and want the repo to catch up.\n *\n * Requires:\n * GITHUB_TOKEN — a token with write access to the repo.\n * Classic: `repo` scope. Fine-grained: \"Contents: Read and write\".\n *\n * Optional:\n * GITHUB_REPO — defaults to the value below.\n * GITHUB_BRANCH — defaults to the repo's default branch.\n */\nimport {\n listFiles,\n listFilesByPath,\n readFile,\n} from \"https://esm.town/v/std/utils/index.ts\";\n\nconst REPO = Deno.env.get(\"GITHUB_REPO\") ?? \"vijevira/devfreestack\";\nconst BRANCH = Deno.env.get(\"GITHUB_BRANCH\") ?? \"main\";\nconst TOKEN = Deno.env.get(\"GITHUB_TOKEN\") ?? \"\";\nconst COMMIT_PREFIX = \"Sync from Val Town\";\n\n/** Files that live here but shouldn't be published. */\nconst SKIP = new Set([\n \"publish-to-github.ts\", // this script itself — not part of the project\n]);\n\ntype Entry = {\n name: string;\n path: string;\n type: \"directory\" | \"file\" | \"interval\" | \"http\" | \"email\" | \"script\";\n};\n\n/* ------------------------------------------------------------------ */\n/* Val Town file access */\n/* ------------------------------------------------------------------ */\n\n/** Walk the val, descending into directories, and return relative file paths. */\nasync function collectFiles(): Promise {\n const found: string[] = [];\n\n async function walk(entries: Entry[], depth = 0) {\n if (depth > 5) return;\n for (const entry of entries) {\n if (entry.type === \"directory\") {\n try {\n await walk((await listFilesByPath(entry.path)) as Entry[], depth + 1);\n } catch {\n // Empty or unreadable directory — nothing to publish.\n }\n } else {\n found.push(entry.path.replace(/^\\//, \"\"));\n }\n }\n }\n\n await walk((await listFiles()) as Entry[]);\n return found.filter((p) => !SKIP.has(p)).sort();\n}\n\n/* ------------------------------------------------------------------ */\n/* base64 helpers (UTF-8 safe — these files contain em dashes, arrows) */\n/* ------------------------------------------------------------------ */\n\nfunction b64encode(text: string): string {\n const bytes = new TextEncoder().encode(text);\n let binary = \"\";\n for (const byte of bytes) binary += String.fromCharCode(byte);\n return btoa(binary);\n}\n\nfunction b64decode(b64: string): string {\n const binary = atob(b64.replace(/\\s/g, \"\"));\n const bytes = Uint8Array.from(binary, (c) => c.charCodeAt(0));\n return new TextDecoder().decode(bytes);\n}\n\n/* ------------------------------------------------------------------ */\n/* GitHub Contents API */\n/* ------------------------------------------------------------------ */\n\nconst API = \"https://api.github.com\";\n\nfunction ghHeaders(): HeadersInit {\n return {\n authorization: `Bearer ${TOKEN}`,\n accept: \"application/vnd.github+json\",\n \"x-github-api-version\": \"2022-11-28\",\n \"content-type\": \"application/json\",\n \"user-agent\": \"devfreestack-val-sync\",\n };\n}\n\ntype ExistingFile = { sha: string; content: string } | null;\n\nasync function getExisting(path: string): Promise {\n const url = `${API}/repos/${REPO}/contents/${path}${\n BRANCH ? `?ref=${BRANCH}` : \"\"\n }`;\n const res = await fetch(url, { headers: ghHeaders() });\n if (res.status === 404) return null;\n if (!res.ok) {\n throw new Error(`GET ${path} → ${res.status} ${await res.text()}`);\n }\n const data = await res.json();\n return { sha: data.sha, content: data.content ?? \"\" };\n}\n\nasync function putFile(\n path: string,\n text: string,\n sha: string | null,\n): Promise {\n const body: Record = {\n message: `${COMMIT_PREFIX}: ${path}`,\n content: b64encode(text),\n };\n if (sha) body.sha = sha;\n if (BRANCH) body.branch = BRANCH;\n\n const res = await fetch(`${API}/repos/${REPO}/contents/${path}`, {\n method: \"PUT\",\n headers: ghHeaders(),\n body: JSON.stringify(body),\n });\n\n if (!res.ok) {\n throw new Error(`PUT ${path} → ${res.status} ${await res.text()}`);\n }\n}\n\n/* ------------------------------------------------------------------ */\n/* Run */\n/* */\n/* Top-level rather than a default export: a script val's default */\n/* export is not invoked automatically when you click Run. */\n/* ------------------------------------------------------------------ */\n\nif (!TOKEN) {\n throw new Error(\n \"GITHUB_TOKEN is not set. Add it to this val's environment variables, then run again.\",\n );\n}\n\n// const paths = await collectFiles();\n// console.log(`Found ${paths.length} files in the val. Syncing to ${REPO}…\\n`);\n\nconst paths = Array.from(new Set(await collectFiles())).sort();\nconsole.log(\n `Found ${paths.length} unique files in the val. Syncing to ${REPO}…\\n`,\n);\n\nconst created: string[] = [];\nconst updated: string[] = [];\nconst unchanged: string[] = [];\nconst failed: string[] = [];\n\nfor (const path of paths) {\n try {\n const local = await readFile(path);\n const remote = await getExisting(path);\n\n if (remote && remote.content && b64decode(remote.content) === local) {\n unchanged.push(path);\n console.log(` = ${path}`);\n continue;\n }\n\n await putFile(path, local, remote?.sha ?? null);\n if (remote) {\n updated.push(path);\n console.log(` ~ ${path}`);\n } else {\n created.push(path);\n console.log(` + ${path}`);\n }\n } catch (err) {\n failed.push(path);\n console.error(` ! ${path} — ${err instanceof Error ? err.message : err}`);\n }\n}\n\nconsole.log(\n [\n \"\",\n \"──────────────────────────────\",\n `created ${created.length}`,\n `updated ${updated.length}`,\n `unchanged ${unchanged.length}`,\n `failed ${failed.length}`,\n \"\",\n `https://github.com/${REPO}`,\n ].join(\"\\n\"),\n);\n\nif (failed.length) {\n throw new Error(\n `Failed to sync ${failed.length} file(s): ${failed.join(\", \")}`,\n );\n}",[150],"d4841e12-fb60-49c9-ba3c-a75be1888ec9","main.tsx",49,["D",1789702702300],9,"http","/**\n * DevFreeStack server.\n *\n * `/api/*` is handled here; everything else falls through to the static file\n * server (index.html, admin.html, favicon.svg).\n *\n * Reads are public. Admin writes require a signed-in Val Town account whose\n * username matches ADMIN_VAL_USERNAME. Sessions are managed by Val Town OAuth.\n */\nimport { staticHTTPServer } from \"https://esm.town/v/std/utils/index.ts\";\nimport {\n getOAuthUserData,\n oauthMiddleware,\n} from \"https://esm.town/v/std/oauth/middleware.ts\";\nimport {\n CATEGORY_IDS,\n TIERS,\n ValidationError,\n countTools,\n createTool,\n deleteTool,\n isDuplicateNameError,\n listTools,\n updateTool,\n validate,\n} from \"./db.ts\";\n\nconst serveStatic = staticHTTPServer();\n\nconst json = (data: unknown, status = 200) =>\n Response.json(data, { status, headers: { \"cache-control\": \"no-store\" } });\n\nconst fail = (message: string, status: number) => json({ error: message }, status);\n\nasync function getAdminSession(req: Request) {\n const session = await getOAuthUserData(req);\n if (!session?.user) return null;\n\n const allowedUsername = Deno.env.get(\"ADMIN_VAL_USERNAME\")?.trim().toLowerCase();\n if (!allowedUsername) return null;\n\n const username = session.user.username?.trim().toLowerCase();\n if (!username || username !== allowedUsername) return null;\n\n return session;\n}\n\nasync function handler(req: Request): Promise {\n const { pathname } = new URL(req.url);\n\n if (pathname === \"/admin.html\") {\n const session = await getAdminSession(req);\n if (!session) {\n return new Response(null, {\n status: 302,\n headers: { Location: \"/auth/login?returnTo=/admin.html\" },\n });\n }\n }\n\n if (!pathname.startsWith(\"/api/\")) return serveStatic(req);\n\n try {\n /* ---------------- Reads (public) ---------------- */\n\n if (pathname === \"/api/status\" && req.method === \"GET\") {\n const admin = await getAdminSession(req);\n return json({\n authenticated: !!admin,\n writable: !!admin,\n configured: !!Deno.env.get(\"ADMIN_VAL_USERNAME\"),\n count: await countTools(),\n categories: CATEGORY_IDS,\n tiers: TIERS,\n });\n }\n\n if (pathname === \"/api/tools\" && req.method === \"GET\") {\n return json({ tools: await listTools() });\n }\n\n /* ---------------- Writes (Val Town account required) ---------------- */\n\n const admin = await getAdminSession(req);\n if (!admin) return fail(\"Admin authentication required. Open /admin.html and sign in with the authorized Val Town account.\", 401);\n\n if (pathname === \"/api/tools\" && req.method === \"POST\") {\n const body = await req.json().catch(() => null);\n if (body === null) return fail(\"Request body must be valid JSON.\", 400);\n const tool = await createTool(validate(body) as Parameters[0]);\n return json({ tool }, 201);\n }\n\n const match = pathname.match(/^\\/api\\/tools\\/(\\d+)$/);\n if (match) {\n const id = Number(match[1]);\n\n if (req.method === \"PATCH\") {\n const body = await req.json().catch(() => null);\n if (body === null) return fail(\"Request body must be valid JSON.\", 400);\n\n const patch = validate(body, true);\n if (Object.keys(patch).length === 0) {\n return fail(\"PATCH body must contain at least one editable field.\", 400);\n }\n\n const tool = await updateTool(id, patch);\n if (!tool) return fail(`No tool with id ${id}.`, 404);\n return json({ tool });\n }\n\n if (req.method === \"PUT\") {\n const body = await req.json().catch(() => null);\n if (body === null) return fail(\"Request body must be valid JSON.\", 400);\n\n const input = validate(body);\n const tool = await updateTool(id, input);\n if (!tool) return fail(`No tool with id ${id}.`, 404);\n return json({ tool });\n }\n\n if (req.method === \"DELETE\") {\n const ok = await deleteTool(id);\n if (!ok) return fail(`No tool with id ${id}.`, 404);\n return json({ deleted: id });\n }\n }\n\n return fail(`No API route for ${req.method} ${pathname}.`, 404);\n } catch (err) {\n if (err instanceof ValidationError) return fail(err.message, 400);\n if (isDuplicateNameError(err)) return fail(\"A tool with that name already exists.\", 409);\n\n console.error(\"Unhandled error:\", err);\n return fail(\"Something went wrong on the server.\", 500);\n }\n}\n\nexport default oauthMiddleware(handler);",[158],"da110ec1-06fa-4789-a184-e4bbf57f2b69","index.html","01a0b01a-bdc2-7765-aabb-29cc772fce45",27,["D",1789663895198],11,"\n\n\n\n\nDevFreeStack — 100% free developer tools, hosting, databases & APIs\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

\n\n \n

\n\n \n \n \n \n \n DevFreeStack\n \n \n\n

\n \n \n \n \n

\n esc\n /\n

\n\n

\n \n \n Suggest a tool\n \n

\n\n \n

\n \n \n \n \n \n $0 forever · no credit card\n \n\n

\n Ship for free.
\n Scale when you're ready.\n

\n\n

\n A curated collection of 100% free developer tools, hosting,\n databases, and APIs. Every entry below has a genuinely usable free tier — no trials that expire in 14 days.\n

\n\n

Tools: —
Categories: —
Cost: $0

\n\n \n

\n\n

\n 0 of 0 shown\n

\n\n

\n \n

Loading directory…

\n\n \n\n

\n \n \n \n

No tools match that

\n Try a broader term like postgres,\n email, or hosting.\n

\n \n\n \n

\n Know a tool we're missing?\n Suggest it →\n

\n\n

\n This directory loads its tools from an API, so it needs JavaScript enabled.\n

\n\n \n \n

\n\n\n\n\n

\n\n\n\n",[166],"cb5bf1f9-73cd-4b33-951b-72fa035f8a1a","favicon.svg","01a0b01a-bdc2-7765-aabb-24bdba58d843",["D",1789661122996],1,"",[174],"7cd19f4e-bd6a-476c-829e-f0332dd69597",["D",1789702710923],2,[28],"83bf9676-667d-4d05-9596-d3be545befdf","admin.html","f5fc0f66-b2b5-11f1-b09e-1607ee4eb77e",48,["D",1789701953042],6,"\n\n\n\n\nDevFreeStack — Admin\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

\n \n \n \n \n \n DevFreeStack\n \n \n \n Admin\n \n

\n —\n \n View site\n \n \n

\n\n

\n\n \n \n\n \n

Authenticated admin session

\n This dashboard uses your Val Town account session. The reusable admin key is no longer stored in the browser.\n

\n Val Town OAuth\n

\n\n

\n\n \n

Add a tool

\n \n

\n\n \n

Directory

\n \n \n

\n \n \n \n \n \n \n \n \n \n \n \n

Name	Categories	Tier	Code	Actions

No tools yet — add one on the left.

\n\n

\n\n\n\n",[185],"b937b263-fb3e-49b1-9095-1f02d6759f14","README.md","01a0b01a-bdc1-7547-bddc-df66332aec08",32,["D",1789664143855],"# DevFreeStack\n\nA curated directory of **100% free** developer tools, infrastructure, and services — hosting, databases, DNS, email APIs, and AI coding assistants.\n\n**No trials that expire in 14 days. No credit card required.**\n\n[Open the live site →](url:index.html) · [Admin →](url:admin.html)\n\n---\n\n## Architecture\n\nTools live in SQLite, not in the HTML. The page fetches them at runtime, so adding an entry is a form submission rather than a code change.\n\n```mermaid\nflowchart LR\n A[Browser] -->|GET /| B[main.tsx]\n A -->|GET /api/tools| B\n C[Admin UI] -->|POST/PUT/DELETE + X-Admin-Key| B\n B -->|static files| D[index.html / admin.html]\n B -->|reads & writes| E[(SQLite tools)]\n```\n\n| File | Role |\n| --- | --- |\n| [`main.tsx`](url:main.tsx) | Router — `/api/*` handled here, everything else served statically |\n| [`db.ts`](url:db.ts) | Schema, validation, CRUD |\n| [`seed-data.ts`](url:seed-data.ts) | Initial 26 tools (used only to seed an empty table) |\n| [`index.html`](url:index.html) | Public directory — fetches `/api/tools` |\n| [`admin.html`](url:admin.html) | Add / edit / delete tools |\n| `favicon.svg` | Site icon |\n\n## Editing tools\n\nThe admin UI is at **[`/admin.html`](url:admin.html)** (not linked from the public site, and marked `noindex`).\n\nWrites require an `ADMIN_KEY` environment variable. Reads are public; without the key configured the API rejects every create/update/delete with a `503`, and the admin page shows a setup banner. Enter the key once and the page stores it in `localStorage` for next time.\n\n👉 Add `ADMIN_KEY` here: https://www.val.town/x/vijevira/devfreestack/environment-variables?key=ADMIN_KEY\n\n### API\n\n| Method | Path | Auth | Purpose |\n| --- | --- | --- | --- |\n| `GET` | `/api/tools` | public | List all tools |\n| `GET` | `/api/status` | public | Write availability, count, category & tier vocabulary |\n| `POST` | `/api/tools` | `X-Admin-Key` | Create |\n| `PUT` | `/api/tools/:id` | `X-Admin-Key` | Update |\n| `DELETE` | `/api/tools/:id` | `X-Admin-Key` | Delete |\n\nValidation happens server-side (`validate()` in `db.ts`): name and description required, URL must be a valid absolute `http(s)` URL, tier must be one of the three known values, at least one category required. Names are unique case-insensitively. Failures return `400` with a human-readable message, `409` on a duplicate name.\n\n## Data model\n\n```sql\nCREATE TABLE tools (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n cats TEXT NOT NULL, -- comma-separated category ids\n tier TEXT NOT NULL,\n icon TEXT NOT NULL, -- Lucide icon name\n url TEXT NOT NULL,\n description TEXT NOT NULL,\n code_label TEXT, -- optional invite/referral code\n code_value TEXT,\n sort_order INTEGER NOT NULL,\n created_at TEXT NOT NULL,\n updated_at TEXT NOT NULL\n);\n```\n\n`cats` is a comma-separated string rather than a join table — at directory scale it saves ceremony, and filtering happens client-side anyway.\n\n**Categories:** `dns`, `comms`, `ai`, `edge`, `paas`, `db`. A tool may belong to several (Wasmer.io is both `edge` and `paas`), and it then appears under each of those pills.\n\n**Tiers:** `Forever Free` (green), `Free Tier` (blue), `Open Source` (violet).\n\n### Invite & referral codes\n\nThe optional `code` field renders a click-to-copy chip on the card, and its value is included in the search index — so pasting `ESB9EDBVDE` into the search bar finds DNSHE.\n\n## Public site features\n\n- **Live search** across name, description, tier, category labels, and code values\n- **Category pills** with live counts, plus a **Saved** filter backed by `localStorage`\n- **Bookmarks** — star any card; persists across reloads\n- **Click-to-copy** for both the tool URL and any invite code\n- Keyboard: `/` focuses search, `Esc` clears it\n- Loading, error-with-retry, and empty states\n\n## Seeding\n\n`db.ts` seeds from `seed-data.ts` on first run, only when the `tools` table is empty. Editing `seed-data.ts` afterwards has no effect on a populated database — use the admin UI, or call `resetSeed()` (destructive: wipes the table and re-inserts the original 26).\n\n## Publishing to GitHub\n\nThe repo at [github.com/vijevira/devfreestack](https://github.com/vijevira/devfreestack) is a\n**mirror, not the source of truth** — the val is.\n\n[`publish-to-github.ts`](url:publish-to-github.ts) syncs this val's files to the repo. Click Run: it\nwalks every file, compares each against what's on GitHub, and commits only what changed. Safe to\nre-run whenever you edit the directory here.\n\nRequires a `GITHUB_TOKEN` environment variable with write access to the repo — classic token with\n`repo` scope, or a fine-grained token with **Contents: Read and write**.\n\n👉 Add `GITHUB_TOKEN` here: https://www.val.town/x/vijevira/devfreestack/environment-variables?key=GITHUB_TOKEN\n\nOptional overrides: `GITHUB_REPO` (defaults to `vijevira/devfreestack`) and `GITHUB_BRANCH`\n(defaults to the repo's default branch).\n\nTwo things it deliberately does not do:\n\n- **It never publishes itself.** `publish-to-github.ts` is in the sync's skip list, so the repo\n contains only the project.\n- **It never deletes.** Removing a file here leaves it on GitHub — delete it there by hand.\n\n## Contributing\n\nSuggestions arrive as GitHub issues filed through\n[`.github/ISSUE_TEMPLATE/suggest-a-tool.yml`](.github/ISSUE_TEMPLATE/suggest-a-tool.yml).\nThe form's fields mirror the database schema (`name`, `url`, `cats[]`, `tier`, `description`, `code`),\nso accepting one is a copy-paste into the admin UI rather than a transcription job. Issues land\nlabelled `suggestion`.\n\nThree entry points on the site link to it:\n\n| Placement | Why |\n| --- | --- |\n| Header button | Always visible, one click from anywhere |\n| Empty state | Highest intent — they searched for something we don't have |\n| Footer | Conventional place to look |\n\nThere is no in-app form and no suggestion database. Moderation, spam handling, notifications and\nthreaded discussion are all GitHub's job, which is the whole reason for going this route.\n\n## Disclosure\n\nSome outbound links carry referral or invite parameters (`?r=`, `?referralCode=`, invite codes). They cost the visitor nothing and never change what a tool's free tier includes — the directory only ever lists tools that are genuinely free to use.\n\n## Notes\n\nFree tiers change constantly. Every vendor's current terms are the source of truth — this directory links out rather than mirroring pricing pages.\n\n---\n\nBuilt for developers who love free infrastructure.",[193],"a6665666-ab5d-4f89-b94a-117a0990fcae",".gitignore","9e13c4d6-b2b7-11f1-8356-1607ee4eb77e",23,["D",1789663712584],"# Secrets\n#\n# Environment variables (ADMIN_KEY and anything you add later) live in Val Town's\n# UI, not in a file — so there is normally nothing to leak here. This covers the\n# case where you create a local .env for testing.\n.env\n.env.*\n!.env.example\n\n# Editor / OS\n.DS_Store\n.idea/\n.vscode/\n\n# Logs\n*.log\nnpm-debug.log*",[200],"012442d2-20f0-4b1d-9697-56be190e76f2",".github","a9f2cc94-40eb-431b-9f35-47e07d559c12",22,["D",1789663698826],"directory",[207],"pulls","branches","forks","envVars",{"_220":222,"_223":63},"connections",{"_220":63,"_221":63},"count","unfilledCount",4,"emptyCount",{"_43":206,"_32":207,"_30":208,"_142":-5,"_41":42,"_40":209,"_144":59,"_38":277,"_13":63,"_33":211,"_35":-5,"_24":25,"_147":-5,"_237":278,"_27":279},{"_43":273,"_32":272,"_30":267,"_142":208,"_41":42,"_40":209,"_144":59,"_38":274,"_13":63,"_33":211,"_35":-5,"_24":25,"_147":-5,"_237":275,"_27":276},{"_43":264,"_32":265,"_30":266,"_142":267,"_41":42,"_40":209,"_144":59,"_38":268,"_13":63,"_33":20,"_35":269,"_24":25,"_147":-5,"_237":270,"_27":271},{"_43":199,"_32":200,"_30":201,"_142":-5,"_41":42,"_40":202,"_144":59,"_38":261,"_13":63,"_33":20,"_35":204,"_24":25,"_147":-5,"_237":262,"_27":263},{"_43":192,"_32":193,"_30":194,"_142":-5,"_41":42,"_40":195,"_144":25,"_38":258,"_13":154,"_33":20,"_35":197,"_24":25,"_147":-5,"_237":259,"_27":260},{"_43":184,"_32":185,"_30":186,"_142":-5,"_41":42,"_40":187,"_144":25,"_38":255,"_13":189,"_33":20,"_35":190,"_24":25,"_147":-5,"_237":256,"_27":257},{"_43":180,"_32":28,"_30":31,"_142":-5,"_41":42,"_40":14,"_144":59,"_38":252,"_13":182,"_33":34,"_35":37,"_24":25,"_147":-5,"_237":253,"_27":254},{"_43":173,"_32":174,"_30":175,"_142":-5,"_41":42,"_40":154,"_144":59,"_38":249,"_13":177,"_33":20,"_35":178,"_24":25,"_147":-5,"_237":250,"_27":251},{"_43":165,"_32":166,"_30":167,"_142":-5,"_41":42,"_40":168,"_144":25,"_38":246,"_13":170,"_33":20,"_35":171,"_24":25,"_147":-5,"_237":247,"_27":248},{"_43":157,"_32":158,"_30":57,"_142":-5,"_41":42,"_40":159,"_144":25,"_38":243,"_13":161,"_33":162,"_35":163,"_24":25,"_147":45,"_237":244,"_27":245},{"_43":149,"_32":150,"_30":151,"_142":-5,"_41":42,"_40":152,"_144":25,"_38":240,"_13":154,"_33":34,"_35":155,"_24":25,"_147":-5,"_237":241,"_27":242},{"_43":139,"_32":140,"_30":141,"_142":-5,"_41":42,"_40":143,"_144":59,"_38":236,"_13":63,"_33":34,"_35":146,"_24":25,"_147":-5,"_237":238,"_27":239},["D",1789662876352],"children",[],[140],["D",1789665551418],[],[150],["D",1789702702300],[],[158],["D",1789663895198],[],[166],["D",1789661122996],[],[174],["D",1789702710923],[],[28],["D",1789701953042],[],[185],["D",1789664143855],[],[193],["D",1789663712584],[],[200],"b888127e-409c-47d7-a771-64aca7683d54","suggest-a-tool.yml","95dff708-b2b7-11f1-b195-1607ee4eb77e","56f91fc9-ef0e-459b-a196-5697528a3c74",["D",1789663698826],"name: Suggest a tool\ndescription: Propose a developer tool, service or free tier that belongs in the directory\ntitle: \"[Tool] \"\nlabels: [\"suggestion\"]\nbody:\n - type: markdown\n attributes:\n value: |\n Thanks for contributing. The directory only lists tools that are **genuinely free to use** —\n no 14-day trials, no \"free forever\" plans that quietly expired.\n\n - type: input\n id: name\n attributes:\n label: Tool name\n description: The name as it should appear on the card.\n placeholder: Neon\n validations:\n required: true\n\n - type: input\n id: url\n attributes:\n label: Website URL\n description: Full URL, including any invite or referral parameters.\n placeholder: https://neon.tech/\n validations:\n required: true\n\n - type: dropdown\n id: category\n attributes:\n label: Category\n description: Pick one or more. Choose the closest fit if you're unsure.\n multiple: true\n options:\n - DNS & Domain\n - Communication & Email\n - AI & Coding\n - Frontend & Edge\n - Backend & PaaS\n - Databases & Caching\n validations:\n required: true\n\n - type: dropdown\n id: tier\n attributes:\n label: Free tier type\n options:\n - Forever Free — free indefinitely, no time limit\n - Free Tier — a permanent free plan with usage caps\n - Open Source — self-hostable, the project itself is free\n - Not sure\n validations:\n required: true\n\n - type: textarea\n id: description\n attributes:\n label: Description\n description: One or two sentences on what the free tier actually gets you. This text goes straight onto the card.\n placeholder: Serverless Postgres with instant branching, scale-to-zero compute and a database-per-preview workflow.\n validations:\n required: true\n\n - type: input\n id: code\n attributes:\n label: Invite or referral code (optional)\n description: Leave blank unless the tool has one. It renders as a click-to-copy chip on the card.\n placeholder: ESB9EDBVDE\n validations:\n required: false\n\n - type: checkboxes\n id: confirmations\n attributes:\n label: Before you submit\n options:\n - label: This tool is genuinely free to use — no expiring trial and no credit card required.\n required: true\n - label: I've checked it isn't already listed in the directory.\n required: true",[],[207,272,265],"ISSUE_TEMPLATE","8935093c-f828-49aa-959b-f71cd373e8bd",["D",1789663698826],[226],[207,272],["D",1789663698826],[225],[207],["D",1789660937610],["D",1789664470421],{"_100":99,"_107":102},{"_100":99,"_101":102,"_103":102,"_18":55,"_104":105,"_106":25},{"_13":89,"_32":90,"_43":42,"_91":44,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":45,"_98":99},"ctx",{"_82":-5,"_126":318,"_319":320,"_321":322,"_323":25,"_324":25,"_325":25,"_326":59,"_327":-5,"_328":-7,"_329":-7,"_330":63,"_331":25,"_332":25,"_333":-5,"_334":25,"_335":25,"_336":25,"_337":-5},"ENV",{"_289":290,"_291":292,"_293":90,"_294":295,"_296":297,"_298":299,"_300":301,"_302":303,"_304":305,"_306":307,"_308":309,"_310":311,"_312":313,"_314":315,"_316":317},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","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"]

\n Ship for free.\n Scale when you're ready.\n

Couldn't load the directory

No tools match that

Add a tool

Directory

\n Ship for free.
\n Scale when you're ready.\n

Diff · v50