Date Me Directory

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_282":283,"_284":285},"routes/_app.x.$handle.$name",{"_100":99,"_32":45,"_108":90,"_27":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_20":-5,"_120":-5,"_121":-5,"_122":25,"_123":124,"_125":59,"_126":-5,"_127":-5,"_128":129},"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":63,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",149,"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","rss","latestPath","fileId","0022bb14-e591-11ef-9eb9-e6cdfca9ef9f","name","fileType","http","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { dataToRSS } from \"https://esm.town/v/stevekrouse/dataToRSS\";\n\nexport async function rss(req: Request) {\n let { rows } = await sqlite.execute(`select * from datemedocs order by LastUpdated desc limit 20`);\n \n let data = profiles.map((p) => {\n let { Name, Profile, LastUpdated, ...rest } = p;\n return {\n title: Name,\n link: Profile,\n pubDate: new Date(LastUpdated),\n description: Object.entries(rest).filter(([, v]) => v).map(([k, v]) => k + \": \" + v).join(\n \"\\n \",\n ),\n };\n }).sort((a, b) => b.pubDate.getTime() - a.pubDate.getTime());\n return new Response(\n dataToRSS(data, {\n title: \"Date Me Directory RSS\",\n link: \"https://dateme.directory\",\n rssLink: \"https://dateme.directory/rss.xml\",\n }),\n {\n headers: {\n \"Content-type\": \"application/rss+xml\",\n },\n },\n );\n}","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { dataToRSS } from \"https://esm.town/v/stevekrouse/dataToRSS\";\n\nfunction safeParse(s) {\n try {\n return JSON.parse(s);\n } catch (e) {\n return s;\n }\n}\n\nexport async function rss(req: Request) {\n let { rows } = await sqlite.execute(`select * from datemedocs order by LastUpdated desc limit 20`);\n \n let data = rows.map((p) => {\n let { Name, Profile, LastUpdated, ...rest } = p;\n return {\n title: safeParse(Name),\n link: safeParse(Profile),\n pubDate: new Date(safeParse(LastUpdated)),\n description: Object.entries(rest).filter(([, v]) => v).map(([k, v]) => k + \": \" + safeParse(v)).join(\n \"\\n \",\n ),\n };\n }).sort((a, b) => b.pubDate.getTime() - a.pubDate.getTime());\n return new Response(\n dataToRSS(data, {\n title: \"Date Me Directory RSS\",\n link: \"https://dateme.directory\",\n rssLink: \"https://dateme.directory/rss.xml\",\n }),\n {\n headers: {\n \"Content-type\": \"application/rss+xml\",\n },\n },\n );\n}","createdAt",["D",1770065872535],"branchVersion","branchId","6ea333ec-e58d-11ef-b8f1-e6cdfca9ef9f","id","6ea2d636-e58d-11ef-b8f1-e6cdfca9ef9f","dateme",["D",1738958108106],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","The Date Me Directory, an alternative dating site","imageUrl","a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18","pinnedFileId","d8c06b22-e58e-11ef-942a-e6cdfca9ef9f","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",2,"orgId","e81e7335-6d4c-4764-a902-d0962bbfa9f7","tursoName","6ea2d636e58d11efb8f1e6cdfca9ef9f","tursoHostname","6ea2d636e58d11efb8f1e6cdfca9ef9f-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789687835965],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_100":99,"_107":103},"org",{"_100":99,"_101":-5,"_102":103,"_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",275,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","stevekrouse","handle","displayName","avatar","https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":277,"_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":278,"_72":63,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":279,"_84":280,"_86":281,"_88":25},"tree",[203,209,210,211,212,213],"files",[203,204,205,206,207,208,209,210,211,212,213],"counts",{"_191":192,"_193":188,"_194":63,"_195":196,"_197":198},"contents",[138,139,140,141,142,143],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[131,132,133],"hasHttpFiles","grants","orgs","customDomains",{"_57":130},"dateme.directory",{"_43":137,"_135":-5},{"_43":136,"_135":-5},{"_43":134,"_135":-5},"668f151e-470b-11f1-9ddf-42b51c65c3df","reporterId","5279f3c8-470b-11f1-9a6f-42b51c65c3df","58c25f54-46ed-11f1-8db1-42b51c65c3df",{"_43":184,"_32":185,"_30":186,"_145":-5,"_41":42,"_40":180,"_146":59,"_38":187,"_13":188,"_33":189,"_35":-5,"_24":25,"_149":-5,"_27":190},{"_43":175,"_32":176,"_30":177,"_145":-5,"_41":42,"_40":178,"_146":25,"_38":179,"_13":180,"_33":181,"_35":182,"_24":25,"_149":-5,"_27":183},{"_43":167,"_32":168,"_30":169,"_145":-5,"_41":42,"_40":170,"_146":25,"_38":171,"_13":172,"_33":20,"_35":173,"_24":25,"_149":-5,"_27":174},{"_43":159,"_32":160,"_30":57,"_145":-5,"_41":42,"_40":161,"_146":25,"_38":162,"_13":163,"_33":34,"_35":164,"_24":25,"_149":165,"_27":166},{"_43":151,"_32":152,"_30":153,"_145":-5,"_41":42,"_40":154,"_146":25,"_38":155,"_13":156,"_33":20,"_35":157,"_24":25,"_149":-5,"_27":158},{"_43":144,"_32":28,"_30":31,"_145":-5,"_41":42,"_40":14,"_146":25,"_38":147,"_13":148,"_33":34,"_35":37,"_24":25,"_149":-5,"_27":150},"d72038a4-0079-11f1-b1d1-42dde27851f2","parentId","latest",["D",1770065872535],10,"label",[28],"8d4eb884-784a-11f0-8edf-0224a6c84d84","locations.json","c1b193ba-e58f-11ef-807b-e6cdfca9ef9f",91,["D",1755092204204],7,"[\n \"San Francisco Bay Area\",\n \"NYC\",\n \"London\",\n \"Central Europe\",\n \"DC\",\n \"UK\",\n \"Los Angeles\",\n \"Berlin\",\n \"Barcelona, Spain\",\n \"North America\",\n \"Flexible\",\n \"Boston\",\n \"NY\",\n \"Western US\",\n \"Seattle\",\n \"Chicago\",\n \"Asia\",\n \"NJ\",\n \"Philadelphia\",\n \"Paris, France\",\n \"Colorado\",\n \"Toronto\",\n \"Austin\",\n \"PA\",\n \"Canada\",\n \"Brighton\",\n \"Southern US\",\n \"Vancouver\",\n \"TX\",\n \"Portland\",\n \"MA\",\n \"Denver\",\n \"Brazil\",\n \"Amsterdam\",\n \"WI\",\n \"South of France\",\n \"Cambridge\",\n \"Berkeley\",\n \"WA\",\n \"Vancouver Island\",\n \"South Bay\",\n \"Oxford\",\n \"Oregon\",\n \"North Carolina\",\n \"Dubai\",\n \"Somerville\",\n \"Seoul\",\n \"Sacramento\",\n \"Ohio\",\n \"Madison\",\n \"Madrid, Spain\",\n \"Ladysmith BC\",\n \"Indianapolis\",\n \"Georgia\",\n \"Asheville\",\n \"Sydney Australia\",\n \"Sweden\",\n \"Ribeirão Bonito\",\n \"ON\",\n \"New Haven\",\n \"Nebraska\",\n \"Monterey\",\n \"Lubbock\",\n \"Ewing\",\n \"Collingswood\",\n \"CT\",\n \"Rhode Island\",\n \"Miami\",\n \"Indonesia\",\n \"Norway\",\n \"Israel\",\n \"Spain\"\n]",[152],"99c2a286-7d15-11f0-a60e-0224a6c84d84","index",108,["D",1755619217577],19,"import { Hono } from \"npm:hono@3\";\nimport browse from \"./pages/browse\";\nimport faq from \"./pages/faq\";\nimport home from \"./pages/home\";\nimport { join } from \"./pages/join\";\nimport { rss } from \"./rss\";\n\nconst app = new Hono();\napp.get(\"/\", home);\napp.get(\"/browse\", browse);\napp.route(\"/join\", join);\napp.get(\"/faq\", faq);\napp.get(\"/rss.xml\", c => rss(c.req.raw));\n\napp.onError(e => Promise.reject(e))\nexport default app.fetch;","date",[160],"973a92ba-fca1-11f0-91e7-42dde27851f2","README.md","b0c1b956-e58d-11ef-b938-e6cdfca9ef9f",139,["D",1769643140536],9,"# Date Me Directory\n\nA dating platform built around long-form, authentic profiles. No swiping, no algorithms—just people sharing who they really are.\n\n**Live site**: | [FAQ](https://date.val.run/faq)\n\n## Tech Stack\n\n- **Framework**: [Hono](https://hono.dev/) for routing\n- **Database**: SQLite (Val Town `std/sqlite`)\n- **Platform**: [Val Town](https://val.town) (serverless TypeScript)\n- **RSS**: Standard XML feed at `/rss.xml`\n\n## Structure\n\n```\ndateme/\n├── index # Main app (Hono routes)\n├── pages/ # Home, browse, join, faq, layout\n├── rss # RSS feed generator\n├── locations.json # Location data\n└── MIGRATE.ts # Database migrations\n```\n\n## Roadmap\n\n**High Priority**\n- [ ] Email verification for profiles\n- [ ] Allow users to edit profiles\n- [ ] Geocoding & map-based location input\n- [ ] Make database forkable\n\n**Future**\n- [ ] Performance optimization & caching\n- [ ] Featured profiles\n- [ ] Better search/filtering\n\n## Contributing\n\nFork the val on Val Town, make changes, and share! Keep it simple and authentic.\n\n---\n\nBuilt with ❤️ by [@stevekrouse](https://val.town/u/stevekrouse)\n",[168],"9df98ce8-fc9f-11f0-aca5-42dde27851f2","MIGRATE.ts","1185f17e-fc9b-11f0-919b-42dde27851f2",136,["D",1769642292866],14,"script","import { sqlite as global } from \"https://esm.town/v/std/sqlite\";\nimport { sqlite as scoped } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// =============================================================================\n// 1. Configuration\n// =============================================================================\n\nfunction getGlobalTableNamesUsedByVal(): string[] {\n return [\"DateMeDocs\"];\n}\n\n// =============================================================================\n// 2. Schema Helpers\n// =============================================================================\n\n// Get CREATE TABLE statement from sqlite_master\n// Note: sqlite_master.sql includes ALTER TABLE modifications\n// See: https://www.sqlite.org/schematab.html\nasync function getCreateTableStatement(tableName: string): Promise {\n const result = await global.execute({\n sql:\n `SELECT sql FROM sqlite_master WHERE type='table' AND name=? COLLATE NOCASE`,\n args: [tableName],\n });\n if (result.rows.length === 0) {\n throw new Error(`Table ${tableName} not found in global database`);\n }\n const sql = result.rows[0][0] as string;\n // Add IF NOT EXISTS for idempotency\n return sql.replace(/^CREATE TABLE/i, \"CREATE TABLE IF NOT EXISTS\");\n}\n\n// Get all indexes for a table (excluding auto-generated ones)\nasync function getCreateIndexStatements(tableName: string): Promise {\n const result = await global.execute({\n sql:\n `SELECT sql FROM sqlite_master WHERE type='index' AND tbl_name=? COLLATE NOCASE AND sql IS NOT NULL`,\n args: [tableName],\n });\n return result.rows\n .map((row: any) => row[0] as string)\n .filter(Boolean)\n .map((sql) =>\n sql.replace(/^CREATE INDEX/i, \"CREATE INDEX IF NOT EXISTS\")\n .replace(/^CREATE UNIQUE INDEX/i, \"CREATE UNIQUE INDEX IF NOT EXISTS\")\n );\n}\n\n// Get all triggers for a table\nasync function getCreateTriggerStatements(\n tableName: string,\n): Promise {\n const result = await global.execute({\n sql:\n `SELECT sql FROM sqlite_master WHERE type='trigger' AND tbl_name=? COLLATE NOCASE AND sql IS NOT NULL`,\n args: [tableName],\n });\n return result.rows\n .map((row: any) => row[0] as string)\n .filter(Boolean);\n}\n\n// Get column names from PRAGMA table_info\nasync function getColumnNames(tableName: string): Promise {\n const result = await global.execute(`PRAGMA table_info(${tableName})`);\n return result.rows.map((row: any) => row[1] as string);\n}\n\n// =============================================================================\n// 3. Migration Actions\n// =============================================================================\n\nasync function createTableInScoped(tableName: string): Promise {\n // Create table\n const createTableSQL = await getCreateTableStatement(tableName);\n console.log(\"CREATE TABLE:\\n\", createTableSQL);\n await scoped.execute(createTableSQL);\n\n // Create indexes\n const indexStatements = await getCreateIndexStatements(tableName);\n for (const sql of indexStatements) {\n console.log(\"CREATE INDEX:\", sql);\n await scoped.execute(sql);\n }\n\n // Create triggers\n const triggerStatements = await getCreateTriggerStatements(tableName);\n for (const sql of triggerStatements) {\n console.log(\"CREATE TRIGGER:\", sql);\n await scoped.execute(sql);\n }\n}\n\nasync function copyData(tableName: string, batchSize = 100): Promise {\n const columns = await getColumnNames(tableName);\n const columnList = columns.join(\", \");\n const placeholders = columns.map(() => \"?\").join(\", \");\n\n let offset = 0;\n let totalCopied = 0;\n\n while (true) {\n const { rows } = await global.execute({\n sql: `SELECT * FROM ${tableName} LIMIT ? OFFSET ?`,\n args: [batchSize, offset],\n });\n\n if (rows.length === 0) break;\n\n const statements = rows.map((row: any) => ({\n sql:\n `INSERT OR IGNORE INTO ${tableName} (${columnList}) VALUES (${placeholders})`,\n args: Array.isArray(row) ? row : Object.values(row),\n }));\n\n await scoped.batch(statements);\n\n totalCopied += rows.length;\n offset += batchSize;\n console.log(` Copied ${totalCopied} rows...`);\n\n if (rows.length < batchSize) break;\n }\n\n return totalCopied;\n}\n\nasync function verifyMigration(tableName: string): Promise {\n const globalCount = await global.execute(`SELECT COUNT(*) FROM ${tableName}`);\n const scopedCount = await scoped.execute(`SELECT COUNT(*) FROM ${tableName}`);\n\n const globalTotal = globalCount.rows[0][0] as number;\n const scopedTotal = scopedCount.rows[0][0] as number;\n\n console.log(` Global: ${globalTotal} rows, Scoped: ${scopedTotal} rows`);\n\n return globalTotal === scopedTotal;\n}\n\n// =============================================================================\n// 4. Main Migration Orchestrator\n// =============================================================================\n\nexport async function migrate() {\n const tables = getGlobalTableNamesUsedByVal();\n\n for (const tableName of tables) {\n console.log(`\\n${\"=\".repeat(60)}`);\n console.log(`Migrating table: ${tableName}`);\n console.log(\"=\".repeat(60));\n\n // Step 1: Create table, indexes, and triggers in scoped database\n console.log(\"\\n[1/3] Creating schema in scoped database...\");\n await createTableInScoped(tableName);\n console.log(\"✓ Schema created\");\n\n // Step 2: Copy data\n console.log(\"\\n[2/3] Copying data...\");\n const count = await copyData(tableName);\n console.log(`✓ Copied ${count} rows`);\n\n // Step 3: Verify\n console.log(\"\\n[3/3] Verifying migration...\");\n const verified = await verifyMigration(tableName);\n if (verified) {\n console.log(\"✓ Migration verified!\");\n } else {\n console.log(\"✗ Row counts don't match - please investigate\");\n }\n }\n\n console.log(`\\n${\"=\".repeat(60)}`);\n console.log(\"Migration complete!\");\n console.log(\"=\".repeat(60));\n console.log(\"\\nNext steps - update imports in:\");\n console.log(\" • pages/browse (line 2)\");\n console.log(\" • pages/join (line 3)\");\n console.log(\" • rss (line 1)\");\n console.log(\"\\nChange:\");\n console.log(' import { sqlite } from \"https://esm.town/v/std/sqlite\";');\n console.log(\"To:\");\n console.log(\n ' import { sqlite } from \"https://esm.town/v/std/sqlite@14-main/main.ts\";',\n );\n}\n\n// Uncomment to run:\nmigrate();",[176],"7b9de126-e58f-11ef-aa79-e6cdfca9ef9f","pages","78e859c0-e58f-11ef-b429-e6cdfca9ef9f",["D",1738958988872],1,"directory",[185],"pulls",0,"branches","forks","envVars",{"_199":201,"_202":192},"connections",{"_199":192,"_200":192},"count","unfilledCount",3,"emptyCount",{"_43":184,"_32":185,"_30":186,"_145":-5,"_41":42,"_40":180,"_146":59,"_38":274,"_13":188,"_33":189,"_35":-5,"_24":25,"_149":-5,"_215":275,"_27":276},{"_43":265,"_32":266,"_30":267,"_145":186,"_41":42,"_40":268,"_146":25,"_38":269,"_13":270,"_33":181,"_35":271,"_24":25,"_149":-5,"_215":272,"_27":273},{"_43":256,"_32":257,"_30":258,"_145":186,"_41":42,"_40":259,"_146":25,"_38":260,"_13":261,"_33":181,"_35":262,"_24":25,"_149":-5,"_215":263,"_27":264},{"_43":247,"_32":248,"_30":249,"_145":186,"_41":42,"_40":250,"_146":25,"_38":251,"_13":252,"_33":181,"_35":253,"_24":25,"_149":-5,"_215":254,"_27":255},{"_43":239,"_32":240,"_30":241,"_145":186,"_41":42,"_40":178,"_146":25,"_38":242,"_13":243,"_33":181,"_35":244,"_24":25,"_149":-5,"_215":245,"_27":246},{"_43":230,"_32":231,"_30":232,"_145":186,"_41":42,"_40":233,"_146":25,"_38":234,"_13":235,"_33":181,"_35":236,"_24":25,"_149":-5,"_215":237,"_27":238},{"_43":175,"_32":176,"_30":177,"_145":-5,"_41":42,"_40":178,"_146":25,"_38":227,"_13":180,"_33":181,"_35":182,"_24":25,"_149":-5,"_215":228,"_27":229},{"_43":167,"_32":168,"_30":169,"_145":-5,"_41":42,"_40":170,"_146":25,"_38":224,"_13":172,"_33":20,"_35":173,"_24":25,"_149":-5,"_215":225,"_27":226},{"_43":159,"_32":160,"_30":57,"_145":-5,"_41":42,"_40":161,"_146":25,"_38":221,"_13":163,"_33":34,"_35":164,"_24":25,"_149":165,"_215":222,"_27":223},{"_43":151,"_32":152,"_30":153,"_145":-5,"_41":42,"_40":154,"_146":25,"_38":218,"_13":156,"_33":20,"_35":157,"_24":25,"_149":-5,"_215":219,"_27":220},{"_43":144,"_32":28,"_30":31,"_145":-5,"_41":42,"_40":14,"_146":25,"_38":214,"_13":148,"_33":34,"_35":37,"_24":25,"_149":-5,"_215":216,"_27":217},["D",1770065872535],"children",[],[28],["D",1755092204204],[],[152],["D",1755619217577],[],[160],["D",1769643140536],[],[168],["D",1769642292866],[],[176],"ffbd2ca0-e990-11ef-bb7b-e6cdfca9ef9f","layout","44427056-e590-11ef-af82-e6cdfca9ef9f",83,["D",1739399444685],12,"/** @jsxImportSource npm:hono@3/jsx */\nimport { PropsWithChildren } from \"npm:hono/jsx\";\nconst tabs = { \"/\": \"Home\", \"/browse\": \"Browse\", \"/faq\": \"FAQ\" };\nimport { parseProject } from \"https://esm.town/v/std/parseImportMeta/project\";\n\nconst thisURL = parseProject(import.meta.url).links.self.project;\n\nexport default function({ activeTab, children }: PropsWithChildren<{ activeTab: string }>) {\n return (\n \n \n Date Me Directory\n \n

Diff · v149