From: Bruce Momjian <maillist@candle.pha.pa.us>
Message-Id: <199910131120.HAA02994@candle.pha.pa.us>
Subject: Re: [HACKERS] Outline for PostgreSQL book
In-Reply-To: <3804545B.FC9376E8@trust.ee> from Hannu Krosing at "Oct 13, 1999
	12:43:55 pm"
To: Hannu Krosing <hannu@trust.ee>
Date: Wed, 13 Oct 1999 07:20:13 -0400 (EDT)
CC: PostgreSQL-development <pgsql-hackers@postgreSQL.org>,
	PostgreSQL-documentation <docs@postgreSQL.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

> And perhaps some discussion about Date/Time types also in the section 
> for programming languages (what you get from date field, how to be 
> sure that what you give to postgresql is understood correctly)
> 
> > The most important thing is to have alot of samples.
> > Practical samples are more useful than just syntax.
> 
> Agreed.
> 
> Maybe "Advanced SQL Commands" could also contain:
> 
> * Outer Joins

But we don't have them yet.

> * Casts (bot AS and ::, with some explanations on why and when)
> 
> Not sure if Views and Triggers should go under Uniqe features - they are 
> supported on most commercial SQL databases.

Yes, I know, but Triggers are specific to the database, and I guess I
have to move views to the other section.

> 
> "Interfacing to the POSTGRESQL Database" could also contain more options
> than PHP,
> at least as references - there are much more of both established (CGI,
> PyApache,mod_perl) 

That's probably too advanced for this book.  Not sure how much detail I
am going to give each interface anyway.  Probably just two examples of
each.

> and emerging (like the recent pgxml announcement) technologies for that
> purpos.
> 
> Server side programming should also mention PL/Tcl 
> 

Added.


> Under which section would requirements the restrictions (db size, field
> size/count, record size/count) 
> or lackof them :) go?

Under Administration, or Installation.


-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026