Re: Collecting ideas for Workbench 5.1 - SQL IDE

[John Zastrow]

My preference is that you stay focused on the modeling aspects because, frankly I don't need another SQL editor right now. SQLyog, Toad, phpMyAdmin, Notepad++, etc. all work fine for me. But I don't have a good Modeling tool. But I know you will be replacing the current SQL editor, so OK.

My requests (on top of the excellent ones above):
* Database reporting tool to a document (HTML is OK, but prefer word proc also) that gives me customizability through a template of some kind to match our organization's document templates. Sounds trivial, but reformatting autogen'd docs take a lot of time. See SQLyog database reporting as starting point.

* Database structure diffing tools, that actually create good alter scripts and to be able to export them and/or step through running them individually.

* Top-notch autocompletion. Fast, tables, columns, aliases, all objects.

* Syntax coloring

* Something that would help me run and interpret EXPLAIN, along with something that would make it easy to compare the timings of two SQL scripts (and each execution part within them). That is, align analagous parts of two scripts, have the IDE run each, then allow me to compare the time taken for each part. These would help with optimization exercises.

* Design checker to look for stupid mistakes (these tables do not have primary keys. or, these tables have too many keys, consider revising).