\n \n \n \n",[18,93],"040d8fe2-5acb-11f0-a3bc-f69ea79377d9",["D",1751848844056],"",[18,118],"b2f8eaec-5acb-11f0-9758-f69ea79377d9",["D",1751849137589],"# Frontend\n\nThis is a client-side React app for the 4x4 Grid Visual Editor.\n\n## `index.html`\n\nThe **entrypoint** for the frontend is `/frontend/index.html`. This is the HTML page that is returned at the root from `/backend/index.ts`.\n\nThis HTML file imports `/frontend/style.css` from `/public/style.css` and `/frontend/favicon.svg` from `/frontend/favicon.svg`. Everything in `/frontend/` is mapped to `/public` by `/backend/index.ts`. This is just a convention. You could import & serve everything out of the same folder name.\n\nThis HTML file has a `

`, which is where we mount the React app.\n\nThis HTML file imports `/frontend/index.tsx` from `/public/index.tsx`, which is the **entrypoint** for all frontend JavaScript, including all the React. It is not a problem that it imports a file with a `.tsx` extension because browsers ignore file extensions. They only pay attention to content-types, which is great, because all these files will be returned as transpiled JS with the appropriate JS content type by [stevekrouse/utils/serve-public](https://www.val.town/x/stevekrouse/utils/branch/main/code/serve-public/README.md).\n\n## `index.tsx`\n\nThis file is the **entrypoint** for frontend JavaScript. It imports the React app from `/frontend/components/App.tsx` and mounts it on `

`.\n\nIt also looks for *bootstrapped* JSON data at `window.__INITIAL_DATA`, and passes that to the ``.\n\n## `favicon.svg`\n\nAs of this writing Val Town only supports text files, which is why the favicon is an SVG and not an .ico or any other binary image format. If you need binary file storage, check out [Blob Storage](https://docs.val.town/std/blob/).\n\n## `components/`\n\nThis directory contains the React components:\n\n- `App.tsx` - Main app component with tab navigation\n- `GridEditor.tsx` - Interactive 4x4 grid editor with save functionality\n- `SavedGridsView.tsx` - Read-only view of all saved grids\n\n## Features\n\n- **Interactive Grid**: Click cells to toggle between black and white\n- **Real-time Text Output**: Shows the textual representation as you edit\n- **Save Once**: Grids can only be saved once to prevent duplicates\n- **Copy to Clipboard**: Easy copying of text representations\n- **Responsive Design**: Works on mobile and desktop",[18,113],"040d8aba-5acb-11f0-a3bc-f69ea79377d9",["D",1751848844056],[18,106],"pulls","branches","forks","envVars",{"_114":26,"_280":26},"connections",{"_114":26,"_279":26},"unfilledCount","emptyCount",{"_37":428,"_13":386,"_80":379,"_47":-5,"_39":40,"_237":44,"_238":24,"_41":429,"_43":26,"_83":107,"_240":-5,"_84":30,"_241":-5,"_308":430,"_17":431},{"_37":424,"_13":409,"_80":404,"_47":379,"_39":40,"_237":44,"_238":24,"_41":425,"_43":26,"_83":107,"_240":-5,"_84":30,"_241":-5,"_308":426,"_17":427},{"_37":417,"_13":113,"_80":418,"_47":404,"_39":40,"_237":419,"_238":24,"_41":420,"_43":44,"_83":21,"_240":421,"_84":30,"_241":-5,"_308":422,"_17":423},{"_37":410,"_13":411,"_80":412,"_47":404,"_39":40,"_237":44,"_238":24,"_41":413,"_43":26,"_83":100,"_240":414,"_84":30,"_241":-5,"_308":415,"_17":416},{"_37":401,"_13":402,"_80":403,"_47":404,"_39":40,"_237":390,"_238":24,"_41":405,"_43":315,"_83":100,"_240":406,"_84":30,"_241":-5,"_308":407,"_17":408},{"_37":394,"_13":113,"_80":395,"_47":379,"_39":40,"_237":396,"_238":24,"_41":397,"_43":44,"_83":21,"_240":398,"_84":30,"_241":-5,"_308":399,"_17":400},{"_37":387,"_13":388,"_80":161,"_47":379,"_39":40,"_237":185,"_238":24,"_41":389,"_43":390,"_83":382,"_240":391,"_84":30,"_241":-5,"_308":392,"_17":393},{"_37":376,"_13":377,"_80":378,"_47":379,"_39":40,"_237":380,"_238":24,"_41":381,"_43":44,"_83":382,"_240":383,"_84":30,"_241":-5,"_308":384,"_17":385},{"_37":236,"_13":18,"_80":150,"_47":-5,"_39":40,"_237":44,"_238":24,"_41":373,"_43":26,"_83":107,"_240":-5,"_84":30,"_241":-5,"_308":374,"_17":375},{"_37":269,"_13":106,"_80":105,"_47":150,"_39":40,"_237":44,"_238":24,"_41":370,"_43":26,"_83":107,"_240":-5,"_84":30,"_241":-5,"_308":371,"_17":372},{"_37":363,"_13":364,"_80":365,"_47":105,"_39":40,"_237":115,"_238":24,"_41":366,"_43":44,"_83":100,"_240":367,"_84":30,"_241":-5,"_308":368,"_17":369},{"_37":355,"_13":356,"_80":357,"_47":105,"_39":40,"_237":358,"_238":24,"_41":359,"_43":26,"_83":100,"_240":360,"_84":30,"_241":-5,"_308":361,"_17":362},{"_37":347,"_13":348,"_80":349,"_47":105,"_39":40,"_237":350,"_238":24,"_41":351,"_43":26,"_83":100,"_240":352,"_84":30,"_241":-5,"_308":353,"_17":354},{"_37":265,"_13":113,"_80":112,"_47":150,"_39":40,"_237":144,"_238":24,"_41":344,"_43":44,"_83":21,"_240":267,"_84":30,"_241":-5,"_308":345,"_17":346},{"_37":261,"_13":118,"_80":117,"_47":150,"_39":40,"_237":44,"_238":24,"_41":341,"_43":26,"_83":21,"_240":263,"_84":30,"_241":-5,"_308":342,"_17":343},{"_37":257,"_13":93,"_80":92,"_47":150,"_39":40,"_237":121,"_238":24,"_41":338,"_43":44,"_83":21,"_240":259,"_84":30,"_241":-5,"_308":339,"_17":340},{"_37":253,"_13":99,"_80":98,"_47":150,"_39":40,"_237":129,"_238":24,"_41":335,"_43":44,"_83":100,"_240":255,"_84":30,"_241":-5,"_308":336,"_17":337},{"_37":249,"_13":82,"_80":81,"_47":150,"_39":40,"_237":137,"_238":24,"_41":332,"_43":44,"_83":21,"_240":251,"_84":30,"_241":-5,"_308":333,"_17":334},{"_37":328,"_13":320,"_80":314,"_47":-5,"_39":40,"_237":44,"_238":24,"_41":329,"_43":26,"_83":107,"_240":-5,"_84":30,"_241":-5,"_308":330,"_17":331},{"_37":321,"_13":113,"_80":322,"_47":314,"_39":40,"_237":323,"_238":24,"_41":324,"_43":44,"_83":21,"_240":325,"_84":30,"_241":-5,"_308":326,"_17":327},{"_37":311,"_13":312,"_80":313,"_47":314,"_39":40,"_237":315,"_238":24,"_41":316,"_43":44,"_83":100,"_240":317,"_84":30,"_241":-5,"_308":318,"_17":319},{"_37":303,"_13":113,"_80":304,"_47":-5,"_39":40,"_237":305,"_238":24,"_41":306,"_43":44,"_83":21,"_240":307,"_84":30,"_241":-5,"_308":309,"_17":310},"823e2a02-5acb-11f0-a5a1-f69ea79377d9","72a1cd46-1e2a-406a-bb0f-ee8d802a3015",12,["D",1751849055834],"# 4x4 Grid Visual Editor\n\nA simple visual editor for creating and managing black and white 4x4 grids. Built with React, Hono, and Val Town.\n\n## Features\n\n- **Visual Grid Editor**: Click cells to toggle between black and white\n- **Text Representation**: Automatically generates a textual representation showing black cell indices and white cell count\n- **Save Functionality**: Save grids to persistent storage (grids can only be saved once)\n- **Saved Grids View**: Browse all previously saved grids in a read-only format\n- **Copy to Clipboard**: Easy copying of text representations\n\n## Project Structure\n\nThis app is broken up into three folders, corresponding to where the code in those folders run:\n\n- `backend/` - runs on Val Town serverless infrastructure in Deno\n- `frontend/` - runs in the user's browser\n- `shared/` - runs in both the frontend and backend\n\nThe entrypoint of this app is `backend/index.ts`, which is the Hono HTTP server, which serves the HTML, CSS, and JS, which run client-side.\n\n## Storage\n\nUses Val Town's blob storage to persist saved grids. The storage key `savedGrids` contains an array of all saved grid objects.\n\nYou can click into each of those folders to view their respective READMEs.","children",[],[113],"25501d96-5acb-11f0-9852-f69ea79377d9","utils.ts","06089187-989a-4643-9050-c61f57b0d0b3","f904af22-e8b6-4a9e-bc0a-aec6a5114ecd",2,["D",1751848899918],"export interface Grid {\n id: string;\n cells: boolean[]; // 16 cells for 4x4 grid, true = black, false = white\n timestamp: string;\n saved: boolean;\n}\n\nexport const GRID_SIZE = 4;\nexport const TOTAL_CELLS = GRID_SIZE * GRID_SIZE;\n\n// Convert grid to textual representation\nexport function gridToText(cells: boolean[]): string {\n const blackIndices = cells\n .map((isBlack, index) => isBlack ? index : -1)\n .filter(index => index !== -1);\n \n const whiteCount = cells.filter(cell => !cell).length;\n \n return `[${blackIndices.join(', ')}], // ${whiteCount} white cells`;\n}\n\n// Create empty grid (all white)\nexport function createEmptyGrid(): boolean[] {\n return new Array(TOTAL_CELLS).fill(false);\n}",[],[320,312],"shared","bc6defaa-5acb-11f0-bf26-f69ea79377d9","ba9804d2-fdc3-4c3b-b012-94f1a95a19bb",16,["D",1751849153408],"# Shared\n\nThis folder contains code and types that are needed on both the frontend and the backend. It's important that you write this code in a particularly defensive way because it's limited by what both environments support:\n\n![shapes at 25-02-25 11.57.13.png](https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/75db1d51-d9b3-45e0-d178-25d886c10700/public)\n\nFor example, you *cannot* use the `Deno` keyword. For imports, you can't use `npm:` specifiers, so we recommend `https://esm.sh` because it works on the server & client. You *can* use TypeScript because that is transpiled in `/backend/index.ts` for the frontend. Most code that works on the frontend tends to work in Deno, because Deno is designed to support \"web-standards\", but there are definitely edge cases to look out for.\n\n## Grid Types and Utilities\n\nThis folder contains:\n\n- `Grid` interface: TypeScript type for grid objects\n- `GRID_SIZE` and `TOTAL_CELLS` constants\n- `gridToText()`: Converts grid state to textual representation\n- `createEmptyGrid()`: Creates a new empty (all white) grid\n\nThese utilities are used by both the frontend React components and the backend API handlers.",[],[320,113],"040d9aaa-5acb-11f0-a3bc-f69ea79377d9",["D",1751848844056],[300,301],[320],["D",1751849030478],[],[18,82],["D",1751848996975],[],[18,99],["D",1751848938236],[],[18,93],["D",1751848844056],[],[18,118],["D",1751849137589],[],[18,113],"587fdaa8-5acb-11f0-8c87-f69ea79377d9","SavedGridsView.tsx","587fdb66-5acb-11f0-8c87-f69ea79377d9",8,["D",1751848985802],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { type Grid, GRID_SIZE, gridToText } from \"../../shared/utils.ts\";\n\ninterface SavedGridsViewProps {\n grids: Grid[];\n}\n\nexport function SavedGridsView({ grids }: SavedGridsViewProps) {\n if (grids.length === 0) {\n return (\n

No saved grids yet. Create and save a grid in the Editor tab!

\n );\n }\n\n return (\n

Saved Grids ({grids.length})

\n {grids.map((grid) => (\n \n ))}\n

\n );\n}\n\nfunction SavedGridItem({ grid }: { grid: Grid }) {\n const formattedDate = new Date(grid.timestamp).toLocaleString();\n const textRepresentation = gridToText(grid.cells);\n\n return (\n

\n Saved: {formattedDate}\n

\n \n

\n {grid.cells.map((isBlack, index) => (\n \n ))}\n

\n\n

\n {textRepresentation}\n \n

\n );\n}",[],[18,106,348],"50062256-5acb-11f0-ba5c-f69ea79377d9","GridEditor.tsx","50062346-5acb-11f0-ba5c-f69ea79377d9",7,["D",1751848971585],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { type Grid, GRID_SIZE, createEmptyGrid, gridToText } from \"../../shared/utils.ts\";\n\ninterface GridEditorProps {\n onGridSaved: () => void;\n}\n\nexport function GridEditor({ onGridSaved }: GridEditorProps) {\n const [cells, setCells] = React.useState(createEmptyGrid());\n const [gridId] = React.useState(() => crypto.randomUUID());\n const [isSaved, setIsSaved] = React.useState(false);\n const [isSaving, setIsSaving] = React.useState(false);\n\n const toggleCell = (index: number) => {\n if (isSaved) return; // Don't allow editing saved grids\n \n setCells(prev => {\n const newCells = [...prev];\n newCells[index] = !newCells[index];\n return newCells;\n });\n };\n\n const resetGrid = () => {\n if (isSaved) return;\n setCells(createEmptyGrid());\n };\n\n const saveGrid = async () => {\n if (isSaved || isSaving) return;\n\n setIsSaving(true);\n try {\n const grid: Grid = {\n id: gridId,\n cells,\n timestamp: new Date().toISOString(),\n saved: false\n };\n\n const response = await fetch(\"/grids\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify(grid),\n });\n\n if (response.ok) {\n setIsSaved(true);\n onGridSaved();\n } else {\n const error = await response.json();\n alert(`Failed to save grid: ${error.error}`);\n }\n } catch (error) {\n console.error(\"Failed to save grid\", error);\n alert(\"Failed to save grid\");\n } finally {\n setIsSaving(false);\n }\n };\n\n const textRepresentation = gridToText(cells);\n\n return (\n

\n {cells.map((isBlack, index) => (\n toggleCell(index)}\n title={`Cell ${index} - Click to ${isBlack ? 'make white' : 'make black'}`}\n />\n ))}\n

\n\n

\n \n \n

\n\n

Text Representation:

\n {textRepresentation}\n \n

\n\n {isSaved && (\n

\n ✅ Grid saved! This grid can no longer be edited.\n

\n )}\n

\n );\n}",[],[18,106,356],"469a7d70-5acb-11f0-8d6d-f69ea79377d9","App.tsx","c51574f8-fdb9-460a-91fa-36e75158900c",["D",1751848955763],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { type Grid, GRID_SIZE, createEmptyGrid, gridToText } from \"../../shared/utils.ts\";\nimport { GridEditor } from \"./GridEditor.tsx\";\nimport { SavedGridsView } from \"./SavedGridsView.tsx\";\n\nexport function App(\n { savedGrids = [], thisProjectURL }: { savedGrids?: Grid[]; thisProjectURL?: string },\n) {\n const [currentTab, setCurrentTab] = React.useState<'editor' | 'saved'>('editor');\n const [grids, setGrids] = React.useState(savedGrids);\n\n const fetchSavedGrids = async () => {\n try {\n const response = await fetch(\"/grids\");\n const data = await response.json();\n setGrids(data);\n } catch (error) {\n console.error(\"Failed to fetch saved grids\", error);\n }\n };\n\n return (\n

🎨 4x4 Grid Editor

\n \n

\n \n \n

\n\n

\n {currentTab === 'editor' ? (\n \n ) : (\n \n )}\n

\n\n {thisProjectURL && (\n \n )}\n

\n );\n}",[],[18,106,364],["D",1751848844056],[291,292,293],[18,106],["D",1751848844056],[290,294,295,296,297,298],[18],"394e49d0-5acb-11f0-a8e1-f69ea79377d9","index.ts","f7a1ab55-c2ca-4b4f-a54f-ec57c03ce174","93514baf-b2a6-4f97-b1b5-0a071667f576",4,["D",1751848933465],"http","import { parseProject, readFile, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport { getSavedGrids, saveGrid } from \"./database/queries.ts\";\n\nconst app = new Hono();\n\n// Serve index.html at the root /\napp.get(\"/\", async c => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n\n // Bootstrap the initial saved grids data into index.html\n // To avoid an extra request and loading flash\n const savedGrids = await getSavedGrids();\n\n // Get this project's URL, in a way that works across forks and branches\n const projectVal = parseProject(import.meta.url);\n const thisProjectURL = projectVal.links.self.project;\n\n // Inject the data as a global variable inside a script tag\n const dataScript = ``;\n\n // Insert the script right before the closing tag\n html = html.replace(\"\", `${dataScript}`);\n\n return c.html(html);\n});\n\n// Serve all /frontend files under /public\napp.get(\"/public/**/*\", c => serveFile(c.req.path.replace(\"/public\", \"/frontend\"), import.meta.url));\n\n// Serve all /shared files under /shared\napp.get(\"/shared/**/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Provide an endpoint for the frontend to get saved grids as JSON\napp.get(\"/grids\", async (c) => {\n const grids = await getSavedGrids();\n return c.json(grids);\n});\n\n// Provide an endpoint for the frontend to save a new grid\napp.post(\"/grids\", async (c) => {\n try {\n const grid = await c.req.json();\n\n if (!grid || !grid.id || !Array.isArray(grid.cells) || grid.cells.length !== 16) {\n return c.json({ error: \"Invalid grid data\" }, 400);\n }\n\n await saveGrid(grid);\n return c.json({ success: true }, 201);\n } catch (error) {\n if (error.message === \"Grid has already been saved\") {\n return c.json({ error: error.message }, 409);\n }\n throw error;\n }\n});\n\n// Unwrap and rethrow Hono errors as the original error\n// If you delete this, all errors will be \"Internal Server Error\"\napp.onError((err, c) => {\n throw err;\n});\n\n// HTTP vals expect an exported \"fetch handler\"\n// This is how you \"run the server\" in Val Town with Hono\nexport default app.fetch;",[],[386,377],"backend","2ee5040c-cc81-11f0-90e6-42dde27851f2","getgrids.ts",["D",1764351565800],17,"import { getSavedGrids } from \"./database/queries.ts\";\nimport { blob } from \"https://esm.town/v/std/blob\";\n\n\n\nconst savedGrids = await blob.getJSON(\"savedGrids\");\n\n const gridWhitesCount = grid => grid.cells.filter(x => x === false).length;\n const templateA = savedGrids.filter(x => gridWhitesCount(x) === 10)[0]\n\n\n\n\nexport default async function(request: Request) {\n return new Response(JSON.stringify(savedGrids))\n}",[],[386,388],"9c7be148-5acb-11f0-8a2d-f69ea79377d9","9d4b149e-2007-4d2e-bae8-882b807d1e36",13,["D",1751849099864],"# Backend\n\nThis folder contains all backend-only code in this project. It's broken up into:\n\n* `index.ts` - this is the **entrypoint** for this whole project\n* `database/` - this contains the code for interfacing with Val Town's blob storage\n\n## Hono\n\nThis app uses [Hono](https://hono.dev/) as the API framework. You can think of Hono as a replacement for [ExpressJS](https://expressjs.com/) that works in serverless environments like Val Town or Cloudflare Workers. If you come from Python or Ruby, Hono is also a lot like [Flask](https://github.com/pallets/flask) or [Sinatra](https://github.com/sinatra/sinatra), respectively.\n\n## Serving assets to the frontend\n\nThis backend HTTP server is responsible for serving all static assets to the browser to render the app, including HTML, JavaScript (including all client-side React), CSS, and even the favicon SVG.\n\nIn a normal server environment, you would likely use a middleware [like this one](https://hono.dev/docs/getting-started/nodejs#serve-static-files) to serve static files. Some frameworks or deployment platforms automatically make any content inside a `public/` folder public. \n\nHowever in Val Town you need to handle this yourself, and it can be suprisingly difficult to read and serve files in a Val Town Project. This template uses helper functions from [stevekrouse/utils/serve-public](https://www.val.town/x/stevekrouse/utils/branch/main/code/serve-public/README.md), which handle reading project files in a way that will work across branches and forks, automatically transpiles typescript to javascript, and assigns content-types based on the file's extension.\n\n### `index.html`\n\nThe most complicated part of this backend API is serving index.html. In this app (like most apps) we serve it at the root, ie `GET /`. \n\nWe *bootstrap* `index.html` with some initial data from the server, so that it gets dynamically injected JSON data without having to make another round-trip request to the server to get that data on the frontend. This is a common pattern for client-side rendered apps.\n\n## CRUD API Routes\n\nThis app has two CRUD API routes: for reading and saving grids. They both speak JSON, which is standard. They import their functions from `/backend/database/queries.ts`. These routes are called from the React app to refresh and update data.\n\n## Storage\n\nInstead of SQLite, this app uses Val Town's blob storage to persist saved grids. This is simpler for this use case and doesn't require database migrations.\n\n## Errors\n\nHono and other API frameworks have a habit of swallowing up Errors. We turn off this default behavior by re-throwing errors, because we think most of the time you'll want to see the full stack trace instead of merely \"Internal Server Error\". You can customize how you want errors to appear.",[],[386,113],"c9c1e526-5acb-11f0-9822-f69ea79377d9","queries.ts","5979949f-2d7b-42aa-9829-74919ef30921","142351da-8260-45dc-a2c9-87d1b7c3f07c",["D",1751849175816],"import { blob } from \"https://esm.town/v/std/blob\";\nimport { type Grid } from \"../../shared/utils.ts\";\n\nconst SAVED_GRIDS_KEY = \"savedGrids\";\n\nexport async function getSavedGrids(): Promise {\n try {\n const savedGrids = await blob.getJSON(SAVED_GRIDS_KEY);\n \n // Handle legacy format or empty case\n if (!savedGrids) {\n return [];\n }\n \n // If it's already an array, return it\n if (Array.isArray(savedGrids)) {\n return savedGrids;\n }\n \n // If it's the old object format, convert it to new array format\n if (typeof savedGrids === 'object') {\n const convertedGrids: Grid[] = [];\n for (const [key, value] of Object.entries(savedGrids)) {\n if (value && typeof value === 'object' && 'gridState' in value) {\n const legacyGrid = value as any;\n convertedGrids.push({\n id: crypto.randomUUID(),\n cells: legacyGrid.gridState || new Array(16).fill(false),\n timestamp: legacyGrid.savedAt || new Date().toISOString(),\n saved: true\n });\n }\n }\n \n // Save the converted format back to blob storage\n if (convertedGrids.length > 0) {\n await blob.setJSON(SAVED_GRIDS_KEY, convertedGrids);\n }\n \n return convertedGrids;\n }\n \n return [];\n } catch (error) {\n // If the key doesn't exist, return empty array\n return [];\n }\n}\n\nexport async function saveGrid(grid: Grid): Promise {\n const savedGrids = await getSavedGrids();\n \n // Check if grid is already saved\n const existingGrid = savedGrids.find(g => g.id === grid.id);\n if (existingGrid) {\n throw new Error(\"Grid has already been saved\");\n }\n \n // Mark as saved and add to collection\n grid.saved = true;\n savedGrids.push(grid);\n \n await blob.setJSON(SAVED_GRIDS_KEY, savedGrids);\n}",[],[386,409,402],"database","040d6f9e-5acb-11f0-a3bc-f69ea79377d9","migrations.ts","bc96213c-425e-47b2-9017-7f21e4a785bb",["D",1751848844056],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nexport const tableName = \"reactHonoStarter_messages\";\n\nexport async function createTables() {\n await sqlite.batch([\n `CREATE TABLE IF NOT EXISTS ${tableName} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n content TEXT NOT NULL,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n )`,\n /* Add any other tables or migrations you want here\n\n However, you should know that SQLite has much more limited\n support for altering existing tables as compared to other databases.\n Often it's easier to create new tables with the schema you want, and then\n copy the data over. */\n ]);\n}",[],[386,409,411],"a79c0012-5acb-11f0-8d8f-f69ea79377d9","8c137ceb-1bb6-4ce3-af63-d421f501e864",14,["D",1751849118526],"# Database\n\nThis app uses [Val Town Blob Storage](https://docs.val.town/std/blob/) to manage data. Every Val Town account comes with free blob storage for simple key-value data persistence. This folder contains:\n\n* `queries.ts` - functions to read and write grid data to blob storage, which are imported and used in the main Hono server in `/backend/index.ts`\n\n## Storage Strategy\n\nInstead of using SQLite, this app uses blob storage because:\n- Simpler for this use case (no complex relationships)\n- No need for database migrations\n- Easy JSON serialization/deserialization\n- Perfect for storing arrays of grid objects\n\n## Data Structure\n\nThe app stores a single blob with the key `savedGrids` containing an array of Grid objects. Each grid has:\n- `id`: unique identifier\n- `cells`: array of 16 booleans representing the 4x4 grid state\n- `timestamp`: when the grid was created\n- `saved`: whether the grid has been saved (prevents duplicate saves)\n\n## Queries\n\nThe queries file exports functions to:\n- `getSavedGrids()`: Retrieve all saved grids from blob storage\n- `saveGrid(grid)`: Add a new grid to the saved collection (with duplicate prevention)\n\nThe functions handle cases where the blob doesn't exist yet and provide proper error handling for duplicate saves.",[],[386,409,113],"040d7480-5acb-11f0-a3bc-f69ea79377d9",["D",1751848844056],[283,284,285],[386,409],"040d85ec-5acb-11f0-a3bc-f69ea79377d9",["D",1751848844056],[282,286,287,288],[386],["D",1751848844056],{"_11":12,"_202":87},{"_11":12,"_197":198,"_86":87,"_31":85,"_199":200,"_201":30},{"_43":185,"_13":16,"_37":40,"_186":152,"_187":77,"_188":189,"_190":156,"_191":192,"_193":194,"_195":14,"_196":12},"ctx",{"_56":-5,"_223":469,"_470":471,"_472":473,"_474":30,"_475":30,"_476":30,"_477":24,"_478":-5,"_479":-7,"_480":-7,"_481":26,"_482":30,"_483":30,"_484":-5,"_485":30,"_486":30,"_487":30,"_488":-5},"ENV",{"_440":441,"_442":443,"_444":16,"_445":446,"_447":448,"_449":450,"_451":452,"_453":454,"_455":456,"_457":458,"_459":460,"_461":462,"_463":464,"_465":466,"_467":468},"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"]

History · frontend