Marx${activeTag ? ` – ${activeTag}` : \"\"}

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_163":164,"_165":166},"routes/_app.x.$handle.$name",{"_99":98,"_32":44,"_108":89,"_27":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_20":-5,"_120":-5,"_121":-5,"_122":48,"_123":124,"_125":25,"_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",{"_42":43,"_32":44,"_37":45,"_46":-5,"_47":48,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":25,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":48},"version",3,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",true,"deletedHere","path","seed.ts","latestPath","fileId","d1020074-1aff-11f1-9887-42dde27851f2","name","fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst bookmarks = [\n {\"url\":\"https://marco.org/podcasting-microphones\",\"title\":\"Podcasting Microphones Mega-Review – Marco.org\",\"description\":\"\",\"tags\":[],\"saved\":\"2022-03-27T06:14:50.000Z\"},\n {\"url\":\"https://github.com/Kinark/mac-hey\",\"title\":\"GitHub - Kinark/mac-hey\",\"description\":\"See: https://www.reddit.com/r/HeyEmail/comments/tcmy49/guide_to_speed_up_your_desktop_hey_app/\",\"tags\":[\"tech\"],\"saved\":\"2022-03-26T22:31:28.000Z\"},\n {\"url\":\"http://www.nosdiet.com/\",\"title\":\"No S Diet: No snacks, sweets, seconds, except on days that start with S.\",\"description\":\"No snacks, No Sweets, No Seconds. Except on days that start with S.\",\"tags\":[\"health\"],\"saved\":\"2022-03-26T22:20:58.000Z\"},\n] as const;\n\n// This is a placeholder - we'll populate via the import endpoint instead\nconsole.log(\"Use the /api/import endpoint to import bookmarks from JSON\");\n","createdAt",["D",1772982254108],"branchVersion","branchId","c018ddf0-1aff-11f1-bf64-42dde27851f2","id","c0188634-1aff-11f1-bf64-42dde27851f2","marx",["D",1772982116698],"deletedAt","legacyEnvVars",false,"privacy","public","httpPrivacy","description","Bookmark manager with tag filtering, backed by SQLite","imageUrl","f497980b-7fd3-43fe-9915-57490c62d759","pinnedFileId","e967a682-1aff-11f1-bf68-42dde27851f2","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","e32aedd8-e0da-4562-9eaa-0e87a5bf5ecc","tursoName","c01886341aff11f1bf6442dde27851f2","tursoHostname","c01886341aff11f1bf6442dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789518064818],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_107":103},"org",{"_99":98,"_100":101,"_102":103,"_18":55,"_104":105,"_106":48},"branch",{"_13":88,"_32":89,"_42":41,"_90":43,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":44,"_97":98},"isOwned",29,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","snptrs","handle","displayName","Sean","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ybGJINk9XVXlsZlFZSkFQdzBRRXpKYXFKMkUifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_32":44,"_37":158,"_46":-5,"_47":48,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":25,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":159,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":160,"_83":161,"_85":162,"_87":48},"tree",[153],"files",[153],"counts",{"_142":62,"_143":134,"_144":145,"_146":147,"_148":149},"contents",[130],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":131,"_32":132,"_30":57,"_133":-5,"_40":41,"_39":134,"_135":48,"_37":136,"_13":62,"_33":137,"_35":138,"_24":48,"_139":140,"_27":141},"e967a5b0-1aff-11f1-bf68-42dde27851f2","main.ts","parentId",2,"latest",["D",1772982185999],"http","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// --- Database helpers ---\n\nasync function getAllBookmarks() {\n const result = await sqlite.execute(`\n SELECT b.id, b.url, b.title, b.description, b.saved,\n GROUP_CONCAT(t.name) as tags\n FROM bookmarks b\n LEFT JOIN bookmark_tags bt ON b.id = bt.bookmark_id\n LEFT JOIN tags t ON bt.tag_id = t.id\n GROUP BY b.id\n ORDER BY b.saved DESC\n `);\n return result.rows.map(rowToBookmark);\n}\n\nasync function getBookmarksByTag(tagSlug: string) {\n const result = await sqlite.execute({\n sql: `\n SELECT b.id, b.url, b.title, b.description, b.saved,\n GROUP_CONCAT(t2.name) as tags\n FROM bookmarks b\n JOIN bookmark_tags bt ON b.id = bt.bookmark_id\n JOIN tags t ON bt.tag_id = t.id\n LEFT JOIN bookmark_tags bt2 ON b.id = bt2.bookmark_id\n LEFT JOIN tags t2 ON bt2.tag_id = t2.id\n WHERE LOWER(REPLACE(REPLACE(t.name, ' ', '-'), ':', '-')) = ?\n GROUP BY b.id\n ORDER BY b.saved DESC\n `,\n args: [tagSlug],\n });\n return result.rows.map(rowToBookmark);\n}\n\nasync function getAllTags() {\n const result = await sqlite.execute(`\n SELECT t.name, COUNT(bt.bookmark_id) as count\n FROM tags t\n JOIN bookmark_tags bt ON t.id = bt.tag_id\n GROUP BY t.id\n ORDER BY t.name COLLATE NOCASE\n `);\n return result.rows.map((row: any) => ({\n name: row.name,\n slug: slugify(row.name),\n count: row.count,\n }));\n}\n\nfunction rowToBookmark(row: any) {\n return {\n id: row.id,\n url: row.url,\n title: row.title,\n description: row.description,\n saved: row.saved,\n tags: row.tags ? row.tags.split(\",\") : [],\n };\n}\n\nfunction slugify(tag: string): string {\n return tag.toLowerCase().replace(/[^a-z0-9]+/g, \"-\").replace(/(^-|-$)/g, \"\");\n}\n\nfunction formatDate(isoDate: string): string {\n const d = new Date(isoDate);\n const day = d.getUTCDate();\n const month = d.toLocaleDateString(\"en-US\", { month: \"short\", timeZone: \"UTC\" });\n const year = d.getUTCFullYear();\n return `${day} ${month} ${year}`;\n}\n\n// --- Tag grouping (by first letter) ---\n\nfunction groupTagsByLetter(tags: { name: string; slug: string; count: number }[]) {\n const groups: Record = {};\n for (const tag of tags) {\n const letter = tag.name.charAt(0).toUpperCase();\n if (!groups[letter]) groups[letter] = [];\n groups[letter].push(tag);\n }\n return Object.keys(groups).sort().map((letter) => ({ letter, tags: groups[letter] }));\n}\n\n// --- HTML rendering ---\n\nfunction renderPage(bookmarks: any[], tags: any[], activeTag?: string) {\n const tagGroups = groupTagsByLetter(tags);\n\n return `\n\n\n \n \n Marx${activeTag ? ` – ${activeTag}` : \"\"}\n \n \n\n\n \n\n

\n \n\n

\n ${bookmarks.map(renderBookmarkItem).join(\"\\n\")}\n

\n\n`;\n}\n\nfunction renderBookmarkItem(bookmark: any): string {\n const tagsHtml = bookmark.tags.length\n ? `${bookmark.tags\n .map((t: string) => `#${t}`)\n .join(\" \")}`\n : \"\";\n\n const separator = bookmark.tags.length && bookmark.description ? ` | ` : \"\";\n const descHtml = bookmark.description ? `${escapeHtml(bookmark.description)}` : \"\";\n\n const metaLine = tagsHtml || descHtml\n ? `

${tagsHtml}${separator}${descHtml}

`\n : \"\";\n\n return `

\n \n $\"\"$ \n ${escapeHtml(bookmark.title || bookmark.url)}\n \n ${metaLine}\n

${formatDate(bookmark.saved)}

`;\n}\n\nfunction renderTagSidebar(tagGroups: any[], activeTag?: string): string {\n if (activeTag) {\n return `

Tags

${groupsHtml}

`;\n}\n\nfunction escapeHtml(str: string): string {\n return str.replace(/&/g, \"&\").replace(//g, \">\").replace(/\"/g, \""\");\n}\n\n// --- Import endpoint ---\n\nasync function handleImport(req: Request): Promise {\n const bookmarks: any[] = await req.json();\n\n // Collect unique tags\n const tagSet = new Set();\n for (const b of bookmarks) {\n for (const t of b.tags || []) tagSet.add(t);\n }\n\n // Insert tags\n for (const tag of tagSet) {\n await sqlite.execute({\n sql: \"INSERT OR IGNORE INTO tags (name) VALUES (?)\",\n args: [tag],\n });\n }\n\n // Get tag ID map\n const tagResult = await sqlite.execute(\"SELECT id, name FROM tags\");\n const tagIdMap = new Map();\n for (const row of tagResult.rows as any[]) {\n tagIdMap.set(row.name, row.id);\n }\n\n // Insert bookmarks\n for (const b of bookmarks) {\n const result = await sqlite.execute({\n sql: \"INSERT INTO bookmarks (url, title, description, saved) VALUES (?, ?, ?, ?)\",\n args: [b.url, b.title || \"\", b.description || \"\", b.saved],\n });\n const bookmarkId = result.lastInsertRowid;\n\n for (const tag of b.tags || []) {\n const tagId = tagIdMap.get(tag);\n if (tagId && bookmarkId) {\n await sqlite.execute({\n sql: \"INSERT OR IGNORE INTO bookmark_tags (bookmark_id, tag_id) VALUES (?, ?)\",\n args: [Number(bookmarkId), tagId],\n });\n }\n }\n }\n\n return new Response(JSON.stringify({ imported: bookmarks.length }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n}\n\n// --- Router ---\n\nexport default async function(req: Request): Promise {\n const url = new URL(req.url);\n const path = url.pathname;\n\n // Import API\n if (path === \"/api/import\" && req.method === \"POST\") {\n return handleImport(req);\n }\n\n // Tag page: /tags/{slug}/\n const tagMatch = path.match(/^\\/tags\\/([^/]+)\\/?$/);\n if (tagMatch) {\n const tagSlug = tagMatch[1];\n const [bookmarks, tags] = await Promise.all([getBookmarksByTag(tagSlug), getAllTags()]);\n const activeTag = tags.find((t) => t.slug === tagSlug)?.name || tagSlug;\n return new Response(renderPage(bookmarks, tags, activeTag), {\n headers: { \"Content-Type\": \"text/html\" },\n });\n }\n\n // Home page\n if (path === \"/\" || path === \"\") {\n const [bookmarks, tags] = await Promise.all([getAllBookmarks(), getAllTags()]);\n return new Response(renderPage(bookmarks, tags), {\n headers: { \"Content-Type\": \"text/html\" },\n });\n }\n\n return new Response(\"Not found\", { status: 404 });\n}\n","label","marxbookmarks",[132],"pulls","branches","forks",1,"envVars",{"_150":145,"_152":62},"connections",{"_150":62,"_151":62},"count","unfilledCount","emptyCount",{"_42":131,"_32":132,"_30":57,"_133":-5,"_40":41,"_39":134,"_135":48,"_37":154,"_13":62,"_33":137,"_35":138,"_24":48,"_139":140,"_155":156,"_27":157},["D",1772982185999],"children",[],[132],["D",1772982116698],["D",1789518064818],{"_99":98,"_107":103},{"_99":98,"_100":101,"_102":103,"_18":55,"_104":105,"_106":48},{"_13":88,"_32":89,"_42":41,"_90":43,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":44,"_97":98},"ctx",{"_81":-5,"_127":196,"_197":198,"_199":200,"_201":48,"_202":48,"_203":48,"_204":25,"_205":-5,"_206":-7,"_207":-7,"_208":62,"_209":48,"_210":48,"_211":-5,"_212":48,"_213":48,"_214":48,"_215":-5},"ENV",{"_167":168,"_169":170,"_171":89,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195},"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 · v3