[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_209":210,"_211":212},"routes/_app.x.$handle.$name",{"_119":118,"_34":63,"_127":105,"_29":128,"_13":14,"_129":-5,"_11":130,"_131":132,"_133":134,"_135":136,"_137":138,"_23":-5,"_139":140,"_141":142,"_143":27,"_144":145,"_146":75,"_147":-5,"_148":-5,"_149":150},"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":83,"_84":85,"_86":87,"_88":-5,"_89":90,"_91":90,"_92":93,"_94":93,"_95":93,"_96":90,"_97":90,"_98":99,"_100":101,"_102":103,"_104":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","f8b0f006-00b0-4bc5-85e1-2d8fa31b7ae7","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",1748965433162],"branchVersion","branchId","8d3594e4-4091-11f0-8cbd-76b3cceeab13",{"_32":47,"_34":46,"_36":23,"_38":48,"_40":49,"_42":14,"_43":44,"_26":27},"README.md","ecc7cb8a-0274-4604-a86c-19e742beabe8","# 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",1748965433162],{"_32":52,"_34":51,"_36":53,"_38":-5,"_40":54,"_42":14,"_43":44,"_26":27},"utils","b297def9-42c6-4750-8242-5b03c1c31729","directory",["D",1748965433162],{"_32":57,"_34":56,"_36":58,"_38":59,"_40":60,"_42":14,"_43":44,"_26":27},"main.tsx","994d03dd-fb85-48ee-a575-14f717bb99c9","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