[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_349":350,"_351":352},"routes/_app.x.$handle.$name",{"_97":96,"_31":44,"_105":87,"_26":52,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":24,"_119":120,"_121":24,"_122":-5,"_123":-5,"_124":125},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":24},"version",23,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","dashboard/backend/database/queries.ts","latestPath","fileId","31dfcc56-2933-11f0-befd-569c3dd06744","name","queries.ts","fileType","script","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { type Memory } from \"../../shared/types.ts\";\n\n// toggle the commented out table name to switch between the demo and production tables\n// const tableName = \"memories\";\nconst tableName = \"memories_demo\";\n\nexport async function getAllMemories(): Promise {\n const result = await sqlite.execute(\n `SELECT id, date, text, createdBy, createdDate, tags FROM ${tableName}\n ORDER BY createdDate DESC`\n );\n\n // Ensure correct typing, especially for potential null values\n return result.rows.map((row) => ({\n id: row.id as string,\n date: row.date as string | null,\n text: row.text as string,\n createdBy: row.createdBy as string | null,\n createdDate: row.createdDate as number | null,\n tags: row.tags as string | null,\n })) as Memory[];\n}\n\nexport async function createMemory(\n memory: Omit\n): Promise {\n // Use nanoid like in getWeather.ts\n const { nanoid } = await import(\"https://esm.sh/nanoid@5.0.5\");\n const newId = nanoid(10); // Generate a shorter ID like in getWeather\n const createdDate = memory.createdDate ?? Date.now(); // Default to now if not provided\n\n await sqlite.execute(\n `INSERT INTO ${tableName} (id, date, text, createdBy, createdDate, tags)\n VALUES (?, ?, ?, ?, ?, ?)`,\n [\n newId,\n memory.date,\n memory.text,\n memory.createdBy || \"dashboard\", // Default creator\n createdDate,\n memory.tags,\n ]\n );\n\n return {\n ...memory,\n id: newId,\n createdDate,\n };\n}\n\nexport async function updateMemory(\n id: string,\n memory: Partial>\n): Promise {\n const fields = Object.keys(memory).filter((key) => key !== \"id\");\n const values = Object.values(memory);\n\n if (fields.length === 0) {\n throw new Error(\"No fields provided for update\");\n }\n\n const setClause = fields.map((field) => `${field} = ?`).join(\", \");\n\n await sqlite.execute(`UPDATE ${tableName} SET ${setClause} WHERE id = ?`, [\n ...values,\n id,\n ]);\n}\n\nexport async function deleteMemory(id: string): Promise {\n await sqlite.execute(`DELETE FROM ${tableName} WHERE id = ?`, [id]);\n}\n","createdAt",["D",1746396030423],"branchVersion","branchId","310ed38a-2933-11f0-9935-569c3dd06744","id","310e0586-2933-11f0-9935-569c3dd06744","a574a4824db_",["D",1746396029148],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","37ba9450-2873-11f0-89c9-c7d0e2d9e1ea","pinnedFileId","31e3af6a-2933-11f0-bd55-569c3dd06744","pinPreview",true,"pinMigrated","screenshotVersion",47,"likeCount",0,"orgId","62b2fe23-7ead-40f7-8ba8-fb3de4aaca50","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_97":96,"_104":100},"org",{"_97":96,"_98":-5,"_99":100,"_18":54,"_101":102,"_103":24},"branch",{"_13":86,"_31":87,"_42":41,"_88":43,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":44,"_95":96},"isOwned",49,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","vtTestLocal","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ3YmNBQW9hQUdHRGIxdVBJYnp2QVZrQnk5NiJ9","tier","pro","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_42":43,"_31":44,"_37":345,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":346,"_81":347,"_83":348,"_85":24},"tree",[175,176,194,195,196],"files",[175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197],"counts",{"_165":63,"_166":135,"_167":63,"_168":169,"_170":171},"contents",[126,127,128,129,130],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":159,"_31":160,"_29":161,"_134":-5,"_40":41,"_39":162,"_136":58,"_37":163,"_13":63,"_33":138,"_35":-5,"_23":24,"_139":-5,"_26":164},{"_42":153,"_31":154,"_29":155,"_134":-5,"_40":41,"_39":156,"_136":58,"_37":157,"_13":63,"_33":138,"_35":-5,"_23":24,"_139":-5,"_26":158},{"_42":147,"_31":148,"_29":149,"_134":-5,"_40":41,"_39":150,"_136":58,"_37":151,"_13":63,"_33":138,"_35":-5,"_23":24,"_139":-5,"_26":152},{"_42":141,"_31":142,"_29":143,"_134":-5,"_40":41,"_39":144,"_136":58,"_37":145,"_13":63,"_33":138,"_35":-5,"_23":24,"_139":-5,"_26":146},{"_42":131,"_31":132,"_29":133,"_134":-5,"_40":41,"_39":135,"_136":58,"_37":137,"_13":63,"_33":138,"_35":-5,"_23":24,"_139":-5,"_26":140},"312e9d00-2933-11f0-8866-569c3dd06744","shared","312e9de6-2933-11f0-8866-569c3dd06744","parentId",1,"latest",["D",1746396029305],"directory","label",[132],"31428e1e-2933-11f0-b5e4-569c3dd06744","importers","31428edc-2933-11f0-b5e4-569c3dd06744",3,["D",1746396029494],[142],"3150c65a-2933-11f0-befd-569c3dd06744","dbUtils","3150c704-2933-11f0-befd-569c3dd06744",4,["D",1746396029553],[148],"31389e86-2933-11f0-8866-569c3dd06744","dashboard","31389f26-2933-11f0-8866-569c3dd06744",2,["D",1746396029430],[154],"31602de8-2933-11f0-8a9c-569c3dd06744","dailyBriefing","31602eba-2933-11f0-8a9c-569c3dd06744",5,["D",1746396029687],[160],"pulls","branches","forks","envVars",{"_172":63,"_174":63},"connections",{"_172":63,"_173":63},"count","unfilledCount","emptyCount",{"_42":159,"_31":160,"_29":161,"_134":-5,"_40":41,"_39":162,"_136":58,"_37":342,"_13":63,"_33":138,"_35":-5,"_23":24,"_139":-5,"_204":343,"_26":344},{"_42":153,"_31":154,"_29":155,"_134":-5,"_40":41,"_39":156,"_136":58,"_37":339,"_13":63,"_33":138,"_35":-5,"_23":24,"_139":-5,"_204":340,"_26":341},{"_42":334,"_31":319,"_29":329,"_134":155,"_40":41,"_39":335,"_136":58,"_37":336,"_13":63,"_33":138,"_35":-5,"_23":24,"_139":-5,"_204":337,"_26":338},{"_42":328,"_31":320,"_29":315,"_134":329,"_40":41,"_39":330,"_136":58,"_37":331,"_13":63,"_33":138,"_35":-5,"_23":24,"_139":-5,"_204":332,"_26":333},{"_42":321,"_31":233,"_29":322,"_134":315,"_40":41,"_39":323,"_136":58,"_37":324,"_13":63,"_33":20,"_35":325,"_23":24,"_139":-5,"_204":326,"_26":327},{"_42":314,"_31":32,"_29":30,"_134":315,"_40":41,"_39":14,"_136":58,"_37":316,"_13":63,"_33":34,"_35":36,"_23":24,"_139":-5,"_204":317,"_26":318},{"_42":309,"_31":254,"_29":248,"_134":155,"_40":41,"_39":310,"_136":58,"_37":311,"_13":63,"_33":138,"_35":-5,"_23":24,"_139":-5,"_204":312,"_26":313},{"_42":304,"_31":287,"_29":281,"_134":248,"_40":41,"_39":305,"_136":58,"_37":306,"_13":63,"_33":138,"_35":-5,"_23":24,"_139":-5,"_204":307,"_26":308},{"_42":296,"_31":297,"_29":298,"_134":281,"_40":41,"_39":299,"_136":58,"_37":300,"_13":63,"_33":34,"_35":301,"_23":24,"_139":-5,"_204":302,"_26":303},{"_42":288,"_31":289,"_29":290,"_134":281,"_40":41,"_39":291,"_136":58,"_37":292,"_13":63,"_33":34,"_35":293,"_23":24,"_139":-5,"_204":294,"_26":295},{"_42":278,"_31":279,"_29":280,"_134":281,"_40":41,"_39":282,"_136":58,"_37":283,"_13":63,"_33":34,"_35":284,"_23":24,"_139":-5,"_204":285,"_26":286},{"_42":271,"_31":233,"_29":272,"_134":248,"_40":41,"_39":273,"_136":58,"_37":274,"_13":63,"_33":20,"_35":275,"_23":24,"_139":-5,"_204":276,"_26":277},{"_42":263,"_31":264,"_29":265,"_134":248,"_40":41,"_39":266,"_136":58,"_37":267,"_13":63,"_33":20,"_35":268,"_23":24,"_139":-5,"_204":269,"_26":270},{"_42":255,"_31":256,"_29":257,"_134":248,"_40":41,"_39":258,"_136":58,"_37":259,"_13":63,"_33":20,"_35":260,"_23":24,"_139":-5,"_204":261,"_26":262},{"_42":245,"_31":246,"_29":247,"_134":248,"_40":41,"_39":249,"_136":58,"_37":250,"_13":63,"_33":34,"_35":251,"_23":24,"_139":-5,"_204":252,"_26":253},{"_42":240,"_31":132,"_29":219,"_134":155,"_40":41,"_39":241,"_136":58,"_37":242,"_13":63,"_33":138,"_35":-5,"_23":24,"_139":-5,"_204":243,"_26":244},{"_42":232,"_31":233,"_29":234,"_134":219,"_40":41,"_39":235,"_136":58,"_37":236,"_13":63,"_33":20,"_35":237,"_23":24,"_139":-5,"_204":238,"_26":239},{"_42":225,"_31":199,"_29":226,"_134":219,"_40":41,"_39":227,"_136":58,"_37":228,"_13":63,"_33":34,"_35":229,"_23":24,"_139":-5,"_204":230,"_26":231},{"_42":216,"_31":217,"_29":218,"_134":219,"_40":41,"_39":220,"_136":58,"_37":221,"_13":63,"_33":34,"_35":222,"_23":24,"_139":-5,"_204":223,"_26":224},{"_42":147,"_31":148,"_29":149,"_134":-5,"_40":41,"_39":150,"_136":58,"_37":213,"_13":63,"_33":138,"_35":-5,"_23":24,"_139":-5,"_204":214,"_26":215},{"_42":141,"_31":142,"_29":143,"_134":-5,"_40":41,"_39":144,"_136":58,"_37":210,"_13":63,"_33":138,"_35":-5,"_23":24,"_139":-5,"_204":211,"_26":212},{"_42":131,"_31":132,"_29":133,"_134":-5,"_40":41,"_39":135,"_136":58,"_37":207,"_13":63,"_33":138,"_35":-5,"_23":24,"_139":-5,"_204":208,"_26":209},{"_42":198,"_31":199,"_29":200,"_134":133,"_40":41,"_39":201,"_136":58,"_37":202,"_13":63,"_33":34,"_35":203,"_23":24,"_139":-5,"_204":205,"_26":206},"31a33872-2933-11f0-bd55-569c3dd06744","types.ts","31a3393a-2933-11f0-bd55-569c3dd06744",11,["D",1746396030129],"export interface Memory {\n id: string;\n date: string;\n text: string;\n tags: string | null;\n\n // New fields from schema\n createdBy?: string;\n createdDate?: number;\n}\n","children",[],[132,199],["D",1746396029305],[197],[132],["D",1746396029494],[],[142],["D",1746396029553],[],[148],"31b202ee-2933-11f0-9935-569c3dd06744","utils.ts","31b204c4-2933-11f0-9935-569c3dd06744","316fa0fc-2933-11f0-881a-569c3dd06744",13,["D",1746396030130],"export interface Message {\n content: string;\n}\n\nexport const MESSAGE_LIMIT = 5;",[],[154,132,217],"31af0012-2933-11f0-b4ff-569c3dd06744","31af00c6-2933-11f0-b4ff-569c3dd06744",12,["D",1746396030130],"/**\n * @jsxImportSource https://esm.sh/react@18.2.0\n */\n\nexport interface Memory {\n id: string; // UUID\n date: string; // ISO 8601 date string or similar\n text: string;\n createdBy?: string | null; // Optional: Who/what created the memory\n createdDate?: number | null; // Optional: Unix timestamp (integer)\n tags?: string | null; // Optional: Comma-separated string or JSON\n}\n",[],[154,132,199],"31b8f374-2933-11f0-895c-569c3dd06744","README.md","31b8f450-2933-11f0-895c-569c3dd06744",15,["D",1746396030131],"# Shared\n\nIt's common to have 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 reccomend `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.",[],[154,132,233],"316fa066-2933-11f0-881a-569c3dd06744",6,["D",1746396029790],[191,192,193],[154,132],"31d836f8-2933-11f0-beb3-569c3dd06744","index.tsx","31d837ac-2933-11f0-beb3-569c3dd06744","317a3350-2933-11f0-b799-569c3dd06744",21,["D",1746396030397],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./components/App.tsx\";\n\nconst rootElement = document.getElementById(\"root\");\nif (!rootElement) {\n throw new Error(\"Root element #root not found\");\n}\n\nconst root = createRoot(rootElement);\nroot.render();\n",[],[154,254,246],"frontend","31d432ec-2933-11f0-be81-569c3dd06744","index.html","31d433be-2933-11f0-be81-569c3dd06744",20,["D",1746396030373],"\n\n \n \n \n Stevens' Notebook\n \n \n \n \n \n \n \n \n \n

\n \n \n \n\n",[],[154,254,256],"31c43b76-2933-11f0-9935-569c3dd06744","favicon.svg","31c43c34-2933-11f0-9935-569c3dd06744",18,["D",1746396030292],"",[],[154,254,264],"31cb86ec-2933-11f0-895c-569c3dd06744","31cb8796-2933-11f0-895c-569c3dd06744",19,["D",1746396030331],"# Frontend\n\nThis template is a classic client-side-only React app. \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 becaues 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 only 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 is where the React components are stored. They're pretty standard client-side React components.",[],[154,254,233],"31b595bc-2933-11f0-9ad8-569c3dd06744","assets.ts","31b59648-2933-11f0-9ad8-569c3dd06744","318ccdb2-2933-11f0-beb3-569c3dd06744",14,["D",1746396030145],"export const ASSETS = {\n // Background\n BACKGROUND:\n \"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/8b501664-722e-4be8-cf71-83aab7756e00/public\",\n\n // Stevens\n STEVENS_FRONT:\n \"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/8b8432bb-add2-44ad-bb12-44b8ea215500/public\",\n STEVENS_BACK:\n \"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/e28da8ab-7710-4b82-8e32-8fdf65c2ed00/public\",\n STEVENS_WALKING:\n \"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/bd7b9997-09b2-4b35-6eb9-9975a85bb700/public\",\n\n // Mailman\n MAILMAN_STANDING:\n \"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/20a6493d-cc31-475e-aa83-ac97d317e400/public\",\n MAILMAN_WALKING:\n \"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/61604576-8a83-4d85-d5e4-8e8e26641700/public\",\n};\n\n// Scene positions for characters and interactive elements\nexport const SCENE_POSITIONS = {\n // Stevens starts inside the house near the notebook\n STEVENS_DEFAULT: { x: 470, y: 600 },\n\n // Interactive elements\n NOTEBOOK: { x: 540, y: 690 }, // The open book on the table\n CALENDAR: { x: 392, y: 524 }, // Calendar on the wall\n MAILBOX: { x: 160, y: 580 }, // Mailbox outside\n TELEGRAPH: { x: 725, y: 580 }, // Telegraph on the desk\n};\n\n// Source types for different animations\nexport const SOURCE_TYPES = {\n CALENDAR: \"calendar\",\n MAIL: \"usps\",\n TELEGRAM: \"telegram\",\n WEATHER: \"weather\",\n DEFAULT: \"default\",\n};\n",[],[154,254,287,279],"components","31bfd022-2933-11f0-91a2-569c3dd06744","NotebookView.tsx","31bfd0ae-2933-11f0-91a2-569c3dd06744",17,["D",1746396030253],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, {\n useState,\n useEffect,\n useCallback,\n useMemo,\n} from \"https://esm.sh/react@18.2.0\";\nimport { type Memory } from \"../../shared/types.ts\";\n\nconst API_BASE = \"/api/memories\";\nconst MEMORIES_PER_PAGE = 20;\n\n// Format date in natural way: \"Wed, April 12\"\nconst formatDate = (dateStr: string) => {\n if (!dateStr) return \"N/A\";\n\n // Parse the date parts manually to avoid timezone issues\n const [year, month, day] = dateStr.split(\"-\").map((num) => parseInt(num, 10));\n\n // Create date with explicit year, month (0-indexed), and day\n const date = new Date(year, month - 1, day);\n\n return date.toLocaleDateString(\"en-US\", {\n weekday: \"short\",\n month: \"long\",\n day: \"numeric\",\n });\n};\n\n// Sort memories by date (ascending)\nconst sortMemoriesByDate = (memories: Memory[]) => {\n return [...memories].sort((a, b) => {\n if (!a.date) return 1;\n if (!b.date) return -1;\n\n // Parse dates manually to avoid timezone issues\n const [aYear, aMonth, aDay] = a.date\n .split(\"-\")\n .map((num) => parseInt(num, 10));\n const [bYear, bMonth, bDay] = b.date\n .split(\"-\")\n .map((num) => parseInt(num, 10));\n\n // Compare year, then month, then day\n if (aYear !== bYear) return aYear - bYear;\n if (aMonth !== bMonth) return aMonth - bMonth;\n return aDay - bDay;\n });\n};\n\ninterface NotebookViewProps {\n onClose: () => void;\n avatarUrl: string | null;\n}\n\nexport function NotebookView({ onClose, avatarUrl }: NotebookViewProps) {\n const [memories, setMemories] = useState([]);\n const [loading, setLoading] = useState(true);\n const [error, setError] = useState(null);\n const [editingMemory, setEditingMemory] = useState(null);\n const [newMemoryText, setNewMemoryText] = useState(\"\");\n const [newMemoryDate, setNewMemoryDate] = useState(\n new Date().toISOString().split(\"T\")[0]\n );\n const [newMemoryTags, setNewMemoryTags] = useState(\"\");\n const [showAddForm, setShowAddForm] = useState(false);\n const [currentPage, setCurrentPage] = useState(1);\n\n const fetchMemories = useCallback(async () => {\n setLoading(true);\n setError(null);\n try {\n const response = await fetch(API_BASE);\n if (!response.ok) {\n throw new Error(`HTTP error! status: ${response.status}`);\n }\n const data = await response.json();\n setMemories(data);\n } catch (e) {\n console.error(\"Failed to fetch memories:\", e);\n setError(e.message || \"Failed to fetch memories.\");\n } finally {\n setLoading(false);\n }\n }, []);\n\n useEffect(() => {\n fetchMemories();\n }, [fetchMemories]);\n\n const handleAddMemory = async (e: React.FormEvent) => {\n e.preventDefault();\n if (!newMemoryText.trim()) return;\n\n const memoryData: Omit = {\n text: newMemoryText,\n date: newMemoryDate,\n tags: newMemoryTags || null,\n };\n\n try {\n const response = await fetch(API_BASE, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(memoryData),\n });\n if (!response.ok) {\n throw new Error(`HTTP error! status: ${response.status}`);\n }\n setNewMemoryText(\"\");\n setNewMemoryDate(new Date().toISOString().split(\"T\")[0]);\n setNewMemoryTags(\"\");\n setShowAddForm(false);\n await fetchMemories();\n } catch (e) {\n console.error(\"Failed to add memory:\", e);\n setError(e.message || \"Failed to add memory.\");\n }\n };\n\n const handleDeleteMemory = async (id: string) => {\n if (!confirm(\"Are you sure you want to delete this memory?\")) return;\n\n try {\n const response = await fetch(`${API_BASE}/${id}`, {\n method: \"DELETE\",\n });\n if (!response.ok) {\n throw new Error(`HTTP error! status: ${response.status}`);\n }\n await fetchMemories();\n } catch (e) {\n console.error(\"Failed to delete memory:\", e);\n setError(e.message || \"Failed to delete memory.\");\n }\n };\n\n const handleEditMemory = (memory: Memory) => {\n setEditingMemory(memory);\n };\n\n const handleCancelEdit = () => {\n setEditingMemory(null);\n };\n\n const handleUpdateMemory = async (e: React.FormEvent) => {\n e.preventDefault();\n if (!editingMemory || !editingMemory.text.trim()) return;\n\n const updatedFields: Partial> = {\n text: editingMemory.text,\n date: editingMemory.date,\n tags: editingMemory.tags,\n };\n\n try {\n const response = await fetch(`${API_BASE}/${editingMemory.id}`, {\n method: \"PUT\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(updatedFields),\n });\n if (!response.ok) {\n throw new Error(`HTTP error! status: ${response.status}`);\n }\n setEditingMemory(null);\n await fetchMemories();\n } catch (e) {\n console.error(\"Failed to update memory:\", e);\n setError(e.message || \"Failed to update memory.\");\n }\n };\n\n // Sort and paginate memories\n const sortedMemories = useMemo(\n () => sortMemoriesByDate(memories),\n [memories]\n );\n\n const totalPages = Math.max(\n 1,\n Math.ceil(sortedMemories.length / MEMORIES_PER_PAGE)\n );\n\n const paginatedMemories = useMemo(() => {\n const startIndex = (currentPage - 1) * MEMORIES_PER_PAGE;\n return sortedMemories.slice(startIndex, startIndex + MEMORIES_PER_PAGE);\n }, [sortedMemories, currentPage]);\n\n const goToNextPage = () => {\n if (currentPage < totalPages) {\n setCurrentPage(currentPage + 1);\n }\n };\n\n const goToPrevPage = () => {\n if (currentPage > 1) {\n setCurrentPage(currentPage - 1);\n }\n };\n\n // Render edit form modal\n const renderEditForm = () => (\n

\n \n

Edit Entry

\n \n Text\n \n \n setEditingMemory({ ...editingMemory!, text: e.target.value })\n }\n className=\"w-full p-2 bg-[#fff8dc] border-2 border-[#8B4513] text-[#4b3621] focus:outline-none focus:border-[#654321] font-pixel text-base leading-[1.2em]\"\n rows={3}\n required\n />\n

\n \n Date\n \n \n setEditingMemory({ ...editingMemory!, date: e.target.value })\n }\n className=\"w-full p-1 bg-[#fff8dc] border-2 border-[#8B4513] text-[#4b3621] focus:outline-none focus:border-[#654321] font-pixel text-base\"\n />\n

\n \n Source\n \n \n setEditingMemory({ ...editingMemory!, tags: e.target.value })\n }\n className=\"w-full p-1 bg-[#fff8dc] border-2 border-[#8B4513] text-[#4b3621] focus:outline-none focus:border-[#654321] font-pixel text-base\"\n />\n

\n \n UPDATE\n \n setEditingMemory(null)}\n className=\"px-3 py-1 bg-[#A0522D] text-[#f8f1e0] rounded font-pixel text-base hover:bg-[#8B4513] border-2 border-b-4 border-r-4 border-[#4b3621]\"\n >\n CANCEL\n \n

\n \n editingMemory && handleDeleteMemory(editingMemory.id)\n }\n className=\"px-3 py-1 bg-[#555555] text-white rounded font-pixel text-base hover:bg-[#333333] border-2 border-b-4 border-r-4 border-[#222222]\"\n >\n DELETE\n \n

\n \n

\n );\n\n // Render add form\n const renderAddForm = () => (\n

\n \n

New Entry

\n setNewMemoryText(e.target.value)}\n className=\"w-full p-1 bg-[#fff8dc] border-2 border-[#8B4513] text-[#4b3621] focus:outline-none focus:border-[#654321] font-pixel text-base leading-[1.2em]\"\n rows={2}\n placeholder=\"Enter your note...\"\n required\n />\n

\n \n Date\n \n setNewMemoryDate(e.target.value)}\n className=\"w-full p-1 bg-[#fff8dc] border-2 border-[#8B4513] text-[#4b3621] focus:outline-none focus:border-[#654321] font-pixel text-base\"\n />\n

\n \n Source\n \n setNewMemoryTags(e.target.value)}\n className=\"w-full p-1 bg-[#fff8dc] border-2 border-[#8B4513] text-[#4b3621] focus:outline-none focus:border-[#654321] font-pixel text-base\"\n placeholder=\"Optional source\"\n />\n

\n \n SAVE\n \n setShowAddForm(false)}\n className=\"px-3 py-1 bg-[#A0522D] text-[#f8f1e0] rounded font-pixel text-base hover:bg-[#8B4513] border-2 border-b-4 border-r-4 border-[#4b3621]\"\n >\n CANCEL\n \n

\n \n

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

\n \n CLOSE\n \n\n

\n Stevens' Notebook\n

\n\n {error && (\n \n ERROR: {error}\n

\n )}\n\n {loading ? (\n

\n ) : (\n

\n \n \n \n \n \n \n \n \n \n \n {paginatedMemories.length === 0 ? (\n \n \n \n ) : (\n paginatedMemories.map((memory) => (\n \n \n \n \n \n \n ))\n )}\n \n

\n DATE\n	\n NOTE\n	\n SOURCE\n	\n EDIT\n
\n \n NO ENTRIES FOUND\n \n
\n \n {formatDate(memory.date)}\n \n	\n \n {memory.text}\n \n	\n \n {memory.tags \|\| \"\"}\n \n	\n handleEditMemory(memory)}\n className=\"mr-1 text-[#8B4513] hover:text-[#654321] font-pixel text-lg\"\n title=\"Edit\"\n >\n ✎\n \n

\n )}\n\n

\n \n PREV\n \n \n NEXT\n \n

\n Page {currentPage} of {totalPages}\n

\n\n

\n {!showAddForm ? (\n setShowAddForm(true)}\n className=\"px-4 py-2 bg-[#8B4513] text-[#f8f1e0] rounded font-pixel text-lg hover:bg-[#654321] shadow-md border-2 border-b-4 border-r-4 border-[#4b3621]\"\n >\n NEW ENTRY\n \n ) : (\n

{renderAddForm()}

\n )}\n

\n\n {/* Edit Modal */}\n {editingMemory && renderEditForm()}\n \n );\n}\n",[],[154,254,287,289],"31bc8f2a-2933-11f0-bd55-569c3dd06744","App.tsx","31bc8fb6-2933-11f0-bd55-569c3dd06744",16,["D",1746396030268],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, {\n useState,\n useEffect,\n useCallback,\n useMemo,\n} from \"https://esm.sh/react@18.2.0\";\nimport { type Memory } from \"../../shared/types.ts\";\nimport { ASSETS, SCENE_POSITIONS, SOURCE_TYPES } from \"./assets.ts\";\nimport { NotebookView } from \"./NotebookView.tsx\";\n\nconst API_BASE = \"/api/memories\";\nconst MEMORIES_PER_PAGE = 20; // Increased from 7 to 20 memories per page\n\n// Format date in natural way: \"Wed, April 12\"\nconst formatDate = (dateStr: string) => {\n if (!dateStr) return \"N/A\";\n\n // Parse the date parts manually to avoid timezone issues\n const [year, month, day] = dateStr.split(\"-\").map((num) => parseInt(num, 10));\n\n // Create date with explicit year, month (0-indexed), and day\n const date = new Date(year, month - 1, day);\n\n return date.toLocaleDateString(\"en-US\", {\n weekday: \"short\",\n month: \"long\",\n day: \"numeric\",\n });\n};\n\n// Sort memories by date (ascending)\nconst sortMemoriesByDate = (memories: Memory[]) => {\n return [...memories].sort((a, b) => {\n if (!a.date) return 1;\n if (!b.date) return -1;\n\n // Parse dates manually to avoid timezone issues\n const [aYear, aMonth, aDay] = a.date\n .split(\"-\")\n .map((num) => parseInt(num, 10));\n const [bYear, bMonth, bDay] = b.date\n .split(\"-\")\n .map((num) => parseInt(num, 10));\n\n // Compare year, then month, then day\n if (aYear !== bYear) return aYear - bYear;\n if (aMonth !== bMonth) return aMonth - bMonth;\n return aDay - bDay;\n });\n};\n\n// Scene positions for specific elements on the 512x512 grid\nconst SCENE_ELEMENTS = {\n // Main elements\n DESK: { x: 209, y: 304, width: 84, height: 36 },\n DESK_SITTING: { x: 219, y: 264, width: 64, height: 64 },\n MAILBOX: { x: 61, y: 249, width: 52, height: 79 },\n CALENDAR: { x: 156, y: 226, width: 53, height: 53 },\n TELEGRAM: { x: 308, y: 242, width: 62, height: 80 },\n OUTSIDE: { x: 219, y: 366, width: 64, height: 64 },\n};\n\nexport function App() {\n const [memories, setMemories] = useState([]);\n const [loading, setLoading] = useState(true);\n const [error, setError] = useState(null);\n const [editingMemory, setEditingMemory] = useState(null);\n const [newMemoryText, setNewMemoryText] = useState(\"\");\n const [newMemoryDate, setNewMemoryDate] = useState(\n new Date().toISOString().split(\"T\")[0]\n );\n const [newMemoryTags, setNewMemoryTags] = useState(\"\");\n const [showAddForm, setShowAddForm] = useState(false);\n const [currentPage, setCurrentPage] = useState(1);\n const [avatarUrl, setAvatarUrl] = useState(null);\n const [woodUrl, setWoodUrl] = useState(null);\n const [showNotebook, setShowNotebook] = useState(false);\n const [currentMemoryIndex, setCurrentMemoryIndex] = useState(0);\n const [showCaption, setShowCaption] = useState(false);\n const [isAnimating, setIsAnimating] = useState(false);\n const [cookieAndTeaMode, setCookieAndTeaMode] = useState(false);\n\n // Fetch images from backend instead of blob storage directly\n useEffect(() => {\n // Set default background color in case image doesn't load\n if (document.body) {\n document.body.style.backgroundColor = \"#2D1700\"; // Dark brown leather color\n }\n\n // Fetch avatar image\n fetch(\"/api/images/stevens.jpg\")\n .then((response) => {\n if (response.ok) return response.blob();\n throw new Error(\"Failed to load avatar image\");\n })\n .then((imageBlob) => {\n const url = URL.createObjectURL(imageBlob);\n setAvatarUrl(url);\n })\n .catch((err) => {\n console.error(\"Failed to load avatar:\", err);\n });\n\n // Fetch wood background\n fetch(\"/api/images/wood.jpg\")\n .then((response) => {\n if (response.ok) return response.blob();\n throw new Error(\"Failed to load wood background\");\n })\n .then((imageBlob) => {\n const url = URL.createObjectURL(imageBlob);\n setWoodUrl(url);\n\n // Apply wood background to body\n if (document.body) {\n document.body.style.backgroundImage = `url(${url})`;\n }\n })\n .catch((err) => {\n console.error(\"Failed to load background:\", err);\n });\n\n // Cleanup blob URLs on unmount\n return () => {\n if (avatarUrl) URL.revokeObjectURL(avatarUrl);\n if (woodUrl) URL.revokeObjectURL(woodUrl);\n };\n }, []);\n\n const fetchMemories = useCallback(async () => {\n setLoading(true);\n setError(null);\n try {\n const response = await fetch(API_BASE);\n if (!response.ok) {\n throw new Error(`HTTP error! status: ${response.status}`);\n }\n const data = await response.json();\n\n // Change the sorting function to show memories in chronological order\n const sortedMemories = [...data].sort((a, b) => {\n const dateA = a.createdDate || 0;\n const dateB = b.createdDate || 0;\n return dateA - dateB; // Oldest first, chronological order\n });\n\n setMemories(sortedMemories);\n\n // Set current index to the last memory (newest one)\n if (sortedMemories.length > 0) {\n setCurrentMemoryIndex(sortedMemories.length - 1);\n setShowCaption(true);\n }\n } catch (e) {\n console.error(\"Failed to fetch memories:\", e);\n setError(e.message || \"Failed to fetch memories.\");\n } finally {\n setLoading(false);\n }\n }, []);\n\n useEffect(() => {\n fetchMemories();\n }, [fetchMemories]);\n\n const handleAddMemory = async (e: React.FormEvent) => {\n e.preventDefault();\n if (!newMemoryText.trim()) return;\n\n const memoryData: Omit = {\n text: newMemoryText,\n date: newMemoryDate,\n tags: newMemoryTags || null,\n };\n\n try {\n const response = await fetch(API_BASE, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(memoryData),\n });\n if (!response.ok) {\n throw new Error(`HTTP error! status: ${response.status}`);\n }\n setNewMemoryText(\"\");\n setNewMemoryDate(new Date().toISOString().split(\"T\")[0]);\n setNewMemoryTags(\"\");\n setShowAddForm(false);\n await fetchMemories();\n } catch (e) {\n console.error(\"Failed to add memory:\", e);\n setError(e.message || \"Failed to add memory.\");\n }\n };\n\n const handleDeleteMemory = async (id: string) => {\n if (!confirm(\"Are you sure you want to delete this memory?\")) return;\n\n try {\n const response = await fetch(`${API_BASE}/${id}`, {\n method: \"DELETE\",\n });\n if (!response.ok) {\n throw new Error(`HTTP error! status: ${response.status}`);\n }\n await fetchMemories();\n } catch (e) {\n console.error(\"Failed to delete memory:\", e);\n setError(e.message || \"Failed to delete memory.\");\n }\n };\n\n const handleEditMemory = (memory: Memory) => {\n setEditingMemory(memory);\n };\n\n const handleCancelEdit = () => {\n setEditingMemory(null);\n };\n\n const handleUpdateMemory = async (e: React.FormEvent) => {\n e.preventDefault();\n if (!editingMemory || !editingMemory.text.trim()) return;\n\n const updatedFields: Partial> = {\n text: editingMemory.text,\n date: editingMemory.date,\n tags: editingMemory.tags,\n };\n\n try {\n const response = await fetch(`${API_BASE}/${editingMemory.id}`, {\n method: \"PUT\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(updatedFields),\n });\n if (!response.ok) {\n throw new Error(`HTTP error! status: ${response.status}`);\n }\n setEditingMemory(null);\n await fetchMemories();\n } catch (e) {\n console.error(\"Failed to update memory:\", e);\n setError(e.message || \"Failed to update memory.\");\n }\n };\n\n // Sort and paginate memories\n const sortedMemories = useMemo(\n () => sortMemoriesByDate(memories),\n [memories]\n );\n\n const totalPages = Math.max(\n 1,\n Math.ceil(sortedMemories.length / MEMORIES_PER_PAGE)\n );\n\n const paginatedMemories = useMemo(() => {\n const startIndex = (currentPage - 1) * MEMORIES_PER_PAGE;\n return sortedMemories.slice(startIndex, startIndex + MEMORIES_PER_PAGE);\n }, [sortedMemories, currentPage]);\n\n const goToNextPage = () => {\n if (currentPage < totalPages) {\n setCurrentPage(currentPage + 1);\n }\n };\n\n const goToPrevPage = () => {\n if (currentPage > 1) {\n setCurrentPage(currentPage - 1);\n }\n };\n\n // Animation delay to keep Stevens in place briefly\n const handleAnimationEnd = () => {\n setIsAnimating(false);\n };\n\n // Memory navigation handlers\n const goToNextMemory = () => {\n if (currentMemoryIndex < memories.length - 1) {\n // Reset cookie and tea mode on navigation\n setCookieAndTeaMode(false);\n\n // Trigger animation transition\n setIsAnimating(true);\n\n // Change memory after a brief delay\n setCurrentMemoryIndex(currentMemoryIndex + 1);\n setShowCaption(true);\n }\n };\n\n const goToPrevMemory = () => {\n if (currentMemoryIndex > 0) {\n // Reset cookie and tea mode on navigation\n setCookieAndTeaMode(false);\n\n // Trigger animation transition\n setIsAnimating(true);\n\n // Change memory after a brief delay\n setCurrentMemoryIndex(currentMemoryIndex - 1);\n setShowCaption(true);\n }\n };\n\n // Add keyboard navigation\n useEffect(() => {\n const handleKeyDown = (e: KeyboardEvent) => {\n if (showNotebook) return; // Don't navigate when notebook is open\n\n if (e.key === \"ArrowLeft\") {\n goToPrevMemory();\n } else if (e.key === \"ArrowRight\") {\n goToNextMemory();\n }\n };\n\n window.addEventListener(\"keydown\", handleKeyDown);\n\n return () => {\n window.removeEventListener(\"keydown\", handleKeyDown);\n };\n }, [currentMemoryIndex, memories.length, showNotebook]);\n\n // Generate caption based on memory source and content\n const generateCaption = (memory: Memory | undefined) => {\n if (cookieAndTeaMode) {\n return \"Ah, a lovely cup of tea and a cookie. Most refreshing indeed.\";\n }\n\n if (!memory) return \"No memories to display\";\n\n const source = memory.createdBy || \"unknown\";\n const sourceText =\n source === SOURCE_TYPES.WEATHER\n ? \"Hmm, I should check the weather today.\"\n : source === SOURCE_TYPES.MAIL\n ? \"Ah! A new letter has arrived.\"\n : source === SOURCE_TYPES.TELEGRAM\n ? \"A telegram! I must read it right away.\"\n : source === SOURCE_TYPES.CALENDAR\n ? \"I should check my calendar.\"\n : \"I must make note of this.\";\n\n return `${sourceText} Note for ${memory.date}: ${memory.text}`;\n };\n\n // Handle cookie and tea button\n const handleServeCookieAndTea = () => {\n setCookieAndTeaMode(true);\n };\n\n // Get Stevens' position and appearance based on memory source\n const getStevensState = (memory: Memory | undefined) => {\n // Override with cookie and tea mode\n if (cookieAndTeaMode) {\n return {\n position: SCENE_ELEMENTS.DESK_SITTING,\n image: ASSETS.STEVENS_FRONT,\n highlightElement: SCENE_ELEMENTS.DESK,\n animationClass: \"no-animation\",\n };\n }\n\n if (!memory) {\n // Default state: sitting at desk\n return {\n position: SCENE_ELEMENTS.DESK_SITTING,\n image: ASSETS.STEVENS_FRONT,\n highlightElement: null,\n animationClass: \"no-animation\",\n };\n }\n\n const source = memory.createdBy || \"unknown\";\n\n switch (source) {\n case SOURCE_TYPES.MAIL:\n return {\n position: {\n x: SCENE_ELEMENTS.MAILBOX.x + 20,\n y: SCENE_ELEMENTS.MAILBOX.y - 20,\n },\n image: ASSETS.STEVENS_BACK,\n highlightElement: SCENE_ELEMENTS.MAILBOX,\n animationClass: \"walk-to-mailbox\",\n };\n\n case SOURCE_TYPES.CALENDAR:\n return {\n position: {\n x: SCENE_ELEMENTS.CALENDAR.x + 10,\n y: SCENE_ELEMENTS.CALENDAR.y + 30,\n },\n image: ASSETS.STEVENS_BACK,\n highlightElement: SCENE_ELEMENTS.CALENDAR,\n animationClass: \"walk-to-calendar\",\n };\n\n case SOURCE_TYPES.TELEGRAM:\n return {\n position: {\n x: SCENE_ELEMENTS.TELEGRAM.x - 20,\n y: SCENE_ELEMENTS.TELEGRAM.y + 10,\n },\n image: ASSETS.STEVENS_BACK,\n highlightElement: SCENE_ELEMENTS.TELEGRAM,\n animationClass: \"walk-to-telegram\",\n };\n\n case SOURCE_TYPES.WEATHER:\n return {\n position: SCENE_ELEMENTS.OUTSIDE,\n image: ASSETS.STEVENS_FRONT,\n highlightElement: null,\n animationClass: \"walk-to-outside\",\n };\n\n default:\n return {\n position: SCENE_ELEMENTS.DESK_SITTING,\n image: ASSETS.STEVENS_FRONT,\n highlightElement: SCENE_ELEMENTS.DESK,\n animationClass: \"walk-to-desk\",\n };\n }\n };\n\n // Current memory\n const currentMemory = memories[currentMemoryIndex];\n const caption = generateCaption(currentMemory);\n const stevensState = getStevensState(currentMemory);\n\n // Scale factor for world coordinates (1/2 original size)\n const scaleFactor = 0.5;\n const scalePosition = (pos: { x: number; y: number }) => ({\n x: pos.x * scaleFactor,\n y: pos.y * scaleFactor,\n });\n\n // Render edit form modal\n const renderEditForm = () => (\n

\n \n

Edit Entry

\n \n DELETE\n \n

\n \n

\n );\n\n // Render add form\n const renderAddForm = () => (\n

\n \n

New Entry

\n \n

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

\n \n\n {/* Main game container with fixed dimensions */}\n

\n {/* Game world */}\n \n {/* Notebook clickable area (transparent) */}\n setShowNotebook(true)}\n title=\"Click to open Stevens' notebook\"\n >

\n\n {/* Highlight for interactive elements */}\n {stevensState.highlightElement && (\n

\n )}\n\n {/* Stevens character */}\n \n\n {/* Cookie and teacup for easter egg */}\n {cookieAndTeaMode && (\n <>\n \n \n \n )}\n \n\n {/* Caption area */}\n

\n {showCaption && (currentMemory || cookieAndTeaMode) ? (\n

{caption}

\n ) : (\n

\n Use arrows or buttons to navigate through Stevens' memories\n

\n )}\n

\n\n {/* Timeline controls */}\n

\n {loading\n ? \"Loading memories...\"\n : `Memory ${currentMemoryIndex + 1} of ${memories.length}`}\n

\n\n

\n \n ◀ PREV\n \n\n = memories.length - 1}\n className={`px-4 py-2 rounded-lg border-2 border-b-4 border-r-4 ${\n currentMemoryIndex >= memories.length - 1\n ? \"bg-gray-600 border-gray-700 opacity-50 cursor-not-allowed\"\n : \"bg-[#8B4513] border-[#654321] hover:bg-[#A0522D]\"\n }`}\n aria-label=\"Next memory\"\n >\n NEXT ▶\n \n

\n\n {error && (\n

\n {error}\n

\n )}\n\n {/* Timeline visualization and cookie/tea button */}\n

\n Source:{\" \"}\n {cookieAndTeaMode\n ? \"Tea Time\"\n : currentMemory?.createdBy || \"None\"}\n

\n Use ◀ ▶ arrow keys or buttons to navigate\n

\n\n {/* Easter egg button */}\n \n 🍪☕ Serve Cookie & Tea\n \n

\n\n {/* Notebook View Modal */}\n {showNotebook && (\n setShowNotebook(false)}\n avatarUrl={avatarUrl}\n />\n )}\n \n \n );\n}\n",[],[154,254,287,297],"318cccea-2933-11f0-beb3-569c3dd06744",9,["D",1746396029981],[183,184,185],[154,254,287],"317a3274-2933-11f0-b799-569c3dd06744",7,["D",1746396029857],[182,186,187,188,189],[154,254],"31dfcbc0-2933-11f0-befd-569c3dd06744","3195f784-2933-11f0-895c-569c3dd06744",["D",1746396030423],[],[154,319,320,32],"backend","database","31db8006-2933-11f0-9935-569c3dd06744","31db809c-2933-11f0-9935-569c3dd06744",22,["D",1746396030408],"# Database\n\nThis app uses [Val Town SQLite](https://docs.val.town/std/sqlite/) to manage data. Every Val Town account comes with a free SQLite database, hosted on [Turso](https://turso.tech/). This folder is broken up into two files:\n\n* `migrations.ts` - code to set up the database tables the app needs\n* `queries.ts` - functions to run queries against those tables, which are imported and used in the main Hono server in `/backend/index.ts`\n\n## Migrations\n\nIn `backend/database/migrations.ts`, this app creates a new SQLite table `reactHonoStarter_messages` to store messages. \n\nThis \"migration\" runs once on every app startup because it's imported in `index.ts`. You can comment this line out for a slight (30ms) performance improvement on cold starts. It's left in so that users who fork this project will have the migration run correctly.\n\nSQLite has much more limited support for altering existing tables as compared to other databases. Often it's easier to create new tables with the schema you want, and then copy the data over. Happily LLMs are quite good at those sort of database operations, but please reach out in the [Val Town Discord](https://discord.com/invite/dHv45uN5RY) if you need help.\n\n## Queries\n\nThe queries file is where running the migrations happen in this app. It'd also be reasonable for that to happen in index.ts, or as is said above, for that line to be commented out, and only run when actual changes are made to your database schema.\n\nThe queries file exports functions to get and write data. It relies on shared types and data imported from the `/shared` directory.",[],[154,319,320,233],"3195f6e4-2933-11f0-895c-569c3dd06744","318373c0-2933-11f0-9935-569c3dd06744",10,["D",1746396030038],[179,180],[154,319,320],"318372d0-2933-11f0-9935-569c3dd06744",8,["D",1746396029919],[178],[154,319],["D",1746396029430],[177,181,190],[154],["D",1746396029687],[],[160],["D",1746396029148],{"_97":96,"_104":100},{"_97":96,"_98":-5,"_99":100,"_18":54,"_101":102,"_103":24},{"_13":86,"_31":87,"_42":41,"_88":43,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":44,"_95":96},"ctx",{"_79":-5,"_123":382,"_383":384,"_385":386,"_387":24,"_388":24,"_389":24,"_390":58,"_391":-5,"_392":-7,"_393":-7,"_394":63,"_395":24,"_396":24,"_397":-5,"_398":24,"_399":24,"_400":24,"_401":-5},"ENV",{"_353":354,"_355":356,"_357":87,"_358":359,"_360":361,"_362":363,"_364":365,"_366":367,"_368":369,"_370":371,"_372":373,"_374":375,"_376":377,"_378":379,"_380":381},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","d010005ccf3ba21435d5d6fb7028afb409c58b2e","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"]

Diff · v23