[{"_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":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":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","c46b5680-3483-4485-868c-b96d9abd47f4","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",1750180467045],"branchVersion","branchId","85d8c3c0-4b9e-11f0-88b9-76b3cceeab13",{"_32":45,"_34":46,"_35":47,"_36":48,"_38":49,"_40":14,"_41":42,"_26":27},"utils/sqliteExportHelpers.ts","9b8f15f2-af16-4e0c-8f30-5f278d0da481","sqliteExportHelpers.ts","script","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};",["D",1750180467045],{"_32":52,"_34":51,"_35":53,"_36":-5,"_38":54,"_40":14,"_41":42,"_26":27},"utils","59981135-2243-4735-8ff4-7406fe293e9f","directory",["D",1750180467045],{"_32":57,"_34":56,"_35":58,"_36":59,"_38":60,"_40":14,"_41":42,"_26":27},"main.tsx","3c759c25-9362-453e-8100-4ae6f4789962","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