RIKKAEBI

/** @jsxImportSource https://esm.sh/react */ import confetti from "https://esm.sh/canvas-confetti@1.6.0"; import { useEffect, useState, useTransition } from "https://esm.sh/react"; import { createRoot } from "https://esm.sh/react-dom/client"; type Like = { likes: number; }; function App() { const [isPending, startTransition] = useTransition(); const [likes, setLikes] = useState(0); useEffect(() => { fetch("/likes") .then(async (res) => await res.json() as Like) .then(data => setLikes(data.likes)); }, []); const handleLike = () => { startTransition(() => { confetti(); setLikes((prev) => prev + 1); fetch("/like", { method: "POST" }).catch(console.error); }); }; return (

); } if (typeof document !== "undefined") { createRoot(document.getElementById("root")!).render(); } export default async function server(request: Request): Promise { const { sqlite } = await import("https://esm.town/v/stevekrouse/sqlite"); const KEY = new URL(import.meta.url).pathname.split("/").at(-1); const SCHEMA_VERSION = 1; // Ensure table exists await sqlite.execute(` CREATE TABLE IF NOT EXISTS ${KEY}_likes_${SCHEMA_VERSION} ( id INTEGER PRIMARY KEY, likes INTEGER DEFAULT 0 ) `); // Ensure at least one row exists await sqlite.execute(` INSERT OR IGNORE INTO ${KEY}_likes_${SCHEMA_VERSION} (id, likes) VALUES (1, 0) `); // Handle likes endpoint if (request.method === "GET" && new URL(request.url).pathname === "/likes") { const result = await sqlite.execute(` SELECT likes FROM ${KEY}_likes_${SCHEMA_VERSION} WHERE id = 1 `); return Response.json({ likes: result.rows[0]?.likes || 0 }); } // Handle like increment endpoint if (request.method === "POST" && new URL(request.url).pathname === "/like") { await sqlite.execute(` UPDATE ${KEY}_likes_${SCHEMA_VERSION} SET likes = likes + 1 WHERE id = 1 `); const result = await sqlite.execute(` SELECT likes FROM ${KEY}_likes_${SCHEMA_VERSION} WHERE id = 1 `); return Response.json({ likes: result.rows[0]?.likes || 0 }); } // Serve HTML return new Response( ` RIKKAEBI

`, { headers: { "Content-Type": "text/html" }, }, ); }

app

Versions

v0