Re: Foreign Keys as first class citizens at design time?

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Stephen Feyrer <stephen(dot)feyrer(at)btinternet(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Subject: Re: Foreign Keys as first class citizens at design time?
Date: 2015-08-14 02:52:28
Message-ID: CAKFQuwYJ8roYKzkhzibkzxGK2LxSik+q_hj267B7eJNjQS5S1Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sachin Srivastava 2015-08-14 03:05:03 Re: PostgreSQL - The Best Overall Database
Previous Message Stephen Feyrer 2015-08-14 02:26:51 Re: Foreign Keys as first class citizens at design time?