\n To one day improve my little word games, I \"made\"{\" \"}\n an app{\" \"}\n to let me rate whether words in the Wordnik word game list are \"real words\" or not. This page let's me track my\n progress as I judge. Both the Judge Words app and this dashboard were built leaning quite heavily on Val Town's\n Townie AI interface. If you're in the mood for a very simple word game, check out{\" \"}\n Loopy Letters{\" \"}- Alex.\n

\n );\n}\n\nfunction Dashboard() {\n const [stats, setStats] = useState([]);\n\n useEffect(() => {\n fetch(\"/stats\")\n .then(response => response.json())\n .then(setStats);\n }, []);\n\n const grandTotal = stats.length > 0 ? stats[0] : null;\n\n return (\n

Word Judgment Dashboard

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n {grandTotal && (\n \n \n \n \n \n \n \n \n \n )}\n {stats.slice(1).map(stat => (\n \n \n \n \n \n \n \n \n \n ))}\n \n

Word Length	Total Words	Judged Words	% Judged	Pie Chart	Avg Rating	Rating Distribution
Grand Total	{grandTotal.totalWords}	{grandTotal.judgedWords}	{(grandTotal.percentJudged * 100).toFixed(2)}%	\n \n	{grandTotal.avgRating.toFixed(2)}	\n \n
{stat.wordLength}	{stat.totalWords}	{stat.judgedWords}	{(stat.percentJudged * 100).toFixed(2)}%	\n \n	{stat.avgRating.toFixed(2)}	\n \n

\n \n View Source\n \n

\n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function server(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n\n // Handle stats request\n if (new URL(request.url).pathname === \"/stats\") {\n const stats = await sqlite.execute(`\n WITH WordStats AS (\n SELECT \n length(word) as wordLength,\n COUNT(*) as totalWords,\n COUNT(judgment) as judgedWords,\n AVG(judgment) as avgRating,\n json_object(\n '0', COUNT(CASE WHEN judgment = 0 THEN 1 END),\n '1', COUNT(CASE WHEN judgment = 1 THEN 1 END),\n '2', COUNT(CASE WHEN judgment = 2 THEN 1 END),\n '3', COUNT(CASE WHEN judgment = 3 THEN 1 END),\n '4', COUNT(CASE WHEN judgment = 4 THEN 1 END),\n '5', COUNT(CASE WHEN judgment = 5 THEN 1 END)\n ) as distribution\n FROM judgments\n GROUP BY length(word)\n\n UNION ALL\n\n SELECT \n 'total' as wordLength,\n COUNT(*) as totalWords,\n COUNT(judgment) as judgedWords,\n AVG(CASE WHEN judgment > 0 THEN judgment END) as avgRating,\n json_object(\n '0', COUNT(CASE WHEN judgment = 0 THEN 1 END),\n '1', COUNT(CASE WHEN judgment = 1 THEN 1 END),\n '2', COUNT(CASE WHEN judgment = 2 THEN 1 END),\n '3', COUNT(CASE WHEN judgment = 3 THEN 1 END),\n '4', COUNT(CASE WHEN judgment = 4 THEN 1 END),\n '5', COUNT(CASE WHEN judgment = 5 THEN 1 END)\n ) as distribution\n FROM judgments\n )\n SELECT \n wordLength, \n totalWords, \n judgedWords, \n CAST(judgedWords AS FLOAT) / totalWords as percentJudged, \n COALESCE(avgRating, 0) as avgRating,\n distribution\n FROM WordStats\n ORDER BY \n CASE WHEN wordLength = 'total' THEN 0 ELSE 1 END,\n CAST(wordLength AS INTEGER)\n `);\n\n return new Response(JSON.stringify(stats.rows), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n // Render HTML\n return new Response(\n `\n \n \n Word Judgment Dashboard\n \n \n \n \n

\n \n \n \n \n `,\n {\n headers: { \"Content-Type\": \"text/html\" },\n },\n );\n}\n\nconst styles = {\n container: {\n fontFamily: \"\\\"Roboto Mono\\\", monospace\",\n maxWidth: \"1100px\",\n margin: \"0 auto\",\n padding: \"20px\",\n },\n introBox: {\n backgroundColor: \"#f0f0f0\",\n border: \"1px solid #ddd\",\n borderRadius: \"5px\",\n padding: \"15px\",\n marginBottom: \"20px\",\n },\n table: {\n width: \"100%\",\n borderCollapse: \"collapse\",\n marginBottom: \"20px\",\n },\n cell: {\n padding: \"8px\",\n border: \"1px solid #ddd\",\n },\n cellNumber: {\n padding: \"8px\",\n border: \"1px solid #ddd\",\n textAlign: \"right\",\n },\n cellCenter: {\n padding: \"8px\",\n border: \"1px solid #ddd\",\n textAlign: \"center\",\n },\n grandTotal: {\n backgroundColor: \"#f5f5f5\",\n fontWeight: \"bold\",\n },\n grandTotalCell: {\n padding: \"8px\",\n border: \"2px solid #aaa\",\n },\n grandTotalCellNumber: {\n padding: \"8px\",\n border: \"2px solid #aaa\",\n textAlign: \"right\",\n },\n grandTotalCellCenter: {\n padding: \"8px\",\n border: \"2px solid #aaa\",\n textAlign: \"center\",\n },\n sourceLink: {\n color: \"#666\",\n textDecoration: \"none\",\n fontSize: \"0.8em\",\n },\n};","deleted","label",[99],"permalink","https://www.val.town/x/alexwein/judgeWordsDash/code/main.tsx","extension","actionData","errors"]