RetroBBS - comp.databases.ingres

GUI vs SQL

<66b44f96-cf00-4b64-b687-47a670965de7n@googlegroups.com>

https://www.rocksolidbbs.com/devel/article-flat.php?id=193&group=comp.databases.ingres#193

copy link Newsgroups: comp.databases.ingres

X-Received: by 2002:a05:620a:1a88:: with SMTP id bl8mr188487qkb.495.1641505153254;
Thu, 06 Jan 2022 13:39:13 -0800 (PST)
X-Received: by 2002:a9d:70cc:: with SMTP id w12mr44069776otj.30.1641505152936;
Thu, 06 Jan 2022 13:39:12 -0800 (PST)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.misty.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ingres
Date: Thu, 6 Jan 2022 13:39:12 -0800 (PST)
Injection-Info: google-groups.googlegroups.com; posting-host=2600:8801:d500:6b60:ddc0:aaf8:a2aa:1b0c;
posting-account=MD_47woAAABULmOe11ZqdjPGw6zni88O
NNTP-Posting-Host: 2600:8801:d500:6b60:ddc0:aaf8:a2aa:1b0c
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <66b44f96-cf00-4b64-b687-47a670965de7n@googlegroups.com>
Subject: GUI vs SQL
From: richford990@gmail.com (Rich Ford)
Injection-Date: Thu, 06 Jan 2022 21:39:13 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 0

by: Rich Ford - Thu, 6 Jan 2022 21:39 UTC

Re: [Info-ingres] GUI vs SQL

<mailman.118.1641508440.1681.info-ingres@lists.planetingres.org>

copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=194&group=comp.databases.ingres#194

copy link Newsgroups: comp.databases.ingres

Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.misty.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!buffer2.nntp.dca1.giganews.com!news.giganews.com.POSTED!not-for-mail
NNTP-Posting-Date: Thu, 06 Jan 2022 16:34:02 -0600
Return-Path: <schendel@kbcomputer.com>
X-Original-To: info-ingres@lists.planetingres.org
Delivered-To: info-ingres@mort.croker.net
From: schendel@kbcomputer.com (Karl Schendel)
Content-Type: text/plain;
charset=us-ascii
Content-Transfer-Encoding: quoted-printable
Mime-Version: 1.0 (Mac OS X Mail 14.0 $3654.120.0.1.13$)
Date: Thu, 6 Jan 2022 17:33:56 -0500
References: <66b44f96-cf00-4b64-b687-47a670965de7n@googlegroups.com>
To: Ingres and related product discussion forum
<info-ingres@lists.planetingres.org>
In-Reply-To: <66b44f96-cf00-4b64-b687-47a670965de7n@googlegroups.com>
X-Mailer: Apple Mail (2.3654.120.0.1.13)
Subject: Re: [Info-ingres] GUI vs SQL
X-BeenThere: info-ingres@lists.planetingres.org
X-Mailman-Version: 2.1.12
Precedence: list
List-Id: <info-ingres.lists.planetingres.org>
List-Unsubscribe: <https://lists.planetingres.org/mailman/options/info-ingres>,
<mailto:info-ingres-request@lists.planetingres.org?subject=unsubscribe>
List-Archive: <https://lists.planetingres.org/pipermail/info-ingres/>
List-Post: <mailto:info-ingres@lists.planetingres.org>
List-Help: <mailto:info-ingres-request@lists.planetingres.org?subject=help>
List-Subscribe: <https://lists.planetingres.org/mailman/listinfo/info-ingres>,
<mailto:info-ingres-request@lists.planetingres.org?subject=subscribe>
Newsgroups: comp.databases.ingres
Message-ID: <mailman.118.1641508440.1681.info-ingres@lists.planetingres.org>
Lines: 16
X-Usenet-Provider: http://www.giganews.com
X-Trace: sv3-UUGZqlDv5J/yfP28zc2JuMcP4Sf6N3U/+rqWDOvj4GYBfCTfVk4M3cNo6IL2aO+XtmfMLdwmYSO4U9y!b/H7LAfd3EJ1uVw1QSTttE4aAiQC+QEbIw+q0zQ33g+DQkMLUo43xtvz1/KCGvt9dapjLaBGQwgL!fPkAZFRBL5AUEXkQHZ7Hd6A=
X-Complaints-To: abuse@giganews.com
X-DMCA-Notifications: http://www.giganews.com/info/dmca.html
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.3.40
X-Original-Bytes: 2614

by: Karl Schendel - Thu, 6 Jan 2022 22:33 UTC

> On Jan 6, 2022, at 4:39 PM, Rich Ford <richford990@gmail.com> wrote:
>
> Is there any consensus over using a tool like DBeaver or just using sql from the command line?

It's entirely personal preference. I'm a firmly committed old-fashioned command line
guy myself. (sql, not even isql.) I imagine that those who are more used to the
pointy clicky stuff would use a pointy clicky tool. In the end, it doesn't
really matter as long as the tool works well with Ingres

Karl

Re: GUI vs SQL

<sr7ugf$88d$1@gioia.aioe.org>

copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=195&group=comp.databases.ingres#195

copy link Newsgroups: comp.databases.ingres

Path: i2pn2.org!i2pn.org!aioe.org!ow2HZ3WUoSa7bUAoHqrJ8A.user.46.165.242.75.POSTED!not-for-mail
From: specially@processed.almost.meat (Roy Hann)
Newsgroups: comp.databases.ingres
Subject: Re: GUI vs SQL
Date: Thu, 6 Jan 2022 23:37:51 -0000 (UTC)
Organization: Aioe.org NNTP Server
Message-ID: <sr7ugf$88d$1@gioia.aioe.org>
References: <66b44f96-cf00-4b64-b687-47a670965de7n@googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Injection-Info: gioia.aioe.org; logging-data="8461"; posting-host="ow2HZ3WUoSa7bUAoHqrJ8A.user.gioia.aioe.org"; mail-complaints-to="abuse@aioe.org";
User-Agent: XPN/1.2.6 (Street Spirit ; Windows)
X-Notice: Filtered by postfilter v. 0.9.2

by: Roy Hann - Thu, 6 Jan 2022 23:37 UTC

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

Whip me. Beat me. Make me maintain AIX. -- Stephan Zielinski

devel / comp.databases.ingres / Re: GUI vs SQL

Subject	Author
GUI vs SQL	Rich Ford
Re: [Info-ingres] GUI vs SQL	Karl Schendel
Re: GUI vs SQL	Roy Hann