Public
Readme
View and interact with your Val Town SQLite data. It's based off Steve's excellent SQLite Admin 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 by invisal. This is now more an SPA, with tables, queries and results showing up on the same page.
Install the latest stable version (v86) by forking this val:
Login to your SQLite Explorer with password authentication with your Val Town API Token as the password.
- improve error handling
- improve table formatting
- sticky table headers
- add codemirror
- add loading indication to the run button (initial version shipped)
- add ability to favorite queries
- add saving of last query run for a table (started)
- add visible output for non-query statements
- add schema viewing
- add refresh to table list sidebar after
CREATE/DROP/ALTERstatements - add automatic execution of initial select query on double click
- add views to the sidebar
- add triggers to sidebar
- add upload from SQL, CSV and JSON
- add ability to connect to a non-val town Turso database
- fix wonky sidebar separator height problem (thanks to @stevekrouse)
- make result tables scrollable
- add export to CSV, and JSON (CSV and JSON helper functions written in this val. Thanks to @pomdtr for merging the initial version!)
- add listener for cmd+enter to submit query
Val Town is a social website to write and deploy JavaScript.
Build APIs and schedule functions from your browser.
v87 was merged from the PR "Remove express link (prep for deprecation)" by stevekrouse
nbbaier-sqliteexplorerapp.web.val.run
Updated: October 2, 2024
Was doing some querying with this a few minutes ago and it started glitching, I believe due to active development. I wonder if version pinning + a beta top-level val could be used to allow for development while not breaking the main version
Thanks for the heads up! I didn't think of this. I just added some language to the readme to indicate what the current stable version is (v37). Let me know if that works!
Yes works like a charm! That's a smart way to handle it!
Nice! Now we just need a more official way to indicate that ...
Yea it would be cool to specify a default stable version that gets set when people import. In any case I've pinned my forked val to 37 so feel free to keep hacking
What a lovely convo! Maybe the first such productive back and forth I've seen on a val that I haven't been a part of ❤️
Export to CSV button would be so awesome. Ditto for import from CSV into new table.
Hey! Could I get a password for this app?
Hey @vawogbemi! The easiest way for you to use this is by forking this val: https://www.val.town/v/nbbaier/sqlite_explorer
ty!
an edit button for table entries would be cool, almost got it with townie, but it busted