{front}

{back}

Created: {created_at}
Due: {due_at ?? \"--\"}
Last reviewed: {reviewed_at ?? \"--\"}

\n {/* TODO: options to edit or delete */}\n

\n \n );\n}\n\n// TODO: option to recover\nfunction Deleted({ deletedAt }) {\n return (\n \n

This card was deleted on {deletedAt}

\n \n );\n}",[],[160,180],{"_104":190,"_97":191,"_161":192,"_163":162,"_164":146,"_165":193,"_167":168,"_106":194,"_101":195,"_171":185,"_173":196,"_174":22,"_175":-5,"_176":197,"_100":198},"d9258206-10fc-11f1-bee2-42dde27851f2","Home.tsx","d4466fd8-10f8-11f1-a417-42dde27851f2",64,["D",1771881358596],14,"/** @jsxImportSource npm:hono@4/jsx */\n\nimport Layout from \"./Layout.tsx\";\n\nexport default function Home({ cards }) {\n return (\n \n

Cards

The deck has {cards.length} cards:

\n {front}\n

\n Create a new card →\n

\n \n );\n}",[],[160,191],{"_104":200,"_97":201,"_161":202,"_163":162,"_164":146,"_165":203,"_167":168,"_106":204,"_101":205,"_171":185,"_173":206,"_174":22,"_175":-5,"_176":207,"_100":208},"df5ca4e4-10fa-11f1-8ea2-42dde27851f2","Layout.tsx","3ed07ff0-10fa-11f1-a579-42dde27851f2",44,["D",1771880510033],3,"/** @jsxImportSource npm:hono@4/jsx */\n\nexport default function Layout({ children }) {\n return (\n \n \n

\n Spacertext\n

\n {children}\n \n \n );\n}",[],[160,201],{"_104":210,"_97":211,"_161":212,"_163":162,"_164":146,"_165":213,"_167":168,"_106":214,"_101":215,"_171":185,"_173":216,"_174":22,"_175":-5,"_176":217,"_100":218},"ee295d40-1100-11f1-800d-42dde27851f2","New.tsx","2fe810b6-10fa-11f1-ae2d-42dde27851f2",66,["D",1771883111840],4,"/** @jsxImportSource npm:hono@4/jsx */\n\nimport Layout from \"./Layout.tsx\";\n\nexport default function New() {\n return (\n \n

\n \n

\n \n );\n}",[],[160,211],[160],{"_104":221,"_97":222,"_161":223,"_163":-5,"_164":146,"_165":145,"_167":168,"_106":224,"_101":225,"_171":226,"_173":227,"_174":22,"_175":98,"_176":228,"_100":229},"70d763a4-1101-11f1-813e-42dde27851f2","main.tsx","dfc4579c-10d7-11f1-938f-42dde27851f2",["D",1771883331088],23,"http","/** @jsxImportSource npm:hono@4/jsx */\n\nimport { Hono } from \"npm:hono@4\";\nimport { basicAuth } from \"npm:hono@4/basic-auth\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport Home from \"./components/Home.tsx\";\nimport New from \"./components/New.tsx\";\nimport Card from \"./components/Card.tsx\";\nimport { REVIEW_INTERVAL_MS } from \"./utils.ts\";\n\nconst app = new Hono();\n\n// Basic auth so that only I can read/write to SQLite\napp.use(\n \"*\",\n basicAuth({\n username: Deno.env.get(\"USERNAME\"),\n password: Deno.env.get(\"PASSWORD\"),\n }),\n);\n\napp.get(\"/\", async (c) => {\n const { rows } = await sqlite.execute(\"SELECT * FROM cards\");\n return c.html();\n});\n\napp.get(\"/new\", (c) => {\n return c.html();\n});\n\napp.post(\"/new\", async (c) => {\n const formData = await c.req.formData();\n const front = (formData.get(\"front\") as string)?.trim();\n const back = (formData.get(\"back\") as string)?.trim() || null;\n const dueAt = new Date(Date.now() + REVIEW_INTERVAL_MS[0]).toISOString();\n\n if (!front) {\n return c.text(\"Front is required\", 400);\n }\n\n const result = await sqlite.execute({\n sql:\n \"INSERT INTO cards (front, back, due_at) VALUES (?, ?, ?) RETURNING id\",\n args: [front, back, dueAt],\n });\n\n const newId = result.rows[0][0];\n return c.redirect(`/${newId}`, 303);\n});\n\napp.get(\"/:card\", async (c) => {\n const id = Number(c.req.param(\"card\"));\n if (!Number.isInteger(id)) {\n return c.text(\"Not found\", 404);\n }\n\n const result = await sqlite.execute({\n sql: \"SELECT * FROM cards WHERE id = ?\",\n args: [id],\n });\n\n if (result.rows.length === 0) {\n return c.text(\"Not found\", 404);\n }\n\n return c.html();\n});\n\nexport default app.fetch;",[],[222],{"_104":231,"_97":232,"_161":233,"_163":-5,"_164":146,"_165":215,"_167":168,"_106":234,"_101":235,"_171":185,"_173":236,"_174":22,"_175":-5,"_176":237,"_100":238},"854b7366-10de-11f1-be96-42dde27851f2","sqlite.ts","53449d76-10d8-11f1-b6bc-42dde27851f2",["D",1771868333019],2,"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nawait sqlite.batch([\n `CREATE TABLE IF NOT EXISTS cards (\n id INTEGER PRIMARY KEY,\n front TEXT NOT NULL UNIQUE,\n back TEXT,\n review_step INTEGER NOT NULL DEFAULT 0, -- maps to intervals 0 = 1h, 1 = 1d, 2 = 1w, 3 = 1m, 4 = 1y\n reviewed_at TEXT, -- ISO8601, null if never reviewed\n due_at TEXT, -- ISO8601, computed using reviewed_at and review_interval\n created_at TEXT NOT NULL DEFAULT (datetime('now')), -- ISO8601\n deleted_at TEXT -- ISO8601, card deletion (\"pruning\") is expected\n );`,\n `CREATE TABLE IF NOT EXISTS hyperlinks (\n source_id INTEGER NOT NULL REFERENCES cards(id),\n target_id INTEGER NOT NULL REFERENCES cards(id),\n CHECK (source_id != target_id),\n PRIMARY KEY (source_id, target_id)\n );`,\n]);",[],[232],{"_104":240,"_97":241,"_161":242,"_163":-5,"_164":146,"_165":243,"_167":168,"_106":244,"_101":205,"_171":185,"_173":245,"_174":22,"_175":-5,"_176":246,"_100":247},"6b460698-1101-11f1-9437-42dde27851f2","utils.ts","2d6f0400-1101-11f1-839a-42dde27851f2",72,["D",1771883321743],"export const REVIEW_INTERVAL_MS: Record = {\n 0: 1000 * 60 * 60, // 1 hour\n 1: 1000 * 60 * 60 * 24, // 1 day\n 2: 1000 * 60 * 60 * 24 * 7, // 1 week\n 3: 1000 * 60 * 60 * 24 * 30, // 1 month\n 4: 1000 * 60 * 60 * 24 * 365, // 1 year\n};",[],[241],"files",[158,178,189,199,209,220,230,239],"counts",{"_252":33,"_253":170,"_254":33,"_255":256,"_259":260},"pulls","branches","forks","envVars",{"_257":235,"_258":33},"count","emptyCount","connections",{"_257":33,"_261":33},"unfilledCount","contents",[264,267,270,273],{"_104":159,"_97":160,"_161":162,"_163":-5,"_164":146,"_165":166,"_167":168,"_106":265,"_101":170,"_171":172,"_173":-5,"_174":22,"_175":-5,"_100":266},["D",1771879623421],[160],{"_104":221,"_97":222,"_161":223,"_163":-5,"_164":146,"_165":145,"_167":168,"_106":268,"_101":225,"_171":226,"_173":227,"_174":22,"_175":98,"_100":269},["D",1771883331088],[222],{"_104":231,"_97":232,"_161":233,"_163":-5,"_164":146,"_165":215,"_167":168,"_106":271,"_101":235,"_171":185,"_173":236,"_174":22,"_175":-5,"_100":272},["D",1771868333019],[232],{"_104":240,"_97":241,"_161":242,"_163":-5,"_164":146,"_165":243,"_167":168,"_106":274,"_101":205,"_171":185,"_173":245,"_174":22,"_175":-5,"_100":275},["D",1771883321743],[241],"file","upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.environment-variables",{"_95":96,"_97":98,"_102":285,"_255":290,"_304":22},{"_104":105,"_97":98,"_106":286,"_108":-5,"_109":22,"_110":111,"_112":113,"_114":74,"_14":115,"_116":-5,"_117":22,"_118":-5,"_119":-5,"_120":33,"_16":121,"_122":123,"_124":125,"_126":127,"_128":127,"_129":130,"_131":130,"_132":130,"_133":127,"_134":127,"_23":287,"_138":288,"_143":289,"_155":22},["D",1771865478307],{"_95":96,"_136":137},{"_95":96,"_140":137,"_14":115,"_141":142},{"_101":145,"_97":45,"_104":146,"_147":105,"_148":-5,"_149":-5,"_150":-5,"_151":-5,"_152":-5,"_153":98,"_154":96},[291,299],{"_292":293,"_106":294,"_295":296,"_112":297,"_298":22},"key","PASSWORD",["D",1771879319885],"updatedAt",["D",1771879433677],"Basic Auth password","isEmpty",{"_292":300,"_106":301,"_295":302,"_112":303,"_298":22},"USERNAME",["D",1771879316285],["D",1771879401796],"Basic Auth username","isTeamOrg","actionData","errors"]

Key	Description
PASSWORD	Basic Auth password
USERNAME	Basic Auth username

petermillspaugh

spacertext

Environment variables