Jotter - Notes for Remote Workspaces

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_288":289,"_290":291},"routes/_app.x.$handle.$name",{"_106":105,"_32":51,"_114":96,"_27":115,"_13":14,"_116":-5,"_11":117,"_118":119,"_120":121,"_122":123,"_124":125,"_21":-5,"_126":-5,"_127":-5,"_128":25,"_129":130,"_131":25,"_132":-5,"_133":-5,"_134":135},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_49":50,"_32":51,"_37":52,"_53":-5,"_54":25,"_55":56,"_57":56,"_58":59,"_60":-5,"_18":61,"_62":63,"_64":65,"_66":65,"_67":-5,"_68":69,"_70":71,"_72":73,"_74":75,"_76":77,"_78":-5,"_79":80,"_81":80,"_82":83,"_84":83,"_85":83,"_86":80,"_87":80,"_88":89,"_90":91,"_92":93,"_94":25},"version",11,"changes",[19,20],"aiChatInfo","userId",{"_21":42,"_23":-7,"_24":25,"_26":25,"_27":43,"_29":43},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":-5,"_37":38,"_39":14,"_40":41,"_24":25},"previous","deleted",false,"deletedHere","path","frontend/components","latestPath","fileId","bca7a288-ebf0-438a-96bf-cf363ceca606","name","components","fileType","directory","content","createdAt",["D",1748858284741],"branchVersion","branchId","f048b6b6-3f96-11f0-8f2e-76b3cceeab13",{"_30":44,"_32":45,"_34":46,"_36":47,"_37":48,"_39":14,"_40":41,"_24":25},"frontend/components/SearchBar.tsx","13c1715e-3f98-11f0-b85e-76b3cceeab13","SearchBar.tsx","script","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\n\ninterface SearchBarProps {\n onSearch: (query: string) => void;\n placeholder?: string;\n}\n\nexport default function SearchBar({ onSearch, placeholder = \"Search notes...\" }: SearchBarProps) {\n const [query, setQuery] = useState(\"\");\n\n const handleSubmit = (e: React.FormEvent) => {\n e.preventDefault();\n onSearch(query);\n };\n\n const handleChange = (e: React.ChangeEvent) => {\n const value = e.target.value;\n setQuery(value);\n \n // Search as user types (debounced effect would be better in production)\n onSearch(value);\n };\n\n return (\n \n );\n}",["D",1748858284741],"id","f048737c-3f96-11f0-8f2e-76b3cceeab13","Jotter",["D",1748857795739],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Workflow app for random notes. Doesnt have to important.","imageUrl","63df53b0-3f96-11f0-ad5b-814c56c8abb0","pinnedFileId","079915b2-3f98-11f0-be1c-76b3cceeab13","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","8ef27479-02af-4c82-89ec-299d9c968033","tursoName","f048737c3f9611f08f2e76b3cceeab13","tursoHostname","f048737c3f9611f08f2e76b3cceeab13-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789649456549],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_106":105,"_113":109},"org",{"_106":105,"_107":-5,"_108":109,"_18":61,"_110":111,"_112":25},"branch",{"_13":95,"_32":96,"_49":41,"_97":50,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":-5,"_103":51,"_104":105},"isOwned",37,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","zoebee","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4d21WSXMweHJKU1VGUzRuclN5YnBBVzgyaCJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_49":50,"_32":51,"_37":283,"_53":-5,"_54":25,"_55":56,"_57":56,"_58":59,"_60":-5,"_18":61,"_62":63,"_64":65,"_66":65,"_67":-5,"_68":69,"_70":71,"_72":73,"_74":75,"_76":284,"_78":-5,"_79":80,"_81":80,"_82":83,"_84":83,"_85":83,"_86":80,"_87":80,"_88":285,"_90":286,"_92":287,"_94":25},"tree",[188,195,199,201,202],"files",[188,189,190,191,192,193,194,195,196,197,198,199,200,201,202],"counts",{"_177":69,"_178":179,"_180":69,"_181":182,"_183":184},"contents",[136,137,138,139,140],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_49":171,"_32":172,"_30":173,"_144":-5,"_40":41,"_39":174,"_146":65,"_37":175,"_13":69,"_34":35,"_36":-5,"_24":25,"_150":-5,"_27":176},{"_49":165,"_32":166,"_30":167,"_144":-5,"_40":41,"_39":168,"_146":65,"_37":169,"_13":69,"_34":35,"_36":-5,"_24":25,"_150":-5,"_27":170},{"_49":159,"_32":160,"_30":161,"_144":-5,"_40":41,"_39":162,"_146":65,"_37":163,"_13":69,"_34":35,"_36":-5,"_24":25,"_150":-5,"_27":164},{"_49":152,"_32":153,"_30":154,"_144":-5,"_40":41,"_39":155,"_146":25,"_37":156,"_13":69,"_34":21,"_36":157,"_24":25,"_150":-5,"_27":158},{"_49":141,"_32":142,"_30":143,"_144":-5,"_40":41,"_39":145,"_146":25,"_37":147,"_13":148,"_34":46,"_36":149,"_24":25,"_150":-5,"_27":151},"1ffe41e6-3f97-11f0-91f5-76b3cceeab13","main.tsx","f04a67fe-3f96-11f0-8f2e-76b3cceeab13","parentId",3,"latest",["D",1748857875774],2,"A notes app for remote workspaces","label",[142],"efe409e0-3f97-11f0-ab6c-76b3cceeab13","README.md","efe40a9e-3f97-11f0-ab6c-76b3cceeab13",4,["D",1748858224574],"# Jotter\n\nA simple and user-friendly notes app for remote workspaces.\n\n## Features\n\n- Clean, minimal interface\n- Real-time note editing\n- Organized note management\n- Search functionality\n- Responsive design\n\n## Project Structure\n\n```\n├── backend/\n│ ├── index.ts # Main API server\n│ ├── database/\n│ │ ├── migrations.ts # Database schema\n│ │ └── queries.ts # Database operations\n│ └── routes/\n│ └── notes.ts # Notes API endpoints\n├── frontend/\n│ ├── index.html # Main HTML template\n│ ├── index.tsx # Frontend entry point\n│ ├── components/\n│ │ ├── App.tsx # Main app component\n│ │ ├── NotesList.tsx # Notes sidebar\n│ │ ├── NoteEditor.tsx # Note editing area\n│ │ └── SearchBar.tsx # Search functionality\n│ └── style.css # Custom styles\n└── shared/\n └── types.ts # Shared TypeScript types\n```\n\n## Development\n\nThe app uses:\n- **Backend**: Hono.js for API routes\n- **Frontend**: React with TypeScript\n- **Database**: SQLite for note storage\n- **Styling**: TailwindCSS",[153],"f28a125c-3f97-11f0-933b-76b3cceeab13","shared","a0d5ad60-e89e-45d5-b597-509694c34435",5,["D",1748858229011],[160],"0e4a2e6e-3f98-11f0-81cf-76b3cceeab13","frontend","4bdccf82-d5f9-4df2-b8ec-6913997e0f81",10,["D",1748858275572],[166],"f523b400-3f97-11f0-a83c-76b3cceeab13","backend","d481350a-bfa3-496b-b072-adc37d136c96",6,["D",1748858233376],[172],"pulls","branches",1,"forks","envVars",{"_185":69,"_187":69},"connections",{"_185":69,"_186":69},"count","unfilledCount","emptyCount",{"_49":171,"_32":172,"_30":173,"_144":-5,"_40":41,"_39":174,"_146":65,"_37":280,"_13":69,"_34":35,"_36":-5,"_24":25,"_150":-5,"_204":281,"_27":282},{"_49":276,"_32":268,"_30":262,"_144":173,"_40":41,"_39":174,"_146":65,"_37":277,"_13":69,"_34":35,"_36":-5,"_24":25,"_150":-5,"_204":278,"_27":279},{"_49":269,"_32":270,"_30":271,"_144":262,"_40":41,"_39":174,"_146":25,"_37":272,"_13":69,"_34":46,"_36":273,"_24":25,"_150":-5,"_204":274,"_27":275},{"_49":259,"_32":260,"_30":261,"_144":262,"_40":41,"_39":263,"_146":25,"_37":264,"_13":69,"_34":46,"_36":265,"_24":25,"_150":-5,"_204":266,"_27":267},{"_49":255,"_32":254,"_30":248,"_144":173,"_40":41,"_39":249,"_146":65,"_37":256,"_13":69,"_34":35,"_36":-5,"_24":25,"_150":-5,"_204":257,"_27":258},{"_49":245,"_32":246,"_30":247,"_144":248,"_40":41,"_39":249,"_146":25,"_37":250,"_13":69,"_34":46,"_36":251,"_24":25,"_150":-5,"_204":252,"_27":253},{"_49":238,"_32":239,"_30":63,"_144":173,"_40":41,"_39":240,"_146":25,"_37":241,"_13":69,"_34":46,"_36":242,"_24":25,"_150":-5,"_204":243,"_27":244},{"_49":165,"_32":166,"_30":167,"_144":-5,"_40":41,"_39":168,"_146":65,"_37":235,"_13":69,"_34":35,"_36":-5,"_24":25,"_150":-5,"_204":236,"_27":237},{"_49":231,"_32":33,"_30":31,"_144":167,"_40":41,"_39":14,"_146":65,"_37":232,"_13":69,"_34":35,"_36":-5,"_24":25,"_150":-5,"_204":233,"_27":234},{"_49":227,"_32":45,"_30":44,"_144":31,"_40":41,"_39":14,"_146":65,"_37":228,"_13":69,"_34":46,"_36":47,"_24":25,"_150":-5,"_204":229,"_27":230},{"_49":220,"_32":221,"_30":222,"_144":167,"_40":41,"_39":168,"_146":65,"_37":223,"_13":69,"_34":21,"_36":224,"_24":25,"_150":-5,"_204":225,"_27":226},{"_49":159,"_32":160,"_30":161,"_144":-5,"_40":41,"_39":162,"_146":65,"_37":217,"_13":69,"_34":35,"_36":-5,"_24":25,"_150":-5,"_204":218,"_27":219},{"_49":210,"_32":211,"_30":212,"_144":161,"_40":41,"_39":162,"_146":25,"_37":213,"_13":69,"_34":46,"_36":214,"_24":25,"_150":-5,"_204":215,"_27":216},{"_49":152,"_32":153,"_30":154,"_144":-5,"_40":41,"_39":155,"_146":25,"_37":207,"_13":69,"_34":21,"_36":157,"_24":25,"_150":-5,"_204":208,"_27":209},{"_49":141,"_32":142,"_30":143,"_144":-5,"_40":41,"_39":145,"_146":25,"_37":203,"_13":148,"_34":46,"_36":149,"_24":25,"_150":-5,"_204":205,"_27":206},["D",1748857875774],"children",[],[142],["D",1748858224574],[],[153],"f289e05c-3f97-11f0-933b-76b3cceeab13","types.ts","f289e192-3f97-11f0-933b-76b3cceeab13",["D",1748858229011],"export interface Note {\n id: number;\n title: string;\n content: string;\n created_at: string;\n updated_at: string;\n}\n\nexport interface CreateNoteRequest {\n title: string;\n content: string;\n}\n\nexport interface UpdateNoteRequest {\n title?: string;\n content?: string;\n}",[],[160,211],["D",1748858229011],[200],[160],"0e4a2342-3f98-11f0-81cf-76b3cceeab13","index.html","0e4a23f6-3f98-11f0-81cf-76b3cceeab13",["D",1748858275572],"\n\n\n \n \n Jotter - Notes for Remote Workspaces\n \n \n \n \n \n \n\n\n

\n \n\n",[],[166,221],"13c1706e-3f98-11f0-b85e-76b3cceeab13",["D",1748858284741],[],[166,33,45],"13c1773a-3f98-11f0-b85e-76b3cceeab13",["D",1748858284741],[197],[166,33],["D",1748858275572],[196,198],[166],"079914d6-3f98-11f0-be1c-76b3cceeab13","index.ts",9,["D",1748858264341],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { createNotesTable } from \"./database/migrations.ts\";\nimport { getAllNotes } from \"./database/queries.ts\";\nimport notesRoutes from \"./routes/notes.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Initialize database\nawait createNotesTable();\n\n// API routes\napp.route(\"/api/notes\", notesRoutes);\n\n// Serve static files\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Serve main page with initial data\napp.get(\"/\", async c => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Inject initial notes data to avoid extra round-trip\n const initialNotes = await getAllNotes();\n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n});\n\nexport default app.fetch;",[],[172,239],"025e8730-3f98-11f0-b775-76b3cceeab13","notes.ts","025e87f8-3f98-11f0-b775-76b3cceeab13","375d9928-e523-4387-80e0-575ebe733b85",8,["D",1748858255574],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { \n getAllNotes, \n getNoteById, \n createNote, \n updateNote, \n deleteNote, \n searchNotes \n} from \"../database/queries.ts\";\n\nconst notes = new Hono();\n\n// Get all notes or search\nnotes.get(\"/\", async (c) => {\n const query = c.req.query(\"q\");\n \n if (query) {\n const results = await searchNotes(query);\n return c.json(results);\n }\n \n const allNotes = await getAllNotes();\n return c.json(allNotes);\n});\n\n// Get specific note\nnotes.get(\"/:id\", async (c) => {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n return c.json({ error: \"Invalid note ID\" }, 400);\n }\n \n const note = await getNoteById(id);\n if (!note) {\n return c.json({ error: \"Note not found\" }, 404);\n }\n \n return c.json(note);\n});\n\n// Create new note\nnotes.post(\"/\", async (c) => {\n const body = await c.req.json();\n \n if (!body.title || typeof body.title !== \"string\") {\n return c.json({ error: \"Title is required\" }, 400);\n }\n \n const noteData = {\n title: body.title,\n content: body.content || \"\"\n };\n \n const note = await createNote(noteData);\n return c.json(note, 201);\n});\n\n// Update note\nnotes.put(\"/:id\", async (c) => {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n return c.json({ error: \"Invalid note ID\" }, 400);\n }\n \n const body = await c.req.json();\n const note = await updateNote(id, body);\n \n if (!note) {\n return c.json({ error: \"Note not found\" }, 404);\n }\n \n return c.json(note);\n});\n\n// Delete note\nnotes.delete(\"/:id\", async (c) => {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n return c.json({ error: \"Invalid note ID\" }, 400);\n }\n \n const deleted = await deleteNote(id);\n if (!deleted) {\n return c.json({ error: \"Note not found\" }, 404);\n }\n \n return c.json({ success: true });\n});\n\nexport default notes;",[],[172,254,246],"routes","025e9360-3f98-11f0-b775-76b3cceeab13",["D",1748858255574],[193],[172,254],"fb9d7eba-3f97-11f0-8845-76b3cceeab13","queries.ts","fb9d7f5a-3f97-11f0-8845-76b3cceeab13","a09f57fb-2680-409a-bf5e-a7840ebee99b",7,["D",1748858244242],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLE_NAME } from \"./migrations.ts\";\nimport type { Note, CreateNoteRequest, UpdateNoteRequest } from \"../../shared/types.ts\";\n\nexport async function getAllNotes(): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM ${TABLE_NAME} \n ORDER BY updated_at DESC\n `);\n return result.rows as Note[];\n}\n\nexport async function getNoteById(id: number): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM ${TABLE_NAME} \n WHERE id = ?\n `, [id]);\n \n return result.rows[0] as Note || null;\n}\n\nexport async function createNote(data: CreateNoteRequest): Promise {\n const result = await sqlite.execute(`\n INSERT INTO ${TABLE_NAME} (title, content)\n VALUES (?, ?)\n `, [data.title, data.content]);\n \n const noteId = result.lastInsertRowId;\n const note = await getNoteById(noteId);\n if (!note) throw new Error(\"Failed to create note\");\n return note;\n}\n\nexport async function updateNote(id: number, data: UpdateNoteRequest): Promise {\n const updates: string[] = [];\n const values: any[] = [];\n \n if (data.title !== undefined) {\n updates.push(\"title = ?\");\n values.push(data.title);\n }\n \n if (data.content !== undefined) {\n updates.push(\"content = ?\");\n values.push(data.content);\n }\n \n if (updates.length === 0) {\n return await getNoteById(id);\n }\n \n updates.push(\"updated_at = CURRENT_TIMESTAMP\");\n values.push(id);\n \n await sqlite.execute(`\n UPDATE ${TABLE_NAME} \n SET ${updates.join(\", \")}\n WHERE id = ?\n `, values);\n \n return await getNoteById(id);\n}\n\nexport async function deleteNote(id: number): Promise {\n const result = await sqlite.execute(`\n DELETE FROM ${TABLE_NAME} \n WHERE id = ?\n `, [id]);\n \n return result.changes > 0;\n}\n\nexport async function searchNotes(query: string): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM ${TABLE_NAME} \n WHERE title LIKE ? OR content LIKE ?\n ORDER BY updated_at DESC\n `, [`%${query}%`, `%${query}%`]);\n \n return result.rows as Note[];\n}",[],[172,268,260],"database","f523a8ca-3f97-11f0-a83c-76b3cceeab13","migrations.ts","f523a974-3f97-11f0-a83c-76b3cceeab13",["D",1748858233376],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst TABLE_NAME = 'jotter_notes_v1';\n\nexport async function createNotesTable() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n content TEXT NOT NULL DEFAULT '',\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n}\n\nexport { TABLE_NAME };",[],[172,268,270],"f523b55e-3f97-11f0-a83c-76b3cceeab13",["D",1748858233376],[190,191],[172,268],["D",1748858233376],[189,192,194],[172],["D",1748857795739],["D",1789649456549],{"_106":105,"_113":109},{"_106":105,"_107":-5,"_108":109,"_18":61,"_110":111,"_112":25},{"_13":95,"_32":96,"_49":41,"_97":50,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":-5,"_103":51,"_104":105},"ctx",{"_88":-5,"_133":321,"_322":323,"_324":325,"_326":25,"_327":25,"_328":25,"_329":65,"_330":-5,"_331":-7,"_332":-7,"_333":69,"_334":25,"_335":25,"_336":-5,"_337":25,"_338":25,"_339":25,"_340":-5},"ENV",{"_292":293,"_294":295,"_296":96,"_297":298,"_299":300,"_301":302,"_303":304,"_305":306,"_307":308,"_309":310,"_311":312,"_313":314,"_315":316,"_317":318,"_319":320},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","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 · v11