Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Improve support for saved SQL queries / custom views

david@dalbert.net's profile image david@dalbert.net posted 2 months ago in General Permalink

Browsing/maintaining a database is probably the #1 application of HeidiSQL and the ability to more easily manage custom SQL queries would be hugely useful. The filtered data view is great, but very often, one needs a view that involves some relational joins...so some thoughts:

  1. Allow queries or custom (filtered) views to be created for a table and have them appear under the associated table in the tree viewer.

  2. An easier to implement (and still slick) solution would be to create a Documents/HeidiSQL/Queries folder and then add a node in the main tree view for the Queries folder and its named sub-folders.

I realize you can achieve much of this already using File->LoadSQL and creating your own folder hierarchy, but HeidiSQL is all about ease of use and elegance. The ability to easily find / execute saved queries from within the GUI seems like a significant enhancement.

ansgar's profile image ansgar posted 2 months ago Permalink

Please note there are also the query snippets, in the right side helpers box. I know that's not what you intend to ask for, but another way to organize your queries.

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




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.