flyspeed looks great but any chance of adding these interface features?

Planned

Comments

3 comments

  • Hello, D.

    Thank you very much for your suggestions.

    We have just added the suggestions 1-3 to our to-do list, as they seem to be useful and relatively easy to implement. 

    The fourth suggestion is not clear: "In the structure tree pane allow us to right-click and add/change things to the structure right there, not just in the diagram canvas." -- What exactly you want to be able to do there?

    6. We are saving the query with the layout but in a different format.

    7. Preservation of comments is present in our to-do list since the very beginning. Hopefully, we'll be able to do this till the end of this year.

    0
    Comment actions Permalink
  • Avatar
    D Rosen

    Sounds great -- thanks for your quick response.

    For #4, I suggest running Sqleo to see what you can do in a context menu in their structure tree.  For example right-click on "FIELDS" (which Sqleo calls "SELECT" because they are reproducing the query in that tree as in my #5) and you can "add expression" or even "add subquery" as an additional field to the field list.  Right-click on an individual field and you can "add to group-by", "add to order-by", "edit..." (change its alias or the text if it is an expression -- they don't even have your separate list of fields below the diagram canvas because this information is all right there in the structure tree in the field list and in the conditions), or "remove".  Right-click on "FROM" and you can "add subquery" as one of its "tables".  Right-click on such a subquery, or any query, and you can change it to a UNION with an additional table/subquery.  (And, because they include the entire query in that tree as in my #5, there are also context menus for the WHERE and HAVING nodes so you can add conditions under them, and on the individual conditions themselves so you can edit or remove them.)

    For #6, I hope we can save it as a native sql file with each table's position/size/state  in sql comments (like Sqleo).  This would make the product more appealing because we could send the sql to someone else who could edit the sql by hand or in their own tools and when they send it back to us we haven't completely lost our layout.  Also if we ourselves use Flyspeed to develop sql code that must be exported and run in a different environment where we can't use Flyspeed to directly query the database, but where we sometimes need to make a change to it on the fly, we can round-trip it back into Flyspeed without losing our layout...

    0
    Comment actions Permalink
  • Avatar
    Alandsman

    Hi.

    Was looking to see if it's possible to prevent comment removal when automatically formatting. Couldn't find the setting in SQL Query 3.7.7.5. Searched the forums and this thread appears to be the only pertinent result.

    It's been 2 years; has this functionality been introduced (and I'm just not seeing it)?

    0
    Comment actions Permalink

Please sign in to leave a comment.