Re: [HACKERS] Outline for PostgreSQL book

pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  
help / color / mirror / Atom feed

From: Bruce Momjian <maillist@candle.pha.pa.us>
To: Oliver Elphick <olly@lfix.co.uk>
Cc: PostgreSQL-development <pgsql-hackers@postgreSQL.org>
Cc: PostgreSQL-documentation <docs@postgreSQL.org>
Subject: Re: [HACKERS] Outline for PostgreSQL book
Date: Tue, 12 Oct 1999 16:56:04 -0400 (EDT)
Message-ID: <199910122056.QAA09210@candle.pha.pa.us> (raw)
In-Reply-To: <199910122049.VAA04297@linda.lfix.co.uk>

> It looks good; I have a comment on the order of chapters, however.
> 
> I suggest that Installlation goes in an Appendix.  More and more, people
> will be coming to machines that already have software installed, or have
> them installed as packages (.rpm or .deb).

> 
> Installation is the administrator's job, and not of interest to `normal'
> users, so it should not be placed in the book as if every user had to do
> it.

Done.  Certainly better to get that at the end.  That chapter is going
to be a mess to look at.

New version attached.  No PDF version this time.  Do people like PDF?

-- 
  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
...................................................................

The attached document is in both web page and text formats.
View the one which looks best.


Attachments:

/tmp/book.html (text/html, 4.2K) download
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
<!--Converted with LaTeX2HTML 98.1p1 release (March 2nd, 1998)
originally by Nikos Drakos (nikos@cbl.leeds.ac.uk), CBLU, University of Leeds
* revised and updated by:  Marcus Hennecke, Ross Moore, Herb Swan
* with significant contributions from:
  Jens Lippmann, Marek Rouchal, Martin Wilck and others -->
<HTML>
<HEAD>
<TITLE>PostgreSQL Book Proposal</TITLE>
<META NAME="description" CONTENT="PostgreSQL Book Proposal">
<META NAME="keywords" CONTENT="9162">
<META NAME="resource-type" CONTENT="document">
<META NAME="distribution" CONTENT="global">
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<LINK REL="STYLESHEET" HREF="9162.css">
</HEAD>
<BODY >

<P>

<P>

<P>
<H1 ALIGN="CENTER">PostgreSQL Book Proposal</H1>
<P ALIGN="CENTER"><STRONG>Bruce Momjian</STRONG></P>
<P ALIGN="LEFT"></P>

<P>
<DL COMPACT>
<DT>1.
<DD>Introduction
<P>
<DL COMPACT>
<DT>(a)
<DD>History of P<SMALL>OSTGRE</SMALL>SQL
<DT>(b)
<DD>Open source software
<DT>(c)
<DD>When to use a database
</DL><DT>2.
<DD>Issuing database commands

<P>
<DL COMPACT>
<DT>(a)
<DD>Starting a database session
<DT>(b)
<DD>Controlling a session
<DT>(c)
<DD>Sending queries
<DT>(d)
<DD>Getting help
</DL><DT>3.
<DD>Introduction to SQL

<P>
<DL COMPACT>
<DT>(a)
<DD>Creating tables 
<DT>(b)
<DD>Adding data with I<SMALL>NSERT</SMALL>
<DT>(c)
<DD>Viewing data with S<SMALL>ELECT</SMALL>
<DT>(d)
<DD>Removing data with D<SMALL>ELETE</SMALL>
<DT>(e)
<DD>Modifying data with U<SMALL>PDATE</SMALL>
<DT>(f)
<DD>Restricting with W<SMALL>HERE</SMALL>
<DT>(g)
<DD>Sorting data with O<SMALL>RDER </SMALL>B<SMALL>Y</SMALL>
<DT>(h)
<DD>Using N<SMALL>ULL</SMALL> values
</DL><DT>4.
<DD>Advanced SQL Commands

<P>
<DL COMPACT>
<DT>(a)
<DD>Inserting data from a S<SMALL>ELECT</SMALL>
<DT>(b)
<DD>Aggregates: C<SMALL>OUNT, </SMALL>S<SMALL>UM, ...</SMALL>
<DT>(c)
<DD>G<SMALL>ROUP </SMALL>B<SMALL>Y</SMALL> with aggregates
<DT>(d)
<DD>H<SMALL>AVING</SMALL> with aggregates
<DT>(e)
<DD>Joining tables
<DT>(f)
<DD>Using table aliases
<DT>(g)
<DD>U<SMALL>NION</SMALL> clause
<DT>(h)
<DD>Subqueries
<DT>(i)
<DD>Transactions
<DT>(j)
<DD>Cursors
<DT>(k)
<DD>Indexing
<DT>(l)
<DD>Column defaults
<DT>(m)
<DD>Primary/foreign keys
<DT>(n)
<DD>A<SMALL>ND/</SMALL>O<SMALL>R</SMALL> usage 
<DT>(o)
<DD>L<SMALL>IKE</SMALL> clause usage
<DT>(p)
<DD>Temporary tables
<DT>(q)
<DD>Importing data
</DL><DT>5.
<DD>P<SMALL>OSTGRE</SMALL>SQL'<SMALL>S</SMALL> Unique Features

<P>
<DL COMPACT>
<DT>(a)
<DD>Object <SMALL>ID'S</SMALL> (<SMALL>OID'S)</SMALL>
<DT>(b)
<DD>Multi-Version Concurrency Control
<DT>(c)
<DD>Locking and deadlocks
<DT>(d)
<DD>Vacuum
<DT>(e)
<DD>Views
<DT>(f)
<DD>Rules
<DT>(g)
<DD>Sequences
<DT>(h)
<DD>Triggers
<DT>(i)
<DD>Large objects(<SMALL>BLOBS</SMALL>)
<DT>(j)
<DD>Adding user-defined functions
<DT>(k)
<DD>Adding user-defined operators
<DT>(l)
<DD>Adding user-defined types
<DT>(m)
<DD>Exotic pre-installed types
<DT>(n)
<DD>Arrays
<DT>(o)
<DD>Inheritance
</DL><DT>6.
<DD>Interfacing to the P<SMALL>OSTGRE</SMALL>SQL Database

<P>
<DL COMPACT>
<DT>(a)
<DD>C Language API
<DT>(b)
<DD>Embedded C
<DT>(c)
<DD>C++
<DT>(d)
<DD>J<SMALL>AVA</SMALL>
<DT>(e)
<DD>ODBC
<DT>(f)
<DD>P<SMALL>ERL</SMALL>
<DT>(g)
<DD>T<SMALL>CL/</SMALL>T<SMALL>K</SMALL>
<DT>(h)
<DD>P<SMALL>YTHON</SMALL>
<DT>(i)
<DD>Web access (<SMALL>PHP</SMALL>)
<DT>(j)
<DD>Server-side programming (<SMALL>PLPGSQL</SMALL> and <SMALL>SPI)</SMALL>
</DL><DT>7.
<DD>P<SMALL>OSTGRE</SMALL>SQL Administration

<P>
<DL COMPACT>
<DT>(a)
<DD>Creating users and databases
<DT>(b)
<DD>Backup and restore
<DT>(c)
<DD>Performance
<DT>(d)
<DD>Troubleshooting
<DT>(e)
<DD>Customization
<DT>(f)
<DD>Setting access permissions
<DT>(g)
<DD>International character encodings
</DL><DT>8.
<DD>Additional Resources

<P>
<DL COMPACT>
<DT>(a)
<DD>Frequently Asked Questions (<SMALL>FAQ'S)</SMALL>
<DT>(b)
<DD>Mailing list support
<DT>(c)
<DD>Supplied documentation
<DT>(d)
<DD>Commercial support
<DT>(e)
<DD>Modifying the source code
</DL><DT>9.
<DD>Appendix: Installation

<P>
<DL COMPACT>
<DT>(a)
<DD>Getting P<SMALL>OSTGRE</SMALL>SQL
<DT>(b)
<DD>Compiling
<DT>(c)
<DD>Initialization
<DT>(d)
<DD>Starting the server
<DT>(e)
<DD>Creating a database
</DL><DT>10.
<DD>Annotated Bibliography
</DL>
<BR>

</BODY>
</HTML>

/tmp/book.txt (text/plain, 3.8K) download

                          PostgreSQL Book Proposal
                                      
                               Bruce Momjian
   
   1.
          Introduction
        (a)
               History of POSTGRESQL
        (b)
               Open source software
        (c)
               When to use a database
   2.
          Issuing database commands
        (a)
               Starting a database session
        (b)
               Controlling a session
        (c)
               Sending queries
        (d)
               Getting help
   3.
          Introduction to SQL
        (a)
               Creating tables
        (b)
               Adding data with INSERT
        (c)
               Viewing data with SELECT
        (d)
               Removing data with DELETE
        (e)
               Modifying data with UPDATE
        (f)
               Restricting with WHERE
        (g)
               Sorting data with ORDER BY
        (h)
               Using NULL values
   4.
          Advanced SQL Commands
        (a)
               Inserting data from a SELECT
        (b)
               Aggregates: COUNT, SUM, ...
        (c)
               GROUP BY with aggregates
        (d)
               HAVING with aggregates
        (e)
               Joining tables
        (f)
               Using table aliases
        (g)
               UNION clause
        (h)
               Subqueries
        (i)
               Transactions
        (j)
               Cursors
        (k)
               Indexing
        (l)
               Column defaults
        (m)
               Primary/foreign keys
        (n)
               AND/OR usage
        (o)
               LIKE clause usage
        (p)
               Temporary tables
        (q)
               Importing data
   5.
          POSTGRESQL'S Unique Features
        (a)
               Object ID'S (OID'S)
        (b)
               Multi-Version Concurrency Control
        (c)
               Locking and deadlocks
        (d)
               Vacuum
        (e)
               Views
        (f)
               Rules
        (g)
               Sequences
        (h)
               Triggers
        (i)
               Large objects(BLOBS)
        (j)
               Adding user-defined functions
        (k)
               Adding user-defined operators
        (l)
               Adding user-defined types
        (m)
               Exotic pre-installed types
        (n)
               Arrays
        (o)
               Inheritance
   6.
          Interfacing to the POSTGRESQL Database
        (a)
               C Language API
        (b)
               Embedded C
        (c)
               C++
        (d)
               JAVA
        (e)
               ODBC
        (f)
               PERL
        (g)
               TCL/TK
        (h)
               PYTHON
        (i)
               Web access (PHP)
        (j)
               Server-side programming (PLPGSQL and SPI)
   7.
          POSTGRESQL Administration
        (a)
               Creating users and databases
        (b)
               Backup and restore
        (c)
               Performance
        (d)
               Troubleshooting
        (e)
               Customization
        (f)
               Setting access permissions
        (g)
               International character encodings
   8.
          Additional Resources
        (a)
               Frequently Asked Questions (FAQ'S)
        (b)
               Mailing list support
        (c)
               Supplied documentation
        (d)
               Commercial support
        (e)
               Modifying the source code
   9.
          Appendix: Installation
        (a)
               Getting POSTGRESQL
        (b)
               Compiling
        (c)
               Initialization
        (d)
               Starting the server
        (e)
               Creating a database
   10.
          Annotated Bibliography

view thread (50+ messages)  latest in thread

Message-ID: <199910122056.QAA09210@candle.pha.pa.us>
Permalink:  ../199910122056.QAA09210@candle.pha.pa.us/
Also on:    postgresql.org/message-id/199910122056.QAA09210@candle.pha.pa.us

 ·

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: pgsql-docs@postgresql.org
  Cc: maillist@candle.pha.pa.us, olly@lfix.co.uk, pgsql-hackers@postgreSQL.org, docs@postgreSQL.org
  Subject: Re: [HACKERS] Outline for PostgreSQL book
  In-Reply-To: <199910122056.QAA09210@candle.pha.pa.us>

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

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