Ideas for HeidiSQL

User, date Message
User: rscout13
Posted: Wed, 21 Jul 10 12:00
Category: General
2 posts since Wed, 21 Jul 10
Hi, I'm from Russia. Excuse my English. I want to share ideas.
Instead of two tabs, and query data need one, console Query can be located above or below the data table (user selectable).

http://s48.radikal.ru/i119/1007/d0/9994a3c24e51.gif

In the filters should be able to select columns, filtering parameter with NOT. It would be great to edit the column filtered data about how the picture below.

http://i082.radikal.ru/1007/4c/5b8ba5760a54.gif

If HeidiSQL will be able to filter, sort and edit data based on regular expressions - just incredible fun.
User: anse
Posted: Wed, 21 Jul 10 12:21
1822 posts since Fri, 07 Apr 06
You didn't say how the filter and query tab could live both on the same tab - while I think that will get incredibly ugly, having lots of controls over the data grid.

However, feel free to dive into issue #1085 - similar discussion there.

Your idea about merging Data and Query tabs is good - I had the same idea some months ago. The grid is already listening to the same events in both cases. Only the Data tab has a more GUI related logic, helping users who don't want to enter "SELECT bla FROM blub WHERE xyz...". While the Query tabs have another approach: "Do what you want with any SQL you like". Finally I got to the point that both tabs have their own right to live. The Data tab should not be merged away.
User: rscout13
Posted: Wed, 21 Jul 10 12:37
2 posts since Wed, 21 Jul 10
Originally on the Data tab, there are GUI related logic, but if necessary on the same tab you can open the console.

Above the open filter and сonsole have to think smile
User: anse
Posted: Wed, 21 Jul 10 13:14
1822 posts since Fri, 07 Apr 06
Yes. I think both the filter/sort/columns GUI and a console with free SQL text are not mergable into one logic.
 

Please login to leave a reply, or register at first.