public inbox for [email protected]  
help / color / mirror / Atom feed
From: David Fetter <[email protected]>
To: Peter Eisentraut <[email protected]>
Cc: [email protected]
Cc: Bruce Momjian <[email protected]>
Subject: Re: Re: [COMMITTERS] pgsql: Proofreading adjustments for first two parts of documentation
Date: Mon, 27 Apr 2009 15:13:49 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>

On Mon, Apr 27, 2009 at 10:56:28PM +0300, Peter Eisentraut wrote:
> On Monday 27 April 2009 21:54:12 David Fetter wrote:
> > On Mon, Apr 27, 2009 at 09:50:13PM +0300, Peter Eisentraut wrote:
> > > On Monday 27 April 2009 20:10:27 David Fetter wrote:
> > > > While we're at it, can we see about moving foreign keys out of
> > > > the "advanced" section?  They've been standard for many years.
> > > > Heck, even MySQL has had them, at least in some of their
> > > > engines, for many years.
> > >
> > > Advanced doesn't have to mean nonstandard, and standard doesn't
> > > have to mean basic.
> >
> > Are you seriously arguing that foreign keys aren't basic?
> > Seriously?
> 
> In your words: yes.
> 
> But it's all relative.  Among all the topics that are covered in the
> tutorial, foreign keys have certain prerequisite topics, such as
> logging into the database, creating tables, and putting data in.
> Certain things have to come before others, and sections are used to
> organize the information.  You can relabel the sections to "Really
> Basic" and "Somewhat Basic", if it helps you.

How about "setting up," and "usage," which opens the door to more
advanced features.  In later revs, we could have sections with "Good
Practices" in the title.

> In some way, everything that is covered in the tutorial ought to be
> "basic".  But some things are more basic than others.  You could
> equally make the argument that views and transactions are basic, but
> then there would be hardly anything interesting left in the
> "advanced" section,

Actually, there's plenty.

> especially if you add the argument

*I* certainly wouldn't add that argument.

> that inheritance and window functions could be considered by some as
> very esoteric features that shouldn't be in the tutorial at all.

Partitioning isn't exactly an esoteric feature.  More of an advanced
topic, as windowing and OLAP functions are, at least this year.

SQL/MED might qualify as esoteric, at least this year.  Five years
hence, SQL/MED might be pretty basic, as most of the heavy lifting
will likely be in the back-end, at least for the common scenarios.  By
then, the optimizer will have what it needs to do what it does fairly
transparently. :)

My point in all this is that, "advanced" isn't frozen forever in time,
and neither is, "basic."

Cheers,
David.
-- 
David Fetter <[email protected]> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: [email protected]

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate



view thread (8+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Re: [COMMITTERS] pgsql: Proofreading adjustments for first two parts of documentation
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox