Skip to content

Latest commit

 

History

History
55 lines (50 loc) · 2.37 KB

TODO.md

File metadata and controls

55 lines (50 loc) · 2.37 KB
Raw

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?