[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_206":207,"_208":209},"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,"_38":64,"_65":-5,"_66":27,"_67":68,"_69":68,"_70":-5,"_71":-5,"_18":72,"_73":45,"_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":56,"_25":-7,"_26":27,"_28":27,"_29":57,"_31":57},{"_23":49,"_25":-7,"_26":27,"_28":27,"_29":50,"_31":50},{"_23":43,"_25":-7,"_26":27,"_28":27,"_29":44,"_31":44},{"_23":24,"_25":-7,"_26":27,"_28":27,"_29":30,"_31":30},"file",{"_32":33,"_34":30,"_35":23,"_36":37,"_38":39,"_40":14,"_41":42,"_26":27},"previous","deleted",false,"deletedHere","path","README.md","latestPath","fileId","ba062218-0552-4374-862a-66f12898d4ac","name","fileType","content","# 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","createdAt",["D",1751549087262],"branchVersion","branchId","1710691e-5811-11f0-8007-f69ea79377d9",{"_32":45,"_34":44,"_35":46,"_36":47,"_38":48,"_40":14,"_41":42,"_26":27},"main.tsx","a7f4366d-12ca-456e-b063-864db561c04e","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