[Info-ingres] GUI vs SQL

[Roy Hann]

Rich Ford wrote:

> Is there any consensus over using a tool like DBeaver or just using sql
> from the command line?

I use 'em both. I definitely use sql more though. 

The main reason I use DBeaver is when I have to see entire rows that
would fold in sql. That's only a slight convenience, not a knock-out
punch. And because I need to use sql for scripting anyway I usually
already have it running. Also sql starts up in a trice.

The compelling argument for using sql is you can display query plans in
it, which you can't in DBeaver. (I do wish Ingres would treat QEPs as a
core feature instead of delivering them like stowaways hidden in the
wheel-well, but...)

Roy