TODO.md

TODO

Done

• add toggle for admins in /users
• can't unadmin one's self (prevents last-admin-standing scenario)
• only show/permit admin links for admins
• CLI tooling (db folder, admin, encryption phrase, port)
• temp csv cache file for downloads
• upgrade to express 4.0 to get rid of annoying messages
• save menu button works
• SQL Editor: refresh schema on connection change
• SQL Editor: prompt to choose a connection if one hasn't been chosen
• default db location should be user's HOME directory/sqlpad.
• --dev flag for console.logging
• add datatypes to schema info
• add initial visualizations
• make routes separate js files (broken up by related chunks)
• clean up various dates being displayed to appropriate values
• viz pane/ui hidden away until needed
• clean up and organize front end js (started browserifying things)
• update notifications like nodemon
• about/thank-you page
• viz selections saved with query
• viz ui updates with new query results (fields may have changed)
• only render viz if all req fields are provided
• clean up console.loggings
• SQL Editor: download filename uses query name
• cleanup css for query page
• decide last accessed date stuff (hidden for now)
• Change BASE TABLES to just TABLES
• Remove test connection logging
• Only schema in db info
• all delete buttons should have confirmations
• user/connection sorting (sane default only)
• smart column width in query results (max(value length) or max(column name length)) but no more than some amount (400px)
• vis types - they should probably have an ID and a label, for when things get complicated (multiple bar charts?)

Before considered 1.x.x

• github pages on what/how/why

Later or never

• public mode: anyone can view/run existing queries
• public mode: anyone can view/edit/run queries (but not save)
• public mode: anyone can view/edit/run/save queries
• fun mode (for fun)
• upload zip of .sql files
• connection: window colors (for dif. environments)
• connection: prepend arbitrary SQL (TRANS ISOLATION LEVEL, etc)
• connection: prefer SSL (for postgres --> heroku)
• SQL Editor: Excel file download
• multiple bar charts
• Get rid of tags?
• Loading animation?