\n\t\t\t\n\t\t\t\t

\n\t\t\t\t\t{showSidebarToggle && (\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t)}\n\t\t\t\t\t

\n\t\t\t\t\t\tSQLite Explorer\n\t\t\t\t\t

\n\t\t\t\t

\n\t\t\t\t\t\n\t\t\t\t\t{actions}\n\t\t\t\t

\n\t\t\t\n\t\t

\n\t);\n}\n",[],[201,208,215],{"_102":224,"_95":225,"_151":226,"_153":209,"_154":136,"_155":227,"_157":158,"_104":228,"_99":229,"_160":219,"_162":230,"_163":22,"_164":-5,"_165":231,"_98":232},"51c33d6a-c1da-11f0-954e-42dde27851f2","EditorSection.tsx","667d124a-c1bb-11f0-b3d6-42dde27851f2",314,["D",1763180386719],23,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n\nimport { sql } from \"https://esm.sh/@codemirror/lang-sql@6.5.4\";\nimport { EditorView } from \"https://esm.sh/@codemirror/view@6.22.0\";\nimport CodeMirror, {\n\ttype ReactCodeMirrorRef,\n} from \"https://esm.sh/@uiw/react-codemirror@4.21.21?deps=react@18.2.0\";\nimport { useCallback, useEffect, useMemo } from \"https://esm.sh/react@18.2.0\";\nimport { DownloadSVG, RunSVG } from \"./Icons.tsx\";\n\ninterface EditorSectionProps {\n\tcode: string;\n\tonCodeChange: (code: string) => void;\n\tonRun: () => void;\n\tonDownloadJSON: () => void;\n\tonDownloadCSV: () => void;\n\tisLoading: boolean;\n\teditorRef?: React.MutableRefObject;\n}\n\ninterface ControlButtonProps {\n\ticon: React.ReactNode;\n\tlabel: string;\n\tonClick: () => void;\n\tdisabled?: boolean;\n}\n\nconst ControlButton = ({\n\ticon,\n\tlabel,\n\tonClick,\n\tdisabled,\n}: ControlButtonProps) => (\n\t\n\t\t{icon}\n\t\t{label}\n\t\n);\n\nexport function EditorSection({\n\tcode,\n\tonCodeChange,\n\tonRun,\n\tonDownloadJSON,\n\tonDownloadCSV,\n\tisLoading,\n\teditorRef,\n}: EditorSectionProps) {\n\tconst handleChange = useCallback(\n\t\t(value: string) => {\n\t\t\tonCodeChange(value);\n\t\t},\n\t\t[onCodeChange],\n\t);\n\n\t// Handle Cmd+Enter keyboard shortcut\n\tuseEffect(() => {\n\t\tconst handleKeyDown = (event: KeyboardEvent) => {\n\t\t\tif ((event.metaKey || event.ctrlKey) && event.key === \"Enter\") {\n\t\t\t\tevent.preventDefault();\n\t\t\t\tonRun();\n\t\t\t}\n\t\t};\n\n\t\tdocument.addEventListener(\"keydown\", handleKeyDown);\n\t\treturn () => {\n\t\t\tdocument.removeEventListener(\"keydown\", handleKeyDown);\n\t\t};\n\t}, [onRun]);\n\n\t// Custom theme matching our warm neutral color scheme\n\tconst theme = useMemo(() => {\n\t\tconst isDark = document.documentElement.classList.contains(\"dark\");\n\t\treturn EditorView.theme(\n\t\t\t{\n\t\t\t\t\"&\": {\n\t\t\t\t\tbackgroundColor: isDark ? \"#1e293b\" : \"#ffffff\",\n\t\t\t\t\tcolor: isDark ? \"#e2e8f0\" : \"#334155\",\n\t\t\t\t\theight: \"100%\",\n\t\t\t\t},\n\t\t\t\t\".cm-scroller\": {\n\t\t\t\t\toverflow: \"auto\",\n\t\t\t\t\theight: \"100%\",\n\t\t\t\t},\n\t\t\t\t\".cm-content\": {\n\t\t\t\t\tcaretColor: isDark ? \"#f5ca99\" : \"#d88a3f\",\n\t\t\t\t},\n\t\t\t\t\".cm-cursor, .cm-dropCursor\": {\n\t\t\t\t\tborderLeftColor: isDark ? \"#f5ca99\" : \"#d88a3f\",\n\t\t\t\t},\n\t\t\t\t\"&.cm-focused .cm-selectionBackground, .cm-selectionBackground, .cm-content ::selection\":\n\t\t\t\t\t{\n\t\t\t\t\t\tbackgroundColor: isDark ? \"#334155\" : \"#f5f1ea\",\n\t\t\t\t\t},\n\t\t\t\t\".cm-activeLine\": {\n\t\t\t\t\tbackgroundColor: isDark ? \"#334155\" : \"#fdfcfb\",\n\t\t\t\t},\n\t\t\t\t\".cm-gutters\": {\n\t\t\t\t\tbackgroundColor: isDark ? \"#0f172a\" : \"#faf8f5\",\n\t\t\t\t\tcolor: isDark ? \"#64748b\" : \"#94a3b8\",\n\t\t\t\t\tborder: \"none\",\n\t\t\t\t\tminHeight: \"100%\",\n\t\t\t\t},\n\t\t\t\t\".cm-activeLineGutter\": {\n\t\t\t\t\tbackgroundColor: isDark ? \"#1e293b\" : \"#f5f1ea\",\n\t\t\t\t},\n\t\t\t},\n\t\t\t{ dark: isDark },\n\t\t);\n\t}, []);\n\n\tconst isDisabled = !code.trim() || isLoading;\n\n\treturn (\n\t\t

\n\t\t\t

\n\t\t\t\t\n\t\t\t

\n\n\t\t\t

\n\t\t\t\t}\n\t\t\t\t\tlabel=\"Run\"\n\t\t\t\t\tonClick={onRun}\n\t\t\t\t\tdisabled={isDisabled}\n\t\t\t\t/>\n\t\t\t\t}\n\t\t\t\t\tlabel=\"JSON\"\n\t\t\t\t\tonClick={onDownloadJSON}\n\t\t\t\t\tdisabled={isDisabled}\n\t\t\t\t/>\n\t\t\t\t}\n\t\t\t\t\tlabel=\"CSV\"\n\t\t\t\t\tonClick={onDownloadCSV}\n\t\t\t\t\tdisabled={isDisabled}\n\t\t\t\t/>\n\n\t\t\t\t{isLoading && (\n\t\t\t\t\t\n\t\t\t\t\t\tloading...\n\t\t\t\t\t\n\t\t\t\t)}\n\t\t\t

\n\t\t

\n\t);\n}\n",[],[201,208,225],{"_102":234,"_95":235,"_151":236,"_153":209,"_154":136,"_155":237,"_157":158,"_104":238,"_99":32,"_160":219,"_162":239,"_163":22,"_164":-5,"_165":240,"_98":241},"14d837f2-c1d0-11f0-bc5e-42dde27851f2","ErrorBoundary.tsx","14d838ec-c1d0-11f0-bc5e-42dde27851f2",237,["D",1763175989549],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n\nimport React from \"https://esm.sh/react@18.2.0\";\n\ninterface Props {\n\tchildren: React.ReactNode;\n\tfallback?: React.ReactNode;\n}\n\ninterface State {\n\thasError: boolean;\n\terror: Error | null;\n}\n\nexport class ErrorBoundary extends React.Component {\n\tconstructor(props: Props) {\n\t\tsuper(props);\n\t\tthis.state = { hasError: false, error: null };\n\t}\n\n\tstatic getDerivedStateFromError(error: Error): State {\n\t\treturn { hasError: true, error };\n\t}\n\n\toverride componentDidCatch(error: Error, errorInfo: React.ErrorInfo): void {\n\t\t// In production, you could send to error tracking service\n\t\t// For now, errors are just stored in state and displayed\n\t\tvoid error;\n\t\tvoid errorInfo;\n\t}\n\n\toverride render() {\n\t\tif (this.state.hasError) {\n\t\t\tif (this.props.fallback) {\n\t\t\t\treturn this.props.fallback;\n\t\t\t}\n\n\t\t\treturn (\n\t\t\t\t

\n\t\t\t\t\t

\n\t\t\t\t\t\t

\n\t\t\t\t\t\t\tSomething went wrong\n\t\t\t\t\t\t

\n\t\t\t\t\t\t

\n\t\t\t\t\t\t\tThe application encountered an unexpected error. Please try\n\t\t\t\t\t\t\trefreshing the page.\n\t\t\t\t\t\t

\n\t\t\t\t\t\t{this.state.error && (\n\t\t\t\t\t\t\t

\n\t\t\t\t\t\t\t\t

\n\t\t\t\t\t\t\t\t\tError Details\n\t\t\t\t\t\t\t\t

\n\t\t\t\t\t\t\t\t

\n\t\t\t\t\t\t\t\t\t{this.state.error.message}\n\t\t\t\t\t\t\t\t\t{\"\\n\\n\"}\n\t\t\t\t\t\t\t\t\t{this.state.error.stack}\n\t\t\t\t\t\t\t\t

\n\t\t\t\t\t\t\t

\n\t\t\t\t\t\t)}\n\t\t\t\t\t\t window.location.reload()}\n\t\t\t\t\t\t\tclassName=\"mt-4 px-4 py-2 bg-amber-600 hover:bg-amber-700 text-white rounded-md transition-colors\"\n\t\t\t\t\t\t>\n\t\t\t\t\t\t\tRefresh Page\n\t\t\t\t\t\t\n\t\t\t\t\t

\n\t\t\t\t

\n\t\t\t);\n\t\t}\n\n\t\treturn this.props.children;\n\t}\n}\n",[],[201,208,235],{"_102":243,"_95":244,"_151":245,"_153":209,"_154":136,"_155":246,"_157":158,"_104":247,"_99":248,"_160":219,"_162":249,"_163":22,"_164":-5,"_165":250,"_98":251},"7c67b308-c1de-11f0-979d-42dde27851f2","Icons.tsx","66846630-c1bb-11f0-ba97-42dde27851f2",332,["D",1763182176211],14,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport {\n\tChevronLeft,\n\tChevronRight,\n\tChevronsLeft,\n\tChevronsRight,\n\tDownload,\n\tEye,\n\tPanelsTopLeft,\n\tPanelTop,\n\tPlay,\n\tSearch,\n\tTable2,\n} from \"https://esm.sh/lucide-react@0.479.0?deps=react@18.2.0\";\n\nexport const FirstSVG = () => ;\nexport const LastSVG = () => ;\nexport const PreviousSVG = () => ;\nexport const NextSVG = () => ;\nexport const RunSVG = () => ;\nexport const TableSVG = () => ;\nexport const ViewSVG = () => ;\nexport const DownloadSVG = () => ;\nexport const SearchSVG = () => ;\nexport const SidebarSVG = ({\n\tisSidebarOpen,\n\tclassName = \"size-4\",\n}: {\n\tisSidebarOpen: boolean;\n\tclassName: string;\n}) => {\n\treturn isSidebarOpen ? (\n\t\t\n\t) : (\n\t\t\n\t);\n};\n",[],[201,208,244],{"_102":253,"_95":254,"_151":255,"_153":209,"_154":136,"_155":256,"_157":158,"_104":257,"_99":258,"_160":219,"_162":259,"_163":22,"_164":-5,"_165":260,"_98":261},"4e59399c-c1dd-11f0-bc6a-42dde27851f2","PaginationBar.tsx","9ac14b2c-c1dc-11f0-807c-42dde27851f2",327,["D",1763181669482],2,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n\nimport type React from \"https://esm.sh/react@18.2.0\";\nimport type { QueryResult } from \"../../shared/types.ts\";\nimport { FirstSVG, LastSVG, NextSVG, PreviousSVG } from \"./Icons.tsx\";\nimport { PAGE_SIZE } from \"./Table.tsx\";\n\ninterface PaginationBarProps {\n\tcurrentPage: number;\n\tresult: QueryResult;\n\tsetCurrentPage: (value: React.SetStateAction) => void;\n}\n\ninterface PageButtonProps {\n\ticon: React.ReactNode;\n\tonClick: () => void;\n\tdisabled: boolean;\n}\n\nconst PageButton = ({ icon, onClick, disabled }: PageButtonProps) => (\n\t\n\t\t{icon}\n\t\n);\n\nexport function PaginationBar({\n\tcurrentPage,\n\tresult,\n\tsetCurrentPage,\n}: PaginationBarProps) {\n\treturn (\n\t\tresult &&\n\t\tresult.rows.length > PAGE_SIZE && (\n\t\t\t

\n\t\t\t\t

\n\t\t\t\t\tShowing {(currentPage - 1) * PAGE_SIZE + 1} to{\" \"}\n\t\t\t\t\t{Math.min(currentPage * PAGE_SIZE, result.rows.length)} of{\" \"}\n\t\t\t\t\t{result.rows.length} rows\n\t\t\t\t

\n\t\t\t\t

\n\t\t\t\t\t setCurrentPage(1)}\n\t\t\t\t\t\tdisabled={currentPage === 1}\n\t\t\t\t\t\ticon={}\n\t\t\t\t\t/>\n\t\t\t\t\t setCurrentPage((p) => Math.max(1, p - 1))}\n\t\t\t\t\t\tdisabled={currentPage === 1}\n\t\t\t\t\t\ticon={}\n\t\t\t\t\t/>\n\t\t\t\t\t\n\t\t\t\t\t\tPage {currentPage} / {Math.ceil(result.rows.length / PAGE_SIZE)}\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\t\tsetCurrentPage((p) =>\n\t\t\t\t\t\t\t\tMath.min(Math.ceil(result.rows.length / PAGE_SIZE), p + 1),\n\t\t\t\t\t\t\t)\n\t\t\t\t\t\t}\n\t\t\t\t\t\tdisabled={currentPage === Math.ceil(result.rows.length / PAGE_SIZE)}\n\t\t\t\t\t\ticon={}\n\t\t\t\t\t/>\n\t\t\t\t\t\n\t\t\t\t\t\t\tsetCurrentPage(Math.ceil(result.rows.length / PAGE_SIZE))\n\t\t\t\t\t\t}\n\t\t\t\t\t\tdisabled={currentPage === Math.ceil(result.rows.length / PAGE_SIZE)}\n\t\t\t\t\t\ticon={}\n\t\t\t\t\t/>\n\t\t\t\t

\n\t\t\t

\n\t\t)\n\t);\n}\n",[],[201,208,254],{"_102":263,"_95":264,"_151":265,"_153":209,"_154":136,"_155":266,"_157":158,"_104":267,"_99":268,"_160":219,"_162":269,"_163":22,"_164":-5,"_165":270,"_98":271},"6e6148ce-c1d3-11f0-9eef-42dde27851f2","Table.tsx","6688ddbe-c1bb-11f0-99b9-42dde27851f2",279,["D",1763177428253],11,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n\nimport { useMemo } from \"https://esm.sh/react@18.2.0\";\nimport type { SQLValue } from \"../../shared/types.ts\";\n\nexport const PAGE_SIZE = 100;\n\ninterface TableProps {\n\theaders: string[];\n\trows: SQLValue[][];\n\tcurrentPage: number;\n}\n\nexport function Table({ headers, rows, currentPage }: TableProps) {\n\t// Calculate pagination\n\tconst startIndex = (currentPage - 1) * PAGE_SIZE;\n\tconst endIndex = startIndex + PAGE_SIZE;\n\tconst paginatedRows = useMemo(\n\t\t() => rows.slice(startIndex, endIndex),\n\t\t[rows, startIndex, endIndex],\n\t);\n\tconst createRows = (rows: SQLValue[][], headers: string[]) => {\n\t\t// Check if all rows are empty\n\t\tif (rows.every((subArray) => subArray.length === 0)) {\n\t\t\tconst emptyRow = headers.map((header, index) => (\n\t\t\t\t\n\t\t\t\t\t{header}\n\t\t\t\t\n\t\t\t));\n\n\t\t\treturn {emptyRow};\n\t\t}\n\n\t\treturn rows.map((row, rowIndex) => (\n\t\t\t\n\t\t\t\t{row.map((cell, cellIndex) => (\n\t\t\t\t\t\n\t\t\t\t\t\t{cell !== null && cell !== undefined ? (\n\t\t\t\t\t\t\tString(cell)\n\t\t\t\t\t\t) : (\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\tnull\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t)}\n\t\t\t\t\t\n\t\t\t\t))}\n\t\t\t\n\t\t));\n\t};\n\n\tconst tableRows = createRows(paginatedRows, headers);\n\n\treturn (\n\t\t\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t{headers.map((header, index) => (\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t{header}\n\t\t\t\t\t\t\n\t\t\t\t\t))}\n\t\t\t\t\n\t\t\t\n\t\t\t{tableRows}\n\t\t

\n\t);\n}\n",[],[201,208,264],{"_102":273,"_95":274,"_151":275,"_153":209,"_154":136,"_155":276,"_157":158,"_104":277,"_99":173,"_160":219,"_162":278,"_163":22,"_164":-5,"_165":279,"_98":280},"ce05408a-c1df-11f0-81a1-42dde27851f2","TablesList.tsx","66973206-c1bb-11f0-b3a1-42dde27851f2",361,["D",1763182742671],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n\nimport { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { SchemaItem } from \"../../shared/types.ts\";\nimport { SearchSVG, TableSVG, ViewSVG } from \"./Icons.tsx\";\n\ninterface TablesListProps {\n\ttables: SchemaItem[];\n\tselectedTable: string | null;\n\tonTableSelect: (name: string) => void;\n}\n\nexport function TablesList({\n\ttables,\n\tselectedTable,\n\tonTableSelect,\n}: TablesListProps) {\n\tconst [filter, setFilter] = useState(\"\");\n\n\tconst handleClick = (name: string) => {\n\t\t// Toggle selection: if already selected, deselect it\n\t\tif (selectedTable === name) {\n\t\t\tonTableSelect(\"\");\n\t\t} else {\n\t\t\tonTableSelect(name);\n\t\t}\n\t};\n\n\t// Filter tables based on the filter text\n\tconst filteredTables = tables.filter((item) =>\n\t\titem.name.toLowerCase().includes(filter.toLowerCase()),\n\t);\n\n\treturn (\n\t\t

\n\t\t\t{/* Filter input */}\n\t\t\t

\n\t\t\t\t

\n\t\t\t\t\t

\n\t\t\t\t\t\t\n\t\t\t\t\t

\n\t\t\t\t\t setFilter(e.target.value)}\n\t\t\t\t\t\tplaceholder=\"Filter tables...\"\n\t\t\t\t\t\tclassName=\"w-full pl-9 pr-3 py-1.5 text-sm rounded-lg border border-sand-300 dark:border-slate-600 bg-white dark:bg-slate-900 text-slate-900 dark:text-slate-100 placeholder-slate-500 dark:placeholder-slate-400 focus:outline-none focus:ring-2 focus:ring-warm-500 dark:focus:ring-warm-600 focus:border-transparent\"\n\t\t\t\t\t/>\n\t\t\t\t

\n\t\t\t\t{filter && (\n\t\t\t\t\t

\n\t\t\t\t\t\t{filteredTables.length} of {tables.length} table\n\t\t\t\t\t\t{tables.length !== 1 ? \"s\" : \"\"}\n\t\t\t\t\t

\n\t\t\t\t)}\n\t\t\t

\n\n\t\t\t{/* Tables list */}\n\t\t\t

\n\t\t\t\t{filteredTables.map((item) => {\n\t\t\t\t\tconst isSelected = selectedTable === item.name;\n\n\t\t\t\t\treturn (\n\t\t\t\t\t\t handleClick(item.name)}\n\t\t\t\t\t\t\tclassName={`\n w-full flex items-center gap-2 px-3 py-1 rounded-lg text-left\n font-medium text-sm transition-all duration-200\n ${\n\t\t\t\t\t\t\t\tisSelected\n\t\t\t\t\t\t\t\t\t? \"bg-warm-100 dark:bg-warm-900/30 text-warm-800 dark:text-warm-300 shadow-sm\"\n\t\t\t\t\t\t\t\t\t: \"text-slate-700 dark:text-slate-300 hover:bg-sand-200 dark:hover:bg-slate-700\"\n\t\t\t\t\t\t\t}\n `}\n\t\t\t\t\t\t>\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t{item.type === \"table\" ? : }\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t{item.name}\n\t\t\t\t\t\t\n\t\t\t\t\t);\n\t\t\t\t})}\n\t\t\t

\n\t\t

\n\t);\n}\n",[],[201,208,274],{"_102":282,"_95":283,"_151":284,"_153":209,"_154":136,"_155":285,"_157":158,"_104":286,"_99":258,"_160":219,"_162":287,"_163":22,"_164":-5,"_165":288,"_98":289},"d76f0c4e-c1d2-11f0-b693-42dde27851f2","ThemeToggle.tsx","658dd658-c1c5-11f0-a907-42dde27851f2",263,["D",1763177174936],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n\nimport { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\n\nexport function ThemeToggle() {\n\tconst [isDark, setIsDark] = useState(false);\n\n\t// Initialize theme from localStorage or system preference\n\tuseEffect(() => {\n\t\tconst stored = localStorage.getItem(\"theme\");\n\t\tconst prefersDark = window.matchMedia(\n\t\t\t\"(prefers-color-scheme: dark)\",\n\t\t).matches;\n\t\tconst shouldBeDark = stored === \"dark\" || (!stored && prefersDark);\n\n\t\tsetIsDark(shouldBeDark);\n\t\tdocument.documentElement.classList.toggle(\"dark\", shouldBeDark);\n\t}, []);\n\n\tconst toggleTheme = () => {\n\t\tconst newIsDark = !isDark;\n\t\tsetIsDark(newIsDark);\n\t\tdocument.documentElement.classList.toggle(\"dark\", newIsDark);\n\t\tlocalStorage.setItem(\"theme\", newIsDark ? \"dark\" : \"light\");\n\t};\n\n\treturn (\n\t\t\n\t\t\t{isDark ? (\n\t\t\t\t\n\t\t\t\t\tDark mode\n\t\t\t\t\t\n\t\t\t\t\n\t\t\t) : (\n\t\t\t\t\n\t\t\t\t\tLight mode\n\t\t\t\t\t\n\t\t\t\t\n\t\t\t)}\n\t\t\n\t);\n}\n",[],[201,208,283],[201,208],{"_102":292,"_95":293,"_151":294,"_153":202,"_154":136,"_155":295,"_157":158,"_104":296,"_99":32,"_160":161,"_162":-5,"_163":22,"_164":-5,"_165":297,"_98":335},"666f88f0-c1bb-11f0-b3d6-42dde27851f2","hooks","666f899a-c1bb-11f0-b3d6-42dde27851f2",129,["D",1763167107007],[298,307,316,325],{"_102":299,"_95":300,"_151":301,"_153":294,"_154":136,"_155":302,"_157":158,"_104":303,"_99":173,"_160":219,"_162":304,"_163":22,"_164":-5,"_165":305,"_98":306},"cee50496-c1d4-11f0-84ec-42dde27851f2","useCodeEditor.ts","66a558fe-c1bb-11f0-865f-42dde27851f2",284,["D",1763178019667],"import type { ReactCodeMirrorRef } from \"https://esm.sh/@uiw/react-codemirror@4.21.21?deps=react@18.2.0\";\nimport { useCallback, useRef, useState } from \"https://esm.sh/react@18.2.0\";\nimport { getStatementAtPosition } from \"../../shared/sqlHelpers.ts\";\n\ninterface UseCodeEditorResult {\n\tcode: string;\n\tsetCode: (code: string) => void;\n\tgetActiveStatement: () => string;\n\teditorRef: React.MutableRefObject;\n}\n\n/**\n * Custom hook for managing code editor state and extracting SQL statements\n */\nexport function useCodeEditor(): UseCodeEditorResult {\n\tconst [code, setCode] = useState(\"\");\n\tconst editorRef = useRef(null);\n\n\t/**\n\t * Get the SQL statement at the current cursor position\n\t * Falls back to entire code if cursor position can't be determined\n\t */\n\tconst getActiveStatement = useCallback((): string => {\n\t\tif (!code.trim()) return \"\";\n\n\t\ttry {\n\t\t\t// Try to get cursor position from CodeMirror editor\n\t\t\tconst editor = editorRef.current;\n\t\t\tif (editor?.view?.state) {\n\t\t\t\tconst cursorPosition = editor.view.state.selection.main.head;\n\t\t\t\tconst statement = getStatementAtPosition(code, cursorPosition);\n\t\t\t\treturn statement || code;\n\t\t\t}\n\t\t} catch (err) {\n\t\t\tconsole.error(\"Error getting cursor position:\", err);\n\t\t}\n\n\t\t// Fallback to entire code if cursor position unavailable\n\t\treturn code;\n\t}, [code]);\n\n\treturn {\n\t\tcode,\n\t\tsetCode,\n\t\tgetActiveStatement,\n\t\teditorRef,\n\t};\n}\n",[],[201,293,300],{"_102":308,"_95":309,"_151":310,"_153":294,"_154":136,"_155":311,"_157":158,"_104":312,"_99":258,"_160":219,"_162":313,"_163":22,"_164":-5,"_165":314,"_98":315},"d792f2ee-c1d2-11f0-ac85-42dde27851f2","useDownload.ts","669c63c0-c1bb-11f0-ba97-42dde27851f2",269,["D",1763177175169],"import { useCallback } from \"https://esm.sh/react@18.2.0\";\nimport { getErrorMessage } from \"../../shared/types.ts\";\n\ntype DownloadFormat = \"csv\" | \"json\";\n\n/**\n * Custom hook for downloading query results\n */\nexport function useDownload() {\n\tconst downloadQuery = useCallback(\n\t\tasync (query: string, format: DownloadFormat) => {\n\t\t\tif (!query.trim()) {\n\t\t\t\tthrow new Error(\"Cannot download: query is empty\");\n\t\t\t}\n\n\t\t\ttry {\n\t\t\t\tconst encodedQuery = encodeURIComponent(query);\n\t\t\t\tconst url = `/api/download/${format}?query=${encodedQuery}`;\n\n\t\t\t\t// Trigger download by creating a temporary link\n\t\t\t\tconst link = document.createElement(\"a\");\n\t\t\t\tlink.href = url;\n\t\t\t\tlink.download = `results.${format}`;\n\t\t\t\tdocument.body.appendChild(link);\n\t\t\t\tlink.click();\n\t\t\t\tdocument.body.removeChild(link);\n\t\t\t} catch (err) {\n\t\t\t\t// Re-throw with a formatted error message\n\t\t\t\tthrow new Error(\n\t\t\t\t\t`Failed to download ${format}: ${getErrorMessage(err)}`,\n\t\t\t\t);\n\t\t\t}\n\t\t},\n\t\t[],\n\t);\n\n\treturn { downloadQuery };\n}\n",[],[201,293,309],{"_102":317,"_95":318,"_151":319,"_153":294,"_154":136,"_155":320,"_157":158,"_104":321,"_99":258,"_160":219,"_162":322,"_163":22,"_164":-5,"_165":323,"_98":324},"d7890ea0-c1d2-11f0-93b4-42dde27851f2","useQueryExecution.ts","66a9ea22-c1bb-11f0-99b9-42dde27851f2",268,["D",1763177175177],"import { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { QueryResult } from \"../../shared/types.ts\";\n\ninterface UseQueryExecutionResult {\n\tresult: QueryResult | null;\n\terror: string | null;\n\tisLoading: boolean;\n\texecuteQuery: (query: string) => Promise;\n\tclearResults: () => void;\n}\n\n/**\n * Custom hook for executing SQL queries\n */\nexport function useQueryExecution(): UseQueryExecutionResult {\n\tconst [result, setResult] = useState(null);\n\tconst [error, setError] = useState(null);\n\tconst [isLoading, setIsLoading] = useState(false);\n\n\tconst executeQuery = async (query: string) => {\n\t\tif (!query.trim()) {\n\t\t\tsetError(\"Query cannot be empty\");\n\t\t\treturn;\n\t\t}\n\n\t\tsetIsLoading(true);\n\t\tsetError(null);\n\t\tsetResult(null);\n\n\t\ttry {\n\t\t\tconst response = await fetch(\"/api/query\", {\n\t\t\t\tmethod: \"POST\",\n\t\t\t\theaders: {\n\t\t\t\t\t\"Content-Type\": \"application/json\",\n\t\t\t\t},\n\t\t\t\tbody: JSON.stringify({ query }),\n\t\t\t});\n\n\t\t\t// Handle authentication errors\n\t\t\tif (response.status === 401) {\n\t\t\t\twindow.location.href = \"/auth/login\";\n\t\t\t\treturn;\n\t\t\t}\n\n\t\t\tconst data = await response.json();\n\n\t\t\tif (data.success) {\n\t\t\t\tsetResult(data.data);\n\t\t\t} else {\n\t\t\t\tsetError(data.error || \"Query failed\");\n\t\t\t}\n\t\t} catch (err) {\n\t\t\tsetError(err instanceof Error ? err.message : \"Unknown error occurred\");\n\t\t} finally {\n\t\t\tsetIsLoading(false);\n\t\t}\n\t};\n\n\tconst clearResults = () => {\n\t\tsetResult(null);\n\t\tsetError(null);\n\t};\n\n\treturn {\n\t\tresult,\n\t\terror,\n\t\tisLoading,\n\t\texecuteQuery,\n\t\tclearResults,\n\t};\n}\n",[],[201,293,318],{"_102":326,"_95":327,"_151":328,"_153":294,"_154":136,"_155":329,"_157":158,"_104":330,"_99":331,"_160":219,"_162":332,"_163":22,"_164":-5,"_165":333,"_98":334},"d796c6b2-c1d2-11f0-9069-42dde27851f2","useTableSelection.ts","66a2c152-c1bb-11f0-b3d6-42dde27851f2",270,["D",1763177175193],1,"import { useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { generateDefaultQuery } from \"../../shared/sqlHelpers.ts\";\n\n/**\n * Custom hook for managing table selection and query persistence\n */\nexport function useTableSelection(\n\tselectedTable: string | null,\n\tonCodeChange: (code: string) => void,\n) {\n\tuseEffect(() => {\n\t\tif (!selectedTable) return;\n\n\t\t// Try to load saved query from localStorage\n\t\tconst savedQuery = localStorage.getItem(`saved-${selectedTable}`);\n\n\t\tif (savedQuery) {\n\t\t\tonCodeChange(savedQuery);\n\t\t} else {\n\t\t\t// Generate default SELECT query\n\t\t\tconst defaultQuery = generateDefaultQuery(selectedTable, \"table\");\n\t\t\tonCodeChange(defaultQuery);\n\t\t}\n\t}, [selectedTable, onCodeChange]);\n\n\t// Save query to localStorage when it changes\n\tconst saveQuery = (tableName: string, query: string) => {\n\t\tif (tableName && query.trim()) {\n\t\t\tlocalStorage.setItem(`saved-${tableName}`, query);\n\t\t}\n\t};\n\n\treturn { saveQuery };\n}\n",[],[201,293,327],[201,293],{"_102":337,"_95":338,"_151":339,"_153":202,"_154":136,"_155":340,"_157":158,"_104":341,"_99":342,"_160":219,"_162":343,"_163":22,"_164":-5,"_165":344,"_98":345},"9abcd600-c1dc-11f0-88b0-42dde27851f2","App.tsx","668f3754-c1bb-11f0-865f-42dde27851f2",323,["D",1763181368128],37,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n\nimport { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport type { QueryResult, SchemaItem } from \"../shared/types.ts\";\nimport { AppHeader } from \"./components/AppHeader.tsx\";\nimport { EditorSection } from \"./components/EditorSection.tsx\";\nimport { PaginationBar } from \"./components/PaginationBar.tsx\";\nimport { Table } from \"./components/Table.tsx\";\nimport { TablesList } from \"./components/TablesList.tsx\";\nimport { useCodeEditor } from \"./hooks/useCodeEditor.ts\";\nimport { useDownload } from \"./hooks/useDownload.ts\";\nimport { useQueryExecution } from \"./hooks/useQueryExecution.ts\";\nimport { useTableSelection } from \"./hooks/useTableSelection.ts\";\n\nexport function App() {\n\tconst [tables, setTables] = useState([]);\n\tconst [selectedTable, setSelectedTable] = useState(null);\n\tconst [isLoadingSchema, setIsLoadingSchema] = useState(true);\n\tconst [isAuthenticated, setIsAuthenticated] = useState(true);\n\tconst [isSidebarOpen, setIsSidebarOpen] = useState(true);\n\tconst [currentPage, setCurrentPage] = useState(1);\n\n\tconst { code, setCode, getActiveStatement, editorRef } = useCodeEditor();\n\tconst { result, error, isLoading, executeQuery } = useQueryExecution();\n\tconst { saveQuery } = useTableSelection(selectedTable, setCode);\n\tconst { downloadQuery } = useDownload();\n\n\tuseEffect(() => {\n\t\tsetCurrentPage(1);\n\t}, [result]);\n\n\tuseEffect(() => {\n\t\tconst loadSchema = async () => {\n\t\t\ttry {\n\t\t\t\tconst response = await fetch(\"/api/schema\");\n\t\t\t\tif (response.status === 401) {\n\t\t\t\t\tsetIsAuthenticated(false);\n\t\t\t\t\treturn;\n\t\t\t\t}\n\t\t\t\tconst data = await response.json();\n\t\t\t\tconst allItems = [...data.tables, ...data.views];\n\t\t\t\tsetTables(allItems);\n\t\t\t\tsetIsAuthenticated(true);\n\t\t\t} catch (_err) {\n\t\t\t\tsetTables([]);\n\t\t\t} finally {\n\t\t\t\tsetIsLoadingSchema(false);\n\t\t\t}\n\t\t};\n\n\t\tloadSchema();\n\t}, []);\n\n\tuseEffect(() => {\n\t\tconst handleResize = () => {\n\t\t\tif (window.innerWidth < 1024) {\n\t\t\t\tsetIsSidebarOpen(false);\n\t\t\t} else {\n\t\t\t\tsetIsSidebarOpen(true);\n\t\t\t}\n\t\t};\n\t\thandleResize();\n\t\twindow.addEventListener(\"resize\", handleResize);\n\t\treturn () => window.removeEventListener(\"resize\", handleResize);\n\t}, []);\n\n\tconst handleRun = () => {\n\t\tconst statement = getActiveStatement();\n\t\tif (statement) {\n\t\t\texecuteQuery(statement);\n\t\t\tif (selectedTable) {\n\t\t\t\tsaveQuery(selectedTable, statement);\n\t\t\t}\n\t\t}\n\t};\n\n\tconst handleDownloadJSON = async () => {\n\t\tconst statement = getActiveStatement();\n\t\tif (statement) {\n\t\t\tawait downloadQuery(statement, \"json\");\n\t\t}\n\t};\n\n\tconst handleDownloadCSV = async () => {\n\t\tconst statement = getActiveStatement();\n\t\tif (statement) {\n\t\t\tawait downloadQuery(statement, \"csv\");\n\t\t}\n\t};\n\n\tif (!isAuthenticated) {\n\t\treturn (\n\t\t\t

\n\t\t\t\t\n\t\t\t\t

\n\t\t\t\t\t

\n\t\t\t\t\t\tPlease log in to access the SQLite Explorer\n\t\t\t\t\t

\n\t\t\t\t\t\n\t\t\t\t\t\tLogin with Val Town\n\t\t\t\t\t\n\t\t\t\t

\n\t\t\t

\n\t\t);\n\t}\n\n\treturn (\n\t\t

\n\t\t\t setIsSidebarOpen((prev) => !prev)}\n\t\t\t\tactions={\n\t\t\t\t\t\n\t\t\t\t\t\tLogout\n\t\t\t\t\t\n\t\t\t\t}\n\t\t\t/>\n\t\t\t

\n\t\t\t\t{/* Sidebar */}\n\t\t\t\t{isSidebarOpen && (\n\t\t\t\t\t

\n\t\t\t\t\t\t{isLoadingSchema ? (\n\t\t\t\t\t\t\t

\n\t\t\t\t\t\t\t\tLoading schema...\n\t\t\t\t\t\t\t

\n\t\t\t\t\t\t) : (\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t)}\n\t\t\t\t\t

\n\t\t\t\t)}\n\n\t\t\t\t

\n\t\t\t\t\t

\n\t\t\t\t\t\t\n\t\t\t\t\t

\n\n\t\t\t\t\t\n\n\t\t\t\t\t

\n\t\t\t\t\t\t{error && (\n\t\t\t\t\t\t\t

\n\t\t\t\t\t\t\t\t{error}\n\t\t\t\t\t\t\t

\n\t\t\t\t\t\t)}\n\t\t\t\t\t\t{result && (\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t)}\n\t\t\t\t\t\t{!error && !result && (\n\t\t\t\t\t\t\t

\n\t\t\t\t\t\t\t\tRun a query to see results here\n\t\t\t\t\t\t\t

\n\t\t\t\t\t\t)}\n\t\t\t\t\t

\n\t\t\t\t

\n\t\t\t

\n\t\t

\n\t);\n}\n",[],[201,338],{"_102":347,"_95":348,"_151":349,"_153":202,"_154":136,"_155":350,"_157":158,"_104":351,"_99":352,"_160":174,"_162":353,"_163":22,"_164":-5,"_165":354,"_98":355},"59f62f60-c1c6-11f0-9a2c-42dde27851f2","index.html","66816ac0-c1bb-11f0-b3a1-42dde27851f2",189,["D",1763171810529],3,"\n\n\n \n \n SQLite Explorer\n\n \n \n \n \n\n \n \n \n\n \n \n\n\n

\n \n\n\n",[],[201,348],{"_102":357,"_95":358,"_151":359,"_153":202,"_154":136,"_155":360,"_157":158,"_104":361,"_99":258,"_160":219,"_162":362,"_163":22,"_164":-5,"_165":363,"_98":364},"d76a8b06-c1d2-11f0-9069-42dde27851f2","main.tsx","cd229286-c1bb-11f0-b487-42dde27851f2",262,["D",1763177174947],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n\nimport React from \"https://esm.sh/react@18.2.0\";\nimport ReactDOM from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./App.tsx\";\nimport { ErrorBoundary } from \"./components/ErrorBoundary.tsx\";\n\nconst root = document.getElementById(\"root\");\n\nif (root) {\n\tReactDOM.createRoot(root).render(\n\t\t\n\t\t\t\n\t\t\t\t\n\t\t\t\n\t\t,\n\t);\n} else {\n\t// Show error to user\n\tdocument.body.innerHTML =\n\t\t'

Failed to initialize application: Root element not found

';\n}\n",[],[201,358],[201],{"_102":367,"_95":368,"_151":369,"_153":-5,"_154":136,"_155":370,"_157":158,"_104":371,"_99":32,"_160":161,"_162":-5,"_163":22,"_164":-5,"_165":372,"_98":400},"664aeffe-c1bb-11f0-984e-42dde27851f2","shared","664af0b2-c1bb-11f0-984e-42dde27851f2",126,["D",1763167106768],[373,382,391],{"_102":374,"_95":375,"_151":376,"_153":369,"_154":136,"_155":377,"_157":158,"_104":378,"_99":258,"_160":219,"_162":379,"_163":22,"_164":-5,"_165":380,"_98":381},"d7b0be50-c1d2-11f0-8802-42dde27851f2","exportHelpers.ts","66b3bcdc-c1bb-11f0-984e-42dde27851f2",276,["D",1763177175438],"import { Parser } from \"https://esm.sh/@json2csv/plainjs\";\nimport type { QueryResult, SQLValue } from \"./types.ts\";\n\nexport const sqlToJSON = (result: QueryResult): Record[] => {\n\tconst { columns, rows } = result;\n\n\treturn rows.map((row) =>\n\t\tcolumns.reduce(\n\t\t\t(obj, col, index) => {\n\t\t\t\tobj[col] = row[index];\n\t\t\t\treturn obj;\n\t\t\t},\n\t\t\t{} as Record,\n\t\t),\n\t);\n};\n\nexport const sqlToCSV = (result: QueryResult): string => {\n\tconst { columns } = result;\n\tconst records = sqlToJSON(result);\n\treturn new Parser({ fields: columns }).parse(records);\n};\n",[],[368,375],{"_102":383,"_95":384,"_151":385,"_153":369,"_154":136,"_155":386,"_157":158,"_104":387,"_99":331,"_160":219,"_162":388,"_163":22,"_164":-5,"_165":389,"_98":390},"d7b4261c-c1d2-11f0-b693-42dde27851f2","sqlHelpers.ts","66b6e236-c1bb-11f0-815e-42dde27851f2",277,["D",1763177175451],"import { identify } from \"https://esm.sh/sql-query-identifier@2.7.0\";\nimport type { ParsedStatement } from \"./types.ts\";\n\n/**\n * Parse SQL code into individual statements with their positions\n */\nexport function parseSQLStatements(code: string): ParsedStatement[] {\n\treturn identify(code, {\n\t\tdialect: \"sqlite\",\n\t\tstrict: false,\n\t});\n}\n\n/**\n * Select the SQL statement at a given cursor position\n */\nexport function selectStatementFromPosition(\n\tstatements: ParsedStatement[],\n\tposition: number,\n): ParsedStatement | undefined {\n\tfor (const statement of statements) {\n\t\tif (statement.end + 1 >= position) {\n\t\t\treturn statement;\n\t\t}\n\t}\n\treturn undefined;\n}\n\n/**\n * Get the SQL statement at the current cursor position\n * If no statement found, returns empty string\n */\nexport function getStatementAtPosition(\n\tcode: string,\n\tcursorPosition: number,\n): string {\n\tconst statements = parseSQLStatements(code);\n\tconst statement = selectStatementFromPosition(statements, cursorPosition);\n\treturn statement?.text || \"\";\n}\n\n/**\n * Generate a default SELECT query for a table or view\n */\nexport function generateDefaultQuery(\n\tname: string,\n\t_type: \"table\" | \"view\",\n): string {\n\treturn `SELECT * FROM ${name} LIMIT 100;`;\n}\n",[],[368,384],{"_102":392,"_95":393,"_151":394,"_153":369,"_154":136,"_155":395,"_157":158,"_104":396,"_99":258,"_160":219,"_162":397,"_163":22,"_164":-5,"_165":398,"_98":399},"d7abc09e-c1d2-11f0-9069-42dde27851f2","types.ts","66b04fc0-c1bb-11f0-99b9-42dde27851f2",275,["D",1763177175394],"// Shared TypeScript types for SQLite Explorer\n\nexport type SchemaItemType = \"table\" | \"view\";\n\nexport interface SchemaItem {\n\tname: string;\n\ttype: SchemaItemType;\n}\n\n// SQL values can be string, number, boolean, null, or Buffer\nexport type SQLValue = string | number | boolean | null;\n\nexport interface QueryResult {\n\tcolumns: string[];\n\trows: SQLValue[][];\n\trowsAffected?: number;\n}\n\nexport interface QueryResponse {\n\tsuccess: boolean;\n\tdata?: QueryResult;\n\terror?: string;\n}\n\nexport interface SchemaResponse {\n\ttables: SchemaItem[];\n\tviews: SchemaItem[];\n}\n\nexport interface ParsedStatement {\n\tstart: number;\n\tend: number;\n\ttext: string;\n\ttype: string;\n}\n\n// Error type guard helper\nexport function isError(error: unknown): error is Error {\n\treturn error instanceof Error;\n}\n\n// Safe error message extractor\nexport function getErrorMessage(error: unknown): string {\n\tif (isError(error)) {\n\t\treturn error.message;\n\t}\n\tif (typeof error === \"string\") {\n\t\treturn error;\n\t}\n\treturn \"An unknown error occurred\";\n}\n",[],[368,393],[368],{"_102":402,"_95":403,"_151":404,"_153":-5,"_154":136,"_155":405,"_157":158,"_104":406,"_99":32,"_160":174,"_162":407,"_163":22,"_164":-5,"_165":408,"_98":409},"eb958e14-c1cd-11f0-86d5-42dde27851f2",".gitignore","eb958ec8-c1cd-11f0-86d5-42dde27851f2",230,["D",1763175061179],"# dependencies (bun install)\nnode_modules\n\n# output\nout\ndist\n*.tgz\n\n# code coverage\ncoverage\n*.lcov\n\n# logs\nlogs\n_.log\nreport.[0-9]_.[0-9]_.[0-9]_.[0-9]_.json\n\n# dotenv environment variable files\n.env\n.env.development.local\n.env.test.local\n.env.production.local\n.env.local\n\n# caches\n.eslintcache\n.cache\n*.tsbuildinfo\n\n# IntelliJ based IDEs\n.idea\n\n# Finder (MacOS) folder config\n.DS_Store\n",[],[403],{"_102":411,"_95":412,"_151":413,"_153":-5,"_154":136,"_155":414,"_157":158,"_104":415,"_99":32,"_160":174,"_162":416,"_163":22,"_164":-5,"_165":417,"_98":418},"9cf13b88-9963-11f0-9b8d-0224a6c84d84",".vtignore","9cf13c28-9963-11f0-9b8d-0224a6c84d84",42,["D",1758731356226],".git\n.vscode\n.cursor\n.DS_Store\nnode_modules\nvendor",[],[412],{"_102":420,"_95":421,"_151":422,"_153":-5,"_154":136,"_155":423,"_157":158,"_104":424,"_99":32,"_160":174,"_162":425,"_163":22,"_164":-5,"_165":426,"_98":427},"9c4c6010-c1b1-11f0-9319-42dde27851f2","AGENTS.md","9c4c60f6-c1b1-11f0-9319-42dde27851f2",118,["D",1763162902404],"You are an advanced assistant specialized in generating Val Town code.\n\n## Core Guidelines\n\n- Ask clarifying questions when requirements are ambiguous\n- Provide complete, functional solutions rather than skeleton implementations\n- Test your logic against edge cases before presenting the final solution\n- Ensure all code follows Val Town's specific platform requirements\n- If a section of code that you're working on is getting too complex, consider\n refactoring it into subcomponents\n\n## Code Standards\n\n- Generate code in TypeScript or TSX\n- Add appropriate TypeScript types and interfaces for all data structures\n- Prefer official SDKs or libraries than writing API calls directly\n- Ask the user to supply API or library documentation if you are at all unsure\n about it\n- **Never bake in secrets into the code** - always use environment variables\n- Include comments explaining complex logic (avoid commenting obvious\n operations)\n- Follow modern ES6+ conventions and functional programming practices if\n possible\n\n## Types of triggers\n\n### 1. HTTP Trigger\n\n- Create web APIs and endpoints\n- Handle HTTP requests and responses\n- Example structure:\n\n```ts\nexport default async function (req: Request) {\n return new Response(\"Hello World\");\n}\n```\n\nFiles that are HTTP triggers have http in their name like `foobar.http.tsx`\n\n### 2. Cron Triggers\n\n- Run on a schedule\n- Use cron expressions for timing\n- Example structure:\n\n```ts\nexport default async function () {\n // Scheduled task code\n}\n```\n\nFiles that are Cron triggers have cron in their name like `foobar.cron.tsx`\n\n### 3. Email Triggers\n\n- Process incoming emails\n- Handle email-based workflows\n- Example structure:\n\n```ts\nexport default async function (email: Email) {\n // Process email\n}\n```\n\nFiles that are Email triggers have email in their name like `foobar.email.tsx`\n\n## Val Town Standard Libraries\n\nVal Town provides several hosted services and utility functions.\n\n### Blob Storage\n\n```ts\nimport { blob } from \"https://esm.town/v/std/blob\";\nawait blob.setJSON(\"myKey\", { hello: \"world\" });\nlet blobDemo = await blob.getJSON(\"myKey\");\nlet appKeys = await blob.list(\"app_\");\nawait blob.delete(\"myKey\");\n```\n\n### SQLite\n\n```ts\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nconst TABLE_NAME = \"todo_app_users_2\";\n// Create table - do this before usage and change table name when modifying schema\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL\n)`);\n// Query data\nconst result = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME} WHERE id = ?`,\n [1],\n);\n```\n\nNote: When changing a SQLite table's schema, change the table's name (e.g., add\n_2 or _3) to create a fresh table.\n\n### OpenAI\n\n```ts\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\nconst openai = new OpenAI();\nconst completion = await openai.chat.completions.create({\n messages: [\n { role: \"user\", content: \"Say hello in a creative way\" },\n ],\n model: \"gpt-4o-mini\",\n max_tokens: 30,\n});\n```\n\n### Email\n\n```ts\nimport { email } from \"https://esm.town/v/std/email\";\n// By default emails the owner of the val\nawait email({\n subject: \"Hi\",\n text: \"Hi\",\n html: \"

Hi

\",\n});\n```\n\n## Val Town Utility Functions\n\nVal Town provides several utility functions to help with common project tasks.\n\n### Importing Utilities\n\nAlways import utilities with version pins to avoid breaking changes:\n\n```ts\nimport {\n parseProject,\n readFile,\n serveFile,\n} from \"https://esm.town/v/std/utils@85-main/index.ts\";\n```\n\n### Available Utilities\n\n#### **serveFile** - Serve project files with proper content types\n\nFor example, in Hono:\n\n```ts\n// serve all files in frontend/ and shared/\napp.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", (c) => serveFile(c.req.path, import.meta.url));\n```\n\n#### **readFile** - Read files from within the project:\n\n```ts\n// Read a file from the project\nconst fileContent = await readFile(\"/frontend/index.html\", import.meta.url);\n```\n\n#### **listFiles** - List all files in the project\n\n```ts\nconst files = await listFiles(import.meta.url);\n```\n\n#### **parseProject** - Extract information about the current project from import.meta.url\n\nThis is useful for including info for linking back to a val, ie in \"view source\"\nurls:\n\n```ts\nconst projectVal = parseProject(import.meta.url);\nconsole.log(projectVal.username); // Owner of the project\nconsole.log(projectVal.name); // Project name\nconsole.log(projectVal.version); // Version number\nconsole.log(projectVal.branch); // Branch name\nconsole.log(projectVal.links.self.project); // URL to the project page\n```\n\nHowever, it's _extremely importing_ to note that `parseProject` and other\nStandard Library utilities ONLY RUN ON THE SERVER. If you need access to this\ndata on the client, run it in the server and pass it to the client by splicing\nit into the HTML page or by making an API request for it.\n\n## Val Town Platform Specifics\n\n- **Redirects:** Use\n `return new Response(null, { status: 302, headers: { Location: \"/place/to/redirect\" }})`\n instead of `Response.redirect` which is broken\n- **Images:** Avoid external images or base64 images. Use emojis, unicode\n symbols, or icon fonts/libraries instead\n- **AI Image:** To inline generate an AI image use:\n `

`\n- **Storage:** DO NOT use the Deno KV module for storage\n- **Browser APIs:** DO NOT use the `alert()`, `prompt()`, or `confirm()` methods\n- **Weather Data:** Use open-meteo for weather data (doesn't require API keys)\n unless otherwise specified\n- **View Source:** Add a view source link by importing & using\n `import.meta.url.replace(\"ems.sh\", \"val.town)\"` (or passing this data to the\n client) and include `target=\"_top\"` attribute\n- **Error Debugging:** Add\n `` to HTML to capture\n client-side errors\n- **Error Handling:** Only use try...catch when there's a clear local\n resolution; Avoid catches that merely log or return 500s. Let errors bubble up\n with full context\n- **Environment Variables:** Use `Deno.env.get('keyname')` when you need to, but\n generally prefer APIs that don't require keys\n- **Imports:** Use `https://esm.sh` for npm and Deno dependencies to ensure\n compatibility on server and browser\n- **Storage Strategy:** Only use backend storage if explicitly required; prefer\n simple static client-side sites\n- **React Configuration:** When using React libraries, pin versions with\n `?deps=react@18.2.0,react-dom@18.2.0` and start the file with\n `/** @jsxImportSource https://esm.sh/react@18.2.0 */`\n- Ensure all React dependencies and sub-dependencies are pinned to the same\n version\n- **Styling:** Default to using TailwindCSS via\n `` unless otherwise\n specified\n\n## Project Structure and Design Patterns\n\n### Recommended Directory Structure\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Schema definitions\n│ │ ├── queries.ts # DB query functions\n│ │ └── README.md\n│ └── routes/ # Route modules\n│ ├── [route].ts\n│ └── static.ts # Static file serving\n│ ├── index.ts # Main entry point\n│ └── README.md\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx\n│ │ └── [Component].tsx\n│ ├── favicon.svg\n│ ├── index.html # Main HTML template\n│ ├── index.tsx # Frontend JS entry point\n│ ├── README.md\n│ └── style.css\n├── README.md\n└── shared/\n ├── README.md\n └── utils.ts # Shared types and functions\n```\n\n### Backend (Hono) Best Practices\n\n- Hono is the recommended API framework\n- Main entry point should be `backend/index.ts`\n- **Static asset serving:** Use the utility functions to read and serve project\n files:\n ```ts\n import {\n readFile,\n serveFile,\n } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n\n // serve all files in frontend/ and shared/\n app.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\n app.get(\"/shared/*\", (c) => serveFile(c.req.path, import.meta.url));\n\n // For index.html, often you'll want to bootstrap with initial data\n app.get(\"/\", async (c) => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n\n // Inject data to avoid extra round-trips\n const initialData = await fetchInitialData();\n const dataScript = ``;\n\n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n });\n ```\n- Create RESTful API routes for CRUD operations\n- Always include this snippet at the top-level Hono app to re-throwing errors to\n see full stack traces:\n ```ts\n // Unwrap Hono errors to see original error details\n app.onError((err, c) => {\n throw err;\n });\n ```\n\n### Database Patterns\n\n- Run migrations on startup or comment out for performance\n- Change table names when modifying schemas rather than altering\n- Export clear query functions with proper TypeScript typing\n\n## Common Gotchas and Solutions\n\n1. **Environment Limitations:**\n - Val Town runs on Deno in a serverless context, not Node.js\n - Code in `shared/` must work in both frontend and backend environments\n - Cannot use `Deno` keyword in shared code\n - Use `https://esm.sh` for imports that work in both environments\n\n2. **SQLite Peculiarities:**\n - Limited support for ALTER TABLE operations\n - Create new tables with updated schemas and copy data when needed\n - Always run table creation before querying\n\n3. **React Configuration:**\n - All React dependencies must be pinned to 18.2.0\n - Always include `@jsxImportSource https://esm.sh/react@18.2.0` at the top of\n React files\n - Rendering issues often come from mismatched React versions\n\n4. **File Handling:**\n - Val Town only supports text files, not binary\n - Use the provided utilities to read files across branches and forks\n - For files in the project, use `readFile` helpers\n\n5. **API Design:**\n - `fetch` handler is the entry point for HTTP vals\n - Run the Hono app with\n `export default app.fetch // This is the entry point for HTTP vals`",[],[421],{"_102":429,"_95":430,"_151":431,"_153":-5,"_154":136,"_155":432,"_157":158,"_104":433,"_99":331,"_160":174,"_162":434,"_163":22,"_164":-5,"_165":435,"_98":436},"80567bcc-c1d2-11f0-9ed1-42dde27851f2","MIGRATION_GUIDE.md","cd1db45a-c1bb-11f0-9970-42dde27851f2",260,["D",1763177028838],"# SQLite Explorer - React Migration Guide\n\n## Migration Completed ✅\n\nThe SQLite Explorer has been successfully migrated from server-rendered JSX with HTMX to a React SPA with Hono backend, following Val Town best practices.\n\n## New Project Structure\n\n```\nproject-sqlite/\n├── backend/\n│ └── index.http.ts # Main Hono server with API routes\n├── frontend/\n│ ├── components/\n│ │ ├── Icons.tsx # SVG icon components\n│ │ ├── Table.tsx # Query results table\n│ │ ├── TablesList.tsx # Database schema browser\n│ │ ├── EditorSection.tsx # SQL editor with CodeMirror\n│ │ └── Separator.tsx # Panel separators\n│ ├── hooks/\n│ │ ├── useCodeEditor.ts # Editor state & SQL extraction\n│ │ ├── useQueryExecution.ts # Query execution logic\n│ │ ├── useTableSelection.ts # Table selection & persistence\n│ │ └── useDownload.ts # Download functionality\n│ ├── App.tsx # Main application component\n│ ├── main.tsx # React entry point\n│ ├── index.html # HTML template\n│ ├── reset.css # CSS reset\n│ └── style.css # Application styles\n└── shared/\n ├── types.ts # Shared TypeScript types\n ├── sqlHelpers.ts # SQL parsing utilities\n └── exportHelpers.ts # CSV/JSON export functions\n```\n\n## Technology Stack\n\n### Frontend\n\n- **React 18.2.0** - UI framework\n- **@uiw/react-codemirror** - SQL code editor\n- **@codemirror/lang-sql** - SQL syntax highlighting\n- **TailwindCSS (twind)** - Utility-first CSS via CDN\n- **Custom CSS** - Layout and component styles\n\n### Backend\n\n- **Hono 4** - Lightweight web framework\n- **Val Town SQLite** - Database (Turso/libSQL)\n- **Val Town utilities** - File serving, auth, iframe handling\n\n### Utilities\n\n- **sql-query-identifier** - SQL statement parsing\n- **@json2csv/plainjs** - CSV export\n\n## Key Features\n\n✅ **All original features preserved:**\n\n- Database schema browser (tables & views)\n- SQL editor with syntax highlighting\n- Query execution with results display\n- CSV and JSON export\n- Query persistence per table (localStorage)\n- Keyboard shortcuts (Cmd+Enter to run)\n- Password authentication\n- Error handling and display\n\n✅ **Architecture improvements:**\n\n- React state management (hooks-based)\n- Clean separation of concerns\n- Reusable components\n- TypeScript types for type safety\n- API-based data fetching\n- Better code organization\n\n## API Endpoints\n\nThe backend exposes the following REST API endpoints:\n\n- `GET /api/schema` - Returns all tables and views\n- `POST /api/query` - Executes SQL query, returns results\n- `GET /api/download/csv?query=...` - Downloads results as CSV\n- `GET /api/download/json?query=...` - Downloads results as JSON\n- `GET /` - Serves React application\n- `GET /frontend/*` - Serves frontend assets\n- `GET /shared/*` - Serves shared utilities\n\n## How It Works\n\n### Application Flow\n\n1. **Initial Load**\n\n - Backend serves `frontend/index.html`\n - React app bootstraps via `frontend/main.tsx`\n - App component mounts and fetches database schema\n\n2. **Table Selection**\n\n - User clicks table/view in sidebar\n - `useTableSelection` hook loads saved query from localStorage OR generates default `SELECT * FROM table`\n - Editor updates with query\n\n3. **Query Execution**\n\n - User edits SQL in CodeMirror editor\n - Press Cmd+Enter or click Run button\n - `useCodeEditor` extracts statement at cursor position\n - `useQueryExecution` sends POST to `/api/query`\n - Results displayed in table below editor\n\n4. **Data Export**\n - Click Download CSV/JSON button\n - `useDownload` hook triggers download from `/api/download/*`\n - Browser downloads file\n\n### State Management\n\nThe app uses React hooks for state management:\n\n- **App.tsx** - Global state (schema, selected table)\n- **useCodeEditor** - Editor content, cursor position, statement extraction\n- **useQueryExecution** - Query results, errors, loading state\n- **useTableSelection** - Table selection, localStorage sync\n- **useDownload** - Download operations\n\n## Testing Checklist\n\n### Core Functionality\n\n- [ ] Application loads without errors\n- [ ] Database schema loads and displays in sidebar\n- [ ] Clicking a table loads default SELECT query\n- [ ] SQL editor has syntax highlighting\n- [ ] Code editor accepts text input\n- [ ] Cmd+Enter executes query\n- [ ] Run button executes query\n- [ ] Query results display correctly in table\n- [ ] SQL errors display in red text\n\n### Features\n\n- [ ] Download CSV button works\n- [ ] Download JSON button works\n- [ ] Buttons are disabled when editor is empty\n- [ ] Buttons are enabled when editor has content\n- [ ] Loading indicator shows during query execution\n- [ ] Saved queries persist in localStorage\n- [ ] Selecting a table loads saved query (if exists)\n\n### Edge Cases\n\n- [ ] Empty query handling\n- [ ] Invalid SQL error messages\n- [ ] Multi-statement SQL (executes statement at cursor)\n- [ ] Large result sets display properly\n- [ ] Views vs tables distinguished by icons\n\n## Deployment\n\n### Val Town Deployment\n\n1. Ensure the project is in the Val Town recommended structure\n2. The main entry point is `backend/index.http.ts`\n3. The file should be set as type \"http\"\n4. All authentication and iframe handling is already configured\n\n### Local Development\n\nFor local development outside Val Town, you'll need to:\n\n1. Replace Val Town-specific imports:\n\n - `https://esm.town/v/std/sqlite` → Use better-sqlite3 or Turso client\n - `https://esm.town/v/std/utils` → Implement file serving manually\n - Remove Val Town auth middleware (or implement custom auth)\n\n2. Set up a dev server with Vite or similar\n\n## Key Differences from Original\n\n### Removed\n\n- ❌ HTMX (replaced with React state + fetch)\n- ❌ Hyperscript (replaced with React event handlers)\n- ❌ code-mirror web component (replaced with @uiw/react-codemirror)\n- ❌ Server-side JSX rendering (now client-side React)\n\n### Added\n\n- ✅ React components and hooks\n- ✅ TypeScript types\n- ✅ REST API endpoints\n- ✅ Client-side state management\n- ✅ Better code organization\n- ✅ DownloadSVG icon\n\n### Changed\n\n- 🔄 Form submission → API calls via fetch\n- 🔄 Hyperscript click handlers → React onClick\n- 🔄 HTMX target swapping → React state updates\n- 🔄 Server-rendered components → Client-rendered React\n- 🔄 Inline scripts → React hooks\n\n## Known Limitations\n\n- Panel resizing is visual only (resize functionality not yet implemented)\n - Can use `react-resizable-panels` library if needed\n- Authentication still uses Val Town-specific middleware\n- File serving uses Val Town utilities\n\n## Future Enhancements\n\nPotential improvements to consider:\n\n- [ ] Query history panel (show recent queries)\n- [ ] Saved queries UI (beyond localStorage)\n- [ ] Query formatting button (using sql-formatter)\n- [ ] Dark mode support\n- [ ] Table schema viewer (show column names/types)\n- [ ] Query execution time display\n- [ ] Result pagination for large datasets\n- [ ] Export options (limit rows, custom filename)\n- [ ] Keyboard shortcut help panel\n- [ ] Multiple tabs for queries\n\n## Troubleshooting\n\n### Application doesn't load\n\n- Check browser console for errors\n- Verify `/frontend/index.html` is being served\n- Check that all imports resolve correctly\n\n### Query execution fails\n\n- Check backend console for errors\n- Verify `/api/query` endpoint is accessible\n- Check authentication is working\n\n### Editor not working\n\n- Verify CodeMirror dependencies loaded from esm.sh\n- Check React version is pinned to 18.2.0\n- Look for import errors in browser console\n\n### Downloads not working\n\n- Check `/api/download/*` endpoints\n- Verify query parameter is being passed\n- Check browser download settings\n\n## Resources\n\n- [Val Town Docs](https://docs.val.town)\n- [React Docs](https://react.dev)\n- [Hono Docs](https://hono.dev)\n- [CodeMirror 6 Docs](https://codemirror.net)\n\n---\n\n**Migration completed on:** 2025-11-14\n**Framework:** React 18 + Hono 4\n**Status:** Ready for testing\n",[],[430],{"_102":438,"_95":439,"_151":440,"_153":-5,"_154":136,"_155":135,"_157":158,"_104":441,"_99":442,"_160":174,"_162":443,"_163":22,"_164":-5,"_165":444,"_98":445},"40e45126-c1e1-11f0-ae7c-42dde27851f2","README.md","72074bc4-c1d1-11f0-9bc5-42dde27851f2",["D",1763183364889],22,"# SQLite Explorer (vReact)\n\n_Look ma, no HTMX!_\n\nA modern, web-based SQLite database browser and query tool built for\n[Val Town](https://val.town). Execute SQL queries, browse database schema, and\nexport results with a clean, intuitive interface.\n\n## Features\n\n- 🔍 **Database Schema Browser** - View all tables and views with visual icons\n- ✨ **SQL Code Editor** - Syntax highlighting with CodeMirror\n- ⚡ **Query Execution** - Execute SQL queries with real-time results\n- 📊 **Paginated Results** - Handle large datasets (100 rows per page)\n- 💾 **Export Data** - Download results as CSV or JSON\n- 🎨 **Dark Mode** - Automatic theme switching with warm color palette\n- 💬 **Query Persistence** - Saves queries per table in localStorage\n- ⌨️ **Keyboard Shortcuts** - `Cmd/Ctrl+Enter` to run queries\n- 🔒 **OAuth Authentication** - Secure Val Town authentication\n- 🛡️ **Error Boundaries** - Graceful error handling and recovery\n\n## Tech Stack\n\n### Frontend\n\n- **React 18.2.0** - UI framework\n- **CodeMirror 6** - SQL editor with syntax highlighting\n- **TailwindCSS** - Styling (via Play CDN)\n- **TypeScript** - Type safety with strict mode\n\n### Backend\n\n- **Hono 4** - Lightweight web framework\n- **Turso/libSQL** - SQLite database (via Val Town)\n- **Deno** - Runtime environment\n\n### Tools\n\n- **Biome** - Linting and formatting\n- **TypeScript Strict Mode** - Enhanced type safety\n\n## Project Structure\n\n```\n.\n├── backend/\n│ └── index.http.ts # Hono API server / Entry Point\n├── frontend/\n│ ├── components/\n│ │ ├── AppHeader.tsx # App header with title\n│ │ ├── EditorSection.tsx # SQL editor with controls\n│ │ ├── ErrorBoundary.tsx # Error boundary component\n│ │ ├── Icons.tsx # Icon components\n│ │ ├── PaginationBar.tsx # Pagination controls\n│ │ ├── Table.tsx # Data table with pagination\n│ │ ├── TablesList.tsx # Schema sidebar\n│ │ └── ThemeToggle.tsx # Dark mode toggle\n│ ├── hooks/\n│ │ ├── useCodeEditor.ts # Editor state management\n│ │ ├── useDownload.ts # Export functionality\n│ │ ├── useQueryExecution.ts # Query execution logic\n│ │ └── useTableSelection.ts # Table selection logic\n│ ├── App.tsx # Main React application\n│ ├── index.html # HTML entry point\n│ └── main.tsx # React entry point\n└── shared/\n ├── exportHelpers.ts # CSV/JSON export utilities\n ├── sqlHelpers.ts # SQL parsing utilities\n └── types.ts # Shared TypeScript types\n```\n\n## Usage\n\n### Running Queries\n\n1. **Select a table** from the sidebar to auto-populate the editor with\n `SELECT * FROM [table]`\n2. **Write or edit your SQL query** in the editor\n3. **Press `Cmd/Ctrl+Enter`** or click the \"Run Query\" button\n4. **View results** in the paginated table below\n\n### Multi-Statement Queries\n\nThe editor supports multiple SQL statements. It will execute the statement at\nyour cursor position when you press `Cmd/Ctrl+Enter`.\n\n### Exporting Data\n\n1. **Execute a query** to get results\n2. **Click \"Download CSV\"** or **\"Download JSON\"**\n3. File downloads automatically with the results\n\n### Keyboard Shortcuts\n\n- `Cmd/Ctrl+Enter` - Execute query at cursor\n- Click table name - Auto-populate SELECT query\n\n## API Endpoints\n\n### `GET /api/schema`\n\nReturns all tables and views in the database.\n\n**Response:**\n\n```json\n{\n \"tables\": [{ \"name\": \"users\", \"type\": \"table\" }],\n \"views\": [{ \"name\": \"active_users\", \"type\": \"view\" }]\n}\n```\n\n### `POST /api/query`\n\nExecutes a SQL query.\n\n**Request:**\n\n```json\n{ \"query\": \"SELECT * FROM users LIMIT 10\" }\n```\n\n**Response:**\n\n```json\n{\n \"success\": true,\n \"data\": {\n \"columns\": [\"id\", \"name\", \"email\"],\n \"rows\": [[1, \"Alice\", \"alice@example.com\"]]\n }\n}\n```\n\n### `GET /api/download/csv?query=`\n\nDownloads query results as CSV.\n\n### `GET /api/download/json?query=`\n\nDownloads query results as JSON.\n\n## Limitations\n\n- **Admin tool only** - Not designed for public-facing applications\n- **Single database** - Works with Val Town's SQLite instance\n- **No query history** - Future enhancement planned\n- **100 row pagination** - Configurable in `Table.tsx`\n\n## Migration History\n\nThis project was migrated from HTMX to React on November 14, 2024. See\n`MIGRATION_GUIDE.md` for details on the migration process.",[],[439],{"_102":447,"_95":448,"_151":449,"_153":-5,"_154":136,"_155":450,"_157":158,"_104":451,"_99":258,"_160":174,"_162":452,"_163":22,"_164":-5,"_165":453,"_98":454},"25857ad2-c1d6-11f0-837c-42dde27851f2","biome.json","9c50218c-c1b1-11f0-a520-42dde27851f2",292,["D",1763178594507],"{\n\t\"$schema\": \"https://biomejs.dev/schemas/2.3.5/schema.json\",\n\t\"vcs\": { \"enabled\": true, \"clientKind\": \"git\", \"useIgnoreFile\": true },\n\t\"files\": { \"ignoreUnknown\": false },\n\t\"formatter\": { \"enabled\": true, \"indentStyle\": \"tab\" },\n\t\"linter\": { \"enabled\": true, \"rules\": { \"recommended\": true } },\n\t\"javascript\": { \"formatter\": { \"quoteStyle\": \"double\" } },\n\t\"assist\": {\n\t\t\"enabled\": true,\n\t\t\"actions\": { \"source\": { \"organizeImports\": \"on\" } }\n\t}\n}\n",[],[448],{"_102":456,"_95":457,"_151":458,"_153":-5,"_154":136,"_155":459,"_157":158,"_104":460,"_99":352,"_160":174,"_162":461,"_163":22,"_164":-5,"_165":462,"_98":463},"d79ac08c-c1d2-11f0-9ab8-42dde27851f2","deno.json","9c57bac8-c1b1-11f0-8727-42dde27851f2",271,["D",1763177175262],"{\n\t\"$schema\": \"https://raw.githubusercontent.com/denoland/deno/348900b8b79f4a434cab4c74b3bc8d4d2fa8ee74/cli/schemas/config-file.v1.json\",\n\t\"compilerOptions\": {\n\t\t\"lib\": [\n\t\t\t\"dom\",\n\t\t\t\"dom.iterable\",\n\t\t\t\"dom.asynciterable\",\n\t\t\t\"deno.ns\",\n\t\t\t\"deno.unstable\"\n\t\t],\n\t\t\"noImplicitAny\": true,\n\t\t\"strict\": true,\n\t\t\"types\": [\"https://www.val.town/types/valtown.d.ts\"]\n\t},\n\t\"experimental\": {\n\t\t\"unstable-node-globals\": true,\n\t\t\"unstable-sloppy-imports\": true,\n\t\t\"unstable-temporal\": true,\n\t\t\"unstable-worker-options\": true\n\t},\n\t\"imports\": {\n\t\t\"@biomejs/biome\": \"npm:@biomejs/biome@^2.3.5\"\n\t},\n\t\"lint\": {\n\t\t\"files\": {\n\t\t\t\"include\": [\"deno:/https/esm.town/**/*\"]\n\t\t},\n\t\t\"rules\": {\n\t\t\t\"exclude\": [\"no-explicit-any\", \"no-import-prefix\"]\n\t\t}\n\t},\n\t\"lock\": true,\n\t\"nodeModulesDir\": \"auto\"\n}\n",[],[457],{"_102":465,"_95":466,"_151":467,"_153":-5,"_154":136,"_155":468,"_157":158,"_104":469,"_99":331,"_160":174,"_162":470,"_163":22,"_164":-5,"_165":471,"_98":472},"52ae9f2a-c1d6-11f0-822a-42dde27851f2","deno.lock","14e1d65e-c1d0-11f0-bc5e-42dde27851f2",294,["D",1763178670272],"{\n \"version\": \"5\",\n \"specifiers\": {\n \"npm:@biomejs/biome@^2.3.5\": \"2.3.5\",\n \"npm:@libsql/client@0.6.0\": \"0.6.0\",\n \"npm:@valtown/sdk@0.37.0\": \"0.37.0\",\n \"npm:@valtown/sdk@1.9.0\": \"1.9.0\",\n \"npm:badge-maker@*\": \"5.0.2\",\n \"npm:hono@*\": \"4.10.1\",\n \"npm:hono@4\": \"4.10.1\",\n \"npm:mime-types@2.1.35\": \"2.1.35\",\n \"npm:preact-render-to-string@*\": \"6.6.2_preact@10.27.2\",\n \"npm:pretty-ms@*\": \"9.3.0\",\n \"npm:zod@*\": \"4.1.12\"\n },\n \"npm\": {\n \"@biomejs/biome@2.3.5\": {\n \"integrity\": \"sha512-HvLhNlIlBIbAV77VysRIBEwp55oM/QAjQEin74QQX9Xb259/XP/D5AGGnZMOyF1el4zcvlNYYR3AyTMUV3ILhg==\",\n \"optionalDependencies\": [\n \"@biomejs/cli-darwin-arm64\",\n \"@biomejs/cli-darwin-x64\",\n \"@biomejs/cli-linux-arm64\",\n \"@biomejs/cli-linux-arm64-musl\",\n \"@biomejs/cli-linux-x64\",\n \"@biomejs/cli-linux-x64-musl\",\n \"@biomejs/cli-win32-arm64\",\n \"@biomejs/cli-win32-x64\"\n ],\n \"bin\": true\n },\n \"@biomejs/cli-darwin-arm64@2.3.5\": {\n \"integrity\": \"sha512-fLdTur8cJU33HxHUUsii3GLx/TR0BsfQx8FkeqIiW33cGMtUD56fAtrh+2Fx1uhiCsVZlFh6iLKUU3pniZREQw==\",\n \"os\": [\"darwin\"],\n \"cpu\": [\"arm64\"]\n },\n \"@biomejs/cli-darwin-x64@2.3.5\": {\n \"integrity\": \"sha512-qpT8XDqeUlzrOW8zb4k3tjhT7rmvVRumhi2657I2aGcY4B+Ft5fNwDdZGACzn8zj7/K1fdWjgwYE3i2mSZ+vOA==\",\n \"os\": [\"darwin\"],\n \"cpu\": [\"x64\"]\n },\n \"@biomejs/cli-linux-arm64-musl@2.3.5\": {\n \"integrity\": \"sha512-eGUG7+hcLgGnMNl1KHVZUYxahYAhC462jF/wQolqu4qso2MSk32Q+QrpN7eN4jAHAg7FUMIo897muIhK4hXhqg==\",\n \"os\": [\"linux\"],\n \"cpu\": [\"arm64\"]\n },\n \"@biomejs/cli-linux-arm64@2.3.5\": {\n \"integrity\": \"sha512-u/pybjTBPGBHB66ku4pK1gj+Dxgx7/+Z0jAriZISPX1ocTO8aHh8x8e7Kb1rB4Ms0nA/SzjtNOVJ4exVavQBCw==\",\n \"os\": [\"linux\"],\n \"cpu\": [\"arm64\"]\n },\n \"@biomejs/cli-linux-x64-musl@2.3.5\": {\n \"integrity\": \"sha512-awVuycTPpVTH/+WDVnEEYSf6nbCBHf/4wB3lquwT7puhNg8R4XvonWNZzUsfHZrCkjkLhFH/vCZK5jHatD9FEg==\",\n \"os\": [\"linux\"],\n \"cpu\": [\"x64\"]\n },\n \"@biomejs/cli-linux-x64@2.3.5\": {\n \"integrity\": \"sha512-XrIVi9YAW6ye0CGQ+yax0gLfx+BFOtKaNX74n+xHWla6Cl6huUmcKNO7HPx7BiKnJUzrxXY1qYlm7xMvi08X4g==\",\n \"os\": [\"linux\"],\n \"cpu\": [\"x64\"]\n },\n \"@biomejs/cli-win32-arm64@2.3.5\": {\n \"integrity\": \"sha512-DlBiMlBZZ9eIq4H7RimDSGsYcOtfOIfZOaI5CqsWiSlbTfqbPVfWtCf92wNzx8GNMbu1s7/g3ZZESr6+GwM/SA==\",\n \"os\": [\"win32\"],\n \"cpu\": [\"arm64\"]\n },\n \"@biomejs/cli-win32-x64@2.3.5\": {\n \"integrity\": \"sha512-nUmR8gb6yvrKhtRgzwo/gDimPwnO5a4sCydf8ZS2kHIJhEmSmk+STsusr1LHTuM//wXppBawvSQi2xFXJCdgKQ==\",\n \"os\": [\"win32\"],\n \"cpu\": [\"x64\"]\n },\n \"@libsql/client@0.6.0\": {\n \"integrity\": \"sha512-qhQzTG/y2IEVbL3+9PULDvlQFWJ/RnjFXECr/Nc3nRngGiiMysDaOV5VUzYk7DulUX98EA4wi+z3FspKrUplUA==\",\n \"dependencies\": [\n \"@libsql/core\",\n \"@libsql/hrana-client\",\n \"js-base64\",\n \"libsql\"\n ]\n },\n \"@libsql/core@0.6.2\": {\n \"integrity\": \"sha512-c2P4M+4u/4b2L02A0KjggO3UW51rGkhxr/7fzJO0fEAqsqrWGxuNj2YtRkina/oxfYvAof6xjp8RucNoIV/Odw==\",\n \"dependencies\": [\n \"js-base64\"\n ]\n },\n \"@libsql/darwin-arm64@0.3.19\": {\n \"integrity\": \"sha512-rmOqsLcDI65zzxlUOoEiPJLhqmbFsZF6p4UJQ2kMqB+Kc0Rt5/A1OAdOZ/Wo8fQfJWjR1IbkbpEINFioyKf+nQ==\",\n \"os\": [\"darwin\"],\n \"cpu\": [\"arm64\"]\n },\n \"@libsql/darwin-x64@0.3.19\": {\n \"integrity\": \"sha512-q9O55B646zU+644SMmOQL3FIfpmEvdWpRpzubwFc2trsa+zoBlSkHuzU9v/C+UNoPHQVRMP7KQctJ455I/h/xw==\",\n \"os\": [\"darwin\"],\n \"cpu\": [\"x64\"]\n },\n \"@libsql/hrana-client@0.6.2\": {\n \"integrity\": \"sha512-MWxgD7mXLNf9FXXiM0bc90wCjZSpErWKr5mGza7ERy2FJNNMXd7JIOv+DepBA1FQTIfI8TFO4/QDYgaQC0goNw==\",\n \"dependencies\": [\n \"@libsql/isomorphic-fetch\",\n \"@libsql/isomorphic-ws\",\n \"js-base64\",\n \"node-fetch@3.3.2\"\n ]\n },\n \"@libsql/isomorphic-fetch@0.2.5\": {\n \"integrity\": \"sha512-8s/B2TClEHms2yb+JGpsVRTPBfy1ih/Pq6h6gvyaNcYnMVJvgQRY7wAa8U2nD0dppbCuDU5evTNMEhrQ17ZKKg==\"\n },\n \"@libsql/isomorphic-ws@0.1.5\": {\n \"integrity\": \"sha512-DtLWIH29onUYR00i0GlQ3UdcTRC6EP4u9w/h9LxpUZJWRMARk6dQwZ6Jkd+QdwVpuAOrdxt18v0K2uIYR3fwFg==\",\n \"dependencies\": [\n \"@types/ws\",\n \"ws\"\n ]\n },\n \"@libsql/linux-arm64-gnu@0.3.19\": {\n \"integrity\": \"sha512-mgeAUU1oqqh57k7I3cQyU6Trpdsdt607eFyEmH5QO7dv303ti+LjUvh1pp21QWV6WX7wZyjeJV1/VzEImB+jRg==\",\n \"os\": [\"linux\"],\n \"cpu\": [\"arm64\"]\n },\n \"@libsql/linux-arm64-musl@0.3.19\": {\n \"integrity\": \"sha512-VEZtxghyK6zwGzU9PHohvNxthruSxBEnRrX7BSL5jQ62tN4n2JNepJ6SdzXp70pdzTfwroOj/eMwiPt94gkVRg==\",\n \"os\": [\"linux\"],\n \"cpu\": [\"arm64\"]\n },\n \"@libsql/linux-x64-gnu@0.3.19\": {\n \"integrity\": \"sha512-2t/J7LD5w2f63wGihEO+0GxfTyYIyLGEvTFEsMO16XI5o7IS9vcSHrxsvAJs4w2Pf907uDjmc7fUfMg6L82BrQ==\",\n \"os\": [\"linux\"],\n \"cpu\": [\"x64\"]\n },\n \"@libsql/linux-x64-musl@0.3.19\": {\n \"integrity\": \"sha512-BLsXyJaL8gZD8+3W2LU08lDEd9MIgGds0yPy5iNPp8tfhXx3pV/Fge2GErN0FC+nzt4DYQtjL+A9GUMglQefXQ==\",\n \"os\": [\"linux\"],\n \"cpu\": [\"x64\"]\n },\n \"@libsql/win32-x64-msvc@0.3.19\": {\n \"integrity\": \"sha512-ay1X9AobE4BpzG0XPw1gplyLZPGHIgJOovvW23gUrukRegiUP62uzhpRbKNogLlUOynyXeq//prHgPXiebUfWg==\",\n \"os\": [\"win32\"],\n \"cpu\": [\"x64\"]\n },\n \"@neon-rs/load@0.0.4\": {\n \"integrity\": \"sha512-kTPhdZyTQxB+2wpiRcFWrDcejc4JI6tkPuS7UZCG4l6Zvc5kU/gGQ/ozvHTh1XR5tS+UlfAfGuPajjzQjCiHCw==\"\n },\n \"@types/node-fetch@2.6.13\": {\n \"integrity\": \"sha512-QGpRVpzSaUs30JBSGPjOg4Uveu384erbHBoT1zeONvyCfwQxIkUshLAOqN/k9EjGviPRmWTTe6aH2qySWKTVSw==\",\n \"dependencies\": [\n \"@types/node@24.2.0\",\n \"form-data\"\n ]\n },\n \"@types/node@18.19.129\": {\n \"integrity\": \"sha512-hrmi5jWt2w60ayox3iIXwpMEnfUvOLJCRtrOPbHtH15nTjvO7uhnelvrdAs0dO0/zl5DZ3ZbahiaXEVb54ca/A==\",\n \"dependencies\": [\n \"undici-types@5.26.5\"\n ]\n },\n \"@types/node@24.2.0\": {\n \"integrity\": \"sha512-3xyG3pMCq3oYCNg7/ZP+E1ooTaGB4cG8JWRsqqOYQdbWNY4zbaV0Ennrd7stjiJEFZCaybcIgpTjJWHRfBSIDw==\",\n \"dependencies\": [\n \"undici-types@7.10.0\"\n ]\n },\n \"@types/ws@8.18.1\": {\n \"integrity\": \"sha512-ThVF6DCVhA8kUGy+aazFQ4kXQ7E1Ty7A3ypFOe0IcJV8O/M511G99AW24irKrW56Wt44yG9+ij8FaqoBGkuBXg==\",\n \"dependencies\": [\n \"@types/node@24.2.0\"\n ]\n },\n \"@valtown/sdk@0.37.0\": {\n \"integrity\": \"sha512-8YnynWRljje10MDRGJdftC5qU5FguFLYLDIauEjDUb5IlZbVevMdiunJpK7i37jDBm/QljCmIjPdPUpDE89snw==\",\n \"dependencies\": [\n \"@types/node@18.19.129\",\n \"@types/node-fetch\",\n \"abort-controller\",\n \"agentkeepalive\",\n \"form-data-encoder\",\n \"formdata-node\",\n \"node-fetch@2.7.0\"\n ]\n },\n \"@valtown/sdk@1.9.0\": {\n \"integrity\": \"sha512-xV8B02a+IJZYkxMk7CVS5hcNjyJ2XhZvJ3iXxqaILVbNsaq9BCAzSvYS+GteaFxG0OO9YiWSSNh68047o+Rk+g==\",\n \"dependencies\": [\n \"@types/node@18.19.129\",\n \"@types/node-fetch\",\n \"abort-controller\",\n \"agentkeepalive\",\n \"form-data-encoder\",\n \"formdata-node\",\n \"node-fetch@2.7.0\"\n ]\n },\n \"abort-controller@3.0.0\": {\n \"integrity\": \"sha512-h8lQ8tacZYnR3vNQTgibj+tODHI5/+l06Au2Pcriv/Gmet0eaj4TwWH41sO9wnHDiQsEj19q0drzdWdeAHtweg==\",\n \"dependencies\": [\n \"event-target-shim\"\n ]\n },\n \"agentkeepalive@4.6.0\": {\n \"integrity\": \"sha512-kja8j7PjmncONqaTsB8fQ+wE2mSU2DJ9D4XKoJ5PFWIdRMa6SLSN1ff4mOr4jCbfRSsxR4keIiySJU0N9T5hIQ==\",\n \"dependencies\": [\n \"humanize-ms\"\n ]\n },\n \"anafanafo@2.0.0\": {\n \"integrity\": \"sha512-Nlfq7NC4AOkTJerWRIZcOAiMNtIDVIGWGvQ98O7Jl6Kr2Dk0dX5u4MqN778kSRTy5KRqchpLdF2RtLFEz9FVkQ==\",\n \"dependencies\": [\n \"char-width-table-consumer\"\n ]\n },\n \"asynckit@0.4.0\": {\n \"integrity\": \"sha512-Oei9OH4tRh0YqU3GxhX79dM/mwVgvbZJaSNaRk+bshkj0S5cfHcgYakreBjrHwatXKbz+IoIdYLxrKim2MjW0Q==\"\n },\n \"badge-maker@5.0.2\": {\n \"integrity\": \"sha512-Xd3YUmKPEShQcn6PFB03Wxq0RNJRFwVVroyRz0qIjSXwniYUGsGWNHqtNsQYi/Sbs8Ni7qAEf7LKgDOtcAoCDg==\",\n \"dependencies\": [\n \"anafanafo\",\n \"css-color-converter\"\n ],\n \"bin\": true\n },\n \"binary-search@1.3.6\": {\n \"integrity\": \"sha512-nbE1WxOTTrUWIfsfZ4aHGYu5DOuNkbxGokjV6Z2kxfJK3uaAb8zNK1muzOeipoLHZjInT4Br88BHpzevc681xA==\"\n },\n \"call-bind-apply-helpers@1.0.2\": {\n \"integrity\": \"sha512-Sp1ablJ0ivDkSzjcaJdxEunN5/XvksFJ2sMBFfq6x0ryhQV/2b/KwFe21cMpmHtPOSij8K99/wSfoEuTObmuMQ==\",\n \"dependencies\": [\n \"es-errors\",\n \"function-bind\"\n ]\n },\n \"char-width-table-consumer@1.0.0\": {\n \"integrity\": \"sha512-Fz4UD0LBpxPgL9i29CJ5O4KANwaMnX/OhhbxzvNa332h+9+nRKyeuLw4wA51lt/ex67+/AdsoBQJF3kgX2feYQ==\",\n \"dependencies\": [\n \"binary-search\"\n ]\n },\n \"color-convert@0.5.3\": {\n \"integrity\": \"sha512-RwBeO/B/vZR3dfKL1ye/vx8MHZ40ugzpyfeVG5GsiuGnrlMWe2o8wxBbLCpw9CsxV+wHuzYlCiWnybrIA0ling==\"\n },\n \"color-name@1.1.4\": {\n \"integrity\": \"sha512-dOy+3AuW3a2wNbZHIuMZpTcgjGuLU/uBL/ubcZF9OXbDo8ff4O8yVp5Bf0efS8uEoYo5q4Fx7dY9OgQGXgAsQA==\"\n },\n \"combined-stream@1.0.8\": {\n \"integrity\": \"sha512-FQN4MRfuJeHf7cBbBMJFXhKSDq+2kAArBlmRBvcvFE5BB1HZKXtSFASDhdlz9zOYwxh8lDdnvmMOe/+5cdoEdg==\",\n \"dependencies\": [\n \"delayed-stream\"\n ]\n },\n \"css-color-converter@2.0.0\": {\n \"integrity\": \"sha512-oLIG2soZz3wcC3aAl/7Us5RS8Hvvc6I8G8LniF/qfMmrm7fIKQ8RIDDRZeKyGL2SrWfNqYspuLShbnjBMVWm8g==\",\n \"dependencies\": [\n \"color-convert\",\n \"color-name\",\n \"css-unit-converter\"\n ]\n },\n \"css-unit-converter@1.1.2\": {\n \"integrity\": \"sha512-IiJwMC8rdZE0+xiEZHeru6YoONC4rfPMqGm2W85jMIbkFvv5nFTwJVFHam2eFrN6txmoUYFAFXiv8ICVeTO0MA==\"\n },\n \"data-uri-to-buffer@4.0.1\": {\n \"integrity\": \"sha512-0R9ikRb668HB7QDxT1vkpuUBtqc53YyAwMwGeUFKRojY/NWKvdZ+9UYtRfGmhqNbRkTSVpMbmyhXipFFv2cb/A==\"\n },\n \"delayed-stream@1.0.0\": {\n \"integrity\": \"sha512-ZySD7Nf91aLB0RxL4KGrKHBXl7Eds1DAmEdcoVawXnLD7SDhpNgtuII2aAkg7a7QS41jxPSZ17p4VdGnMHk3MQ==\"\n },\n \"detect-libc@2.0.2\": {\n \"integrity\": \"sha512-UX6sGumvvqSaXgdKGUsgZWqcUyIXZ/vZTrlRT/iobiKhGL0zL4d3osHj3uqllWJK+i+sixDS/3COVEOFbupFyw==\"\n },\n \"dunder-proto@1.0.1\": {\n \"integrity\": \"sha512-KIN/nDJBQRcXw0MLVhZE9iQHmG68qAVIBg9CqmUYjmQIhgij9U5MFvrqkUL5FbtyyzZuOeOt0zdeRe4UY7ct+A==\",\n \"dependencies\": [\n \"call-bind-apply-helpers\",\n \"es-errors\",\n \"gopd\"\n ]\n },\n \"es-define-property@1.0.1\": {\n \"integrity\": \"sha512-e3nRfgfUZ4rNGL232gUgX06QNyyez04KdjFrF+LTRoOXmrOgFKDg4BCdsjW8EnT69eqdYGmRpJwiPVYNrCaW3g==\"\n },\n \"es-errors@1.3.0\": {\n \"integrity\": \"sha512-Zf5H2Kxt2xjTvbJvP2ZWLEICxA6j+hAmMzIlypy4xcBg1vKVnx89Wy0GbS+kf5cwCVFFzdCFh2XSCFNULS6csw==\"\n },\n \"es-object-atoms@1.1.1\": {\n \"integrity\": \"sha512-FGgH2h8zKNim9ljj7dankFPcICIK9Cp5bm+c2gQSYePhpaG5+esrLODihIorn+Pe6FGJzWhXQotPv73jTaldXA==\",\n \"dependencies\": [\n \"es-errors\"\n ]\n },\n \"es-set-tostringtag@2.1.0\": {\n \"integrity\": \"sha512-j6vWzfrGVfyXxge+O0x5sh6cvxAog0a/4Rdd2K36zCMV5eJ+/+tOAngRO8cODMNWbVRdVlmGZQL2YS3yR8bIUA==\",\n \"dependencies\": [\n \"es-errors\",\n \"get-intrinsic\",\n \"has-tostringtag\",\n \"hasown\"\n ]\n },\n \"event-target-shim@5.0.1\": {\n \"integrity\": \"sha512-i/2XbnSz/uxRCU6+NdVJgKWDTM427+MqYbkQzD321DuCQJUqOuJKIA0IM2+W2xtYHdKOmZ4dR6fExsd4SXL+WQ==\"\n },\n \"fetch-blob@3.2.0\": {\n \"integrity\": \"sha512-7yAQpD2UMJzLi1Dqv7qFYnPbaPx7ZfFK6PiIxQ4PfkGPyNyl2Ugx+a/umUonmKqjhM4DnfbMvdX6otXq83soQQ==\",\n \"dependencies\": [\n \"node-domexception\",\n \"web-streams-polyfill@3.3.3\"\n ]\n },\n \"form-data-encoder@1.7.2\": {\n \"integrity\": \"sha512-qfqtYan3rxrnCk1VYaA4H+Ms9xdpPqvLZa6xmMgFvhO32x7/3J/ExcTd6qpxM0vH2GdMI+poehyBZvqfMTto8A==\"\n },\n \"form-data@4.0.4\": {\n \"integrity\": \"sha512-KrGhL9Q4zjj0kiUt5OO4Mr/A/jlI2jDYs5eHBpYHPcBEVSiipAvn2Ko2HnPe20rmcuuvMHNdZFp+4IlGTMF0Ow==\",\n \"dependencies\": [\n \"asynckit\",\n \"combined-stream\",\n \"es-set-tostringtag\",\n \"hasown\",\n \"mime-types\"\n ]\n },\n \"formdata-node@4.4.1\": {\n \"integrity\": \"sha512-0iirZp3uVDjVGt9p49aTaqjk84TrglENEDuqfdlZQ1roC9CWlPk6Avf8EEnZNcAqPonwkG35x4n3ww/1THYAeQ==\",\n \"dependencies\": [\n \"node-domexception\",\n \"web-streams-polyfill@4.0.0-beta.3\"\n ]\n },\n \"formdata-polyfill@4.0.10\": {\n \"integrity\": \"sha512-buewHzMvYL29jdeQTVILecSaZKnt/RJWjoZCF5OW60Z67/GmSLBkOFM7qh1PI3zFNtJbaZL5eQu1vLfazOwj4g==\",\n \"dependencies\": [\n \"fetch-blob\"\n ]\n },\n \"function-bind@1.1.2\": {\n \"integrity\": \"sha512-7XHNxH7qX9xG5mIwxkhumTox/MIRNcOgDrxWsMt2pAr23WHp6MrRlN7FBSFpCpr+oVO0F744iUgR82nJMfG2SA==\"\n },\n \"get-intrinsic@1.3.0\": {\n \"integrity\": \"sha512-9fSjSaos/fRIVIp+xSJlE6lfwhES7LNtKaCBIamHsjr2na1BiABJPo0mOjjz8GJDURarmCPGqaiVg5mfjb98CQ==\",\n \"dependencies\": [\n \"call-bind-apply-helpers\",\n \"es-define-property\",\n \"es-errors\",\n \"es-object-atoms\",\n \"function-bind\",\n \"get-proto\",\n \"gopd\",\n \"has-symbols\",\n \"hasown\",\n \"math-intrinsics\"\n ]\n },\n \"get-proto@1.0.1\": {\n \"integrity\": \"sha512-sTSfBjoXBp89JvIKIefqw7U2CCebsc74kiY6awiGogKtoSGbgjYE/G/+l9sF3MWFPNc9IcoOC4ODfKHfxFmp0g==\",\n \"dependencies\": [\n \"dunder-proto\",\n \"es-object-atoms\"\n ]\n },\n \"gopd@1.2.0\": {\n \"integrity\": \"sha512-ZUKRh6/kUFoAiTAtTYPZJ3hw9wNxx+BIBOijnlG9PnrJsCcSjs1wyyD6vJpaYtgnzDrKYRSqf3OO6Rfa93xsRg==\"\n },\n \"has-symbols@1.1.0\": {\n \"integrity\": \"sha512-1cDNdwJ2Jaohmb3sg4OmKaMBwuC48sYni5HUw2DvsC8LjGTLK9h+eb1X6RyuOHe4hT0ULCW68iomhjUoKUqlPQ==\"\n },\n \"has-tostringtag@1.0.2\": {\n \"integrity\": \"sha512-NqADB8VjPFLM2V0VvHUewwwsw0ZWBaIdgo+ieHtK3hasLz4qeCRjYcqfB6AQrBggRKppKF8L52/VqdVsO47Dlw==\",\n \"dependencies\": [\n \"has-symbols\"\n ]\n },\n \"hasown@2.0.2\": {\n \"integrity\": \"sha512-0hJU9SCPvmMzIBdZFqNPXWa6dqh7WdH0cII9y+CyS8rG3nL48Bclra9HmKhVVUHyPWNH5Y7xDwAB7bfgSjkUMQ==\",\n \"dependencies\": [\n \"function-bind\"\n ]\n },\n \"hono@4.10.1\": {\n \"integrity\": \"sha512-rpGNOfacO4WEPClfkEt1yfl8cbu10uB1lNpiI33AKoiAHwOS8lV748JiLx4b5ozO/u4qLjIvfpFsPXdY5Qjkmg==\"\n },\n \"humanize-ms@1.2.1\": {\n \"integrity\": \"sha512-Fl70vYtsAFb/C06PTS9dZBo7ihau+Tu/DNCk/OyHhea07S+aeMWpFFkUaXRa8fI+ScZbEI8dfSxwY7gxZ9SAVQ==\",\n \"dependencies\": [\n \"ms\"\n ]\n },\n \"js-base64@3.7.8\": {\n \"integrity\": \"sha512-hNngCeKxIUQiEUN3GPJOkz4wF/YvdUdbNL9hsBcMQTkKzboD7T/q3OYOuuPZLUE6dBxSGpwhk5mwuDud7JVAow==\"\n },\n \"libsql@0.3.19\": {\n \"integrity\": \"sha512-Aj5cQ5uk/6fHdmeW0TiXK42FqUlwx7ytmMLPSaUQPin5HKKKuUPD62MAbN4OEweGBBI7q1BekoEN4gPUEL6MZA==\",\n \"dependencies\": [\n \"@neon-rs/load\",\n \"detect-libc\"\n ],\n \"optionalDependencies\": [\n \"@libsql/darwin-arm64\",\n \"@libsql/darwin-x64\",\n \"@libsql/linux-arm64-gnu\",\n \"@libsql/linux-arm64-musl\",\n \"@libsql/linux-x64-gnu\",\n \"@libsql/linux-x64-musl\",\n \"@libsql/win32-x64-msvc\"\n ],\n \"os\": [\"darwin\", \"linux\", \"win32\"],\n \"cpu\": [\"x64\", \"arm64\", \"wasm32\"]\n },\n \"math-intrinsics@1.1.0\": {\n \"integrity\": \"sha512-/IXtbwEk5HTPyEwyKX6hGkYXxM9nbj64B+ilVJnC/R6B0pH5G4V3b0pVbL7DBj4tkhBAppbQUlf6F6Xl9LHu1g==\"\n },\n \"mime-db@1.52.0\": {\n \"integrity\": \"sha512-sPU4uV7dYlvtWJxwwxHD0PuihVNiE7TyAbQ5SWxDCB9mUYvOgroQOwYQQOKPJ8CIbE+1ETVlOoK1UC2nU3gYvg==\"\n },\n \"mime-types@2.1.35\": {\n \"integrity\": \"sha512-ZDY+bPm5zTTF+YpCrAU9nK0UgICYPT0QtT1NZWFv4s++TNkcgVaT0g6+4R2uI4MjQjzysHB1zxuWL50hzaeXiw==\",\n \"dependencies\": [\n \"mime-db\"\n ]\n },\n \"ms@2.1.3\": {\n \"integrity\": \"sha512-6FlzubTLZG3J2a/NVCAleEhjzq5oxgHyaCU9yYXvcLsvoVaHJq/s5xXI6/XXP6tz7R9xAOtHnSO/tXtF3WRTlA==\"\n },\n \"node-domexception@1.0.0\": {\n \"integrity\": \"sha512-/jKZoMpw0F8GRwl4/eLROPA3cfcXtLApP0QzLmUT/HuPCZWyB7IY9ZrMeKw2O/nFIqPQB3PVM9aYm0F312AXDQ==\",\n \"deprecated\": true\n },\n \"node-fetch@2.7.0\": {\n \"integrity\": \"sha512-c4FRfUm/dbcWZ7U+1Wq0AwCyFL+3nt2bEw05wfxSz+DWpWsitgmSgYmy2dQdWyKC1694ELPqMs/YzUSNozLt8A==\",\n \"dependencies\": [\n \"whatwg-url\"\n ]\n },\n \"node-fetch@3.3.2\": {\n \"integrity\": \"sha512-dRB78srN/l6gqWulah9SrxeYnxeddIG30+GOqK/9OlLVyLg3HPnr6SqOWTWOXKRwC2eGYCkZ59NNuSgvSrpgOA==\",\n \"dependencies\": [\n \"data-uri-to-buffer\",\n \"fetch-blob\",\n \"formdata-polyfill\"\n ]\n },\n \"parse-ms@4.0.0\": {\n \"integrity\": \"sha512-TXfryirbmq34y8QBwgqCVLi+8oA3oWx2eAnSn62ITyEhEYaWRlVZ2DvMM9eZbMs/RfxPu/PK/aBLyGj4IrqMHw==\"\n },\n \"preact-render-to-string@6.6.2_preact@10.27.2\": {\n \"integrity\": \"sha512-VJ++Pkzv6+ZOmeN/9Qvx0mRdXqnei1Lo3uu9bGvYHhoMI1VUkDT44hcpGbiokl/kuuYTayYa3yvmYTLZMplfMA==\",\n \"dependencies\": [\n \"preact\"\n ]\n },\n \"preact@10.27.2\": {\n \"integrity\": \"sha512-5SYSgFKSyhCbk6SrXyMpqjb5+MQBgfvEKE/OC+PujcY34sOpqtr+0AZQtPYx5IA6VxynQ7rUPCtKzyovpj9Bpg==\"\n },\n \"pretty-ms@9.3.0\": {\n \"integrity\": \"sha512-gjVS5hOP+M3wMm5nmNOucbIrqudzs9v/57bWRHQWLYklXqoXKrVfYW2W9+glfGsqtPgpiz5WwyEEB+ksXIx3gQ==\",\n \"dependencies\": [\n \"parse-ms\"\n ]\n },\n \"tr46@0.0.3\": {\n \"integrity\": \"sha512-N3WMsuqV66lT30CrXNbEjx4GEwlow3v6rr4mCcv6prnfwhS01rkgyFdjPNBYd9br7LpXV1+Emh01fHnq2Gdgrw==\"\n },\n \"undici-types@5.26.5\": {\n \"integrity\": \"sha512-JlCMO+ehdEIKqlFxk6IfVoAUVmgz7cU7zD/h9XZ0qzeosSHmUJVOzSQvvYSYWXkFXC+IfLKSIffhv0sVZup6pA==\"\n },\n \"undici-types@7.10.0\": {\n \"integrity\": \"sha512-t5Fy/nfn+14LuOc2KNYg75vZqClpAiqscVvMygNnlsHBFpSXdJaYtXMcdNLpl/Qvc3P2cB3s6lOV51nqsFq4ag==\"\n },\n \"web-streams-polyfill@3.3.3\": {\n \"integrity\": \"sha512-d2JWLCivmZYTSIoge9MsgFCZrt571BikcWGYkjC1khllbTeDlGqZ2D8vD8E/lJa8WGWbb7Plm8/XJYV7IJHZZw==\"\n },\n \"web-streams-polyfill@4.0.0-beta.3\": {\n \"integrity\": \"sha512-QW95TCTaHmsYfHDybGMwO5IJIM93I/6vTRk+daHTWFPhwh+C8Cg7j7XyKrwrj8Ib6vYXe0ocYNrmzY4xAAN6ug==\"\n },\n \"webidl-conversions@3.0.1\": {\n \"integrity\": \"sha512-2JAn3z8AR6rjK8Sm8orRC0h/bcl/DqL7tRPdGZ4I1CjdF+EaMLmYxBHyXuKL849eucPFhvBoxMsflfOb8kxaeQ==\"\n },\n \"whatwg-url@5.0.0\": {\n \"integrity\": \"sha512-saE57nupxk6v3HY35+jzBwYa0rKSy0XR8JSxZPwgLr7ys0IBzhGviA1/TUGJLmSVqs8pb9AnvICXEuOHLprYTw==\",\n \"dependencies\": [\n \"tr46\",\n \"webidl-conversions\"\n ]\n },\n \"ws@8.18.3\": {\n \"integrity\": \"sha512-PEIGCY5tSlUt50cqyMXfCzX+oOPqN0vuGqWzbcJ2xvnkzkq46oOpz7dQaTDBdfICb4N14+GARUDw2XV2N4tvzg==\"\n },\n \"zod@4.1.12\": {\n \"integrity\": \"sha512-JInaHOamG8pt5+Ey8kGmdcAcg3OL9reK8ltczgHTAwNhMys/6ThXHityHxVV2p3fkw/c+MAvBHFVYHFZDmjMCQ==\"\n }\n },\n \"redirects\": {\n \"https://esm.sh/@json2csv/plainjs\": \"https://esm.sh/@json2csv/plainjs@7.0.6\",\n \"https://esm.sh/@types/react-dom@~18.2.25/client.d.ts\": \"https://esm.sh/@types/react-dom@18.2.25/client.d.ts\",\n \"https://esm.sh/@types/react@~18.2.79/index.d.ts\": \"https://esm.sh/@types/react@18.2.79/index.d.ts\",\n \"https://esm.sh/@types/react@~18.2.79/jsx-runtime.d.ts\": \"https://esm.sh/@types/react@18.2.79/jsx-runtime.d.ts\",\n \"https://esm.sh/preact/jsx-runtime\": \"https://esm.sh/preact@10.27.2/jsx-runtime\",\n \"https://esm.town/v/std/API_URL\": \"https://esm.town/v/std/API_URL?v=5\",\n \"https://esm.town/v/std/ValTownBlobError\": \"https://esm.town/v/std/ValTownBlobError?v=2\",\n \"https://esm.town/v/std/ValTownBlobNotFoundError\": \"https://esm.town/v/std/ValTownBlobNotFoundError?v=2\",\n \"https://esm.town/v/std/blob\": \"https://esm.town/v/std/blob?v=13\",\n \"https://esm.town/v/std/oauth/middleware.ts\": \"https://esm.town/v/std/oauth@172-main/middleware.ts\",\n \"https://esm.town/v/std/sqlite\": \"https://esm.town/v/std/sqlite?v=6\",\n \"https://esm.town/v/std/utils/index.ts\": \"https://esm.town/v/std/utils@196-main/index.ts\"\n },\n \"remote\": {\n \"https://esm.sh/@codemirror/lang-sql@6.5.4\": \"cab7d12aa08cd1c22ddc983d90e174229d36e62e57fdb441969b4ed66937dc94\",\n \"https://esm.sh/@codemirror/view@6.22.0\": \"564be27874b7c2b0a9b8834947f1b52b2bac0c23410136828adf8dcdb72f6b5e\",\n \"https://esm.sh/@json2csv/plainjs@7.0.6\": \"acc8af37aa8824688f818dbaae3d52730dc6c3582db6f0c93cd926448fb3caf7\",\n \"https://esm.sh/@uiw/react-codemirror@4.21.21?deps=react@18.2.0\": \"fa3bab229b11b67368ce613534db502ccb58131f1831ab7ee04d67b4512e35eb\",\n \"https://esm.sh/lucide-react@0.479.0/X-ZHJlYWN0QDE4LjIuMA/denonext/lucide-react.mjs\": \"7649775980650efc330224ae77e399916d407ae5f30204ee891ab1e316dd3a40\",\n \"https://esm.sh/lucide-react@0.479.0?deps=react@18.2.0\": \"a511cd32ce85e45105715be8e428e64462d2adf5d2d9b53d8ce305453053d540\",\n \"https://esm.sh/preact@10.27.2/jsx-runtime\": \"47eea90062ca8af935c0018026958ab025fea5ef1307ee07f73eff4386200167\",\n \"https://esm.sh/react-dom@18.2.0/client\": \"f43f7bb47905958ce487302ca818ba5a845a6029daa7ea22ef097a575b72045b\",\n \"https://esm.sh/react@18.2.0\": \"fed8aeb7d240bb42a2167c9c7c6e842e128c7630cbcb08c4d61c9c1926f89c75\",\n \"https://esm.sh/react@18.2.0/denonext/react.mjs\": \"a986c2876dc2f73879f395e677dc34cb751f260e69db16364810655f884df173\",\n \"https://esm.sh/react@18.2.0/jsx-runtime\": \"0bb3cca902d25a6827ac8153c8038b637e21bd20180bd58e827515d67de80582\",\n \"https://esm.sh/sql-query-identifier@2.7.0\": \"ed78d3f99b7714eea7febca3e9102ea7d76fcef36ba4cdd4de346483f3f867fd\",\n \"https://esm.town/v/std/API_URL?v=5\": \"46109f905a50e32281d3ffbe7b9c8209a778290c5274d83d131fba2d26c4974d\",\n \"https://esm.town/v/std/ValTownBlobError?v=2\": \"5f078bdb92be6111fc3e039a223d2e7c606eec737fb5ba664dc9d9931edfc04e\",\n \"https://esm.town/v/std/ValTownBlobNotFoundError?v=2\": \"0f4f41f3504a33fca793e83a73f2d12de8ca5acbcc397ad8e29510d32527a6ac\",\n \"https://esm.town/v/std/blob?v=13\": \"1ddf1e6a329b18d2109333ad589ebbeef86aa6957e51bf12df48f51180067bfd\",\n \"https://esm.town/v/std/oauth@172-main/crypto.ts\": \"97c603adf621881d00a55cf86d743b36c5913ae3b93584d41fecca1b4cee682e\",\n \"https://esm.town/v/std/oauth@172-main/middleware.ts\": \"936fccebd8e8cb6531c80ea609bab5a1d1ffc75f90ff28122371c74a5e9df6a3\",\n \"https://esm.town/v/std/oauth@172-main/oauth.ts\": \"f12ebe685d79eb2afba366121c7b529e0203e67ab4920809684cca1ade192b7b\",\n \"https://esm.town/v/std/oauth@172-main/session.ts\": \"89c0363087649d9586c0c59ce7d7c6b572f94663722aa4353f3a8b54a5b48f77\",\n \"https://esm.town/v/std/sqlite?v=6\": \"9b20a6ae261b6e3e15bd50cc5268bb4f0713f86f5ae4a525c97982c2162e1519\",\n \"https://esm.town/v/std/utils@105-main/parseImportMeta/project.ts\": \"1ebbe08847a68e921c988511b0ad1d0f18ead83d9b755503e6b4787d443bb2db\",\n \"https://esm.town/v/std/utils@196-main/file.ts\": \"ae1bba38dc3dd1111ac81bdad8a8d6672be2ee0a561991ec5927880ecfae31b1\",\n \"https://esm.town/v/std/utils@196-main/index.ts\": \"333d7454f47cc0dfa6996fd41c12076d3c604871c3c519b308947f3d619de1a5\",\n \"https://esm.town/v/std/utils@196-main/is-main.ts\": \"602b3f833e2a2d08f301b52dced89943f45ff422d5e904cd3608fa15f96a2fd8\",\n \"https://esm.town/v/std/utils@196-main/parseImportMeta.ts\": \"55f0e3e896ca0d950bc6ee27f8208b6c066707f6e030ec22ea360f12aa30fdac\",\n \"https://esm.town/v/std/utils@196-main/serve-file.ts\": \"cd7fd9b0c418b8a89ec2b0ac0fb0eb782321de2b13895c3825725b7b826b171a\",\n \"https://esm.town/v/std/utils@196-main/static.tsx\": \"274bec2ed7492b8bcfc5784f6b765550b7454517d6e20a55dce8dbfe5e53e376\",\n \"https://esm.town/v/std/utils@196-main/test.tsx\": \"996acd34c6b6b273043cbcb4822ac3a47d0650c78b22a25c3349a309cd94a79d\",\n \"https://esm.town/v/std/utils@85-main/file/index.ts\": \"f7b4d1f95fb1ef1cbcb3bc0d2fe83194f18403c7d35115a9f066cba4ef6b84d0\",\n \"https://esm.town/v/std/utils@85-main/index.ts\": \"3d060a58ccd352517da960077ffd78b80c1051ca2117cb37adbff0365cb45efb\",\n \"https://esm.town/v/std/utils@85-main/parseImportMeta/project.ts\": \"1a47e75e21faf22b38fb07e6ead284b6a381a48970a39490e585507a8bb47bbf\",\n \"https://esm.town/v/std/utils@85-main/serve-file/index.ts\": \"1386c1fe12e8e9a41e3561b0a1e55f332bc559fe98fa81f99434b4f642275cd4\",\n \"https://esm.town/v/std/utils@85-main/test/index.tsx\": \"41fc8ccb29945e8cf65263dc61a6840decf9f62fb035be8d0651267ac84b573d\"\n },\n \"workspace\": {\n \"dependencies\": [\n \"npm:@biomejs/biome@^2.3.5\"\n ]\n }\n}\n",[],[466],"files",[148,167,179,186,199,206,213,223,233,242,252,262,272,281,291,298,307,316,325,336,346,356,366,373,382,391,401,410,419,428,437,446,455,464],"counts",{"_477":32,"_478":331,"_479":32,"_480":481},"pulls","branches","forks","envVars",{"_482":32,"_483":32},"count","emptyCount","contents",[486,489,492,495,498,501,504,507,510,513,516,519],{"_102":149,"_95":150,"_151":152,"_153":-5,"_154":136,"_155":156,"_157":158,"_104":487,"_99":32,"_160":161,"_162":-5,"_163":22,"_164":-5,"_98":488},["D",1763167106586],[150],{"_102":180,"_95":181,"_151":182,"_153":-5,"_154":136,"_155":183,"_157":158,"_104":490,"_99":32,"_160":161,"_162":-5,"_163":22,"_164":-5,"_98":491},["D",1763167106681],[181],{"_102":200,"_95":201,"_151":202,"_153":-5,"_154":136,"_155":203,"_157":158,"_104":493,"_99":32,"_160":161,"_162":-5,"_163":22,"_164":-5,"_98":494},["D",1763167106504],[201],{"_102":367,"_95":368,"_151":369,"_153":-5,"_154":136,"_155":370,"_157":158,"_104":496,"_99":32,"_160":161,"_162":-5,"_163":22,"_164":-5,"_98":497},["D",1763167106768],[368],{"_102":402,"_95":403,"_151":404,"_153":-5,"_154":136,"_155":405,"_157":158,"_104":499,"_99":32,"_160":174,"_162":407,"_163":22,"_164":-5,"_98":500},["D",1763175061179],[403],{"_102":411,"_95":412,"_151":413,"_153":-5,"_154":136,"_155":414,"_157":158,"_104":502,"_99":32,"_160":174,"_162":416,"_163":22,"_164":-5,"_98":503},["D",1758731356226],[412],{"_102":420,"_95":421,"_151":422,"_153":-5,"_154":136,"_155":423,"_157":158,"_104":505,"_99":32,"_160":174,"_162":425,"_163":22,"_164":-5,"_98":506},["D",1763162902404],[421],{"_102":429,"_95":430,"_151":431,"_153":-5,"_154":136,"_155":432,"_157":158,"_104":508,"_99":331,"_160":174,"_162":434,"_163":22,"_164":-5,"_98":509},["D",1763177028838],[430],{"_102":438,"_95":439,"_151":440,"_153":-5,"_154":136,"_155":135,"_157":158,"_104":511,"_99":442,"_160":174,"_162":443,"_163":22,"_164":-5,"_98":512},["D",1763183364889],[439],{"_102":447,"_95":448,"_151":449,"_153":-5,"_154":136,"_155":450,"_157":158,"_104":514,"_99":258,"_160":174,"_162":452,"_163":22,"_164":-5,"_98":515},["D",1763178594507],[448],{"_102":456,"_95":457,"_151":458,"_153":-5,"_154":136,"_155":459,"_157":158,"_104":517,"_99":352,"_160":174,"_162":461,"_163":22,"_164":-5,"_98":518},["D",1763177175262],[457],{"_102":465,"_95":466,"_151":467,"_153":-5,"_154":136,"_155":468,"_157":158,"_104":520,"_99":331,"_160":174,"_162":470,"_163":22,"_164":-5,"_98":521},["D",1763178670272],[466],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.environment-variables",{"_93":94,"_95":96,"_100":530,"_480":535},{"_102":103,"_95":96,"_104":531,"_106":-5,"_107":22,"_108":109,"_110":-5,"_111":-5,"_14":112,"_113":-5,"_114":22,"_115":-5,"_116":32,"_16":117,"_118":119,"_120":119,"_121":122,"_123":122,"_124":122,"_125":119,"_126":119,"_23":532,"_130":533,"_133":534,"_145":22},["D",1758683685878],{"_93":94,"_128":129},{"_93":94,"_132":129,"_14":112},{"_99":135,"_95":43,"_102":136,"_137":103,"_138":-5,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":96,"_144":94},[],"actionData","errors"]

nbbaier

sqliteExplorerReact

Environment variables