#!/usr/bin/env docker run

[{"_1":2,"_122":-5,"_123":-5},"loaderData",{"_3":4,"_92":93,"_121":-5},"root",{"_5":6,"_33":34,"_59":60,"_90":91},"ctx",{"_7":8,"_18":19,"_20":-5,"_21":22,"_23":24,"_25":26,"_27":26,"_28":26,"_29":30,"_31":32},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5},"sessionClaims","sessionId","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","environmentVariableKeys",[],"user","preferences_keybindings","default","preferences_theme","light","preferences_fixers",false,"preferences_copilot","preferences_selection_ai","preferences_model","claude-3-5-haiku-20241022","notification_count",0,"ENV",{"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56,"_57":58},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","3c31150dafe09c885efd1ad349c1e23d5ba90676","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","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","API_URL","https://api.val.town","WORKER_FINGERPRINT","c7de7de11d2fa3884730f0fa9fd384f8","clerkState",{"_61":62},"__internal_clerk_state",{"_63":64,"_65":44,"_66":67,"_68":67,"_69":26,"_70":67,"_71":67,"_72":67,"_73":67,"_74":67,"_75":67,"_76":67,"_77":67,"_78":79,"_88":26,"_89":26},"__clerk_ssr_state",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__signInForceRedirectUrl","__signUpForceRedirectUrl","__signInFallbackRedirectUrl","__signUpFallbackRedirectUrl","__clerk_debug",{"_80":26,"_81":67,"_82":83,"_84":67,"_85":44,"_86":26,"_87":67},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","remixVersion",2,"routes/_app.pulls.$prId",{"_94":95},"pullRequest",{"_96":97,"_98":99,"_100":101,"_102":26,"_103":26,"_104":105,"_116":117},"id","36704810-cab4-11ee-ae85-325518e2651b","description","Type that client side code!","state","merged","canAccept","canCancel","target",{"_106":107,"_108":109,"_110":111,"_112":113,"_114":115},"code","import { sqlite } from \"https://esm.town/v/std/sqlite?v=4\";\nimport { html } from \"https://esm.town/v/stevekrouse/html\";\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)`);\n\nexport default async function(req: Request): Promise {\n 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 return html(`\n\n\n \n \n \n #!/usr/bin/env docker run\n \n \n

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

\n \n \n`);\n}","readme","# Val Town Port of [adtac/Dockerfile](https://gist.github.com/adtac/595b5823ef73b329167b815757bbce9f)\n\na whole little fullstack (sqlite, backend js, frontend js, html) app in a single val","handle","stevekrouse","profileImageUrl","https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg","name","backend_in_a_file","fork",{"_106":118,"_108":109,"_110":119,"_112":120,"_114":115},"export function main(data) {\n const el = document.getElementById(\"canvas\") as HTMLCanvasElement;\n const 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 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\nexport default async function(req: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite?v=4\");\n const { html } = await import(\"https://esm.town/v/stevekrouse/html\");\n\n sqlite.execute(`CREATE TABLE IF NOT EXISTS backend_in_a_file_clicks (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n time INTEGER NOT NULL\n )`);\n\n 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 return html(`\n\n\n \n \n \n #!/usr/bin/env docker run\n \n \n

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

\n \n \n`);\n}","saolsen","https://images.clerk.dev/oauth_github/img_2QtXHzN3gDPhKsBOvKsst8LTxC5.png","routes/_app","actionData","errors"]

Review pull request

Description

stevekrouse/backend_in_a_file

saolsen/backend_in_a_file