MySQL Forums
Forum List  »  MySQL Workbench

Re: Collecting ideas for Workbench 5.1 - SQL IDE
Posted by: John Zastrow
Date: April 07, 2008 09:35AM

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).

Options: ReplyQuote

Written By
Re: Collecting ideas for Workbench 5.1 - SQL IDE
April 07, 2008 09:35AM
February 06, 2009 07:30AM
March 12, 2009 01:38AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.