No Data Found

No entries found in the pins table.

\n \n \n `, {\n headers: { \"Content-Type\": \"text/html\" }\n });\n }\n\n const row = result.rows[0];\n \n // Extract data from the known column structure\n const id = row[0] || \"\";\n const url = row[1] || \"#\";\n const title = row[2] || \"Untitled\";\n const description = row[3] || \"\";\n const tags = row[4] || \"\";\n const added = row[5] || \"\";\n const updated = row[6] || \"\";\n const hash = row[7] || \"\";\n \n // Parse tags (assuming they're space-separated)\n const tagList = tags && tags !== \"untagged\" ? String(tags).split(/\\s+/).map(tag => tag.trim()).filter(tag => tag) : [];\n \n // Convert added date to Unix timestamp for Pinboard URL\n let pinboardUrl = null;\n let displayDate = added;\n \n if (added) {\n try {\n let addedDate;\n \n // Check if it's already a Unix timestamp (number or numeric string)\n if (!isNaN(Number(added))) {\n const timestamp = Number(added);\n // If it's in milliseconds (13 digits), convert to seconds\n addedDate = timestamp > 9999999999 ? new Date(timestamp) : new Date(timestamp * 1000);\n } else {\n // Parse as date string\n addedDate = new Date(added);\n }\n \n // Format display date\n displayDate = addedDate.toISOString().slice(0, 19).replace('T', ' ');\n \n const unixTimestamp = Math.floor(addedDate.getTime() / 1000) + 1; // Add 1 as requested\n pinboardUrl = `https://pinboard.in/u:flymaster/before:${unixTimestamp}`;\n } catch (e) {\n // If date parsing fails, fall back to search\n pinboardUrl = `https://pinboard.in/search/u:flymaster/?query=${encodeURIComponent(url)}`;\n }\n }\n\n const html = `\n \n \n \n Random Pinboard Archive\n \n \n \n \n

\n \n ${escapeHtml(title)}\n \n

\n \n ${escapeHtml(url)}\n \n ${displayDate ? `Added: ${escapeHtml(displayDate)}` : ''}\n ${pinboardUrl ? `\n \n \n 📌 View on Pinboard\n \n \n ` : ''}\n \n \n ✏️ Edit on Pinboard\n \n \n

\n\n ${description ? `\n

Description

${escapeHtml(description)}

\n ` : ''}\n\n ${tagList.length > 0 ? `\n

Preview

\n Note: Some websites may not display in the iframe due to security policies. \n If the preview doesn't load, use the \"Open in New Tab\" button below.\n

\n \n

\n \n 🔗 Open in New Tab\n \n

\n \n \n

\n \n \n `;\n\n return new Response(html, {\n headers: { \"Content-Type\": \"text/html\" }\n });\n\n } catch (error) {\n console.error(\"Database error:\", error);\n \n return new Response(`\n \n \n \n Error - Random Pinboard Archive\n \n \n \n

Error

Failed to fetch data from the pins table.

Error: ${escapeHtml(error.message)}

\n \n Try Again\n \n

\n \n \n `, {\n status: 500,\n headers: { \"Content-Type\": \"text/html\" }\n });\n }\n}\n\n// Helper function to escape HTML to prevent XSS\nfunction escapeHtml(text: string | null | undefined): string {\n if (!text) return '';\n return String(text)\n .replace(/&/g, '&')\n .replace(//g, '>')\n .replace(/\"/g, '"')\n .replace(/'/g, ''');\n}","deleted","label","emvee-pins","children",[],[150],"files",[148],"counts",{"_174":32,"_175":176,"_177":32,"_178":179},"pulls","branches",1,"forks","envVars",{"_180":32,"_181":32},"count","emptyCount","contents",[184],{"_102":149,"_95":150,"_151":152,"_153":-5,"_154":136,"_155":135,"_156":157,"_104":185,"_99":159,"_160":161,"_162":163,"_164":22,"_165":166,"_98":186},["D",1749054393060],[150],"file","upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name._index",{"_93":94,"_95":96,"_97":-7,"_99":-7,"_100":196,"_182":201,"_204":-7,"_205":-5,"_206":-5,"_170":207,"_211":212,"_213":-5,"_214":-5},{"_102":103,"_95":96,"_104":197,"_106":-5,"_107":22,"_108":109,"_110":-5,"_111":-5,"_14":112,"_113":-5,"_114":22,"_115":-5,"_116":32,"_16":117,"_118":119,"_120":119,"_121":122,"_123":122,"_124":122,"_125":119,"_126":119,"_23":198,"_130":199,"_133":200,"_145":22},["D",1748979146595],{"_93":94,"_128":129},{"_93":94,"_132":129},{"_99":135,"_95":43,"_102":136,"_137":103,"_138":-5,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":96,"_144":94},[202],{"_102":149,"_95":150,"_151":152,"_153":-5,"_154":136,"_155":135,"_156":157,"_104":185,"_99":159,"_160":161,"_162":163,"_164":22,"_165":166,"_98":203},[150],"readme","upstream","pull",[208],{"_102":149,"_95":150,"_151":152,"_153":-5,"_154":136,"_155":135,"_156":157,"_104":158,"_99":159,"_160":161,"_162":163,"_164":22,"_165":166,"_167":209,"_98":210},[],[150],"previews",[208],"ahead","behind","actionData","errors"]

No Data Found

Description

Tags

Preview

Error

flymaster

pinboardviewer