New mentions of Val Town on Twitter:

${content}

`,\n });\n}",["D",1731086607746],"version",3,"currentUserHasLiked","referenceCount","dependencyCount","commentCount","prCount","mergedPr",{"_97":98,"_102":103},"forkedVal",{"_95":152,"_97":153,"_125":126,"_141":154,"_155":-5},"056ecf12-961e-11ef-8e68-de64eea55b61","stevekrouse",54,"prDisabledHint","description","Twitter 𝕏 keyword alerts Custom notifications for when you, your company, or anything you care about is mentioned on Twitter. This val gets Twitter data via SocialData via\n@stevekrouse/socialDataProxy. Val Town Pro users can call this API\n100 times per day, so be sure not to set this cron to run more than once every 15 min.\nIf you want to use it more, get your own SocialData \nAPI token and pay for it directly. 1. Query Change the query variable for what you want to get notified for. You can use Twitter's search operators to customize your query, for some collection of keywords, filtering out others, and much more! 2. Notification Below I'm sending these mentions to a public channel in our company Discord, but you can customize that to whatever you want, @std/email, Slack, Telegram, whatever.","latestEvaluation","slug","samwho/twitterAlert","versions",[163,167,170,174],{"_99":164,"_141":142,"_165":166},["D",1731086607746],"n","1",{"_99":168,"_141":91,"_165":169},["D",1731086561038],"2",{"_99":171,"_141":172,"_165":173},["D",1731086504828],1,"3",{"_99":175,"_141":32,"_165":176},["D",1731086367694],"4",{"_121":178,"_123":179},"c9a120ec-406f-11ef-a7fe-de64eea55b61",{"_125":180,"_127":96,"_121":178,"_128":-5,"_106":-5,"_129":130,"_131":181,"_133":182,"_135":183,"_137":26,"_95":183,"_138":184,"_99":185,"_141":142,"_143":26,"_108":32,"_144":32,"_145":186,"_146":32,"_110":32,"_147":32,"_148":-5,"_20":187,"_150":188,"_134":-7,"_156":192,"_158":-5,"_159":193,"_161":194},"sqliteExplorerApp","# 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.express.val.run/Install%20Stable%20Release%20(v81))](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","http","784e0aa4-479d-11ef-9124-de64eea55b61","/** @jsxImportSource https://esm.sh/hono@latest/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/sqliteExportHelpers\";\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