[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_277":278,"_279":280},"routes/_app.x.$handle.$name",{"_94":93,"_31":44,"_103":84,"_26":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":24,"_118":119,"_120":121,"_122":-5,"_123":-5,"_124":125},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":-5,"_56":24,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":77,"_78":79,"_80":81,"_82":24},"version",14,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","backend/index.http.ts","latestPath","fileId","1ed9a0b0-0a91-11f1-9740-42dde27851f2","name","index.http.ts","fileType","http","content","import { Hono } from \"https://esm.sh/hono@4.4.0\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport { pages } from \"./routes/pages.ts\";\nimport { api } from \"./routes/api.ts\";\n\nconst app = new Hono();\n\napp.onError((err, _c) => {\n throw err;\n});\n\nlet migrationsRan = false;\napp.use(\"*\", async (_c, next) => {\n if (!migrationsRan) {\n await runMigrations();\n migrationsRan = true;\n }\n await next();\n});\n\napp.route(\"/api\", api);\napp.route(\"/\", pages);\n\nexport default app.fetch;\n","createdAt",["D",1771175382903],"branchVersion","branchId","1d3b78dc-0a91-11f1-9151-42dde27851f2","id","1d3a5aa6-0a91-11f1-9151-42dde27851f2","openpds",["D",1771175379615],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","AT Protocol PDS servers with open registration.","imageUrl","14049850-28c1-11f0-89c9-c7d0e2d9e1ea","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","c04d51b2-a7dc-46ca-ad6f-52f47c2906a8","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_94":93,"_102":98},"org",{"_94":93,"_95":96,"_97":98,"_18":54,"_99":100,"_101":24},"branch",{"_13":83,"_31":84,"_42":41,"_85":43,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":44,"_92":93},"isOwned",102,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","tijs","handle","displayName","Tijs","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yd2Nod2N0bE1MWFdEUlRYd083ZE5pbXJ1bDAifQ","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_31":44,"_37":273,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":-5,"_56":24,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":274,"_78":275,"_80":276,"_82":24},"tree",[177,187,188,189,190],"files",[177,178,179,180,181,182,183,184,185,186,187,188,189,190],"counts",{"_167":60,"_168":164,"_169":60,"_170":171,"_172":173},"contents",[127,128,129,130,131],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{"_30":126},"openpds.tijs.org",{"_42":161,"_31":162,"_29":163,"_135":-5,"_40":41,"_39":164,"_137":121,"_37":165,"_13":60,"_33":147,"_35":-5,"_23":24,"_140":-5,"_26":166},{"_42":155,"_31":156,"_29":157,"_135":-5,"_40":41,"_39":158,"_137":121,"_37":159,"_13":60,"_33":147,"_35":-5,"_23":24,"_140":-5,"_26":160},{"_42":149,"_31":150,"_29":151,"_135":-5,"_40":41,"_39":152,"_137":24,"_37":153,"_13":60,"_33":147,"_35":-5,"_23":24,"_140":-5,"_26":154},{"_42":142,"_31":143,"_29":144,"_135":-5,"_40":41,"_39":145,"_137":121,"_37":146,"_13":60,"_33":147,"_35":-5,"_23":24,"_140":-5,"_26":148},{"_42":132,"_31":133,"_29":134,"_135":-5,"_40":41,"_39":136,"_137":24,"_37":138,"_13":60,"_33":20,"_35":139,"_23":24,"_140":-5,"_26":141},"1eafafb2-0a91-11f1-afb2-42dde27851f2","deno.json","1eafb070-0a91-11f1-afb2-42dde27851f2","parentId",8,"latest",["D",1771175382646],"{\n \"$schema\": \"https://raw.githubusercontent.com/denoland/deno/348900b8b79f4a434cab4c74b3bc8d4d2fa8ee74/cli/schemas/config-file.v1.json\",\n \"lock\": false,\n \"compilerOptions\": {\n \"noImplicitAny\": false,\n \"strict\": false,\n \"types\": [\"https://www.val.town/types/valtown.d.ts\"],\n \"lib\": [\n \"dom\",\n \"dom.iterable\",\n \"dom.asynciterable\",\n \"deno.ns\",\n \"deno.unstable\"\n ]\n },\n \"lint\": {\n \"include\": [\"**/*.ts\"],\n \"rules\": { \"exclude\": [\"no-explicit-any\", \"no-import-prefix\"] }\n },\n \"node_modules_dir\": false,\n \"tasks\": {\n \"check\": \"deno check --allow-import backend/index.http.ts cron/refresh.cron.ts\",\n \"quality\": \"deno fmt && deno lint && deno task check\",\n \"deploy\": \"deno task quality && vt push\"\n }\n}\n","label",[133],"1df465fe-0a91-11f1-ac04-42dde27851f2","shared","1df466e4-0a91-11f1-ac04-42dde27851f2",2,["D",1771175381422],"directory",[143],"1e17be1e-0a91-11f1-9455-42dde27851f2","openen","1e17bedc-0a91-11f1-9455-42dde27851f2",3,["D",1771175381651],[150],"1e3f9592-0a91-11f1-a289-42dde27851f2","cron","1e3f9650-0a91-11f1-a289-42dde27851f2",4,["D",1771175381915],[156],"1dd5afa6-0a91-11f1-a289-42dde27851f2","backend","1dd5b05a-0a91-11f1-a289-42dde27851f2",1,["D",1771175381220],[162],"pulls","branches","forks","envVars",{"_174":60,"_176":60},"connections",{"_174":60,"_175":60},"count","unfilledCount","emptyCount",{"_42":161,"_31":162,"_29":163,"_135":-5,"_40":41,"_39":164,"_137":121,"_37":270,"_13":60,"_33":147,"_35":-5,"_23":24,"_140":-5,"_192":271,"_26":272},{"_42":265,"_31":256,"_29":250,"_135":163,"_40":41,"_39":266,"_137":121,"_37":267,"_13":60,"_33":147,"_35":-5,"_23":24,"_140":-5,"_192":268,"_26":269},{"_42":257,"_31":258,"_29":259,"_135":250,"_40":41,"_39":260,"_137":24,"_37":261,"_13":60,"_33":214,"_35":262,"_23":24,"_140":-5,"_192":263,"_26":264},{"_42":247,"_31":248,"_29":249,"_135":250,"_40":41,"_39":251,"_137":24,"_37":252,"_13":60,"_33":214,"_35":253,"_23":24,"_140":-5,"_192":254,"_26":255},{"_42":242,"_31":233,"_29":227,"_135":163,"_40":41,"_39":243,"_137":121,"_37":244,"_13":60,"_33":147,"_35":-5,"_23":24,"_140":-5,"_192":245,"_26":246},{"_42":234,"_31":235,"_29":236,"_135":227,"_40":41,"_39":237,"_137":24,"_37":238,"_13":60,"_33":214,"_35":239,"_23":24,"_140":-5,"_192":240,"_26":241},{"_42":224,"_31":225,"_29":226,"_135":227,"_40":41,"_39":228,"_137":24,"_37":229,"_13":60,"_33":214,"_35":230,"_23":24,"_140":-5,"_192":231,"_26":232},{"_42":219,"_31":218,"_29":211,"_135":163,"_40":41,"_39":220,"_137":121,"_37":221,"_13":60,"_33":147,"_35":-5,"_23":24,"_140":-5,"_192":222,"_26":223},{"_42":208,"_31":209,"_29":210,"_135":211,"_40":41,"_39":212,"_137":121,"_37":213,"_13":60,"_33":214,"_35":215,"_23":24,"_140":-5,"_192":216,"_26":217},{"_42":204,"_31":32,"_29":30,"_135":163,"_40":41,"_39":14,"_137":24,"_37":205,"_13":60,"_33":34,"_35":36,"_23":24,"_140":44,"_192":206,"_26":207},{"_42":155,"_31":156,"_29":157,"_135":-5,"_40":41,"_39":158,"_137":121,"_37":201,"_13":60,"_33":147,"_35":-5,"_23":24,"_140":-5,"_192":202,"_26":203},{"_42":149,"_31":150,"_29":151,"_135":-5,"_40":41,"_39":152,"_137":24,"_37":198,"_13":60,"_33":147,"_35":-5,"_23":24,"_140":-5,"_192":199,"_26":200},{"_42":142,"_31":143,"_29":144,"_135":-5,"_40":41,"_39":145,"_137":121,"_37":195,"_13":60,"_33":147,"_35":-5,"_23":24,"_140":-5,"_192":196,"_26":197},{"_42":132,"_31":133,"_29":134,"_135":-5,"_40":41,"_39":136,"_137":24,"_37":191,"_13":60,"_33":20,"_35":139,"_23":24,"_140":-5,"_192":193,"_26":194},["D",1771175382646],"children",[],[133],["D",1771175381422],[],[143],["D",1771175381651],[],[150],["D",1771175381915],[],[156],"1ed99eb2-0a91-11f1-9740-42dde27851f2",["D",1771175382903],[],[162,32],"1ed2b034-0a91-11f1-a09a-42dde27851f2","geo-resolver.ts","1ed2b0e8-0a91-11f1-a09a-42dde27851f2","1e950220-0a91-11f1-987b-42dde27851f2",13,["D",1771175382877],"script","import type { DnsResponse, GeoIpResult } from \"../../shared/types.ts\";\n\n/** Resolve hostname to IP address via DNS-over-HTTPS */\nexport async function resolveIp(hostname: string): Promise {\n try {\n const resp = await fetch(\n `https://dns.google/resolve?name=${encodeURIComponent(hostname)}&type=A`,\n { signal: AbortSignal.timeout(5000) },\n );\n if (!resp.ok) return null;\n\n const data: DnsResponse = await resp.json();\n if (!data.Answer || data.Answer.length === 0) return null;\n\n // Return the last A record (usually the actual IP after CNAMEs)\n return data.Answer[data.Answer.length - 1].data;\n } catch {\n return null;\n }\n}\n\n/** Batch geo-IP lookup for up to 100 IPs */\nexport async function batchGeoLookup(\n ipMap: Map,\n): Promise> {\n const results = new Map<\n string,\n { countryCode: string; countryName: string }\n >();\n if (ipMap.size === 0) return results;\n\n // ip-api.com batch endpoint: POST array of IPs\n const ips = [...new Set(ipMap.values())].filter(Boolean);\n if (ips.length === 0) return results;\n\n try {\n const resp = await fetch(\n \"http://ip-api.com/batch?fields=status,query,country,countryCode\",\n {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(ips),\n signal: AbortSignal.timeout(10000),\n },\n );\n\n if (!resp.ok) {\n console.error(`ip-api.com batch error: ${resp.status}`);\n return results;\n }\n\n const geoResults: GeoIpResult[] = await resp.json();\n\n // Build IP → geo map\n const ipToGeo = new Map<\n string,\n { countryCode: string; countryName: string }\n >();\n for (const r of geoResults) {\n if (r.status === \"success\") {\n ipToGeo.set(r.query, {\n countryCode: r.countryCode,\n countryName: r.country,\n });\n }\n }\n\n // Map hostnames back to geo data via their IPs\n for (const [hostname, ip] of ipMap) {\n const geo = ipToGeo.get(ip);\n if (geo) results.set(hostname, geo);\n }\n } catch (err) {\n console.error(\"Geo lookup failed:\", err);\n }\n\n return results;\n}\n",[],[162,218,209],"services","1e95013a-0a91-11f1-987b-42dde27851f2",7,["D",1771175382473],[185],[162,218],"1eb91ac0-0a91-11f1-aa7d-42dde27851f2","pages.ts","1eb91b88-0a91-11f1-aa7d-42dde27851f2","1e7af3e4-0a91-11f1-a09a-42dde27851f2",10,["D",1771175382678],"import { Hono } from \"https://esm.sh/hono@4.4.0\";\nimport {\n getMetadata,\n getOpenServers,\n getServerCount,\n} from \"../database/queries.ts\";\nimport { countryFlag } from \"../../shared/constants.ts\";\nimport type {\n PdsServer,\n SortDirection,\n SortField,\n} from \"../../shared/types.ts\";\n\nconst pages = new Hono();\n\npages.get(\"/\", async (c) => {\n const sort = (c.req.query(\"sort\") || \"users\") as SortField;\n const dir = (c.req.query(\"dir\") || \"desc\") as SortDirection;\n const showOutdated = c.req.query(\"show_outdated\") === \"true\";\n\n const [latestVersion, counts] = await Promise.all([\n getMetadata(\"latest_pds_version\"),\n getServerCount(),\n ]);\n\n const servers = await getOpenServers(sort, dir, showOutdated, latestVersion);\n\n return c.html(renderPage(servers, {\n sort,\n dir,\n showOutdated,\n latestVersion,\n openCount: counts.open,\n totalCount: counts.total,\n }));\n});\n\ntype PageOpts = {\n sort: SortField;\n dir: SortDirection;\n showOutdated: boolean;\n latestVersion: string | null;\n openCount: number;\n totalCount: number;\n};\n\nfunction renderPage(servers: PdsServer[], opts: PageOpts): string {\n const { sort, dir, showOutdated, latestVersion, openCount, totalCount } =\n opts;\n\n function sortUrl(field: SortField): string {\n const newDir = sort === field && dir === \"desc\" ? \"asc\" : \"desc\";\n const params = new URLSearchParams();\n params.set(\"sort\", field);\n params.set(\"dir\", newDir);\n if (showOutdated) params.set(\"show_outdated\", \"true\");\n return `/?${params}`;\n }\n\n function sortIndicator(field: SortField): string {\n if (sort !== field) return \"\";\n return dir === \"asc\" ? \" ▲\" : \" ▼\";\n }\n\n const toggleUrl = (() => {\n const params = new URLSearchParams();\n params.set(\"sort\", sort);\n params.set(\"dir\", dir);\n if (!showOutdated) params.set(\"show_outdated\", \"true\");\n return `/?${params}`;\n })();\n\n const rows = servers.map((s) => renderRow(s, latestVersion)).join(\"\\n\");\n\n return `\n\n\n \n \n OpenPDS - AT Protocol PDS Directory\n \n\n\n

OpenPDS

\n AT Protocol PDS servers with open registration.\n Data from atproto-scraping,\n enriched daily.\n

\n ${servers.length} servers listed\n ${openCount} open of ${totalCount} known\n ${latestVersion ? `Latest PDS: ${esc(latestVersion)}` : \"\"}\n

\n ${\n showOutdated ? \"Hide outdated versions\" : \"Show outdated versions\"\n }\n

\n ${\n servers.length > 0\n ? `\n \n \n \n \n \n \n \n \n \n \n \n \n ${rows}\n \n

Hostname	Country${\n sortIndicator(\"country\")\n }	Version${\n sortIndicator(\"version\")\n }	Users${\n sortIndicator(\"users\")\n }	First seen${sortIndicator(\"first_seen\")}	Trust

`\n : `

No servers found. Data may still be loading — check back after the first cron run.

`\n }\n \n\n`;\n}\n\nfunction renderRow(s: PdsServer, latestVersion: string | null): string {\n const hostname = new URL(s.url).hostname;\n const flag = s.country_code ? countryFlag(s.country_code) + \" \" : \"\";\n const country = s.country_name || \"\";\n\n let versionClass = \"version-unknown\";\n let versionText = \"unknown\";\n if (s.version) {\n versionText = s.version;\n versionClass = s.version === latestVersion\n ? \"version-current\"\n : \"version-outdated\";\n }\n\n const users = s.user_count != null\n ? (s.user_count >= 1000 ? \"1000+\" : String(s.user_count))\n : \"-\";\n\n const firstSeen = s.first_seen\n ? new Date(s.first_seen).toLocaleDateString(\"en-US\", {\n month: \"short\",\n day: \"numeric\",\n year: \"numeric\",\n })\n : \"-\";\n\n const hasEmail = s.contact_email;\n const hasTos = s.terms_of_service;\n const hasPrivacy = s.privacy_policy;\n\n return `\n ${esc(hostname)}\n ${flag}${esc(country)}\n ${\n esc(versionText)\n }\n ${esc(users)}\n ${esc(firstSeen)}\n \n \n ${\n hasEmail\n ? `@`\n : `@`\n }\n ${\n hasTos\n ? `T`\n : `T`\n }\n ${\n hasPrivacy\n ? `P`\n : `P`\n }\n \n \n `;\n}\n\nfunction esc(str: string): string {\n return str\n .replace(/&/g, \"&\")\n .replace(//g, \">\")\n .replace(/\"/g, \""\");\n}\n\nexport { pages };\n",[],[162,233,225],"routes","1eccee1a-0a91-11f1-a315-42dde27851f2","api.ts","1eccef46-0a91-11f1-a315-42dde27851f2",12,["D",1771175382678],"import { Hono } from \"https://esm.sh/hono@4.4.0\";\nimport {\n getAllServers,\n getMetadata,\n getServerCount,\n} from \"../database/queries.ts\";\n\nconst api = new Hono();\n\napi.get(\"/servers\", async (c) => {\n const [servers, latestVersion, counts] = await Promise.all([\n getAllServers(),\n getMetadata(\"latest_pds_version\"),\n getServerCount(),\n ]);\n\n return c.json({\n meta: {\n latest_pds_version: latestVersion,\n total_known: counts.total,\n total_open: counts.open,\n updated_at: new Date().toISOString(),\n },\n servers,\n });\n});\n\nexport { api };\n",[],[162,233,235],"1e7af2d6-0a91-11f1-a09a-42dde27851f2",6,["D",1771175382290],[182,183],[162,233],"1eb4281c-0a91-11f1-a169-42dde27851f2","queries.ts","1eb42916-0a91-11f1-a169-42dde27851f2","1e5c8756-0a91-11f1-8d35-42dde27851f2",9,["D",1771175382658],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite?v=13\";\nimport { METADATA_TABLE, SERVERS_TABLE } from \"../../shared/constants.ts\";\nimport type {\n PdsServer,\n SortDirection,\n SortField,\n} from \"../../shared/types.ts\";\n\n// --- Server operations ---\n\nexport async function upsertServer(\n url: string,\n opts: {\n inviteCodeRequired: boolean;\n version: string | null;\n errorAt: number | null;\n isOpen: boolean;\n },\n): Promise {\n const now = new Date().toISOString();\n await sqlite.execute({\n sql: `\n INSERT INTO ${SERVERS_TABLE} (url, first_seen, last_seen, invite_code_required, version, error_at, is_open)\n VALUES (?, ?, ?, ?, ?, ?, ?)\n ON CONFLICT(url) DO UPDATE SET\n last_seen = ?,\n invite_code_required = ?,\n version = COALESCE(?, version),\n error_at = ?,\n is_open = ?\n `,\n args: [\n url,\n now,\n now,\n opts.inviteCodeRequired ? 1 : 0,\n opts.version,\n opts.errorAt,\n opts.isOpen ? 1 : 0,\n now,\n opts.inviteCodeRequired ? 1 : 0,\n opts.version,\n opts.errorAt,\n opts.isOpen ? 1 : 0,\n ],\n });\n}\n\nexport async function updateEnrichment(\n url: string,\n data: {\n version?: string | null;\n did?: string | null;\n phoneVerification?: boolean;\n userDomains?: string[];\n contactEmail?: string | null;\n privacyPolicy?: string | null;\n termsOfService?: string | null;\n userCount?: number | null;\n countryCode?: string | null;\n countryName?: string | null;\n ipAddress?: string | null;\n },\n): Promise {\n const now = new Date().toISOString();\n await sqlite.execute({\n sql: `\n UPDATE ${SERVERS_TABLE} SET\n last_enriched = ?,\n version = COALESCE(?, version),\n did = COALESCE(?, did),\n phone_verification = ?,\n user_domains = ?,\n contact_email = ?,\n privacy_policy = ?,\n terms_of_service = ?,\n user_count = COALESCE(?, user_count),\n country_code = COALESCE(?, country_code),\n country_name = COALESCE(?, country_name),\n ip_address = COALESCE(?, ip_address)\n WHERE url = ?\n `,\n args: [\n now,\n data.version ?? null,\n data.did ?? null,\n data.phoneVerification ? 1 : 0,\n data.userDomains ? JSON.stringify(data.userDomains) : null,\n data.contactEmail ?? null,\n data.privacyPolicy ?? null,\n data.termsOfService ?? null,\n data.userCount ?? null,\n data.countryCode ?? null,\n data.countryName ?? null,\n data.ipAddress ?? null,\n url,\n ],\n });\n}\n\nexport async function getServersToEnrich(limit: number): Promise {\n const result = await sqlite.execute({\n sql: `\n SELECT url FROM ${SERVERS_TABLE}\n WHERE is_open = 1\n ORDER BY last_enriched ASC NULLS FIRST\n LIMIT ?\n `,\n args: [limit],\n });\n return result.rows.map((r) => r.url as string);\n}\n\nexport async function getOpenServers(\n sort: SortField = \"users\",\n dir: SortDirection = \"desc\",\n showOutdated: boolean = false,\n latestVersion: string | null = null,\n): Promise {\n let orderClause: string;\n switch (sort) {\n case \"users\":\n orderClause = `user_count ${dir} NULLS LAST`;\n break;\n case \"country\":\n orderClause = `country_name ${dir} NULLS LAST`;\n break;\n case \"first_seen\":\n orderClause = `first_seen ${dir}`;\n break;\n case \"version\":\n orderClause = `version ${dir} NULLS LAST`;\n break;\n default:\n orderClause = \"user_count DESC NULLS LAST\";\n }\n\n let whereClause = \"is_open = 1\";\n const args: (string | number)[] = [];\n\n if (!showOutdated && latestVersion) {\n whereClause += \" AND (version = ? OR version IS NULL)\";\n args.push(latestVersion);\n }\n\n const result = await sqlite.execute({\n sql:\n `SELECT * FROM ${SERVERS_TABLE} WHERE ${whereClause} ORDER BY ${orderClause}`,\n args,\n });\n\n return result.rows.map(rowToServer);\n}\n\nexport async function getAllServers(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${SERVERS_TABLE} WHERE is_open = 1 ORDER BY user_count DESC NULLS LAST`,\n );\n return result.rows.map(rowToServer);\n}\n\nexport async function getServerCount(): Promise<\n { open: number; total: number }\n> {\n const result = await sqlite.execute(\n `SELECT COUNT(*) as total, SUM(CASE WHEN is_open = 1 THEN 1 ELSE 0 END) as open FROM ${SERVERS_TABLE}`,\n );\n const row = result.rows[0];\n return {\n total: (row.total as number) || 0,\n open: (row.open as number) || 0,\n };\n}\n\n// --- Metadata operations ---\n\nexport async function getMetadata(key: string): Promise {\n const result = await sqlite.execute({\n sql: `SELECT value FROM ${METADATA_TABLE} WHERE key = ?`,\n args: [key],\n });\n return result.rows.length > 0 ? (result.rows[0].value as string) : null;\n}\n\nexport async function setMetadata(key: string, value: string): Promise {\n await sqlite.execute({\n sql: `\n INSERT INTO ${METADATA_TABLE} (key, value) VALUES (?, ?)\n ON CONFLICT(key) DO UPDATE SET value = ?\n `,\n args: [key, value, value],\n });\n}\n\n// --- Helpers ---\n\nfunction rowToServer(row: Record): PdsServer {\n return {\n url: row.url as string,\n first_seen: row.first_seen as string,\n last_seen: row.last_seen as string,\n last_enriched: (row.last_enriched as string) || null,\n version: (row.version as string) || null,\n did: (row.did as string) || null,\n invite_code_required: Boolean(row.invite_code_required),\n phone_verification: Boolean(row.phone_verification),\n user_domains: row.user_domains\n ? JSON.parse(row.user_domains as string)\n : [],\n contact_email: (row.contact_email as string) || null,\n privacy_policy: (row.privacy_policy as string) || null,\n terms_of_service: (row.terms_of_service as string) || null,\n user_count: row.user_count != null ? Number(row.user_count) : null,\n country_code: (row.country_code as string) || null,\n country_name: (row.country_name as string) || null,\n ip_address: (row.ip_address as string) || null,\n is_open: Boolean(row.is_open),\n error_at: row.error_at != null ? Number(row.error_at) : null,\n };\n}\n",[],[162,256,248],"database","1ebd22e6-0a91-11f1-9740-42dde27851f2","migrations.ts","1ebd23c2-0a91-11f1-9740-42dde27851f2",11,["D",1771175382658],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite?v=13\";\nimport { METADATA_TABLE, SERVERS_TABLE } from \"../../shared/constants.ts\";\n\nexport async function runMigrations(): Promise {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${SERVERS_TABLE} (\n url TEXT PRIMARY KEY,\n first_seen TEXT NOT NULL,\n last_seen TEXT NOT NULL,\n last_enriched TEXT,\n version TEXT,\n did TEXT,\n invite_code_required INTEGER NOT NULL DEFAULT 0,\n phone_verification INTEGER NOT NULL DEFAULT 0,\n user_domains TEXT,\n contact_email TEXT,\n privacy_policy TEXT,\n terms_of_service TEXT,\n user_count INTEGER,\n country_code TEXT,\n country_name TEXT,\n ip_address TEXT,\n is_open INTEGER NOT NULL DEFAULT 0,\n error_at INTEGER\n )\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${SERVERS_TABLE}_is_open\n ON ${SERVERS_TABLE} (is_open)\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${SERVERS_TABLE}_last_enriched\n ON ${SERVERS_TABLE} (last_enriched)\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${METADATA_TABLE} (\n key TEXT PRIMARY KEY,\n value TEXT NOT NULL\n )\n `);\n}\n",[],[162,256,258],"1e5c86ac-0a91-11f1-8d35-42dde27851f2",5,["D",1771175382101],[179,180],[162,256],["D",1771175381220],[178,181,184,186],[162],["D",1771175379615],{"_94":93,"_102":98},{"_94":93,"_95":96,"_97":98,"_18":54,"_99":100,"_101":24},{"_13":83,"_31":84,"_42":41,"_85":43,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":44,"_92":93},"ctx",{"_76":-5,"_123":310,"_311":312,"_313":314,"_315":24,"_316":24,"_317":24,"_318":121,"_319":-5,"_320":-7,"_321":-7,"_322":60,"_323":24,"_324":24,"_325":-5,"_326":24,"_327":24,"_328":24,"_329":-5},"ENV",{"_281":282,"_283":284,"_285":84,"_286":287,"_288":289,"_290":291,"_292":293,"_294":295,"_296":297,"_298":299,"_300":301,"_302":303,"_304":305,"_306":307,"_308":309},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","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"]

Diff · v14