Summary of issues for M3

[kjk]

Must have:

• [ ] perf improvements for large results #95
• [ ] progress on redesign #96
• [ ] "Hide SQL Preview" messes things up
• [ ] apparently we don't work if password contains '?' in it

Nice to have:

• [ ] frontend: don't clear query when going to "Structure" and back
• [ ] sqlite support #94
• [ ] switch to CodeMirror
• [ ] on the feedback page allow anonymous feedback, in addition to sending e-mail (a form with submit button)
• [ ] switching between query and structure shows old data until new data arrives. we should clear the results
• [ ] option for verbose logging of the backend. Use mostly LogVerbosef(), add option to enable verbose logging, add a way to turn it on in the desktop app (and remember). This would be useful for debugging people's issues
• [ ] on connect make sure to start on query page

Done:

• [x] fix history for async queries
• [x] mouse cursor over table header columns should be a hand to hint that they are clickable
• [x] speed up connecting by getting info about all tables in one call
• [x] add "allowOldPasswords=true" to mysql connection string to hopefully fix https://dbhero.freshdesk.com/helpdesk/tickets/14. Alternatively do like in pg by trying both with and without
• [x] ESC in "Filter Results" field should clear it
• [x] for release builds, compile and minify react in production mode (https://www.npmjs.com/package/react)
• [x] "Filter results" is not re-positioned when resizing edit field (shouldn't part of Table?)
• [x] change where DragBarHoriz is in the hierarchy
• [x] api.js shouldn't swallow exceptions from callbacks
• [x] "Connection Info" and "Activity" are broken
• [x] setup publicly available test databases for first timers to try out
• [x] mac, win: add more prominent "feedback" button directly in the app UI. We already have menus for that but I think most people don't see them. We should also have a tooltip on that button that encourages feedback "We would love to year your comments and ideas".
• [x] make feedback button launch a website
• [x] frontend: fix update #98
• [x] mac: fix or remove zoom in/out. It doesn't work the way I expected
• [x] mac: sometimes the upgrade notification doesn't display correctly
• [x] win: switch to Chrome
• [x] website: in usage stats, show number of mac vs windows users, show os and latest version used

[thellimist]

In my opinion sqlite is useless. We should focus on things that would actually kill us. For our product there are a few I can see.

• Performance improvement
• Marketting
• Double click to edit rows

[kjk]

sqlite is the most popular database in the world. https://github.com/sqlitebrowser/sqlitebrowser has 2927 stars. "sqlite gui client" returns more results than "postgres gui client" and close to "mysql gui client". There is demand for that.