[Gerry]

For me, Embarcadero Rapid SQL is who MyEclipse Pro is up against. If you guys can match most of their features, I’ll recommend MyEclipse Pro just for the database browser/editor and I’m sure a lot of folks at my company will drop Rapid and buy ME Pro instead.

Anyway, requests for ME and/or ME Pro version, in priority order high is first:

1. Columns shows column type, size, null/not null in addition to column name (after, or in hover, or sublist – just something more than the name so we don’t have to open the DDL to figure out what it is!!!!

2. Opening table [+] in table list also shows sub-lists of constraints, PKs, FKs, UKs, Triggers (at least for Oracle, don’t know about other databases)

3. Button w/popup-dialog to select SQL syntax to paste into editor (should be easy to have XML file with keys as commands/functions and syntax as value). Dialog shows list of commands/functions (grouped probably) on left and preview of syntax on right. VERY helpful if you don’t do SQL all the time and need a quick reference or to past syntax to edit into proper statement.

4. Viewing/opening .SQL file goes to Database Explorer perspective automatically.

5. When generating ERDs, allow user to select items to remove from the diagram (and auto-layout automatically afterward), or to preselect only the items of interest. Haven’t tried the UML editor yet, but generating diagrams from ONLY selected files would be useful for quick-print while doing focused iterations.

6. Allow bookmarks/favorites in list of connection profiles or under connection profile that go straight to a table, view, or whatever and automatically connects for you if not connected. Should be able to add bookmark via right-click on object

Also, the syntax coloring in 4.1.1 (same in 4.1.0, too, I think) is buggy and inconsistent. I’ve even seen words partially syntax colored. Ick.

Anyway, I see a LOT of potential with this feature of ME/ME Pro that could be sold on it’s own merit! I hope you guys pay a lot of attention to the database features and improve it quickly, for your bottom line and our benefit![/img]

[Riyad Kalla]

I am sending all these requests to our DB team to have a look at and filter apart, thank you for taking the time to file them. We are dedicated to the DB tooling as we have seen a big ROI in the form of happy users for the time we have invested in it.

[Brian Fernandes]

Thanks again for taking the time to list your concerns.

1. Columns shows column type, size, null/not null in addition to column name (after, or in hover, or sublist – just something more than the name so we don’t have to open the DDL to figure out what it is!!!!

Most of this info is present in the Table Info view – part of the DB Explorer perspective. Have you seen that?

2. Opening table [+] in table list also shows sub-lists of constraints, PKs, FKs, UKs, Triggers (at least for Oracle, don’t know about other databases)

Good point, this is something we have started to think about recently.

3. Button w/popup-dialog to select SQL syntax to paste into editor (should be easy to have XML file with keys as commands/functions and syntax as value). Dialog shows list of commands/functions (grouped probably) on left and preview of syntax on right. VERY helpful if you don’t do SQL all the time and need a quick reference or to past syntax to edit into proper statement.

Interesting, are there any tools out there which do this already? I’d like to have a clearer picture of this feature.

4. Viewing/opening .SQL file goes to Database Explorer perspective automatically.

Noted, this might become a preference if we choose to do it.

5. When generating ERDs, allow user to select items to remove from the diagram (and auto-layout automatically afterward), or to preselect only the items of interest. Haven’t tried the UML editor yet, but generating diagrams from ONLY selected files would be useful for quick-print while doing focused iterations.

Selective diagram generation and refreshing for the ERD is coming in 5.0M1. If you could have a look at that when it’s released, we’d appreciate your feedback.

6. Allow bookmarks/favorites in list of connection profiles or under connection profile that go straight to a table, view, or whatever and automatically connects for you if not connected. Should be able to add bookmark via right-click on object

Good idea.

Also, the syntax coloring in 4.1.1 (same in 4.1.0, too, I think) is buggy and inconsistent. I’ve even seen words partially syntax colored. Ick.

Yes, we agree. The SQL editor will be improved in subsequent releases. Stay tuned 🙂

Best,
Brian.

[Gerry]

Brian,

I don’t see what you think I might be seeing on #1. Embarcadero Rapid SQL does #3. I’ll PM you some images of both.

[Dennis]

I’m not sure if this got filed as a bug… so, I’ll repeat it here just in case.

Along the lines of syntax highlighting. The text color, etc gets copied during a cut and paste to a new document (like MS Word). My preference would be that the text color and background always copy as black on white, and that bolding and other other highlights get dropped entirely. Seems to me that the destination program should determine the syntax highlighting, if any.

[Author]

Posts