/tmp/book.html

text/html
Filename: /tmp/book.html
Type: text/html
Part: 0
Message: Re: [HACKERS] Outline for PostgreSQL book
<!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>