From: | "Stephen Feyrer" <stephen(dot)feyrer(at)btinternet(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Foreign Keys as first class citizens at design time? |
Date: | 2015-08-14 09:30:51 |
Message-ID: | op.x3cp1pwwx77qtv@sveta.home.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I agree with each of the points you've made. The idea here is meant as an
extension of what is already available. So yes, this is intended to
answer the questions of the designer's original model. The consideration
being that you design your database and the underlying logic of your
decision are already built in. Then when querying that database to
perform mundane day to day business tasks your query set is simple and
easy to build.
I don't see why this should detract from the idea of a free form query
being built using the existing tools to answer a new question which may be
entirely unrelated to the original models purpose. This just couldn't
work independently of the current SQL feature set.
Additionally, this something which has not really been touched on, this
allows a form of iterative structure in a one line query.
On Fri, 14 Aug 2015 03:52:28 +0100, David G. Johnston
<david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
> On Thu, Aug 13, 2015 at 7:26 PM, Stephen Feyrer
> <stephen(dot)feyrer(at)btinternet(dot)com> wrote:
>> When we design databases, invariably, normally we design the queries at
>> the same time.
>
> Well this may be true to an extent well implemented models have the
> ability to answer questions (queries) the original designer never
> thought of or that >were not important at the time.
>
> As for the rest - invest in a good graphical query builder (or write
> one if the existing choices are insufficient).
>
> David J.
>
--
Kind regards
Stephen Feyrer
From | Date | Subject | |
---|---|---|---|
Next Message | Martín Marqués | 2015-08-14 10:14:30 | Re: Migrations |
Previous Message | Aviel Buskila | 2015-08-14 07:14:51 | Re: repmgr won't update witness after failover |