Val Town is a collaborative website to build and scale JavaScript apps.
Deploy APIs, crons, & store data – all from the browser, and deployed in milliseconds.
main.tsx
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 (v37) by forking this val that imports & exports it in your account:
SQLite Explorer basic authentication with your Val Town API Token as the password (leave the username field blank).
- fix wonky sidebar separator height problem
- improve error handling
- improve table formatting
- make result tables scrollable
- 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 export to CSV, and JSON (CSV and JSON helper functions written in this val)
- add export to sqlite
- add refresh to table list sidebar after
CREATE/DROP/ALTERstatements - add automatic execution of initial select query on double click
- add listener for cmd+enter to submit query
- add views to the sidebar