\" + (page * 10 + i + 1) + \". \" + bookmarks.rows[i][0]\n + \"

\";\n }\n var pagination = \"

\";\n if (page > 0) {\n pagination += \" < prev \";\n }\n if (page < pagesCount) {\n pagination += \" next > \";\n }\n pagination += \"

\";\n const html = `\n \n Michael & Kelly Bookmarks\n \n \n \n

Michael & Kelly Bookmarks

`\n + bookmarksList\n + pagination + `\n `;\n return new Response(\n html,\n {\n headers: {\n \"Content-Type\": \"text/html\",\n },\n },\n );\n});\n\napp.get(\"/save\", async (c) => {\n const id = c.req.query(\"id\");\n const secret = c.req.query(\"secret\");\n const title = c.req.query(\"t\");\n const url = c.req.query(\"u\");\n if (!id && !secret) {\n return c.text(\"Authentication details (ID/Secret) missing!\");\n }\n if (id != Deno.env.get(\"bookmarks_client_id\") || secret != Deno.env.get(\"bookmarks_client_secret\")) {\n return c.text(\"Unauthorized!\");\n }\n if (!url) {\n return c.text(\"URL missing!\");\n }\n const create_table = await sqlite.execute(\n \"CREATE TABLE IF NOT EXISTS bookmarks (title TEXT, url TEXT, created_at DATETIME DEFAULT CURRENT_TIMESTAMP)\",\n );\n const res = await sqlite.execute({\n sql: `insert into bookmarks (title, url) values (:title, :url)`,\n args: { title: title, url: url },\n });\n return c.text(\"Saved!\");\n});\n\napp.get(\"/api/bookmarks\", async (c) => {\n var baseUrl = c.req.url;\n var page = parseInt(c.req.query(\"page\") || \"0\");\n var offset = 0;\n if (page && page > 0) {\n offset = page * 10;\n }\n var bookmarks = await sqlite.execute({\n sql: \"select title, url from bookmarks order by created_at desc limit 10 offset :offset\",\n args: { offset: offset },\n });\n\n var totalBookmarkRows = await sqlite.execute(\"select count(1) from bookmarks order by created_at desc\");\n var totalBookmarks = parseInt(totalBookmarkRows.rows[0][0].toString());\n var pagesCount = Math.floor(\n ((totalBookmarks % 10) == 0 && totalBookmarks / 10 > 0)\n ? ((totalBookmarks / 10) - 1)\n : (totalBookmarks / 10),\n );\n let response = {\n prev: page > 0 ? baseUrl + \"?page=\" + (page - 1) : null,\n next: page < pagesCount ? baseUrl + \"?page=\" + (page + 1) : null,\n data: bookmarks.rows.map(b => {\n return {\n title: b[0],\n url: b[1],\n };\n }),\n };\n\n return c.json(response);\n});\n\nexport default app.fetch;","label",[67],"89bd9a2a-26db-11f0-a5b3-569c3dd06744",["D",1715129569752],"# A minimal bookmarking tool\n\nThis allows you to bookmark links and view them later. Completely powered by ValTown and SQLite.\n\n### To set this up for yourself\n1. Fork the val\n2. From your ValTown settings page, add an environment variable named `bookmarks_client_id` and give it a value (you will be using this for saving)\n3. Add another environment variable named `bookmarks_client_secret` and give it a value (you will also be using this for saving)\n4. At first, the \"bookmarks\" table will not exist, so we need to save an article first, which will create the \"bookmarks\" table\n5. To do this, add a bookmarklet to your browser with this value (replace `BOOKMARKS-CLIENT-ID` and `BOOKMARKS-CLIENT-SECRET` with the values you added to the environment variables, and replace `BOOKMARKS-URL` with your VAL's URL):\n```\njavascript:void(open('BOOKMARKS-URL/save?u='+encodeURIComponent(location.href)+'&t='+encodeURIComponent(document.title)+'&id=BOOKMARKS-CLIENT-ID&secret=BOOKMARKS-CLIENT-SECRET', 'Bookmark a link', 'width=400,height=450'))\n```\n6. Click this bookmarklet to bookmark the URL of the current active tab\n7. Go to your VAL URL homepage to see the bookmark\n\n### Demo\nHere are my bookmarks:\nhttps://ramkarthik-bookmark.web.val.run/\n\n### Note\nMake sure you don't share `bookmarks_client_id` and `bookmarks_client_secret`. It is used for authentication before saving a bookmark.",[78],"pulls","branches","forks","envVars",{"_74":20,"_211":20},"connections",{"_74":20,"_210":20},"unfilledCount","emptyCount",{"_31":199,"_13":78,"_65":77,"_41":-5,"_33":34,"_192":38,"_193":110,"_35":218,"_37":20,"_68":51,"_195":201,"_70":24,"_197":-5,"_215":219,"_156":220},{"_31":191,"_13":67,"_65":66,"_41":-5,"_33":34,"_192":101,"_193":110,"_35":214,"_37":94,"_68":69,"_195":196,"_70":24,"_197":-5,"_215":216,"_156":217},["D",1715130174948],"children",[],[67],["D",1715129569752],[],[78],["D",1746138479886],{"_11":12,"_155":73},{"_11":12,"_151":-5,"_72":73,"_25":71,"_152":153,"_154":24},{"_37":101,"_13":16,"_31":34,"_140":106,"_141":142,"_143":20,"_144":112,"_145":146,"_147":148,"_149":14,"_150":12},"ctx",{"_49":-5,"_177":258,"_259":260,"_261":262,"_263":24,"_264":24,"_265":24,"_266":110,"_267":-5,"_268":-7,"_269":-7,"_270":20,"_271":24,"_272":24,"_273":-5,"_274":24,"_275":24,"_276":24,"_277":-5},"ENV",{"_229":230,"_231":232,"_233":16,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243,"_244":245,"_246":247,"_248":249,"_250":251,"_252":253,"_254":255,"_256":257},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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"]

History