[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_226":227,"_228":229},"routes/_app.x.$handle.$name",{"_106":105,"_38":51,"_114":96,"_33":108,"_13":14,"_115":-5,"_11":116,"_117":118,"_119":120,"_121":122,"_123":124,"_26":-5,"_125":-5,"_126":-5,"_127":31,"_128":129,"_130":65,"_131":-5,"_132":-5,"_133":134},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_49":50,"_38":51,"_44":52,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":69,"_70":71,"_72":73,"_74":75,"_76":77,"_78":-5,"_79":80,"_81":80,"_82":83,"_84":83,"_85":83,"_86":80,"_87":80,"_88":89,"_90":91,"_92":93,"_94":31},"version",17,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","be755653-f8ae-4c10-a3fc-9adb3d11d40e","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":29,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":34,"_39":40,"_41":43,"_44":45,"_46":14,"_47":48,"_30":31},"previous",{"_36":37,"_38":34,"_39":40,"_41":42},"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 await sqlite.execute(\n `CREATE UNIQUE INDEX IF NOT EXISTS tools_name_unique ON tools (lower(name))`,\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(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}","createdAt",["D",1789662942402],"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",{"_106":105,"_113":108},"org",{"_106":105,"_107":108,"_109":108,"_19":61,"_110":111,"_112":31},"branch",{"_13":95,"_38":96,"_49":48,"_97":50,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":-5,"_103":51,"_104":105},"isOwned",73,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","vijevira","handle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_49":50,"_38":51,"_44":221,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":69,"_70":71,"_72":73,"_74":75,"_76":222,"_78":-5,"_79":80,"_81":80,"_82":83,"_84":83,"_85":83,"_86":80,"_87":80,"_88":223,"_90":224,"_92":225,"_94":31},"tree",[196,197,198,199,200,201],"files",[196,197,198,199,200,201],"counts",{"_185":69,"_186":155,"_187":69,"_188":189,"_190":191},"contents",[135,136,137,138,139,140],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_49":177,"_38":178,"_36":179,"_144":-5,"_47":48,"_46":180,"_146":31,"_44":181,"_13":182,"_39":26,"_41":183,"_30":31,"_149":-5,"_33":184},{"_49":174,"_38":34,"_36":37,"_144":-5,"_47":48,"_46":14,"_146":31,"_44":175,"_13":155,"_39":40,"_41":43,"_30":31,"_149":-5,"_33":176},{"_49":167,"_38":168,"_36":169,"_144":-5,"_47":48,"_46":170,"_146":65,"_44":171,"_13":155,"_39":26,"_41":172,"_30":31,"_149":-5,"_33":173},{"_49":159,"_38":160,"_36":161,"_144":-5,"_47":48,"_46":162,"_146":31,"_44":163,"_13":164,"_39":26,"_41":165,"_30":31,"_149":-5,"_33":166},{"_49":151,"_38":152,"_36":63,"_144":-5,"_47":48,"_46":153,"_146":31,"_44":154,"_13":155,"_39":156,"_41":157,"_30":31,"_149":51,"_33":158},{"_49":141,"_38":142,"_36":143,"_144":-5,"_47":48,"_46":145,"_146":65,"_44":147,"_13":69,"_39":40,"_41":148,"_30":31,"_149":-5,"_33":150},"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",[142],"4adca238-3d03-4f67-9128-a5d3354de3d2","main.tsx",16,["D",1789662925078],1,"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. Writes require the ADMIN_KEY environment variable, sent by\n * the admin UI as an `X-Admin-Key` header — without it anyone who found the URL\n * could edit the directory.\n */\nimport { staticHTTPServer } from \"https://esm.town/v/std/utils/index.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\n/**\n * Write access check.\n * Returns \"ok\", \"missing\" (no key configured on the val), or \"denied\".\n */\nfunction checkAdmin(req: Request): \"ok\" | \"missing\" | \"denied\" {\n const expected = Deno.env.get(\"ADMIN_KEY\") ?? \"\";\n if (!expected) return \"missing\";\n\n const given = req.headers.get(\"x-admin-key\") ?? \"\";\n if (given.length !== expected.length) return \"denied\";\n\n // Constant-time-ish compare: don't bail early on the first mismatched byte.\n let diff = 0;\n for (let i = 0; i < expected.length; i++) {\n diff |= given.charCodeAt(i) ^ expected.charCodeAt(i);\n }\n return diff === 0 ? \"ok\" : \"denied\";\n}\n\nexport default async function handler(req: Request): Promise {\n const { pathname } = new URL(req.url);\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 return json({\n writable: checkAdmin(req) === \"ok\",\n configured: (Deno.env.get(\"ADMIN_KEY\") ?? \"\").length > 0,\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 (admin key required) ---------------- */\n\n const auth = checkAdmin(req);\n if (auth === \"missing\") {\n return fail(\n \"Writes are disabled: set the ADMIN_KEY environment variable on this val to enable the admin API.\",\n 503,\n );\n }\n if (auth === \"denied\") return fail(\"Invalid or missing X-Admin-Key header.\", 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 === \"PUT\" || 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 const tool = await updateTool(id, validate(body) as Parameters[1]);\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}",[152],"571259d8-c73d-42a4-a902-47967ac08665","index.html","01a0b01a-bdc2-7765-aabb-29cc772fce45",12,["D",1789662768598],7,"\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 Browse all\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 \n \n

No tools match that

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

\n \n

\n\n \n \n

\n\n\n\n\n

\n\n\n\n",[160],"cb5bf1f9-73cd-4b33-951b-72fa035f8a1a","favicon.svg","01a0b01a-bdc2-7765-aabb-24bdba58d843",5,["D",1789661122996],"",[168],"d65d69d6-fbe6-4261-984c-79bfbd65f279",["D",1789662942402],[34],"9bf07500-9ac8-4eff-82f7-d9ff0a413f10","README.md","01a0b01a-bdc1-7547-bddc-df66332aec08",13,["D",1789662781487],2,"# 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)\n\n---\n\n## What it does\n\nA single-page, fully responsive directory with instant client-side filtering:\n\n- **Live search** — filters cards by name, category, and description as you type (multi-word queries supported, `⌘/Ctrl + K`-style `/` shortcut to focus, `Esc` to clear)\n- **Category pills** — All · DNS & Domain · Communication & Email · AI & Coding · Frontend & Edge · Backend & PaaS · Databases & Caching, each with a live tool count\n- **Bookmarks** — tap the ★ on any card to save it; the **Saved** button filters to just your bookmarks. Persisted in `localStorage`, so it survives reloads\n- **Click-to-copy** — every card has a copy-link button with inline confirmation\n- **Tier badges** — color-coded by commitment level: Forever Free (green), Free Tier (blue), Open Source (violet)\n\n## Design\n\nDeveloper-focused dark mode: deep charcoal/slate canvas, faint blueprint grid, subtle borders, high-contrast type, and electric-blue + neon-green accents. Set in Inter, with JetBrains Mono for labels, counts, and badges.\n\n## Files\n\n| File | Role |\n| --- | --- |\n| [`index.html`](url:index.html) | The entire application — markup, Tailwind config, CSS, tool data, and logic |\n| `main.tsx` | Tiny HTTP handler that serves the static files |\n| `favicon.svg` | Site icon |\n\n## Adding a tool\n\nAll the content lives in the `TOOLS` array near the top of the `

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

No tools match that

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

Diff · v17