Driftboard

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_170":171,"_172":173},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_129":-5,"_20":130,"_22":131,"_132":133,"_134":135,"_26":136,"_24":137,"_138":-5,"_139":-5,"_140":52,"_141":142,"_143":43,"_144":-5,"_145":-5,"_146":147},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","bow18","name","driftboard","branchName","main","version","path","main.ts","project",{"_33":70,"_13":14,"_44":71,"_72":-5,"_73":52,"_74":75,"_76":75,"_77":78,"_79":-5,"_80":81,"_82":36,"_83":43,"_84":-5,"_85":-5,"_86":87,"_88":89,"_90":91,"_92":93,"_94":95,"_96":-5,"_97":98,"_99":98,"_100":101,"_102":101,"_103":101,"_104":98,"_105":98,"_106":107,"_108":109,"_110":111,"_112":52},"tree",[55,56],"file",{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":45,"_17":46,"_47":48,"_49":50,"_51":52,"_53":14,"_18":54},"contents",[],"upstream","pull","ahead","behind","envVars","id","6be65715-1687-414b-ac2c-76749b83958c","fileId","b348197a-a8ed-11f1-92f0-1607ee4eb77e","parentId","branchId","e9ae59c0-b2a5-4b07-b020-7a2a35912908","branchVersion",7,"latest",true,"createdAt",["D",1788588848694],4,"fileType","http","content","import { readFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst JSON_HEADERS = { \"content-type\": \"application/json\" };\n\n// Each photo is stored as its own row, so new uploads ADD to the board instead\n// of overwriting the whole list (which made photos mysteriously disappear when\n// two people uploaded around the same time).\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS photos (\n id TEXT PRIMARY KEY,\n dataUrl TEXT NOT NULL,\n aspect TEXT NOT NULL DEFAULT 'square',\n caption TEXT NOT NULL DEFAULT '',\n posX REAL NOT NULL DEFAULT 0,\n posY REAL NOT NULL DEFAULT 0,\n dur REAL NOT NULL DEFAULT 5,\n delay REAL NOT NULL DEFAULT 0,\n rot REAL NOT NULL DEFAULT 0\n)`);\n\n// Wishes/notes: each note or greeting card is its own row, with authorId so a\n// note can only be removed by the person who wrote it.\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS notes (\n id TEXT PRIMARY KEY,\n authorId TEXT NOT NULL,\n kind TEXT NOT NULL DEFAULT 'note',\n color TEXT NOT NULL DEFAULT 'yellow',\n text TEXT NOT NULL DEFAULT '',\n posX REAL NOT NULL DEFAULT 0,\n posY REAL NOT NULL DEFAULT 0,\n dur REAL NOT NULL DEFAULT 5,\n delay REAL NOT NULL DEFAULT 0,\n rot REAL NOT NULL DEFAULT 0\n)`);\n\nfunction rowToPhoto(r: Record) {\n return {\n id: r.id,\n dataUrl: r.dataUrl,\n aspect: r.aspect,\n caption: r.caption,\n left: r.posX,\n top: r.posY,\n dur: r.dur,\n delay: r.delay,\n rot: r.rot,\n };\n}\n\nexport default async function handler(req: Request): Promise {\n const url = new URL(req.url);\n const path = url.pathname;\n\n // Theme stays a single shared blob (only one person edits it at a time).\n if (path === \"/api/theme\") {\n if (req.method === \"GET\") {\n let value = null;\n try { value = await (await blob.get(\"wall:theme\")).text(); } catch { /* absent */ }\n return new Response(JSON.stringify({ value }), { headers: JSON_HEADERS });\n }\n if (req.method === \"PUT\" || req.method === \"POST\") {\n await blob.set(\"wall:theme\", await req.text());\n return new Response(JSON.stringify({ ok: true }), { headers: JSON_HEADERS });\n }\n }\n\n // Photos: per-photo rows, merged instead of overwritten.\n if (path === \"/api/photos\") {\n if (req.method === \"GET\") {\n const res = await sqlite.execute(\"SELECT * FROM photos\");\n const photos = res.rows.map(rowToPhoto);\n return new Response(JSON.stringify({ value: JSON.stringify(photos) }), {\n headers: JSON_HEADERS,\n });\n }\n if (req.method === \"PUT\" || req.method === \"POST\") {\n let incoming: any[] = [];\n try { incoming = JSON.parse(await req.text()); } catch { /* ignore */ }\n // Upsert each incoming photo by id; existing ones from other people are\n // left untouched so nothing gets lost.\n await sqlite.batch(incoming.map((p) => ({\n sql: `INSERT INTO photos (id, dataUrl, aspect, caption, posX, posY, dur, delay, rot)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)\n ON CONFLICT(id) DO UPDATE SET\n dataUrl=excluded.dataUrl, aspect=excluded.aspect, caption=excluded.caption,\n posX=excluded.posX, posY=excluded.posY, dur=excluded.dur,\n delay=excluded.delay, rot=excluded.rot`,\n args: [p.id, p.dataUrl, p.aspect || \"square\", p.caption || \"\",\n p.left ?? 0, p.top ?? 0, p.dur ?? 5, p.delay ?? 0, p.rot ?? 0],\n })));\n return new Response(JSON.stringify({ ok: true }), { headers: JSON_HEADERS });\n }\n if (req.method === \"DELETE\") {\n const id = url.searchParams.get(\"id\");\n if (id) {\n await sqlite.execute(\"DELETE FROM photos WHERE id = ?\", [id]);\n }\n return new Response(JSON.stringify({ ok: true }), { headers: JSON_HEADERS });\n }\n }\n\n // Notes / wishes: add is an upsert of ONLY the new note(s) sent by the client;\n // deletion requires matching authorId so nobody can remove someone else's note.\n if (path === \"/api/notes\") {\n if (req.method === \"GET\") {\n const res = await sqlite.execute(\"SELECT * FROM notes ORDER BY id\");\n const rows = res.rows.map((n) => ({\n id: n.id, authorId: n.authorId, kind: n.kind, color: n.color, text: n.text,\n left: n.posX, top: n.posY, dur: n.dur, delay: n.delay, rot: n.rot,\n }));\n return new Response(JSON.stringify({ value: JSON.stringify(rows) }), {\n headers: JSON_HEADERS,\n });\n }\n if (req.method === \"PUT\" || req.method === \"POST\") {\n let incoming: any[] = [];\n try { incoming = JSON.parse(await req.text()); } catch { /* ignore */ }\n await sqlite.batch(incoming.map((n) => ({\n sql: `INSERT INTO notes (id, authorId, kind, color, text, posX, posY, dur, delay, rot)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n ON CONFLICT(id) DO UPDATE SET\n authorId=excluded.authorId, kind=excluded.kind, color=excluded.color,\n text=excluded.text, posX=excluded.posX, posY=excluded.posY,\n dur=excluded.dur, delay=excluded.delay, rot=excluded.rot`,\n args: [n.id, n.authorId, n.kind || \"note\", n.color || \"yellow\", n.text || \"\",\n n.left ?? 0, n.top ?? 0, n.dur ?? 5, n.delay ?? 0, n.rot ?? 0],\n })));\n return new Response(JSON.stringify({ ok: true }), { headers: JSON_HEADERS });\n }\n if (req.method === \"DELETE\") {\n const id = url.searchParams.get(\"id\");\n const authorId = url.searchParams.get(\"authorId\");\n if (id && authorId) {\n await sqlite.execute(\n \"DELETE FROM notes WHERE id = ? AND authorId = ?\", [id, authorId]);\n }\n return new Response(JSON.stringify({ ok: true }), { headers: JSON_HEADERS });\n }\n }\n\n // Everything else: the board itself\n const html = await readFile(\"index.html\");\n return new Response(html, {\n headers: { \"content-type\": \"text/html; charset=utf-8\" },\n });\n}\n","deleted",false,"label",[19],{"_33":61,"_13":62,"_35":63,"_37":-5,"_38":39,"_40":64,"_42":43,"_44":65,"_17":66,"_47":24,"_49":67,"_51":52,"_53":-5,"_58":68,"_18":69},{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":57,"_17":46,"_47":48,"_49":50,"_51":52,"_53":14,"_58":59,"_18":60},["D",1788588848694],"children",[],[19],"6bd18ef9-2920-4fc3-bf87-641ff994cebc","index.html","cfb92216-a8ed-11f1-b7ac-1607ee4eb77e",20,["D",1788931100881],14,"\n\n\n\n\nDriftboard\n\n\n\n\n\n\n

\n\n\n\n\n\n

Nothing's drifted in yet

Add a photo and it'll float onto the board for everyone to see.

\n\n

\n \n

Decorate the board

\n\n

\n Board title\n \n

\n\n

\n Header font\n \n

\n\n

\n Header text color\n

\n Applies to the title above\n \n

\n\n

\n Background\n

✎

Background top

Background bottom

Accent

Buttons / frames-2

Card paper

Body text

\n\n

\n Frame style\n

Polaroid

Round

Torn edge

\n\n \n\n

This board is shared — the title, font, colors, frame style, every photo, and every wish are stored globally, so everyone who opens this page sees the exact same thing. The board also checks for new photos and wishes every few seconds, so uploads from others appear without needing to reload.

\n\n\n\n

\n\n\n\n\n",[],[62],"af373afd-b310-4dde-b2bc-5c0e6fee6db3",["D",1788587422877],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","A shared photo wall that floats photos around the screen","imageUrl","userId","e9091daf-d5df-471c-885e-1571291d0838","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01a0701d-408a-77ec-89f9-f4150f4028b2","tursoName","af373afdb3104ddeb2bc5c0e6fee6db3","tursoHostname","af373afdb3104ddeb2bc5c0e6fee6db3-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789456888508],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_128":124},"org",{"_11":12,"_121":122,"_123":124,"_80":81,"_125":126,"_127":52},"branch",{"_17":64,"_13":16,"_33":39,"_113":70,"_114":-5,"_115":-5,"_116":-5,"_117":-5,"_118":-5,"_119":14,"_120":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Hà Trang Nguyễn","avatar","https://lh3.googleusercontent.com/a/ACg8ocJSfPRWndJg2KJgy3vmS9sYWzO1_47IkNbva0LStn3c-WJ2LM2X=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":70,"_13":14,"_44":165,"_72":-5,"_73":52,"_74":75,"_76":75,"_77":78,"_79":-5,"_80":81,"_82":36,"_83":43,"_84":-5,"_85":-5,"_86":87,"_88":89,"_90":91,"_92":93,"_94":166,"_96":-5,"_97":98,"_99":98,"_100":101,"_102":101,"_103":101,"_104":98,"_105":98,"_106":167,"_108":168,"_110":169,"_112":52},[159,160],"files",[159,160],"counts",{"_149":87,"_150":151,"_152":151,"_32":153,"_154":155},[],{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":45,"_17":46,"_47":48,"_49":50,"_51":52,"_53":14,"_18":148},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],"pulls","branches",1,"forks",{"_156":87,"_158":87},"connections",{"_156":87,"_157":87},"count","unfilledCount","emptyCount",{"_33":61,"_13":62,"_35":63,"_37":-5,"_38":39,"_40":64,"_42":43,"_44":65,"_17":66,"_47":24,"_49":67,"_51":52,"_53":-5,"_58":163,"_18":164},{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":57,"_17":46,"_47":48,"_49":50,"_51":52,"_53":14,"_58":161,"_18":162},[],[19],[],[62],["D",1788587422877],["D",1789456888508],{"_11":12,"_128":124},{"_11":12,"_121":122,"_123":124,"_80":81,"_125":126,"_127":52},{"_17":64,"_13":16,"_33":39,"_113":70,"_114":-5,"_115":-5,"_116":-5,"_117":-5,"_118":-5,"_119":14,"_120":12},"ctx",{"_106":-5,"_145":203,"_204":205,"_206":207,"_208":52,"_209":52,"_210":52,"_211":43,"_212":-5,"_213":-7,"_214":-7,"_215":87,"_216":52,"_217":52,"_218":-5,"_219":52,"_220":52,"_221":52,"_222":-5},"ENV",{"_174":175,"_176":177,"_178":16,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","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"]

Decorate the board

💌 Write a wish