\n \n\n\n","label",[167,67],"frontend","pulls","branches","forks","envVars",{"_175":26,"_177":26},"connections",{"_175":26,"_176":26},"count","unfilledCount","emptyCount",{"_32":461,"_13":460,"_65":455,"_42":-5,"_34":35,"_160":39,"_161":85,"_36":462,"_38":26,"_68":298,"_163":-5,"_69":24,"_165":-5,"_220":463,"_17":464},{"_32":452,"_13":453,"_65":454,"_42":455,"_34":35,"_160":39,"_161":85,"_36":456,"_38":26,"_68":21,"_163":457,"_69":24,"_165":-5,"_220":458,"_17":459},{"_32":448,"_13":440,"_65":435,"_42":-5,"_34":35,"_160":39,"_161":85,"_36":449,"_38":26,"_68":298,"_163":-5,"_69":24,"_165":-5,"_220":450,"_17":451},{"_32":441,"_13":442,"_65":83,"_42":435,"_34":35,"_160":39,"_161":85,"_36":443,"_38":26,"_68":444,"_163":445,"_69":24,"_165":-5,"_220":446,"_17":447},{"_32":432,"_13":433,"_65":434,"_42":435,"_34":35,"_160":39,"_161":85,"_36":436,"_38":26,"_68":277,"_163":437,"_69":24,"_165":-5,"_220":438,"_17":439},{"_32":428,"_13":167,"_65":159,"_42":-5,"_34":35,"_160":39,"_161":85,"_36":429,"_38":26,"_68":298,"_163":-5,"_69":24,"_165":-5,"_220":430,"_17":431},{"_32":424,"_13":367,"_65":362,"_42":159,"_34":35,"_160":39,"_161":85,"_36":425,"_38":26,"_68":298,"_163":-5,"_69":24,"_165":-5,"_220":426,"_17":427},{"_32":417,"_13":418,"_65":419,"_42":362,"_34":35,"_160":39,"_161":85,"_36":420,"_38":26,"_68":277,"_163":421,"_69":24,"_165":-5,"_220":422,"_17":423},{"_32":410,"_13":411,"_65":412,"_42":362,"_34":35,"_160":39,"_161":85,"_36":413,"_38":26,"_68":277,"_163":414,"_69":24,"_165":-5,"_220":415,"_17":416},{"_32":403,"_13":404,"_65":405,"_42":362,"_34":35,"_160":39,"_161":85,"_36":406,"_38":26,"_68":277,"_163":407,"_69":24,"_165":-5,"_220":408,"_17":409},{"_32":396,"_13":397,"_65":398,"_42":362,"_34":35,"_160":39,"_161":85,"_36":399,"_38":26,"_68":277,"_163":400,"_69":24,"_165":-5,"_220":401,"_17":402},{"_32":389,"_13":390,"_65":391,"_42":362,"_34":35,"_160":39,"_161":85,"_36":392,"_38":26,"_68":277,"_163":393,"_69":24,"_165":-5,"_220":394,"_17":395},{"_32":382,"_13":383,"_65":384,"_42":362,"_34":35,"_160":39,"_161":85,"_36":385,"_38":26,"_68":277,"_163":386,"_69":24,"_165":-5,"_220":387,"_17":388},{"_32":375,"_13":376,"_65":377,"_42":362,"_34":35,"_160":39,"_161":85,"_36":378,"_38":26,"_68":277,"_163":379,"_69":24,"_165":-5,"_220":380,"_17":381},{"_32":368,"_13":369,"_65":370,"_42":362,"_34":35,"_160":39,"_161":85,"_36":371,"_38":26,"_68":277,"_163":372,"_69":24,"_165":-5,"_220":373,"_17":374},{"_32":359,"_13":360,"_65":361,"_42":362,"_34":35,"_160":39,"_161":85,"_36":363,"_38":26,"_68":277,"_163":364,"_69":24,"_165":-5,"_220":365,"_17":366},{"_32":355,"_13":326,"_65":321,"_42":159,"_34":35,"_160":39,"_161":85,"_36":356,"_38":26,"_68":298,"_163":-5,"_69":24,"_165":-5,"_220":357,"_17":358},{"_32":348,"_13":349,"_65":350,"_42":321,"_34":35,"_160":39,"_161":85,"_36":351,"_38":26,"_68":277,"_163":352,"_69":24,"_165":-5,"_220":353,"_17":354},{"_32":341,"_13":342,"_65":343,"_42":321,"_34":35,"_160":39,"_161":85,"_36":344,"_38":26,"_68":277,"_163":345,"_69":24,"_165":-5,"_220":346,"_17":347},{"_32":334,"_13":335,"_65":336,"_42":321,"_34":35,"_160":39,"_161":85,"_36":337,"_38":26,"_68":277,"_163":338,"_69":24,"_165":-5,"_220":339,"_17":340},{"_32":327,"_13":328,"_65":329,"_42":321,"_34":35,"_160":39,"_161":85,"_36":330,"_38":26,"_68":277,"_163":331,"_69":24,"_165":-5,"_220":332,"_17":333},{"_32":318,"_13":319,"_65":320,"_42":321,"_34":35,"_160":39,"_161":85,"_36":322,"_38":26,"_68":277,"_163":323,"_69":24,"_165":-5,"_220":324,"_17":325},{"_32":311,"_13":312,"_65":313,"_42":159,"_34":35,"_160":39,"_161":85,"_36":314,"_38":26,"_68":277,"_163":315,"_69":24,"_165":-5,"_220":316,"_17":317},{"_32":158,"_13":67,"_65":66,"_42":159,"_34":35,"_160":39,"_161":85,"_36":308,"_38":26,"_68":21,"_163":164,"_69":24,"_165":-5,"_220":309,"_17":310},{"_32":301,"_13":302,"_65":303,"_42":159,"_34":35,"_160":39,"_161":85,"_36":304,"_38":26,"_68":277,"_163":305,"_69":24,"_165":-5,"_220":306,"_17":307},{"_32":296,"_13":281,"_65":275,"_42":-5,"_34":35,"_160":39,"_161":85,"_36":297,"_38":26,"_68":298,"_163":-5,"_69":24,"_165":-5,"_220":299,"_17":300},{"_32":289,"_13":290,"_65":291,"_42":275,"_34":35,"_160":39,"_161":85,"_36":292,"_38":26,"_68":277,"_163":293,"_69":24,"_165":-5,"_220":294,"_17":295},{"_32":282,"_13":283,"_65":284,"_42":275,"_34":35,"_160":39,"_161":85,"_36":285,"_38":26,"_68":277,"_163":286,"_69":24,"_165":-5,"_220":287,"_17":288},{"_32":272,"_13":273,"_65":274,"_42":275,"_34":35,"_160":39,"_161":85,"_36":276,"_38":26,"_68":277,"_163":278,"_69":24,"_165":-5,"_220":279,"_17":280},{"_32":265,"_13":266,"_65":267,"_42":-5,"_34":35,"_160":39,"_161":85,"_36":268,"_38":26,"_68":21,"_163":269,"_69":24,"_165":-5,"_220":270,"_17":271},{"_32":258,"_13":259,"_65":260,"_42":-5,"_34":35,"_160":39,"_161":85,"_36":261,"_38":26,"_68":21,"_163":262,"_69":24,"_165":-5,"_220":263,"_17":264},{"_32":251,"_13":252,"_65":253,"_42":-5,"_34":35,"_160":39,"_161":85,"_36":254,"_38":26,"_68":21,"_163":255,"_69":24,"_165":-5,"_220":256,"_17":257},{"_32":244,"_13":245,"_65":246,"_42":-5,"_34":35,"_160":111,"_161":85,"_36":247,"_38":39,"_68":21,"_163":248,"_69":24,"_165":-5,"_220":249,"_17":250},{"_32":237,"_13":238,"_65":239,"_42":-5,"_34":35,"_160":39,"_161":85,"_36":240,"_38":26,"_68":21,"_163":241,"_69":24,"_165":-5,"_220":242,"_17":243},{"_32":230,"_13":231,"_65":232,"_42":-5,"_34":35,"_160":39,"_161":85,"_36":233,"_38":26,"_68":21,"_163":234,"_69":24,"_165":-5,"_220":235,"_17":236},{"_32":223,"_13":224,"_65":225,"_42":-5,"_34":35,"_160":39,"_161":85,"_36":226,"_38":26,"_68":21,"_163":227,"_69":24,"_165":-5,"_220":228,"_17":229},{"_32":215,"_13":216,"_65":217,"_42":-5,"_34":35,"_160":39,"_161":85,"_36":218,"_38":26,"_68":21,"_163":219,"_69":24,"_165":-5,"_220":221,"_17":222},"0422ae62-10ca-11f1-9045-42dde27851f2","deno.lock","019c8b0e-c2d9-753f-9f6e-46cbfc5ed862",["D",1771859526231],"{\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 \"npm:zod@4.1.12\": \"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","children",[],[216],"0422a430-10ca-11f1-9045-42dde27851f2","deno.json","019c8b0e-c2d9-753f-9f6e-4158310b27ca",["D",1771859526231],"{\n \"$schema\": \"https://raw.githubusercontent.com/denoland/deno/348900b8b79f4a434cab4c74b3bc8d4d2fa8ee74/cli/schemas/config-file.v1.json\",\n \"compilerOptions\": {\n \"lib\": [\n \"dom\",\n \"dom.iterable\",\n \"dom.asynciterable\",\n \"deno.ns\",\n \"deno.unstable\"\n ],\n \"noImplicitAny\": true,\n \"strict\": true,\n \"types\": [\"https://www.val.town/types/valtown.d.ts\"]\n },\n \"experimental\": {\n \"unstable-node-globals\": true,\n \"unstable-sloppy-imports\": true,\n \"unstable-temporal\": true,\n \"unstable-worker-options\": true\n },\n \"imports\": {\n \"@biomejs/biome\": \"npm:@biomejs/biome@^2.3.5\"\n },\n \"lint\": {\n \"files\": {\n \"include\": [\"deno:/https/esm.town/**/*\"]\n },\n \"rules\": {\n \"exclude\": [\"no-explicit-any\", \"no-import-prefix\"]\n }\n },\n \"lock\": true,\n \"nodeModulesDir\": \"auto\"\n}\n",[],[224],"0422a00c-10ca-11f1-9045-42dde27851f2","biome.json","019c8b0e-c2d9-753f-9f6e-3e1c43341d7b",["D",1771859526231],"{\n \"$schema\": \"https://biomejs.dev/schemas/2.3.5/schema.json\",\n \"vcs\": { \"enabled\": true, \"clientKind\": \"git\", \"useIgnoreFile\": true },\n \"files\": { \"ignoreUnknown\": false },\n \"formatter\": { \"enabled\": true, \"indentStyle\": \"space\" },\n \"linter\": { \"enabled\": true, \"rules\": { \"recommended\": true } },\n \"javascript\": { \"formatter\": { \"quoteStyle\": \"double\" } },\n \"assist\": {\n \"enabled\": true,\n \"actions\": { \"source\": { \"organizeImports\": \"on\" } }\n }\n}\n",[],[231],"0422863a-10ca-11f1-9045-42dde27851f2","README.md","019c8b0e-c2d9-753f-9f6e-3bdd5be646db",["D",1771859526231],"# 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.",[],[238],"514b022a-10ca-11f1-ade7-42dde27851f2","MIGRATION_GUIDE.md","019c8b0e-c2d9-753f-9f6e-359d1caf4c72",["D",1771859655838],"# 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",[],[245],"0422219a-10ca-11f1-9045-42dde27851f2","AGENTS.md","019c8b0e-c2d9-753f-9f6e-33116bf5c105",["D",1771859526231],"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`",[],[252],"04221fb0-10ca-11f1-9045-42dde27851f2",".vtignore","019c8b0e-c2d9-753f-9f6e-2eac3b72c2d7",["D",1771859526231],".git\n.vscode\n.cursor\n.DS_Store\nnode_modules\nvendor",[],[259],"04221c18-10ca-11f1-9045-42dde27851f2",".gitignore","019c8b0e-c2d9-753f-9f6e-2acb98ada403",["D",1771859526231],"# 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",[],[266],"04220a84-10ca-11f1-9045-42dde27851f2","types.ts","019c8b0e-c2d9-753f-9f6e-2017a29071ef","019c8b0e-c2d9-753f-9f6e-26d192acf00b",["D",1771859526231],"script","// Shared TypeScript types for SQLite Explorer\n\nexport type SchemaItemType = \"table\" | \"view\";\n\nexport interface SchemaItem {\n name: string;\n type: 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 columns: string[];\n rows: SQLValue[][];\n rowsAffected?: number;\n}\n\nexport interface QueryResponse {\n success: boolean;\n data?: QueryResult;\n error?: string;\n}\n\nexport interface SchemaResponse {\n tables: SchemaItem[];\n views: SchemaItem[];\n}\n\nexport interface ParsedStatement {\n start: number;\n end: number;\n text: string;\n type: string;\n}\n\nexport interface CsvUploadRequest {\n tableName: string;\n columns: string[];\n rows: string[][];\n dropIfExists?: boolean;\n}\n\nexport interface CsvUploadResponse {\n success: boolean;\n tableName?: string;\n rowsInserted?: number;\n error?: string;\n}\n\n// Error type guard helper\nexport function isError(error: unknown): error is Error {\n return error instanceof Error;\n}\n\n// Safe error message extractor\nexport function getErrorMessage(error: unknown): string {\n if (isError(error)) {\n return error.message;\n }\n if (typeof error === \"string\") {\n return error;\n }\n return \"An unknown error occurred\";\n}\n",[],[281,273],"shared","0421fddc-10ca-11f1-9045-42dde27851f2","sqlHelpers.ts","019c8b0e-c2d9-753f-9f6e-1decf5fa7b20",["D",1771859526231],"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 return identify(code, {\n dialect: \"sqlite\",\n strict: false,\n });\n}\n\n/**\n * Select the SQL statement at a given cursor position\n */\nexport function selectStatementFromPosition(\n statements: ParsedStatement[],\n position: number,\n): ParsedStatement | undefined {\n for (const statement of statements) {\n if (statement.end + 1 >= position) {\n return statement;\n }\n }\n return 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 code: string,\n cursorPosition: number,\n): string {\n const statements = parseSQLStatements(code);\n const statement = selectStatementFromPosition(statements, cursorPosition);\n return statement?.text || \"\";\n}\n\n/**\n * Generate a default SELECT query for a table or view\n */\nexport function generateDefaultQuery(\n name: string,\n _type: \"table\" | \"view\",\n): string {\n return `SELECT * FROM ${name} LIMIT 100;`;\n}\n",[],[281,283],"0421f88c-10ca-11f1-9045-42dde27851f2","exportHelpers.ts","019c8b0e-c2d9-753f-9f6e-1ab6af488510",["D",1771859526231],"import { Parser } from \"https://esm.sh/@json2csv/plainjs\";\nimport type { QueryResult, SQLValue } from \"./types.ts\";\n\nexport const sqlToJSON = (result: QueryResult): Record[] => {\n const { columns, rows } = result;\n\n return rows.map((row) =>\n columns.reduce(\n (obj, col, index) => {\n obj[col] = row[index];\n return obj;\n },\n {} as Record,\n ),\n );\n};\n\nexport const sqlToCSV = (result: QueryResult): string => {\n const { columns } = result;\n const records = sqlToJSON(result);\n return new Parser({ fields: columns }).parse(records);\n};\n",[],[281,290],"04221aa6-10ca-11f1-9045-42dde27851f2",["D",1771859526231],"directory",[204,205,206],[281],"0421f260-10ca-11f1-9045-42dde27851f2","main.tsx","019c8b0e-c2d9-753f-9f6e-12eebe240859",["D",1771859526231],"/** @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 ReactDOM.createRoot(root).render(\n \n \n \n \n ,\n );\n} else {\n // Show error to user\n document.body.innerHTML =\n '

Failed to initialize application: Root element not found

';\n}\n",[],[167,302],["D",1771859526231],[],[167,67],"0421c74a-10ca-11f1-9045-42dde27851f2","App.tsx","019c8b0e-c2d9-753f-9f6e-085b1968f8da",["D",1771859526231],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n\nimport { useCallback, 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 { CsvUploadModal } from \"./components/CsvUploadModal.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 { useCsvUpload } from \"./hooks/useCsvUpload.ts\";\nimport { useDownload } from \"./hooks/useDownload.ts\";\nimport { useQueryExecution } from \"./hooks/useQueryExecution.ts\";\nimport { useTableSelection } from \"./hooks/useTableSelection.ts\";\n\nexport function App() {\n const [tables, setTables] = useState([]);\n const [selectedTable, setSelectedTable] = useState(null);\n const [isLoadingSchema, setIsLoadingSchema] = useState(true);\n const [isAuthenticated, setIsAuthenticated] = useState(true);\n const [isSidebarOpen, setIsSidebarOpen] = useState(true);\n const [currentPage, setCurrentPage] = useState(1);\n\n const { code, setCode, getActiveStatement, editorRef } = useCodeEditor();\n const { result, error, isLoading, executeQuery } = useQueryExecution();\n const { saveQuery } = useTableSelection(selectedTable, setCode);\n const { downloadQuery } = useDownload();\n const csvUpload = useCsvUpload();\n\n const loadSchema = useCallback(async () => {\n try {\n const response = await fetch(\"/api/schema\");\n if (response.status === 401) {\n setIsAuthenticated(false);\n return;\n }\n const data = await response.json();\n const allItems = [...data.tables, ...data.views];\n setTables(allItems);\n setIsAuthenticated(true);\n } catch (_err) {\n setTables([]);\n } finally {\n setIsLoadingSchema(false);\n }\n }, []);\n\n useEffect(() => {\n setCurrentPage(1);\n }, [result]);\n\n useEffect(() => {\n loadSchema();\n }, [loadSchema]);\n\n useEffect(() => {\n const handleResize = () => {\n if (window.innerWidth < 1024) {\n setIsSidebarOpen(false);\n } else {\n setIsSidebarOpen(true);\n }\n };\n handleResize();\n window.addEventListener(\"resize\", handleResize);\n return () => window.removeEventListener(\"resize\", handleResize);\n }, []);\n\n const handleRun = () => {\n const statement = getActiveStatement();\n if (statement) {\n executeQuery(statement);\n if (selectedTable) {\n saveQuery(selectedTable, statement);\n }\n }\n };\n\n const handleDownloadJSON = async () => {\n const statement = getActiveStatement();\n if (statement) {\n await downloadQuery(statement, \"json\");\n }\n };\n\n const handleDownloadCSV = async () => {\n const statement = getActiveStatement();\n if (statement) {\n await downloadQuery(statement, \"csv\");\n }\n };\n\n const handleCsvUpload = useCallback(\n async (params: {\n tableName: string;\n columns: string[];\n rows: string[][];\n dropIfExists: boolean;\n }) => {\n const result = await csvUpload.uploadCsv(params);\n if (result.success) {\n csvUpload.closeModal();\n await loadSchema();\n setSelectedTable(params.tableName);\n }\n return result;\n },\n [csvUpload, loadSchema],\n );\n\n if (!isAuthenticated) {\n return (\n

\n \n

\n Please log in to access the SQLite Explorer\n

\n \n Login with Val Town\n \n

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

\n setIsSidebarOpen((prev) => !prev)}\n actions={\n \n Logout\n \n }\n />\n

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

\n {isLoadingSchema ? (\n

\n Loading schema...\n

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

\n )}\n\n

\n \n

\n\n \n\n

\n {error && (\n

\n {error}\n

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

\n Run a query to see results here\n

\n )}\n

\n\n \n

\n );\n}\n",[],[167,312],"0421bfac-10ca-11f1-9045-42dde27851f2","useTableSelection.ts","019c8b0e-c2d9-753f-9f6e-039f97fc3f22","019c8b0e-c2d9-753f-9f6e-041567aec031",["D",1771859526231],"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 selectedTable: string | null,\n onCodeChange: (code: string) => void,\n) {\n useEffect(() => {\n if (!selectedTable) return;\n\n // Try to load saved query from localStorage\n const savedQuery = localStorage.getItem(`saved-${selectedTable}`);\n\n if (savedQuery) {\n onCodeChange(savedQuery);\n } else {\n // Generate default SELECT query\n const defaultQuery = generateDefaultQuery(selectedTable, \"table\");\n onCodeChange(defaultQuery);\n }\n }, [selectedTable, onCodeChange]);\n\n // Save query to localStorage when it changes\n const saveQuery = (tableName: string, query: string) => {\n const trimmed = query.trim().toUpperCase();\n if (tableName && trimmed && !trimmed.startsWith(\"DROP\")) {\n localStorage.setItem(`saved-${tableName}`, query);\n }\n };\n\n return { saveQuery };\n}\n",[],[167,326,319],"hooks","0421b714-10ca-11f1-9045-42dde27851f2","useQueryExecution.ts","019c8b0e-c2d9-753f-9f6d-fe7c9a46c2e8",["D",1771859526231],"import { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { QueryResult } from \"../../shared/types.ts\";\n\ninterface UseQueryExecutionResult {\n result: QueryResult | null;\n error: string | null;\n isLoading: boolean;\n executeQuery: (query: string) => Promise;\n clearResults: () => void;\n}\n\n/**\n * Custom hook for executing SQL queries\n */\nexport function useQueryExecution(): UseQueryExecutionResult {\n const [result, setResult] = useState(null);\n const [error, setError] = useState(null);\n const [isLoading, setIsLoading] = useState(false);\n\n const executeQuery = async (query: string) => {\n if (!query.trim()) {\n setError(\"Query cannot be empty\");\n return;\n }\n\n setIsLoading(true);\n setError(null);\n setResult(null);\n\n try {\n const response = await fetch(\"/api/query\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({ query }),\n });\n\n // Handle authentication errors\n if (response.status === 401) {\n window.location.href = \"/auth/login\";\n return;\n }\n\n const data = await response.json();\n\n if (data.success) {\n setResult(data.data);\n } else {\n setError(data.error || \"Query failed\");\n }\n } catch (err) {\n setError(err instanceof Error ? err.message : \"Unknown error occurred\");\n } finally {\n setIsLoading(false);\n }\n };\n\n const clearResults = () => {\n setResult(null);\n setError(null);\n };\n\n return {\n result,\n error,\n isLoading,\n executeQuery,\n clearResults,\n };\n}\n",[],[167,326,328],"0421af8a-10ca-11f1-9045-42dde27851f2","useDownload.ts","019c8b0e-c2d9-753f-9f6d-faaabe74681c",["D",1771859526231],"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 const downloadQuery = useCallback(\n async (query: string, format: DownloadFormat) => {\n if (!query.trim()) {\n throw new Error(\"Cannot download: query is empty\");\n }\n\n try {\n const encodedQuery = encodeURIComponent(query);\n const url = `/api/download/${format}?query=${encodedQuery}`;\n\n // Trigger download by creating a temporary link\n const link = document.createElement(\"a\");\n link.href = url;\n link.download = `results.${format}`;\n document.body.appendChild(link);\n link.click();\n document.body.removeChild(link);\n } catch (err) {\n // Re-throw with a formatted error message\n throw new Error(\n `Failed to download ${format}: ${getErrorMessage(err)}`,\n );\n }\n },\n [],\n );\n\n return { downloadQuery };\n}\n",[],[167,326,335],"04219e32-10ca-11f1-9045-42dde27851f2","useCsvUpload.ts","019c8b0e-c2d9-753f-9f6d-f74a854748ba",["D",1771859526231],"import { useCallback, useState } from \"https://esm.sh/react@18.2.0\";\nimport Papa from \"https://esm.sh/papaparse@5.4.1\";\nimport type { CsvUploadResponse } from \"../../shared/types.ts\";\n\ninterface ParsedCsv {\n columns: string[];\n rows: string[][];\n}\n\ninterface UseCsvUploadResult {\n isModalOpen: boolean;\n isUploading: boolean;\n uploadError: string | null;\n openModal: () => void;\n closeModal: () => void;\n parseFile: (file: File) => Promise;\n uploadCsv: (params: {\n tableName: string;\n columns: string[];\n rows: string[][];\n dropIfExists: boolean;\n }) => Promise;\n}\n\nexport function useCsvUpload(): UseCsvUploadResult {\n const [isModalOpen, setIsModalOpen] = useState(false);\n const [isUploading, setIsUploading] = useState(false);\n const [uploadError, setUploadError] = useState(null);\n\n const openModal = useCallback(() => {\n setUploadError(null);\n setIsModalOpen(true);\n }, []);\n\n const closeModal = useCallback(() => {\n setIsModalOpen(false);\n setUploadError(null);\n }, []);\n\n const parseFile = useCallback((file: File): Promise => {\n return new Promise((resolve, reject) => {\n Papa.parse(file, {\n header: false,\n skipEmptyLines: true,\n complete: (results: any) => {\n const allRows: string[][] = results.data;\n if (allRows.length === 0) {\n reject(new Error(\"CSV file is empty\"));\n return;\n }\n const columns = allRows[0].map(String);\n const rows = allRows.slice(1).map((row: any[]) => row.map(String));\n resolve({ columns, rows });\n },\n error: (err: any) => {\n reject(new Error(err.message || \"Failed to parse CSV\"));\n },\n });\n });\n }, []);\n\n const uploadCsv = useCallback(\n async (params: {\n tableName: string;\n columns: string[];\n rows: string[][];\n dropIfExists: boolean;\n }): Promise => {\n setIsUploading(true);\n setUploadError(null);\n\n try {\n const response = await fetch(\"/api/upload/csv\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({\n tableName: params.tableName,\n columns: params.columns,\n rows: params.rows,\n dropIfExists: params.dropIfExists,\n }),\n });\n\n if (response.status === 401) {\n window.location.href = \"/auth/login\";\n return { success: false, error: \"Unauthorized\" };\n }\n\n const data: CsvUploadResponse = await response.json();\n if (!data.success) {\n setUploadError(data.error || \"Upload failed\");\n }\n return data;\n } catch (err) {\n const message = err instanceof Error ? err.message : \"Upload failed\";\n setUploadError(message);\n return { success: false, error: message };\n } finally {\n setIsUploading(false);\n }\n },\n [],\n );\n\n return {\n isModalOpen,\n isUploading,\n uploadError,\n openModal,\n closeModal,\n parseFile,\n uploadCsv,\n };\n}\n",[],[167,326,342],"0421952c-10ca-11f1-9045-42dde27851f2","useCodeEditor.ts","019c8b0e-c2d9-753f-9f6d-f08492979640",["D",1771859526231],"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 code: string;\n setCode: (code: string) => void;\n getActiveStatement: () => string;\n editorRef: React.MutableRefObject;\n}\n\n/**\n * Custom hook for managing code editor state and extracting SQL statements\n */\nexport function useCodeEditor(): UseCodeEditorResult {\n const [code, setCode] = useState(\"\");\n const editorRef = useRef(null);\n\n /**\n * Get the SQL statement at the current cursor position\n * Falls back to entire code if cursor position can't be determined\n */\n const getActiveStatement = useCallback((): string => {\n if (!code.trim()) return \"\";\n\n try {\n // Try to get cursor position from CodeMirror editor\n const editor = editorRef.current;\n if (editor?.view?.state) {\n const cursorPosition = editor.view.state.selection.main.head;\n const statement = getStatementAtPosition(code, cursorPosition);\n return statement || code;\n }\n } catch (err) {\n console.error(\"Error getting cursor position:\", err);\n }\n\n // Fallback to entire code if cursor position unavailable\n return code;\n }, [code]);\n\n return {\n code,\n setCode,\n getActiveStatement,\n editorRef,\n };\n}\n",[],[167,326,349],"0421c60a-10ca-11f1-9045-42dde27851f2",["D",1771859526231],[195,196,197,198,199],[167,326],"04218596-10ca-11f1-9045-42dde27851f2","ThemeToggle.tsx","019c8b0e-c2d9-753f-9f6d-eb9b508616f9","019c8b0e-c2d9-753f-9f6d-eef1df60db24",["D",1771859526231],"/** @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 const [isDark, setIsDark] = useState(false);\n\n // Initialize theme from localStorage or system preference\n useEffect(() => {\n const stored = localStorage.getItem(\"theme\");\n const prefersDark = window.matchMedia(\n \"(prefers-color-scheme: dark)\",\n ).matches;\n const shouldBeDark = stored === \"dark\" || (!stored && prefersDark);\n\n setIsDark(shouldBeDark);\n document.documentElement.classList.toggle(\"dark\", shouldBeDark);\n }, []);\n\n const toggleTheme = () => {\n const newIsDark = !isDark;\n setIsDark(newIsDark);\n document.documentElement.classList.toggle(\"dark\", newIsDark);\n localStorage.setItem(\"theme\", newIsDark ? \"dark\" : \"light\");\n };\n\n return (\n \n {isDark ? (\n \n Dark mode\n \n \n ) : (\n \n Light mode\n \n \n )}\n \n );\n}\n",[],[167,367,360],"components","042173b2-10ca-11f1-9045-42dde27851f2","TablesList.tsx","019c8b0e-c2d9-753f-9f6d-e41d5fd974b7",["D",1771859526231],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n\nimport { useEffect, 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 tables: SchemaItem[];\n selectedTable: string | null;\n onTableSelect: (name: string) => void;\n}\n\nexport function TablesList({\n tables,\n selectedTable,\n onTableSelect,\n}: TablesListProps) {\n const [filter, setFilter] = useState(\"\");\n\n useEffect(() => {\n if (selectedTable) {\n document.getElementById(selectedTable)?.scrollIntoView({ block: \"nearest\", behavior: \"smooth\" });\n }\n }, [selectedTable]);\n\n const handleClick = (name: string) => {\n // Toggle selection: if already selected, deselect it\n if (selectedTable === name) {\n onTableSelect(\"\");\n } else {\n onTableSelect(name);\n }\n };\n\n // Filter tables based on the filter text\n const filteredTables = tables.filter((item) =>\n item.name.toLowerCase().includes(filter.toLowerCase()),\n );\n\n return (\n

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

\n \n

\n setFilter(e.target.value)}\n placeholder=\"Filter tables...\"\n className=\"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 />\n

\n {filter && (\n

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

\n )}\n

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

\n {filteredTables.map((item) => {\n const isSelected = selectedTable === item.name;\n\n return (\n handleClick(item.name)}\n className={`\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 isSelected\n ? \"bg-warm-100 dark:bg-warm-900/30 text-warm-800 dark:text-warm-300 shadow-sm\"\n : \"text-slate-700 dark:text-slate-300 hover:bg-sand-200 dark:hover:bg-slate-700\"\n }\n `}\n >\n \n {item.type === \"table\" ? : }\n \n {item.name}\n \n );\n })}\n

\n );\n}\n",[],[167,367,369],"0421669c-10ca-11f1-9045-42dde27851f2","Table.tsx","019c8b0e-c2d9-753f-9f6d-e1ab0260df9a",["D",1771859526231],"/** @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 headers: string[];\n rows: SQLValue[][];\n currentPage: number;\n}\n\nexport function Table({ headers, rows, currentPage }: TableProps) {\n // Calculate pagination\n const startIndex = (currentPage - 1) * PAGE_SIZE;\n const endIndex = startIndex + PAGE_SIZE;\n const paginatedRows = useMemo(\n () => rows.slice(startIndex, endIndex),\n [rows, startIndex, endIndex],\n );\n const createRows = (rows: SQLValue[][], headers: string[]) => {\n // Check if all rows are empty\n if (rows.every((subArray) => subArray.length === 0)) {\n const emptyRow = headers.map((header, index) => (\n \n {header}\n \n ));\n\n return {emptyRow};\n }\n\n return rows.map((row, rowIndex) => (\n \n {row.map((cell, cellIndex) => (\n \n {cell !== null && cell !== undefined ? (\n String(cell)\n ) : (\n \n null\n \n )}\n \n ))}\n \n ));\n };\n\n const tableRows = createRows(paginatedRows, headers);\n\n return (\n \n \n \n {headers.map((header, index) => (\n \n {header}\n \n ))}\n \n \n {tableRows}\n

\n );\n}\n",[],[167,367,376],"042157e2-10ca-11f1-9045-42dde27851f2","PaginationBar.tsx","019c8b0e-c2d9-753f-9f6d-dca4780a4941",["D",1771859526231],"/** @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 currentPage: number;\n result: QueryResult;\n setCurrentPage: (value: React.SetStateAction) => void;\n}\n\ninterface PageButtonProps {\n icon: React.ReactNode;\n onClick: () => void;\n disabled: boolean;\n}\n\nconst PageButton = ({ icon, onClick, disabled }: PageButtonProps) => (\n \n {icon}\n \n);\n\nexport function PaginationBar({\n currentPage,\n result,\n setCurrentPage,\n}: PaginationBarProps) {\n return (\n result &&\n result.rows.length > PAGE_SIZE && (\n

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

\n setCurrentPage(1)}\n disabled={currentPage === 1}\n icon={}\n />\n setCurrentPage((p) => Math.max(1, p - 1))}\n disabled={currentPage === 1}\n icon={}\n />\n \n Page {currentPage} / {Math.ceil(result.rows.length / PAGE_SIZE)}\n \n \n setCurrentPage((p) =>\n Math.min(Math.ceil(result.rows.length / PAGE_SIZE), p + 1),\n )\n }\n disabled={currentPage === Math.ceil(result.rows.length / PAGE_SIZE)}\n icon={}\n />\n \n setCurrentPage(Math.ceil(result.rows.length / PAGE_SIZE))\n }\n disabled={currentPage === Math.ceil(result.rows.length / PAGE_SIZE)}\n icon={}\n />\n

\n )\n );\n}\n",[],[167,367,383],"042151b6-10ca-11f1-9045-42dde27851f2","Icons.tsx","019c8b0e-c2d9-753f-9f6d-dbdef16ac904",["D",1771859526231],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport {\n ChevronLeft,\n ChevronRight,\n ChevronsLeft,\n ChevronsRight,\n Download,\n Eye,\n PanelsTopLeft,\n PanelTop,\n Play,\n Search,\n Table2,\n Upload,\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 UploadSVG = () => ;\nexport const SidebarSVG = ({\n isSidebarOpen,\n className = \"size-4\",\n}: {\n isSidebarOpen: boolean;\n className: string;\n}) => {\n return isSidebarOpen ? (\n \n ) : (\n \n );\n};\n",[],[167,367,390],"04214450-10ca-11f1-9045-42dde27851f2","ErrorBoundary.tsx","019c8b0e-c2d9-753f-9f6d-d4411a3a2959",["D",1771859526231],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n\nimport React from \"https://esm.sh/react@18.2.0\";\n\ninterface Props {\n children: React.ReactNode;\n fallback?: React.ReactNode;\n}\n\ninterface State {\n hasError: boolean;\n error: Error | null;\n}\n\nexport class ErrorBoundary extends React.Component {\n constructor(props: Props) {\n super(props);\n this.state = { hasError: false, error: null };\n }\n\n static getDerivedStateFromError(error: Error): State {\n return { hasError: true, error };\n }\n\n override componentDidCatch(error: Error, errorInfo: React.ErrorInfo): void {\n // In production, you could send to error tracking service\n // For now, errors are just stored in state and displayed\n void error;\n void errorInfo;\n }\n\n override render() {\n if (this.state.hasError) {\n if (this.props.fallback) {\n return this.props.fallback;\n }\n\n return (\n

\n Something went wrong\n

\n The application encountered an unexpected error. Please try\n refreshing the page.\n

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

\n Error Details\n

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

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

\n );\n }\n\n return this.props.children;\n }\n}\n",[],[167,367,397],"04212a4c-10ca-11f1-9045-42dde27851f2","EditorSection.tsx","019c8b0e-c2d9-753f-9f6d-d2cda60386ae",["D",1771859526231],"/** @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 type 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, UploadSVG } from \"./Icons.tsx\";\n\ninterface EditorSectionProps {\n code: string;\n onCodeChange: (code: string) => void;\n onRun: () => void;\n onDownloadJSON: () => void;\n onDownloadCSV: () => void;\n onUploadCSV?: () => void;\n isLoading: boolean;\n editorRef?: React.MutableRefObject;\n}\n\ninterface ControlButtonProps {\n icon: React.ReactNode;\n label: string;\n onClick: () => void;\n disabled?: boolean;\n}\n\nconst ControlButton = ({\n icon,\n label,\n onClick,\n disabled,\n}: ControlButtonProps) => (\n \n {icon}\n {label}\n \n);\n\nexport function EditorSection({\n code,\n onCodeChange,\n onRun,\n onDownloadJSON,\n onDownloadCSV,\n onUploadCSV,\n isLoading,\n editorRef,\n}: EditorSectionProps) {\n const handleChange = useCallback(\n (value: string) => {\n onCodeChange(value);\n },\n [onCodeChange],\n );\n\n // Handle Cmd+Enter keyboard shortcut\n useEffect(() => {\n const handleKeyDown = (event: KeyboardEvent) => {\n if ((event.metaKey || event.ctrlKey) && event.key === \"Enter\") {\n event.preventDefault();\n onRun();\n }\n };\n\n document.addEventListener(\"keydown\", handleKeyDown);\n return () => {\n document.removeEventListener(\"keydown\", handleKeyDown);\n };\n }, [onRun]);\n\n // Custom theme matching our warm neutral color scheme\n const theme = useMemo(() => {\n const isDark = document.documentElement.classList.contains(\"dark\");\n return EditorView.theme(\n {\n \"&\": {\n backgroundColor: isDark ? \"#1e293b\" : \"#ffffff\",\n color: isDark ? \"#e2e8f0\" : \"#334155\",\n height: \"100%\",\n },\n \".cm-scroller\": {\n overflow: \"auto\",\n height: \"100%\",\n },\n \".cm-content\": {\n caretColor: isDark ? \"#f5ca99\" : \"#d88a3f\",\n },\n \".cm-cursor, .cm-dropCursor\": {\n borderLeftColor: isDark ? \"#f5ca99\" : \"#d88a3f\",\n },\n \"&.cm-focused .cm-selectionBackground, .cm-selectionBackground, .cm-content ::selection\":\n {\n backgroundColor: isDark ? \"#334155\" : \"#f5f1ea\",\n },\n \".cm-activeLine\": {\n backgroundColor: isDark ? \"#334155\" : \"#fdfcfb\",\n },\n \".cm-gutters\": {\n backgroundColor: isDark ? \"#0f172a\" : \"#faf8f5\",\n color: isDark ? \"#64748b\" : \"#94a3b8\",\n border: \"none\",\n minHeight: \"100%\",\n },\n \".cm-activeLineGutter\": {\n backgroundColor: isDark ? \"#1e293b\" : \"#f5f1ea\",\n },\n },\n { dark: isDark },\n );\n }, []);\n\n const isDisabled = !code.trim() || isLoading;\n\n return (\n

\n \n

\n\n

\n }\n label=\"Run\"\n onClick={onRun}\n disabled={isDisabled}\n />\n }\n label=\"JSON\"\n onClick={onDownloadJSON}\n disabled={isDisabled}\n />\n }\n label=\"CSV\"\n onClick={onDownloadCSV}\n disabled={isDisabled}\n />\n\n {onUploadCSV && (\n }\n label=\"Upload CSV\"\n onClick={onUploadCSV}\n />\n )}\n\n {isLoading && (\n \n loading...\n \n )}\n

\n );\n}\n",[],[167,367,404],"0420fdf6-10ca-11f1-9045-42dde27851f2","CsvUploadModal.tsx","019c8b0e-c2d9-753f-9f6d-cf8c94a902ba",["D",1771859526231],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n\nimport { useCallback, useRef, useState } from \"https://esm.sh/react@18.2.0\";\n\ninterface CsvUploadModalProps {\n isOpen: boolean;\n isUploading: boolean;\n uploadError: string | null;\n onClose: () => void;\n onParseFile: (file: File) => Promise<{ columns: string[]; rows: string[][] }>;\n onUpload: (params: {\n tableName: string;\n columns: string[];\n rows: string[][];\n dropIfExists: boolean;\n }) => Promise<{ success: boolean }>;\n}\n\nconst PREVIEW_ROWS = 5;\n\nexport function CsvUploadModal({\n isOpen,\n isUploading,\n uploadError,\n onClose,\n onParseFile,\n onUpload,\n}: CsvUploadModalProps) {\n const fileInputRef = useRef(null);\n const [tableName, setTableName] = useState(\"\");\n const [dropIfExists, setDropIfExists] = useState(false);\n const [columns, setColumns] = useState([]);\n const [rows, setRows] = useState([]);\n const [parseError, setParseError] = useState(null);\n const [fileName, setFileName] = useState(null);\n\n const reset = useCallback(() => {\n setTableName(\"\");\n setDropIfExists(false);\n setColumns([]);\n setRows([]);\n setParseError(null);\n setFileName(null);\n if (fileInputRef.current) fileInputRef.current.value = \"\";\n }, []);\n\n const handleClose = useCallback(() => {\n reset();\n onClose();\n }, [onClose, reset]);\n\n const handleFileChange = useCallback(\n async (e: React.ChangeEvent) => {\n const file = e.target.files?.[0];\n if (!file) return;\n\n setParseError(null);\n setFileName(file.name);\n\n // Default table name from filename (strip extension, replace non-alphanumeric)\n const baseName = file.name.replace(/\\.csv$/i, \"\").replace(/[^a-zA-Z0-9_]/g, \"_\");\n setTableName(baseName);\n\n try {\n const parsed = await onParseFile(file);\n setColumns(parsed.columns);\n setRows(parsed.rows);\n } catch (err) {\n setParseError(err instanceof Error ? err.message : \"Failed to parse file\");\n setColumns([]);\n setRows([]);\n }\n },\n [onParseFile],\n );\n\n const handleUpload = useCallback(async () => {\n const result = await onUpload({ tableName, columns, rows, dropIfExists });\n if (result.success) {\n reset();\n }\n }, [tableName, columns, rows, dropIfExists, onUpload, reset]);\n\n if (!isOpen) return null;\n\n const hasData = columns.length > 0 && rows.length > 0;\n const previewRows = rows.slice(0, PREVIEW_ROWS);\n const canUpload = hasData && tableName.trim() && !isUploading;\n\n return (\n

\n {/* Backdrop */}\n {}}\n />\n\n {/* Modal */}\n

\n {/* Header */}\n

\n Upload CSV\n

\n \n \n \n

\n\n {/* Body */}\n

\n {/* File Input */}\n

\n \n CSV File\n \n \n

\n\n {/* Table Name */}\n {fileName && (\n

\n \n Table Name\n \n setTableName(e.target.value)}\n placeholder=\"my_table\"\n className=\"w-full px-3 py-2 rounded-lg border border-sand-300 dark:border-slate-600\n bg-white dark:bg-slate-900 text-slate-800 dark:text-slate-200\n text-sm font-mono\n focus:outline-none focus:ring-2 focus:ring-warm-500 dark:focus:ring-warm-400\n placeholder:text-sand-400 dark:placeholder:text-slate-500\"\n />\n

\n )}\n\n {/* Drop if exists */}\n {fileName && (\n \n setDropIfExists(e.target.checked)}\n className=\"rounded border-sand-300 dark:border-slate-600 text-warm-500 focus:ring-warm-500\"\n />\n Drop table if it already exists\n \n )}\n\n {/* Parse Error */}\n {parseError && (\n

\n {parseError}\n

\n )}\n\n {/* Preview */}\n {hasData && (\n

\n Preview ({rows.length} row{rows.length !== 1 ? \"s\" : \"\"}, {columns.length} column{columns.length !== 1 ? \"s\" : \"\"})\n

\n \n \n \n {columns.map((col, i) => (\n \n {col}\n \n ))}\n \n \n \n {previewRows.map((row, ri) => (\n \n {columns.map((_, ci) => (\n \n {row[ci] ?? \"\"}\n \n ))}\n \n ))}\n \n

\n {rows.length > PREVIEW_ROWS && (\n

\n ... and {rows.length - PREVIEW_ROWS} more row{rows.length - PREVIEW_ROWS !== 1 ? \"s\" : \"\"}\n

\n )}\n

\n )}\n\n {/* Upload Error */}\n {uploadError && (\n

\n {uploadError}\n

\n )}\n

\n\n {/* Footer */}\n

\n \n Cancel\n \n \n {isUploading ? \"Uploading...\" : \"Upload\"}\n \n

\n );\n}\n",[],[167,367,411],"0420f360-10ca-11f1-9045-42dde27851f2","AppHeader.tsx","019c8b0e-c2d9-753f-9f6d-ca59c36daed3",["D",1771859526231],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n\nimport type { ReactNode } from \"https://esm.sh/react@18.2.0\";\nimport { SidebarSVG } from \"./Icons.tsx\";\nimport { ThemeToggle } from \"./ThemeToggle.tsx\";\n\ninterface AppHeaderProps {\n showSidebarToggle?: boolean;\n isSidebarOpen?: boolean;\n onSidebarToggle?: () => void;\n containerWidthClass?: string;\n actions?: ReactNode;\n}\n\nexport function AppHeader({\n showSidebarToggle = false,\n isSidebarOpen = true,\n onSidebarToggle,\n containerWidthClass = \"max-w-full mx-auto\",\n actions,\n}: AppHeaderProps) {\n return (\n

\n \n

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

\n SQLite Explorer\n

\n \n {actions}\n

\n \n

\n );\n}\n",[],[167,367,418],"042193c4-10ca-11f1-9045-42dde27851f2",["D",1771859526231],[185,186,187,188,189,190,191,192,193],[167,367],"0421f74c-10ca-11f1-9045-42dde27851f2",["D",1771859526231],[184,194,200,201,202],[167],"0420d9c0-10ca-11f1-9045-42dde27851f2","sqlite.ts","019c8b0e-c2d9-753f-9f6d-c037d9a95af9","019c8b0e-c2d9-753f-9f6d-c64f1dfcf0de",["D",1771859526231],"import { API_URL } from \"https://esm.town/v/std/API_URL\";\nimport { LibsqlError, type TransactionMode } from \"npm:@libsql/client@0.6.0\";\nimport { z } from \"npm:zod@4.1.12\";\n\n/**\n * Every Val Town account comes with its own private\n * [SQLite database](https://www.sqlite.org/) that\n * is accessible from any of your vals.\n * ([Docs ↗](https://docs.val.town/std/sqlite))\n */\nexport const sqlite = {\n /**\n * Executes a SQLite statement.\n *\n * @param {InStatement} statement - The SQLite statement to execute.\n * @param {string} accessToken - the access token for the logged in user\n * @example String query:\n * `sqlite.execute(\"SELECT 1;\")`\n * @example Query with arguments:\n * `sqlite.execute({sql: \"SELECT * from books WHERE year > ?;\", args: [2020]})`\n */\n execute,\n\n /**\n * Executes a batch of SQLite statements.\n *\n * @param {InStatement[]} statements - An array of SQLite statements to execute.\n * @param {string} accessToken - the access token for the logged in user\n * @param {TransactionMode} [mode] - The transaction mode for the batch execution.\n */\n batch,\n};\n\n// ------------\n// Functions\n// ------------\n\nasync function execute(\n statement: InStatement,\n accessToken: string,\n): Promise {\n const res = await fetch(`${API_URL}/v1/sqlite/execute`, {\n method: \"POST\",\n headers: { Authorization: `Bearer ${accessToken}` },\n body: JSON.stringify({ statement }),\n });\n if (!res.ok) {\n throw createResError(await res.text());\n }\n return res.json();\n}\n\nasync function batch(\n statements: InStatement[],\n accessToken: string,\n mode?: TransactionMode,\n): Promise {\n const res = await fetch(`${API_URL}/v1/sqlite/batch`, {\n method: \"POST\",\n headers: { Authorization: `Bearer ${accessToken}` },\n body: JSON.stringify({ statements, mode }),\n });\n if (!res.ok) {\n throw createResError(await res.text());\n }\n return res.json();\n}\n\nfunction createResError(body: string) {\n try {\n const e = zLibsqlError.parse(JSON.parse(body));\n // e.message already contains the code, and LibsqlError adds the\n // code to the beginning, so we remove it here\n const msg = e.message.replace(e.code, \"\").replace(/^:\\s+/, \"\");\n return new LibsqlError(msg, e.code, e.rawCode);\n } catch (_) {\n // Failed to parse libsql error\n }\n return new Error(body);\n}\n\n// ------------\n// Helpers\n// ------------\n\nconst zLibsqlError = z.object({\n message: z.string(),\n code: z.string(),\n rawCode: z.number().optional(),\n});\n\n// We patch these types to only support JSON values\nexport type InValue = null | string | number | boolean;\nexport type InArgs = Array | Record;\nexport type InStatement =\n | {\n /**\n * The SQL statement to execute.\n */\n sql: string;\n\n /**\n * The arguments to bind to the SQL statement.\n */\n args: InArgs;\n }\n | string;\nexport interface ResultSet {\n /** Names of columns.\n *\n * Names of columns can be defined using the `AS` keyword in SQL:\n *\n * ```sql\n * SELECT author AS author, COUNT(*) AS count FROM books GROUP BY author\n * ```\n */\n columns: Array;\n\n /** Types of columns.\n *\n * The types are currently shown for types declared in a SQL table. For\n * column types of function calls, for example, an empty string is\n * returned.\n */\n columnTypes: Array;\n\n /** Rows produced by the statement. */\n rows: Array>;\n\n /** Number of rows that were affected by an UPDATE, INSERT or DELETE operation.\n *\n * This value is not specified for other SQL statements.\n */\n rowsAffected: number;\n\n /** ROWID of the last inserted row.\n *\n * This value is not specified if the SQL statement was not an INSERT or if the table was not a ROWID\n * table.\n */\n lastInsertRowid: bigint | undefined;\n}\n",[],[440,433],"backend","0420b2d8-10ca-11f1-9045-42dde27851f2","index.http.ts",["D",1771859526231],"http","import {\n getOAuthUserData,\n oauthMiddleware,\n} from \"https://esm.town/v/std/oauth/middleware.ts\";\nimport type { SessionData } from \"https://esm.town/v/std/oauth/session.ts\";\nimport {\n readFile,\n serveFile,\n} from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { Hono } from \"npm:hono@latest\";\nimport { sqlToCSV, sqlToJSON } from \"../shared/exportHelpers.ts\";\nimport type {\n CsvUploadRequest,\n CsvUploadResponse,\n QueryResponse,\n SchemaResponse,\n} from \"../shared/types.ts\";\nimport { getErrorMessage } from \"../shared/types.ts\";\nimport { sqlite } from \"./sqlite.ts\";\n\ntype Variables = { session: SessionData | null };\n\nconst app = new Hono<{ Variables: Variables }>();\n\napp.onError((err, _c) => {\n throw err;\n});\n\napp.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", (c) => serveFile(c.req.path, import.meta.url));\n\napp.use(\"/api/*\", async (c, next) => {\n const session = await getOAuthUserData(c.req.raw);\n\n if (!session) return c.json({ error: \"Unauthorized. Please log in.\" }, 401);\n c.set(\"session\", session);\n await next();\n});\n\n// API Routes\n\napp.get(\"/api/schema\", async (c) => {\n try {\n const session = c.get(\"session\");\n if (!session) return c.json({ error: \"Unauthorized. Please log in.\" }, 401);\n\n const data = await sqlite.batch(\n [\n `SELECT name FROM sqlite_schema WHERE type ='table' AND name NOT LIKE 'sqlite_%';`,\n `SELECT name FROM sqlite_schema WHERE type ='view' AND name NOT LIKE 'sqlite_%';`,\n ],\n session.accessToken,\n );\n\n const tables = data[0].rows.map((row) => ({\n name: row[0] as string,\n type: \"table\" as const,\n }));\n\n const views = data[1].rows.map((row) => ({\n name: row[0] as string,\n type: \"view\" as const,\n }));\n\n const response: SchemaResponse = { tables, views };\n return c.json(response);\n } catch (err) {\n console.error(\"Error getting schema\", err);\n return c.json({ error: getErrorMessage(err) }, 500);\n }\n});\n\napp.post(\"/api/query\", async (c) => {\n try {\n const session = c.get(\"session\");\n if (!session) return c.json({ error: \"Unauthorized. Please log in.\" }, 401);\n\n const body = await c.req.json();\n const query = body.query as string;\n\n if (!query || !query.trim()) {\n return c.json({ success: false, error: \"Query is required\" }, 400);\n }\n\n const result = await sqlite.execute(query, session.accessToken);\n\n const response: QueryResponse = {\n success: true,\n data: {\n columns: result.columns,\n rows: result.rows,\n },\n };\n\n return c.json(response);\n } catch (err) {\n return c.json({\n success: false,\n error: getErrorMessage(err),\n });\n }\n});\n\napp.post(\"/api/upload/csv\", async (c) => {\n try {\n const session = c.get(\"session\");\n if (!session) return c.json({ error: \"Unauthorized. Please log in.\" }, 401);\n\n const body: CsvUploadRequest = await c.req.json();\n const { tableName, columns, rows, dropIfExists } = body;\n\n // Validate table name: alphanumeric and underscores only\n if (!tableName || !/^[a-zA-Z_][a-zA-Z0-9_]*$/.test(tableName)) {\n return c.json({\n success: false,\n error:\n \"Invalid table name. Use only letters, numbers, and underscores (must start with a letter or underscore).\",\n }, 400);\n }\n\n if (!columns || columns.length === 0) {\n return c.json({\n success: false,\n error: \"CSV must have at least one column.\",\n }, 400);\n }\n\n // Sanitize column names: replace non-alphanumeric chars with underscores\n const sanitizedColumns = columns.map((col) => {\n const sanitized = col.replace(/[^a-zA-Z0-9_]/g, \"_\").replace(/^(\\d)/, \"_$1\");\n return sanitized || \"_col\";\n });\n\n const statements: string[] = [];\n\n if (dropIfExists) {\n statements.push(`DROP TABLE IF EXISTS \"${tableName}\"`);\n }\n\n const columnDefs = sanitizedColumns.map((col) => `\"${col}\" TEXT`).join(\", \");\n statements.push(`CREATE TABLE \"${tableName}\" (${columnDefs})`);\n\n // Insert rows in chunks of 50\n const CHUNK_SIZE = 50;\n for (let i = 0; i < rows.length; i += CHUNK_SIZE) {\n const chunk = rows.slice(i, i + CHUNK_SIZE);\n for (const row of chunk) {\n const placeholders = sanitizedColumns.map(() => \"?\").join(\", \");\n const values = sanitizedColumns.map((_, idx) => row[idx] ?? null);\n statements.push({\n sql: `INSERT INTO \"${tableName}\" (${sanitizedColumns.map((c) => `\"${c}\"`).join(\", \")}) VALUES (${placeholders})`,\n args: values,\n } as any);\n }\n }\n\n await sqlite.batch(statements as any[], session.accessToken, \"deferred\");\n\n const response: CsvUploadResponse = {\n success: true,\n tableName,\n rowsInserted: rows.length,\n };\n return c.json(response);\n } catch (err) {\n return c.json({\n success: false,\n error: getErrorMessage(err),\n }, 500);\n }\n});\n\napp.get(\"/api/download/csv\", async (c) => {\n try {\n const session = c.get(\"session\");\n if (!session) return c.json({ error: \"Unauthorized. Please log in.\" }, 401);\n\n const query = c.req.query(\"query\");\n\n if (!query) {\n return c.text(\"Query parameter is required\", 400);\n }\n\n const result = await sqlite.execute(query, session.accessToken);\n const csv = sqlToCSV({ columns: result.columns, rows: result.rows });\n\n return new Response(csv, {\n headers: {\n \"Content-Type\": \"text/csv\",\n \"Content-Disposition\": 'attachment; filename=\"results.csv\"',\n },\n });\n } catch (err) {\n return c.text(`Failed to download CSV: ${getErrorMessage(err)}`, 500);\n }\n});\n\napp.get(\"/api/download/json\", async (c) => {\n try {\n const session = c.get(\"session\");\n if (!session) return c.json({ error: \"Unauthorized. Please log in.\" }, 401);\n\n const query = c.req.query(\"query\");\n if (!query) return c.text(\"Query parameter is required\", 400);\n\n const result = await sqlite.execute(query, session.accessToken);\n const jsonData = sqlToJSON({\n columns: result.columns,\n rows: result.rows,\n });\n\n return Response.json(jsonData, {\n headers: {\n \"Content-Disposition\": 'attachment; filename=\"results.json\"',\n },\n });\n } catch (err) {\n return c.text(`Failed to download JSON: ${getErrorMessage(err)}`, 500);\n }\n});\n\napp.get(\"/\", async (c) => {\n try {\n const html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n } catch (err) {\n return c.text(`Error loading application: ${getErrorMessage(err)}`, 500);\n }\n});\n\nexport default oauthMiddleware({\n scopes: [\"openid\", \"offline_access\", \"profile\", \"user_rw\", \"sqlite_rw\"],\n}, app.fetch);",[],[440,442],"0420f1b2-10ca-11f1-9045-42dde27851f2",["D",1771859526231],[181,182],[440],"04208cc2-10ca-11f1-9045-42dde27851f2","settings.local.json","019c8b0e-c2d5-744f-aeb1-2c52f4cb6eb7","019c8b0e-c2d9-753f-9f6d-bbf24fe75fc7",["D",1771859526231],"{\n \"permissions\": {\n \"allow\": [\n \"Bash(cat:*)\",\n \"mcp__val-town__get_val_detail\",\n \"mcp__val-town__list_files\",\n \"Bash(deno check:*)\",\n \"Bash(tree:*)\",\n \"Bash(find:*)\",\n \"Bash(git add:*)\",\n \"Bash(git commit -m \\\"$(cat <<''EOF''\\nImplement critical fixes and cleanup legacy code\\n\\nCritical Improvements:\\n- Add React Error Boundary for graceful error handling\\n- Implement pagination (100 rows/page) to prevent browser freeze\\n- Enable TypeScript strict mode (noImplicitAny, strict, lock)\\n- Remove all ''any'' types, add SQLValue type for type safety\\n- Add error type guards (isError, getErrorMessage)\\n- Remove all production console.log statements\\n- Fix Hono context typing with proper UserData types\\n\\nType Safety Enhancements:\\n- Replace any[][] with SQLValue[][] throughout\\n- Add type guards for safe error handling\\n- Properly type all React hooks and components\\n- Add ''override'' modifiers for class methods\\n- Zero type errors with strict mode enabled\\n\\nPerformance & UX:\\n- Paginated table with First/Previous/Next/Last controls\\n- Shows \\\"X to Y of Z rows\\\" indicator\\n- Only displays pagination when needed (>100 rows)\\n- Better error propagation in download handlers\\n\\nCode Cleanup:\\n- Remove 3 legacy directories (scripts/, sqliteExplorerApp/, sqliteExplorerApp_DEV/)\\n- Delete 11 legacy files (HTMX scripts, duplicate CSS, old helpers)\\n- Remove .DS_Store files\\n- Clean up duplicate export helpers\\n\\nDocumentation:\\n- Add comprehensive README.md with setup, API docs, architecture\\n- Include installation, deployment, and troubleshooting guides\\n- Document project structure and development workflow\\n\\nStats: -1046 lines of legacy code, +160 lines of improvements\\nType checks: ✓ backend ✓ frontend ✓ shared\\n\\n🤖 Generated with [Claude Code](https://claude.com/claude-code)\\n\\nCo-Authored-By: Claude \\nEOF\\n)\\\")\"\n ],\n \"deny\": [],\n \"ask\": []\n }\n}\n",[],[460,453],".claude","0420aa90-10ca-11f1-9045-42dde27851f2",["D",1771859526231],[179],[460],["D",1771859526231],["D",1789620046593],{"_11":12,"_126":72},{"_11":12,"_122":-5,"_71":72,"_30":70,"_123":124,"_125":24},{"_38":111,"_13":16,"_32":35,"_112":74,"_113":62,"_114":63,"_115":78,"_116":117,"_118":119,"_120":14,"_121":12},"ctx",{"_51":-5,"_147":503,"_504":505,"_506":507,"_508":24,"_509":24,"_510":24,"_511":85,"_512":-5,"_513":-7,"_514":-7,"_515":26,"_516":24,"_517":24,"_518":-5,"_519":24,"_520":24,"_521":24,"_522":-5},"ENV",{"_474":475,"_476":477,"_478":16,"_479":480,"_481":482,"_483":484,"_485":486,"_487":488,"_489":490,"_491":492,"_493":494,"_495":496,"_497":498,"_499":500,"_501":502},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","a3e067d4463eea85f6334f8e583e8516ae58c4f6","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

History · index.html