External (from a file) script execution

Feature requests and their debate

External (from a file) script execution

Postby EugeneJF » Mon Apr 11, 2011 3:22 pm

I have very huge script in a file. And it'll be good not to open it in an editor for execution. Could you add such feature to DBeaver?
EugeneJF
 
Posts: 42
Joined: Mon Feb 28, 2011 10:04 am

Re:External (from a file) script execution

Postby Serge » Mon Apr 11, 2011 6:31 pm

Generally most databases have their own tools to execute scripts. These tools works much faster than any GUI tool and we can't compete with them. Moreover these tools supports all nuances of local SQL dialects and will parse scripts 100% correctly.
E.g. for MySQL and PostgreSQL you should just execute mysql and pgsql commands with your script file forwarded to standard input.

From the other hand it's often much more convinient to execute scripts from GUI (no need to know a lot of different command line parameters, enter username/password, etc).

But anyway I'm not sure it is a good idea to try to implement universal script executor for now. But we may do it for certain databases for which we have specific plugins. For now it is only MySQL and may be we'll try to include "external" script execution feature in one of following versions. Note that this feature will require installation of local native client.

Note: if this feature will be often requested then may be will try to do some universal script executor.
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re:External (from a file) script execution

Postby EugeneJF » Mon Apr 11, 2011 7:44 pm

Last edited by EugeneJF on Thu Jan 01, 1970 12:33 am, edited 1 time in total.
EugeneJF
 
Posts: 42
Joined: Mon Feb 28, 2011 10:04 am

Re:External (from a file) script execution

Postby Serge » Mon Apr 11, 2011 8:27 pm

Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb


Return to Feature Requests



Who is online

Users browsing this forum: No registered users and 3 guests