[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_205":206,"_207":208},"routes/_app.x.$handle.$name",{"_116":115,"_34":63,"_124":102,"_29":125,"_13":14,"_126":-5,"_11":127,"_128":129,"_130":131,"_132":133,"_134":135,"_23":-5,"_136":137,"_138":139,"_140":27,"_141":142,"_143":75,"_144":-5,"_145":-5,"_146":147},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_61":62,"_34":63,"_40":64,"_65":-5,"_66":27,"_67":68,"_69":68,"_70":-5,"_71":-5,"_18":72,"_73":57,"_74":75,"_76":75,"_77":-5,"_78":79,"_80":81,"_82":-5,"_83":-5,"_84":-5,"_85":-5,"_86":87,"_88":87,"_89":90,"_91":90,"_92":90,"_93":87,"_94":87,"_95":96,"_97":98,"_99":100,"_101":27},"version",1,"changes",[19,20,21,22],"aiChatInfo","userId",{"_23":55,"_25":-7,"_26":27,"_28":27,"_29":56,"_31":56},{"_23":50,"_25":-7,"_26":27,"_28":27,"_29":51,"_31":51},{"_23":45,"_25":-7,"_26":27,"_28":27,"_29":46,"_31":46},{"_23":24,"_25":-7,"_26":27,"_28":27,"_29":30,"_31":30},"file",{"_32":33,"_34":35,"_36":37,"_38":39,"_40":41,"_42":14,"_43":44,"_26":27},"previous","deleted",false,"deletedHere","path","utils/sqliteExportHelpers.ts","latestPath","fileId","e1cd754e-7283-4f4d-a618-12d086d80d10","name","sqliteExportHelpers.ts","fileType","script","content","import { Statement } from \"https://esm.town/v/postpostscript/sqliteBuilder\";\nimport { ResultSet } from \"https://esm.town/v/std/sqlite?v=6\";\nimport { Parser } from \"npm:@json2csv/plainjs\";\n\nexport const sqlToJSON = (result: ResultSet) => {\n const { columns, rows } = result;\n\n return rows.map(row =>\n columns.reduce((obj, col, index) => {\n obj[col] = row[index];\n return obj;\n }, {})\n );\n};\n\nexport const sqlToCSV = (result: ResultSet) => {\n try {\n const { columns, rows } = result;\n const records = sqlToJSON(result);\n return new Parser({ fields: columns }).parse(records);\n } catch (error) {\n return error.message;\n }\n};","createdAt",["D",1749475270585],"branchVersion","branchId","9c002c8a-4534-11f0-833c-76b3cceeab13",{"_32":47,"_34":46,"_36":23,"_38":48,"_40":49,"_42":14,"_43":44,"_26":27},"README.md","b3c1959e-921b-4bd7-9d3b-1c392eac1288","# SQLite Explorer\n\nView and interact with your Val Town SQLite data. It's based off Steve's excellent [SQLite Admin](https://www.val.town/v/stevekrouse/sqlite_admin?v=46) val, adding the ability to run SQLite queries directly in the interface. This new version has a revised UI and that's heavily inspired by [LibSQL Studio](https://github.com/invisal/libsql-studio) by [invisal](https://github.com/invisal). This is now more an SPA, with tables, queries and results showing up on the same page. \n\n![image.webp](https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/c8e102fd-39ca-4bfb-372a-8d36daf43900/public)\n\n## Install \n\nInstall the latest stable version (v86) by forking this val:\n\n[![Install Stable Release (v86)](https://stevekrouse-button.web.val.run/Install%20Stable%20Release%20(v86))](https://www.val.town/v/nbbaier/sqlite_explorer/fork)\n\n## Authentication\n\nLogin to your SQLite Explorer with [password authentication](https://www.val.town/v/pomdtr/password_auth) with your [Val Town API Token](https://www.val.town/settings/api) as the password.\n\n## Todos / Plans\n- [ ] improve error handling \n- [ ] improve table formatting\n- [ ] sticky table headers\n- [x] add codemirror \n- [ ] add loading indication to the run button (initial version shipped)\n- [ ] add ability to favorite queries \n- [ ] add saving of last query run for a table (started)\n- [ ] add visible output for non-query statements\n- [ ] add schema viewing \n- [ ] add refresh to table list sidebar after `CREATE/DROP/ALTER` statements\n- [ ] add automatic execution of initial select query on double click \n- [x] add views to the sidebar \n- [ ] add triggers to sidebar\n- [ ] add upload from SQL, CSV and JSON\n- [ ] add ability to connect to a non-val town Turso database \n- [x] fix wonky sidebar separator height problem (thanks to @stevekrouse)\n- [x] make result tables scrollable\n- [x] add export to CSV, and JSON (CSV and JSON helper functions written in [this val](https://www.val.town/v/nbbaier/sqliteExportHelpers). Thanks to @pomdtr for merging the initial version!)\n- [x] add listener for cmd+enter to submit query\n\nMigrated from folder: projects/SqliteStudio/sqliteExplorerApp",["D",1749475270585],{"_32":52,"_34":51,"_36":53,"_38":-5,"_40":54,"_42":14,"_43":44,"_26":27},"utils","6fac64bd-6830-466d-b9dd-0740e8f7a86b","directory",["D",1749475270585],{"_32":57,"_34":56,"_36":58,"_38":59,"_40":60,"_42":14,"_43":44,"_26":27},"main.tsx","4a9bfcb1-9b33-44b6-9978-803b3238f079","http","/** @jsxImportSource npm:hono/jsx **/\n\nimport { modifyFetchHandler } from \"https://esm.town/v/andreterron/codeOnValTown?v=50\";\nimport { iframeHandler } from \"https://esm.town/v/nbbaier/iframeHandler\";\nimport { resetStyle } from \"https://esm.town/v/nbbaier/resetStyle\";\nimport { sqlToCSV, sqlToJSON } from \"https://esm.town/v/nbbaier/sqliteExplorerApp/utils/sqliteExportHelpers.ts\";\nimport {\n EditorSection,\n MockTable,\n Separator,\n Table,\n TablesList,\n} from \"https://esm.town/v/nbbaier/sqliteStudioComponents\";\nimport { sqliteStyle } from \"https://esm.town/v/nbbaier/sqliteStyle\";\nimport { passwordAuth } from \"https://esm.town/v/pomdtr/password_auth\";\nimport { verifyToken } from \"https://esm.town/v/pomdtr/verifyToken\";\nimport { ResultSet, sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { reloadOnSaveFetchMiddleware } from \"https://esm.town/v/stevekrouse/reloadOnSave\";\nimport { Hono } from \"npm:hono\";\nimport type { FC } from \"npm:hono/jsx\";\nimport { jsxRenderer } from \"npm:hono/jsx-renderer\";\nimport papa from \"npm:papaparse\";\n\nconst HTML: FC = ({ children }) => {\n return (\n \n \n SQLite Explorer\n \n\n \n \n \n \n\n \n \n \n \n \n

SQLite Explorer

\n {children}\n

Diff · v1