My Bookmarks

${totalBookmarks} total bookmarks | Add Bookmark | Bookmarklet\n

\n\n

\n \n \n \n ${\n bookmarkRows || ''\n }\n \n

Title	Added	Summary	Actions
No bookmarks yet

\n\n ${\n totalPages > 1\n ? `\n

\n Showing ${offset + 1} to ${\n Math.min(offset + limit, totalBookmarks)\n } of ${totalBookmarks} bookmarks\n

\n ${\n page > 1\n ? `\n \n First\n \n \n Previous\n \n `\n : \"\"\n }\n \n ${\n Array.from({ length: Math.min(5, totalPages) }, (_, i) => {\n let pageNum;\n if (totalPages <= 5) {\n pageNum = i + 1;\n } else if (page <= 3) {\n pageNum = i + 1;\n } else if (page >= totalPages - 2) {\n pageNum = totalPages - 4 + i;\n } else {\n pageNum = page - 2 + i;\n }\n\n const isCurrentPage = pageNum === page;\n return `\n \n ${pageNum}\n \n `;\n }).join(\"\")\n }\n \n ${\n page < totalPages\n ? `\n \n Next\n \n \n Last\n \n `\n : \"\"\n }\n

\n `\n : \"\"\n }\n

\n \n \n `;\n\n return c.html(html);\n}\n\n// Add bookmark form page\nasync function handleAddBookmarkForm(c: any) {\n const html = `\n \n \n \n \n \n Add Bookmark\n \n \n \n

Add Bookmark

\n \n

\n\n

\n \n

\n \n \n `;\n\n return c.html(html);\n}\n\n// Delete confirmation page\nasync function handleDeleteConfirmation(c: any) {\n const url = c.req.query(\"url\");\n\n if (!url) {\n return c.redirect(\"/\");\n }\n\n // Get bookmark details for confirmation\n const result = await sqlite.execute(\n `SELECT url, title, summary FROM ${TABLE_NAME} WHERE url = ?`,\n [url],\n );\n\n if (!result.rows || result.rows.length === 0) {\n return c.html(\n `\n \n \n Bookmark Not Found\n \n \n \n \n

Bookmark Not Found

The bookmark you're trying to delete doesn't exist.

\n \n Back to Bookmarks\n \n

\n \n \n `,\n 404,\n );\n }\n\n const bookmark = result.rows[0];\n\n const html = `\n \n \n \n \n \n Delete Bookmark\n \n \n \n \n

Delete Bookmark

\n \n

\n\n

Confirm Deletion

Are you sure you want to delete this bookmark? This action cannot be undone.

\n \n

${bookmark[1] || \"Untitled\"}

${bookmark[0]}

\n ${bookmark[2] ? `

${bookmark[2]}

` : \"\"}\n

\n\n

\n \n \n Cancel\n \n

\n \n \n `;\n\n return c.html(html);\n}\n\n// Delete confirmation handler\nasync function handleDeleteConfirm(c: any) {\n const url = c.req.query(\"url\");\n\n if (!url) {\n return c.redirect(\"/\");\n }\n\n try {\n // Delete the bookmark\n const result = await sqlite.execute(\n `DELETE FROM ${TABLE_NAME} WHERE url = ?`,\n [url],\n );\n\n // Return success page\n return c.html(`\n \n \n Bookmark Deleted\n \n \n \n \n

Bookmark Deleted

The bookmark has been successfully removed.

\n \n Back to Bookmarks\n \n

\n \n \n \n `);\n } catch (error) {\n console.error(\"Error deleting bookmark:\", error);\n return c.html(\n `\n \n \n Delete Error\n \n \n \n \n

Error

Failed to delete bookmark: ${error.message}

\n \n Back to Bookmarks\n \n

\n \n \n `,\n 500,\n );\n }\n}\n\n// Add bookmark endpoint\nasync function handleAddBookmark(c: any) {\n const url = c.req.query(\"url\");\n const title = c.req.query(\"title\");\n const summary = c.req.query(\"summary\") || \"\";\n\n if (!url || !title) {\n return c.html(\n `\n \n \n

Error

URL and title are required.

\n Go back\n \n \n `,\n 400,\n );\n }\n\n try {\n // Check if URL already exists\n const existingResult = await sqlite.execute(\n `SELECT url FROM ${TABLE_NAME} WHERE url = ?`,\n [url],\n );\n\n if (existingResult.rows && existingResult.rows.length > 0) {\n // Update existing bookmark (don't update timestamp)\n await sqlite.execute(\n `UPDATE ${TABLE_NAME} SET title = ?, summary = ? WHERE url = ?`,\n [title, summary, url],\n );\n } else {\n // Insert new bookmark\n await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (url, title, summary) VALUES (?, ?, ?)`,\n [url, title, summary],\n );\n }\n\n // Return success page that closes the popup or redirects\n return c.html(`\n \n \n Bookmark Added\n \n \n \n

Bookmark Added!

\n ${title} has been saved to your bookmarks.\n

\n \n View All Bookmarks\n \n \n

\n \n \n \n `);\n } catch (error) {\n console.error(\"Error adding bookmark:\", error);\n return c.html(\n `\n \n \n

Error

Failed to add bookmark: ${error.message}

\n Go back\n \n \n `,\n 500,\n );\n }\n}\n\n// Find RSS feed page\nasync function handleFindRss(c: any) {\n const url = c.req.query(\"url\");\n\n if (!url) {\n return c.redirect(\"/\");\n }\n\n let feedUrl = \"\";\n let error = \"\";\n let loading = true;\n let recentArticles = [];\n\n try {\n feedUrl = await findFeed(url);\n\n // If we found a feed, try to fetch recent articles\n if (feedUrl) {\n try {\n recentArticles = await getRecentArticles(feedUrl);\n } catch (articleError) {\n console.log(\"Could not fetch articles:\", articleError.message);\n // Don't fail the whole page if we can't fetch articles\n }\n }\n\n loading = false;\n } catch (err) {\n error = err.message || \"Failed to find RSS feed\";\n loading = false;\n }\n\n const html = `\n \n \n \n \n \n \n \n \n \n \n

RSS Feed Discovery

\n \n

\n\n

Source URL

\n ${url}\n

\n\n ${\n loading\n ? `\n

Searching for RSS feeds...

\n `\n : error\n ? `\n

Error

${error}

\n `\n : feedUrl\n ? `\n

RSS Feed Found

\n Feed URL:\n

\n \n \n

\n \n View RSS Feed\n \n \n

\n \n ${\n recentArticles.length > 0\n ? `\n

No RSS Feed Found

No RSS or Atom feeds were discovered for this URL.

\n `\n }\n\n

\n\n \n \n \n `;\n\n return c.html(html);\n}\n\n// Subscribe to RSS feed endpoint\nasync function handleSubscribe(c: any) {\n const feedUrl = c.req.query(\"feedUrl\");\n const sourceUrl = c.req.query(\"sourceUrl\");\n\n if (!feedUrl) {\n return c.redirect(\"/\");\n }\n\n try {\n await addSubscription(feedUrl);\n\n return c.html(`\n \n \n Subscription Added\n \n \n \n \n \n

Subscription Added!

\n You have successfully subscribed to the RSS feed.\n

\n \n Back to Bookmarks\n \n

\n \n \n \n `);\n } catch (error) {\n console.error(\"Error adding subscription:\", error);\n return c.html(\n `\n \n \n Subscription Error\n \n \n \n \n \n

Error

Failed to add subscription: ${error.message}

\n \n Back to Bookmarks\n \n

\n \n \n `,\n 500,\n );\n }\n}\n\n// Utility functions\n\nasync function findFeed(url: string): Promise {\n const { getRssUrlsFromUrl } = await import(\"npm:rss-url-finder\");\n const feedUrls = await getRssUrlsFromUrl(url);\n let feedUrl = feedUrls[0]?.url ?? url;\n\n // Fix URL construction if the feed URL is relative\n if (!feedUrl.includes(\"http\")) {\n // Ensure proper URL joining\n const baseUrl = url.endsWith(\"/\") ? url.slice(0, -1) : url;\n const feedPath = feedUrl.startsWith(\"/\") ? feedUrl : \"/\" + feedUrl;\n feedUrl = baseUrl + feedPath;\n }\n\n console.log(feedUrl);\n return feedUrl;\n}\n\nasync function addSubscription(url: string) {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n let parser = new Parser({\n timeout: 5000,\n });\n console.log(\"getting feed\");\n let feedFile = await fetch(url);\n console.log(\"got feed file\");\n let feedText = await feedFile.text();\n console.log(\"got feed file text\");\n console.log(feedText);\n let feed = await parser.parseString(feedText);\n console.log(\"got feed\");\n const title = feed.title;\n console.log(title);\n\n await sqlite.execute({\n sql: `insert into rssSubscriptions(url, title) values (:feedUrl, :title)`,\n args: { feedUrl: url, title: title },\n });\n}\n\nasync function getRecentArticles(feedUrl: string) {\n try {\n const parser = new Parser();\n\n const feed = await parser.parseURL(feedUrl);\n\n const articles = [];\n const itemsToProcess = Math.min(3, feed.items?.length || 0);\n\n for (let i = 0; i < itemsToProcess; i++) {\n const item = feed.items[i];\n\n const title = item.title?.trim() || \"Untitled\";\n const link = item.link?.trim() || \"\";\n const description = item.contentSnippet || item.content || item.summary ||\n \"\";\n const pubDate = item.pubDate || item.isoDate || \"\";\n\n // Clean up description (limit length)\n const cleanDescription = description\n .replace(/\\s+/g, \" \") // Normalize whitespace\n .trim()\n .substring(0, 200) + (description.length > 200 ? \"...\" : \"\");\n\n // Format date\n let formattedDate = \"\";\n if (pubDate) {\n try {\n const date = new Date(pubDate);\n if (!isNaN(date.getTime())) {\n formattedDate = date.toLocaleDateString(\"en-US\", {\n year: \"numeric\",\n month: \"short\",\n day: \"numeric\",\n });\n }\n } catch (e) {\n formattedDate = pubDate.toString().substring(0, 20);\n }\n }\n\n articles.push({\n title: title,\n link: link,\n description: cleanDescription,\n pubDate: formattedDate,\n });\n }\n\n return articles;\n } catch (error) {\n console.error(\"Error fetching articles:\", error);\n throw error;\n }\n}\n\nexport default app.fetch;","deleted","label","children",[],[151],{"_103":171,"_95":172,"_152":173,"_154":-5,"_155":137,"_156":174,"_157":158,"_105":175,"_100":32,"_161":176,"_163":177,"_165":22,"_166":-5,"_167":178,"_98":179},"64573e2c-844f-11f0-87b3-0224a6c84d84","main_fixed.tsx","64573f08-844f-11f0-87b3-0224a6c84d84",68,["D",1756413696912],"script","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport moment from \"https://esm.sh/moment-timezone@0.5.43\";\nimport Parser from \"npm:rss-parser\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err) => Promise.reject(err));\n\n// Database setup\nconst TABLE_NAME = \"bookmarks\";\n\n// Initialize database table\nasync function initDatabase() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n url TEXT PRIMARY KEY,\n added DATETIME DEFAULT CURRENT_TIMESTAMP,\n title TEXT NOT NULL,\n summary TEXT\n )`);\n}\n\n// Initialize database on startup\nawait initDatabase();\n\n// Simple basic auth middleware\nfunction simpleBasicAuth(username: string, password: string) {\n return async (c: any, next: any) => {\n const auth = c.req.header(\"Authorization\");\n\n if (!auth || !auth.startsWith(\"Basic \")) {\n return new Response(\"Unauthorized\", {\n status: 401,\n headers: {\n \"WWW-Authenticate\": 'Basic realm=\"Bookmarks\"',\n },\n });\n }\n\n const credentials = atob(auth.slice(6));\n const [user, pass] = credentials.split(\":\");\n\n if (user !== username || pass !== password) {\n return new Response(\"Unauthorized\", {\n status: 401,\n headers: {\n \"WWW-Authenticate\": 'Basic realm=\"Bookmarks\"',\n },\n });\n }\n\n await next();\n };\n}\n\n// Apply auth to all routes\napp.use(\"*\", simpleBasicAuth(Deno.env.get(\"USER\"), Deno.env.get(\"PASS\")));\n\n// Route definitions\napp.get(\"/\", handleHomePage);\napp.get(\"/form\", handleAddBookmarkForm);\napp.get(\"/bookmarklet\", handleBookmarkletPage);\napp.get(\"/delete\", handleDeleteConfirmation);\napp.get(\"/delete/confirm\", handleDeleteConfirm);\napp.get(\"/add\", handleAddBookmark);\napp.get(\"/find-rss\", handleFindRss);\napp.get(\"/subscribe\", handleSubscribe);\n\n// Route handler functions\n\n// Home page - displays all bookmarks with pagination\nasync function handleHomePage(c: any) {\n const page = parseInt(c.req.query(\"page\") || \"1\");\n const limit = 25;\n const offset = (page - 1) * limit;\n\n // Get total count for pagination\n const countResult = await sqlite.execute(\n `SELECT COUNT(*) as total FROM ${TABLE_NAME}`\n );\n const totalBookmarks = countResult.rows[0].total;\n const totalPages = Math.ceil(totalBookmarks / limit);\n\n // Get bookmarks for current page\n const result = await sqlite.execute(\n `SELECT url, added, title, summary FROM ${TABLE_NAME} ORDER BY added DESC LIMIT ? OFFSET ?`,\n [limit, offset]\n );\n\n // sqlite.execute returns an object with rows property\n const bookmarks = result.rows || [];\n\n const bookmarkRows = bookmarks.map((bookmark) => `\n \n \n \n ${bookmark[2] || bookmark[0]}\n \n \n \n ${moment.tz(bookmark[1], \"Americas/New_York\").fromNow()}\n \n \n ${bookmark[3] || \"\"}\n \n \n \n 📡\n \n \n \n \n ❌\n \n \n \n `).join(\"\");\n\n const html = `\n \n \n \n \n \n Bookmarks\n \n \n \n

My Bookmarks

\n ${totalBookmarks} total bookmarks\n

\n \n

\n\n \n

\n \n \n \n \n \n \n \n \n \n \n \n ${\n bookmarkRows ||\n ''\n }\n \n

\n Title\n	\n Added\n	\n Summary\n	\n RSS Feed\n	\n Delete\n
No bookmarks yet

\n\n \n ${totalPages > 1 ? `\n

\n Showing ${offset + 1} to ${Math.min(offset + limit, totalBookmarks)} of ${totalBookmarks} bookmarks\n

\n ${page > 1 ? `\n \n First\n \n \n Previous\n \n ` : ''}\n \n ${Array.from({length: Math.min(5, totalPages)}, (_, i) => {\n let pageNum;\n if (totalPages <= 5) {\n pageNum = i + 1;\n } else if (page <= 3) {\n pageNum = i + 1;\n } else if (page >= totalPages - 2) {\n pageNum = totalPages - 4 + i;\n } else {\n pageNum = page - 2 + i;\n }\n \n const isCurrentPage = pageNum === page;\n return `\n \n ${pageNum}\n \n `;\n }).join('')}\n \n ${page < totalPages ? `\n \n Next\n \n \n Last\n \n ` : ''}\n

\n ` : ''}\n

\n \n \n `;\n\n return c.html(html);\n}\n\n// Add bookmark form page\nasync function handleAddBookmarkForm(c: any) {\n const html = `\n \n \n \n \n \n Add Bookmark\n \n \n \n

Add Bookmark

\n \n

\n\n

\n \n

\n \n \n `;\n\n return c.html(html);\n}\n\n// Bookmarklet page\nasync function handleBookmarkletPage(c: any) {\n const baseUrl = c.req.url.split('/')[0] + '//' + c.req.url.split('/')[2];\n \n const html = `\n \n \n \n \n \n Bookmarklet\n \n \n \n

Bookmarklet

\n \n

\n\n

Quick Add Bookmarklet

\n Drag this button to your bookmarks bar to quickly add pages. If you have text selected on the page, it will be used as the summary:\n

\n \n

\n \n 📚 Add to Bookmarks\n \n

← Drag this to your bookmarks bar

\n\n

How to Use

\n 1\n

\n Install: Drag the \"📚 Add to Bookmarks\" button above to your browser's bookmarks bar (also called favorites bar).\n

\n 2\n

\n Navigate: Go to any webpage you want to bookmark.\n

\n 3\n

\n Select (optional): Highlight any text on the page that you want to use as the summary.\n

\n 4\n

\n Click: Click the bookmarklet in your bookmarks bar.\n

\n 5\n

\n Done: The page will be added to your bookmarks with the selected text as the summary. The popup will close automatically.\n

\n\n

💡 Pro Tips:

• The bookmarklet works on any website
• Selected text becomes the summary automatically
• If no text is selected, the summary will be empty
• The popup closes automatically after adding the bookmark

\n \n \n `;\n\n return c.html(html);\n}\n\n// Delete confirmation page\nasync function handleDeleteConfirmation(c: any) {\n const url = c.req.query(\"url\");\n \n if (!url) {\n return c.redirect(\"/\");\n }\n\n // Get bookmark details for confirmation\n const result = await sqlite.execute(\n `SELECT url, title, summary FROM ${TABLE_NAME} WHERE url = ?`,\n [url]\n );\n\n if (!result.rows || result.rows.length === 0) {\n return c.html(`\n \n \n Bookmark Not Found\n \n \n \n

❌ Bookmark Not Found

The bookmark you're trying to delete doesn't exist.

\n \n Back to Bookmarks\n \n

\n \n \n `, 404);\n }\n\n const bookmark = result.rows[0];\n \n const html = `\n \n \n \n \n \n Delete Bookmark\n \n \n \n

Delete Bookmark

\n \n

\n\n

⚠️ Confirm Deletion

Are you sure you want to delete this bookmark? This action cannot be undone.

\n \n

${bookmark[1] || \"Untitled\"}

${bookmark[0]}

\n ${bookmark[2] ? `

${bookmark[2]}

` : ''}\n

\n\n

\n \n \n Cancel\n \n

\n \n \n `;\n\n return c.html(html);\n}\n\n// Delete confirmation handler\nasync function handleDeleteConfirm(c: any) {\n const url = c.req.query(\"url\");\n \n if (!url) {\n return c.redirect(\"/\");\n }\n\n try {\n // Delete the bookmark\n const result = await sqlite.execute(\n `DELETE FROM ${TABLE_NAME} WHERE url = ?`,\n [url]\n );\n\n // Return success page\n return c.html(`\n \n \n Bookmark Deleted\n \n \n \n

✅ Bookmark Deleted

The bookmark has been successfully removed.

\n \n Back to Bookmarks\n \n

\n \n \n \n `);\n } catch (error) {\n console.error(\"Error deleting bookmark:\", error);\n return c.html(`\n \n \n Delete Error\n \n \n \n

❌ Error

Failed to delete bookmark: ${error.message}

\n \n Back to Bookmarks\n \n

\n \n \n `, 500);\n }\n}\n\n// Add bookmark endpoint\nasync function handleAddBookmark(c: any) {\n const url = c.req.query(\"url\");\n const title = c.req.query(\"title\");\n const summary = c.req.query(\"summary\") || \"\";\n\n if (!url || !title) {\n return c.html(\n `\n \n \n

Error

URL and title are required.

✅ Bookmark Added!

\n ${title} has been saved to your bookmarks.\n

\n \n View All Bookmarks\n \n \n

\n \n \n \n `);\n } catch (error) {\n console.error(\"Error adding bookmark:\", error);\n return c.html(\n `\n \n \n

Error

Failed to add bookmark: ${error.message}

\n Go back\n \n \n `,\n 500,\n );\n }\n}\n\n// Find RSS feed page\nasync function handleFindRss(c: any) {\n const url = c.req.query(\"url\");\n \n if (!url) {\n return c.redirect(\"/\");\n }\n\n let feedUrl = \"\";\n let error = \"\";\n let loading = true;\n let recentArticles = [];\n\n try {\n feedUrl = await findFeed(url);\n \n // If we found a feed, try to fetch recent articles\n if (feedUrl) {\n try {\n recentArticles = await getRecentArticles(feedUrl);\n } catch (articleError) {\n console.log(\"Could not fetch articles:\", articleError.message);\n // Don't fail the whole page if we can't fetch articles\n }\n }\n \n loading = false;\n } catch (err) {\n error = err.message || \"Failed to find RSS feed\";\n loading = false;\n }\n\n const html = `\n \n \n \n \n \n RSS Feed Discovery\n \n \n \n \n

RSS Feed Discovery

\n \n

\n\n

Source URL

\n ${url}\n

\n\n ${loading ? `\n

Searching for RSS feeds...

\n ` : error ? `\n

❌ Error

${error}

\n ` : feedUrl ? `\n

📡 RSS Feed Found

\n Feed URL:\n

\n \n \n

\n \n 📡 View RSS Feed\n \n \n

\n \n ${recentArticles.length > 0 ? `\n

📰 Recent Articles

\n ${recentArticles.map(article => `\n

\n \n ${article.title}\n \n

\n ${article.pubDate ? `\n

${article.pubDate}

\n ` : ''}\n ${article.description ? `\n

${article.description}

\n ` : ''}\n

\n `).join('')}\n

\n 💡 Subscribe to this RSS feed to get notified of new articles automatically!\n

\n ` : ''}\n ` : `\n

⚠️ No RSS Feed Found

No RSS or Atom feeds were discovered for this URL.

\n `}\n\n

💡 What is RSS?

\n RSS (Really Simple Syndication) is a web feed format that allows you to stay updated with your favorite websites. \n Instead of manually checking websites for new content, you can subscribe to their RSS feeds using a feed reader.\n

\n Popular RSS readers:\n

• Feedly - Web-based feed reader
• Inoreader - Advanced feed reader
• NewsBlur - Social feed reader

\n\n \n \n \n `;\n\n return c.html(html);\n}\n\n// Subscribe to RSS feed endpoint\nasync function handleSubscribe(c: any) {\n const feedUrl = c.req.query(\"feedUrl\");\n const sourceUrl = c.req.query(\"sourceUrl\");\n \n if (!feedUrl) {\n return c.redirect(\"/\");\n }\n\n try {\n await addSubscription(feedUrl);\n \n return c.html(`\n \n \n Subscription Added\n \n \n \n

✅ Subscription Added!

\n You have successfully subscribed to the RSS feed.\n

\n \n Back to Bookmarks\n \n

\n \n \n \n `);\n } catch (error) {\n console.error(\"Error adding subscription:\", error);\n return c.html(`\n \n \n Subscription Error\n \n \n \n

❌ Error

Failed to add subscription: ${error.message}

\n \n Back to Bookmarks\n \n

\n \n \n `, 500);\n }\n}\n\n// Utility functions\n\nasync function findFeed(url: string): Promise {\n const { getRssUrlsFromUrl } = await import(\"npm:rss-url-finder\");\n const feedUrls = await getRssUrlsFromUrl(url);\n let feedUrl = feedUrls[0]?.url ?? url;\n \n // Fix URL construction if the feed URL is relative\n if (!feedUrl.includes(\"http\")) {\n // Ensure proper URL joining\n const baseUrl = url.endsWith('/') ? url.slice(0, -1) : url;\n const feedPath = feedUrl.startsWith('/') ? feedUrl : '/' + feedUrl;\n feedUrl = baseUrl + feedPath;\n }\n \n console.log(feedUrl);\n return feedUrl;\n}\n\nasync function addSubscription(url: string) {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n let parser = new Parser({\n timeout: 5000,\n });\n console.log(\"getting feed\");\n let feedFile = await fetch(url);\n console.log(\"got feed file\");\n let feedText = await feedFile.text();\n console.log(\"got feed file text\");\n console.log(feedText);\n let feed = await parser.parseString(feedText);\n console.log(\"got feed\");\n const title = feed.title;\n console.log(title);\n\n await sqlite.execute({\n sql: `insert into rssSubscriptions(url, title) values (:feedUrl, :title)`,\n args: { feedUrl: url, title: title },\n });\n}\n\nasync function getRecentArticles(feedUrl: string) {\n try {\n const parser = new Parser();\n \n const feed = await parser.parseURL(feedUrl);\n \n const articles = [];\n const itemsToProcess = Math.min(3, feed.items?.length || 0);\n \n for (let i = 0; i < itemsToProcess; i++) {\n const item = feed.items[i];\n \n const title = item.title?.trim() || 'Untitled';\n const link = item.link?.trim() || '';\n const description = item.contentSnippet || item.content || item.summary || '';\n const pubDate = item.pubDate || item.isoDate || '';\n \n // Clean up description (limit length)\n const cleanDescription = description\n .replace(/\\s+/g, ' ') // Normalize whitespace\n .trim()\n .substring(0, 200) + (description.length > 200 ? '...' : '');\n \n // Format date\n let formattedDate = '';\n if (pubDate) {\n try {\n const date = new Date(pubDate);\n if (!isNaN(date.getTime())) {\n formattedDate = date.toLocaleDateString('en-US', {\n year: 'numeric',\n month: 'short',\n day: 'numeric'\n });\n }\n } catch (e) {\n formattedDate = pubDate.toString().substring(0, 20);\n }\n }\n \n articles.push({\n title: title,\n link: link,\n description: cleanDescription,\n pubDate: formattedDate\n });\n }\n \n return articles;\n } catch (error) {\n console.error('Error fetching articles:', error);\n throw error;\n }\n}\n\nexport default app.fetch;",[],[172],{"_103":181,"_95":182,"_152":183,"_154":-5,"_155":137,"_156":184,"_157":158,"_105":185,"_100":186,"_161":162,"_163":187,"_165":22,"_166":-5,"_167":188,"_98":189},"6c99ee66-8352-11f0-91dd-0224a6c84d84","migrate_notes.ts","3c99e644-8352-11f0-929d-0224a6c84d84",37,["D",1756305048094],5,"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// One-time migration script to parse LINK items from notes_app table\nasync function migrateNotesData() {\n const BOOKMARKS_TABLE = \"bookmarks\";\n const NOTES_TABLE = \"notes_app\";\n \n console.log(\"Starting migration from notes_app LINK items to bookmarks...\");\n \n try {\n // Get all LINK items from notes_app\n console.log(\"Fetching all LINK items from notes_app...\");\n const linkNotes = await sqlite.execute(`SELECT * FROM ${NOTES_TABLE} WHERE note LIKE 'LINK%'`);\n \n if (!linkNotes.rows || linkNotes.rows.length === 0) {\n console.log(\"No LINK items found in notes_app table\");\n return;\n }\n \n console.log(`Found ${linkNotes.rows.length} LINK items to process`);\n \n // Ensure bookmarks table exists\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${BOOKMARKS_TABLE} (\n url TEXT PRIMARY KEY,\n added DATETIME DEFAULT CURRENT_TIMESTAMP,\n title TEXT NOT NULL,\n summary TEXT\n )`);\n \n let successCount = 0;\n let skipCount = 0;\n let errorCount = 0;\n \n // Process each LINK note\n for (const note of linkNotes.rows) {\n const content = note.note;\n \n if (!content || !content.startsWith('LINK')) {\n console.log(`Skipping non-LINK content`);\n skipCount++;\n continue;\n }\n \n try {\n // Split content by newlines (handle both \\r\\n and \\n)\n const lines = content.split(/\\r?\\n/);\n \n if (lines.length < 3) {\n console.log(`Skipping LINK item with insufficient lines:`, lines);\n skipCount++;\n continue;\n }\n \n // Parse the structure:\n // Line 0: \"LINK\"\n // Line 1: URL\n // Line 2: Title\n // Line 3+: Summary (everything after line 2)\n \n const url = lines[1]?.trim();\n const title = lines[2]?.trim();\n const summaryLines = lines.slice(3).filter(line => line.trim() !== ''); // Remove empty lines\n const summary = summaryLines.join('\\n').trim();\n \n if (!url || !title) {\n console.log(`Skipping LINK item with missing url or title:`, { url, title });\n skipCount++;\n continue;\n }\n \n // Basic URL validation\n if (!url.startsWith('http://') && !url.startsWith('https://')) {\n console.log(`Skipping invalid URL: ${url}`);\n skipCount++;\n continue;\n }\n \n // Check if URL already exists\n const existing = await sqlite.execute(\n `SELECT url FROM ${BOOKMARKS_TABLE} WHERE url = ?`,\n [url]\n );\n \n if (existing.rows && existing.rows.length > 0) {\n console.log(`Skipping duplicate URL: ${url}`);\n skipCount++;\n continue;\n }\n \n // Insert new bookmark\n await sqlite.execute(\n `INSERT INTO ${BOOKMARKS_TABLE} (url, title, summary) VALUES (?, ?, ?)`,\n [url, title, summary]\n );\n \n successCount++;\n console.log(`✅ Migrated: ${title} (${url})`);\n if (summary) {\n console.log(` Summary: ${summary.substring(0, 100)}${summary.length > 100 ? '...' : ''}`);\n }\n \n } catch (error) {\n console.error(`❌ Error processing LINK item:`, { content: content.substring(0, 100) + '...', error: error.message });\n errorCount++;\n }\n }\n \n console.log(\"\\n=== Migration Complete ===\");\n console.log(`✅ Successfully migrated: ${successCount} bookmarks`);\n console.log(`⏭️ Skipped (duplicates/invalid): ${skipCount} records`);\n console.log(`❌ Errors: ${errorCount} records`);\n console.log(`📊 Total LINK items processed: ${linkNotes.rows.length} records`);\n \n // Show sample of migrated data\n console.log(\"\\nSample of newly migrated bookmarks:\");\n const sampleBookmarks = await sqlite.execute(`SELECT title, url, summary FROM ${BOOKMARKS_TABLE} ORDER BY added DESC LIMIT 5`);\n console.log(sampleBookmarks.rows);\n \n } catch (error) {\n console.error(\"Migration failed:\", error);\n throw error;\n }\n}\n\n// Run the migration\nexport default async function() {\n try {\n await migrateNotesData();\n return new Response(\"Notes migration completed successfully! Check the logs for details.\", {\n headers: { \"Content-Type\": \"text/plain\" }\n });\n } catch (error) {\n console.error(\"Notes migration script failed:\", error);\n return new Response(`Notes migration failed: ${error.message}`, {\n status: 500,\n headers: { \"Content-Type\": \"text/plain\" }\n });\n }\n}",[],[182],{"_103":191,"_95":99,"_152":192,"_154":-5,"_155":137,"_156":193,"_157":158,"_105":194,"_100":195,"_161":162,"_163":196,"_165":22,"_166":-5,"_167":197,"_98":198},"7d7bc3b8-8351-11f0-ab80-0224a6c84d84","71194438-8351-11f0-9eec-0224a6c84d84",31,["D",1756304646919],2,"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// One-time migration script to copy data from pinboardArchive to bookmarks table\nasync function migratePinboardData() {\n const BOOKMARKS_TABLE = \"bookmarks\";\n const PINBOARD_TABLE = \"pinboardArchive\";\n \n console.log(\"Starting migration from pinboardArchive to bookmarks...\");\n \n try {\n // First, let's see what's in the pinboardArchive table\n console.log(\"Checking pinboardArchive table structure...\");\n const pinboardData = await sqlite.execute(`SELECT * FROM ${PINBOARD_TABLE} LIMIT 5`);\n console.log(\"Sample pinboard data:\", pinboardData);\n \n // Get all data from pinboardArchive\n console.log(\"Fetching all pinboard data...\");\n const allPinboardData = await sqlite.execute(`SELECT title, url, description FROM ${PINBOARD_TABLE}`);\n \n if (!allPinboardData.rows || allPinboardData.rows.length === 0) {\n console.log(\"No data found in pinboardArchive table\");\n return;\n }\n \n console.log(`Found ${allPinboardData.rows.length} records to migrate`);\n \n // Ensure bookmarks table exists\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${BOOKMARKS_TABLE} (\n url TEXT PRIMARY KEY,\n added DATETIME DEFAULT CURRENT_TIMESTAMP,\n title TEXT NOT NULL,\n summary TEXT\n )`);\n \n let successCount = 0;\n let skipCount = 0;\n let errorCount = 0;\n \n // Insert each record into bookmarks table\n for (const row of allPinboardData.rows) {\n const title = row.title;\n const url = row.url;\n const description = row.description;\n \n if (!url || !title) {\n console.log(`Skipping record with missing url or title:`, { title, url });\n skipCount++;\n continue;\n }\n \n try {\n // Check if URL already exists\n const existing = await sqlite.execute(\n `SELECT url FROM ${BOOKMARKS_TABLE} WHERE url = ?`,\n [url]\n );\n \n if (existing.rows && existing.rows.length > 0) {\n console.log(`Skipping duplicate URL: ${url}`);\n skipCount++;\n continue;\n }\n \n // Insert new bookmark\n await sqlite.execute(\n `INSERT INTO ${BOOKMARKS_TABLE} (url, title, summary) VALUES (?, ?, ?)`,\n [url, title, description || \"\"]\n );\n \n successCount++;\n console.log(`✅ Migrated: ${title}`);\n \n } catch (error) {\n console.error(`❌ Error migrating record:`, { title, url, error: error.message });\n errorCount++;\n }\n }\n \n console.log(\"\\n=== Migration Complete ===\");\n console.log(`✅ Successfully migrated: ${successCount} bookmarks`);\n console.log(`⏭️ Skipped (duplicates/invalid): ${skipCount} records`);\n console.log(`❌ Errors: ${errorCount} records`);\n console.log(`📊 Total processed: ${allPinboardData.rows.length} records`);\n \n // Show sample of migrated data\n console.log(\"\\nSample of migrated bookmarks:\");\n const sampleBookmarks = await sqlite.execute(`SELECT title, url FROM ${BOOKMARKS_TABLE} LIMIT 5`);\n console.log(sampleBookmarks.rows);\n \n } catch (error) {\n console.error(\"Migration failed:\", error);\n throw error;\n }\n}\n\n// Run the migration\nexport default async function() {\n try {\n await migratePinboardData();\n return new Response(\"Migration completed successfully! Check the logs for details.\", {\n headers: { \"Content-Type\": \"text/plain\" }\n });\n } catch (error) {\n console.error(\"Migration script failed:\", error);\n return new Response(`Migration failed: ${error.message}`, {\n status: 500,\n headers: { \"Content-Type\": \"text/plain\" }\n });\n }\n}",[],[99],"files",[149,170,180,190],"counts",{"_203":32,"_204":205,"_206":32,"_207":208},"pulls","branches",1,"forks","envVars",{"_209":195,"_210":32},"count","emptyCount","contents",[],"file",{"_103":191,"_155":137,"_152":192,"_95":99,"_163":196,"_161":162,"_100":195,"_154":-5,"_105":215,"_156":193,"_166":-5,"_98":216},["D",1756304646919],[99],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.code.$",{"_93":94,"_95":96,"_97":43,"_100":-7,"_98":99,"_101":225,"_147":230,"_199":243,"_213":244,"_211":247,"_248":-5,"_249":-5,"_250":-5,"_251":-5,"_252":253},{"_103":104,"_95":96,"_105":226,"_107":-5,"_108":22,"_109":110,"_111":-5,"_112":-5,"_14":113,"_114":-5,"_115":22,"_116":-5,"_117":32,"_16":118,"_119":120,"_121":120,"_122":123,"_124":123,"_125":123,"_126":120,"_127":120,"_23":227,"_131":228,"_134":229,"_146":22},["D",1756302790583],{"_93":94,"_129":130},{"_93":94,"_133":130},{"_100":136,"_95":43,"_103":137,"_138":104,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":96,"_145":94},[231,234,237,240],{"_103":150,"_95":151,"_152":153,"_154":-5,"_155":137,"_156":136,"_157":158,"_105":159,"_100":160,"_161":162,"_163":164,"_165":22,"_166":-5,"_167":232,"_98":233},[],[151],{"_103":171,"_95":172,"_152":173,"_154":-5,"_155":137,"_156":174,"_157":158,"_105":175,"_100":32,"_161":176,"_163":177,"_165":22,"_166":-5,"_167":235,"_98":236},[],[172],{"_103":181,"_95":182,"_152":183,"_154":-5,"_155":137,"_156":184,"_157":158,"_105":185,"_100":186,"_161":162,"_163":187,"_165":22,"_166":-5,"_167":238,"_98":239},[],[182],{"_103":191,"_95":99,"_152":192,"_154":-5,"_155":137,"_156":193,"_157":158,"_105":194,"_100":195,"_161":162,"_163":196,"_165":22,"_166":-5,"_167":241,"_98":242},[],[99],[231,234,237,240],{"_103":191,"_155":137,"_152":192,"_95":99,"_163":196,"_161":162,"_100":195,"_154":-5,"_105":245,"_156":193,"_166":-5,"_98":246},["D",1756304646919],[99],[],"upstream","pull","ahead","behind","templates",[],"actionData","errors"]

flymaster

bookmarks