#!/usr/bin/env docker run

\n Page loads over time (last 4 hours)\n \n 0\n

\n \n \n`);\n}","createdAt",["D",1707859008350],"version",18,"currentUserHasLiked","likeCount",1,"forkCount","referenceCount","dependencyCount",4,"commentCount","prCount","mergedPr",{"_132":133,"_134":135},"handle","stevekrouse","profileImageUrl","https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg","forkedVal","interval","slug","stevekrouse/backend_in_a_file","description","Val Town Port of adtac/Dockerfile a whole little fullstack (sqlite, backend js, frontend js, html) app in a single val","versions",[144,148,152,156,160,164,168,172,176,180,184,188,192,196,200,203,207,210,213],{"_119":120,"_145":146,"_117":147,"_114":112},"prId","36704810-cab4-11ee-ae85-325518e2651b",["D",1707859008350],{"_119":149,"_145":-5,"_117":150,"_114":151},17,["D",1705438826030],"459f42c2-b4b2-11ee-9555-325518e2651b",{"_119":153,"_145":-5,"_117":154,"_114":155},16,["D",1705438776469],"2814d456-b4b2-11ee-9555-325518e2651b",{"_119":157,"_145":-5,"_117":158,"_114":159},15,["D",1705438771101],"24e1ba60-b4b2-11ee-aed9-325518e2651b",{"_119":161,"_145":-5,"_117":162,"_114":163},14,["D",1705438737545],"10e18a90-b4b2-11ee-b365-325518e2651b",{"_119":165,"_145":-5,"_117":166,"_114":167},13,["D",1705438472668],"730077be-b4b1-11ee-a65e-325518e2651b",{"_119":169,"_145":-5,"_117":170,"_114":171},12,["D",1705438469546],"7124152c-b4b1-11ee-832a-325518e2651b",{"_119":173,"_145":-5,"_117":174,"_114":175},11,["D",1705438224448],"df0d2228-b4b0-11ee-b748-325518e2651b",{"_119":177,"_145":-5,"_117":178,"_114":179},10,["D",1705438222073],"dda2b498-b4b0-11ee-91c2-325518e2651b",{"_119":181,"_145":-5,"_117":182,"_114":183},9,["D",1705438167698],"bd39ca34-b4b0-11ee-b3e1-325518e2651b",{"_119":185,"_145":-5,"_117":186,"_114":187},8,["D",1705438121609],"a1c1153c-b4b0-11ee-b727-325518e2651b",{"_119":189,"_145":-5,"_117":190,"_114":191},7,["D",1705438111463],"9bb4faf0-b4b0-11ee-a44d-325518e2651b",{"_119":193,"_145":-5,"_117":194,"_114":195},6,["D",1705437959099],"40e41f98-b4b0-11ee-9c59-325518e2651b",{"_119":197,"_145":-5,"_117":198,"_114":199},5,["D",1705437714789],"af456538-b4af-11ee-8793-325518e2651b",{"_119":127,"_145":-5,"_117":201,"_114":202},["D",1705437656163],"8c53a8a0-b4af-11ee-a8fa-325518e2651b",{"_119":204,"_145":-5,"_117":205,"_114":206},3,["D",1705437633952],"7f169c24-b4af-11ee-8cb5-325518e2651b",{"_119":90,"_145":-5,"_117":208,"_114":209},["D",1705437600633],"6b3a7bbc-b4af-11ee-9106-325518e2651b",{"_119":123,"_145":-5,"_117":211,"_114":212},["D",1705437544833],"49f817ac-b4af-11ee-8daf-325518e2651b",{"_119":31,"_145":-5,"_117":214,"_114":215},["D",1705436803087],"8fdaa23c-b4ad-11ee-9db8-325518e2651b","recentThread","breadcrumbs","comments",[220,229],{"_114":221,"_222":223,"_117":224,"_225":-5,"_226":26,"_227":26,"_20":228},"4fdcfac2-cab5-11ee-bb92-325518e2651b","body","Thanks @saolsen for the PR! Much cleaner now!",["D",1707859057283],"updatedAt","canDelete","canEdit",{"_132":133,"_134":135},{"_114":230,"_222":231,"_117":232,"_225":-5,"_226":26,"_227":26,"_20":233},"5f70e368-cab5-11ee-bf3d-325518e2651b","For reference, this PR: https://www.val.town/pulls/36704810-cab4-11ee-ae85-325518e2651b",["D",1707859083418],{"_132":133,"_134":135},"isOwner","routes/_app.v.$handle.$name.versions.$(version)",{"_93":237,"_238":239,"_94":240},"single","redirect","/v/stevekrouse/backend_in_a_file/versions",{"_114":171,"_115":241,"_119":169,"_117":242,"_243":99,"_100":101,"_109":110,"_132":133,"_11":96,"_244":-5,"_245":-5,"_246":-5,"_234":26,"_138":139},"/** @jsxImportSource https://esm.sh/preact */\nimport { sqlite } from \"https://esm.town/v/std/sqlite?v=4\";\nimport { js } from \"https://esm.town/v/stevekrouse/js\";\nimport { preact } from \"https://esm.town/v/stevekrouse/preact\";\n\nsqlite.execute(`CREATE TABLE IF NOT EXISTS backend_in_a_file_clicks (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n time INTEGER NOT NULL\n)`).then(result => console.log(result));\n\nexport default async function(req: Request): Promise {\n console.log(await sqlite.execute(\"INSERT INTO backend_in_a_file_clicks(time) VALUES(unixepoch())\"));\n const results = await sqlite.execute(\n \"SELECT time as t, COUNT(*) as n FROM backend_in_a_file_clicks WHERE t > unixepoch()-4*60*60 GROUP BY t-t%60\",\n );\n const data = (results.rows as any as [number, number][]).map(([t, n]) => [Math.floor(t / 60), n]);\n\n return preact(\n \n \n \n \n #!/usr/bin/env docker run\n \n \n \n \n Page loads over time (last 4 hours)\n \n \n \n 0\n \n \n\n {\n const el = document.getElementById(\"canvas\"), ctx = el.getContext(\"2d\");\n el.width = 0.9 * window.innerWidth * window.devicePixelRatio;\n el.height = 0.9 * window.innerHeight * window.devicePixelRatio;\n ctx.scale(window.devicePixelRatio, window.devicePixelRatio);\n \n const data = ${JSON.stringify(data)};\n const max = data.reduce((prev, [_, n]) => (n > prev ? n : prev), 0);\n document.getElementById(\"max\").innerText = max;\n \n ctx.beginPath();\n ctx.moveTo(0, el.height);\n \n const draw = (t, n) => {\n const [x, y] = [el.width * (t-data[0][0])/240, el.height * (1 - n/max)];\n ctx.lineTo(x, y);\n ctx.moveTo(x, y);\n }\n \n let last = -1;\n for (const [t, n] of data) {\n if (last != -1 && t > last + 1) {\n draw(last + 0.1, 0);\n draw(t - 0.1, 0);\n }\n draw(t, n);\n last = t;\n }\n ctx.stroke();\n })();`,\n }}\n />\n \n ,\n );\n}",["D",1705438469546],"valName","deletedAt","messageId","threadId","routes/_app","actionData","errors"]

backend_in_a_file

Version 12