Thanks For Color-Coding, Now Next Mega-Useful Wish… :-)

[peterlaursen]

I tried to google on 'Parameterized Quick Dump' and 'PQD' but found nothing relevant for this discussion (and I know nothing in advance).  Could you provide some reference, please?

[Sohodojo_Jim]

'peterlaursen' wrote:

I tried to google on 'Parameterized Quick Dump' and 'PQD' but found nothing relevant for this discussion (and I know nothing in advance).  Could you provide some reference, please?

Hi Peter,

Sorry for the delayed reply… I am dropping by to comment and thank you folks — and add a feature request for — for the great new Form view.

'PQD' (Parameterized Quick Dump) is not something that currently exists (AFAIK) but rather a hypothetical/suggested name for the feature I am requesting. So I am not surprised that Google did not turn up anything for your search… at least not until now when a quick check showed that this thread is now at the number two spot for a search on 'Parameterized Quick Dump'! 🙂

Something like this 'remember a tokenized file save' feature is relatively common in applications such as hard drive backup applications.

You folks currently do something very close to 'PQD' with the Scheduled Backups feature. There is the task/job's archive file name and you can prefix a datetime stamp.

However, I believe _scheduled_ backups are much more useful to admins working on a routine rather than developers who are, to use a metaphor, 'walking the bleeding edge' of creating and breaking the state of things between the database and the application they are developing. So, for me, I get a LOT of 'safety net' help from SQLyog by having a work-habit of using the 'Copy database to a different database/host' feature. The speed and convenience of this great SQLyog feature keeps me from hurting myself many times a day, I am sure.

The proposed 'PQD' feature would be a complement to this. That is, PQD would allow developers to 'on-demand' dump a database to file rather than between database/hosts. If PQD was available, I could just do a keyboard shortcut keystroke, hit Enter at a confirming dialog and, “Bam!” I've got a DB dump of that database in my specified location using the naming convention I set. The key idea here is 'on-demand for developers' rather than 'scheduled for admins'. Using such a parameterized approach would allow this on-demand feature to work for _any_ selected database without having to change the PQD settings.

In short, the key to this feature request is: 1) file-naming tokens to make pattern-based dump files easy to specify, and 2) a simple 'set and forget it' preferences feature to specify the file-naming pattern, archive folder location, and shortcut keystroke to do it… and that's about it, I think.

Thanks, as always, for listening to your customers and making such great products. Keep up the good work as it is greatly appreciated.

–Sohodojo Jim–

http://www.Sohodojo.com (R&D)

http://www.Sohodojo.biz (Services)

http://www.DropaBalm.com (new venture in process)

[Author]

Posts