Обсуждение: Request for book reviews/comments

Поиск
Список
Период
Сортировка

Request for book reviews/comments

От
"Josh Berkus"
Дата:
Folks,

Below are several "how-to" book reviews I intend to put up at TechDocs
(with Justin's OK).  The idea is to provide a list of reference books to
reccomend to begineers and other developers, with the caveat that all
books must be directly related to PostgreSQL in some way and the reviews
will be tailored accordingly.  I will start with sections on Postgres,
Database Design/Administration and SQL, and I can also picture sections
on JDBC books, Programming Open Source Projects, etc.

See if you agree with these reviews, and add your own:

Postgres Books:

PostgreSQL, Introduction and Concepts (by Bruce Momjian, Addison-Wesley,
ISBN: 0201703319)  The original beginner's manual to PostgreSQL by one
of the core developers, Momjian's book contains a spectrum of
introductory material on how to get up and running with PostgreSQL while
leaving more advanced topics for later books.  It includes an
introduction to SQL 92 in general as well as Postgres extensions and the
basics of Postgres command-line administration.  As such, this is
probably the perfect book for the user who is brand new to Postgres and
inexperienced in SQL.

REVIEW WANTED: PostgreSQL by Jeff Perkins

REVIEW WANTED: PostgreSQL Programmer's Guide by our own Thomas Lockhart.

SQL Books:

SQL in a Nutshell (Kline, Kline & Kline, O'Reilly, ISBN: 1565927443)
This slim volume is a useful reference for any experienced SQL developer
wanting to keep track of the dialectical differences between Postgres,
MySQL, MS SQL Server, and Oracle or looking to port a SQL application
between platforms.  It also has an informative overview of the several
SQL standards (92, 99 and SQL 3).  As it does not contain any tutorial
material and few examples, it is not useful to the beginner.  Also the
book should not be used as a primary SQL reference dictionary due to
weak indexing and several notable omissions.

REVIEW WANTED:  SQL Queries for Mere Mortals, by Michael Hernandez et
al.

REVIEW WANTED:  SQL for Smarties, by Joe Celko  (plus other Joe Celko
books)

Database Design and Administration Books:

Practical Issues in Database Management (Fabian Pascal, Addison-Wesley,
ISBN: 0201485559)  This book covers in-depth a number of issues that are
all too often neglected for the self-educated DBA, including: relational
design, normalization, primary keys, and deviations from the SQL
standard.  All is explained in a completely implementation-agnostic way,
with many diagrams and examples.  A must for anyone required to create
any complex database application from scratch.

REVIEW WANTED: Database Design for Mere Mortals, by Michael Hernandez.

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco

Вложения

Re: Request for book reviews/comments

От
"Josh Berkus"
Дата:
Folks,

Also, any reviews on foriegn-language SQL or database books (in the
appropriate language) would be appreciated.

-Josh


______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco

Вложения

Re: Request for book reviews/comments

От
Rick Robino
Дата:
Josh,

I noticed that you had a Joe Selko book in your list so I thought it
would only be fair to put in a C.J. Date book as well.  Perhaps:

A Guide to the Sql Standard : A User's Guide to the Standard Database
Language Sql
by Hugh Darwen (Contributor), Chris J. Date
Paperback - 572 pages 1 edition (April 1997) 
Addison-Wesley Pub Co; ISBN: 0201964260

The '93 edition the one I've used often, but I would imagine that the
above is the "updated" version.

--Rick

Josh Berkus wrote:
> 
> Folks,
> 
> Below are several "how-to" book reviews I intend to put up at TechDocs
> (with Justin's OK).  The idea is to provide a list of reference books to
> reccomend to begineers and other developers, with the caveat that all
> books must be directly related to PostgreSQL in some way and the reviews
> will be tailored accordingly.  I will start with sections on Postgres,
> Database Design/Administration and SQL, and I can also picture sections
> on JDBC books, Programming Open Source Projects, etc.
> 
> See if you agree with these reviews, and add your own:
> 
> Postgres Books:
> 
> PostgreSQL, Introduction and Concepts (by Bruce Momjian, Addison-Wesley,
> ISBN: 0201703319)  The original beginner's manual to PostgreSQL by one
> of the core developers, Momjian's book contains a spectrum of
> introductory material on how to get up and running with PostgreSQL while
> leaving more advanced topics for later books.  It includes an
> introduction to SQL 92 in general as well as Postgres extensions and the
> basics of Postgres command-line administration.  As such, this is
> probably the perfect book for the user who is brand new to Postgres and
> inexperienced in SQL.
> 
> REVIEW WANTED: PostgreSQL by Jeff Perkins
> 
> REVIEW WANTED: PostgreSQL Programmer's Guide by our own Thomas Lockhart.
> 
> SQL Books:
> 
> SQL in a Nutshell (Kline, Kline & Kline, O'Reilly, ISBN: 1565927443)
> This slim volume is a useful reference for any experienced SQL developer
> wanting to keep track of the dialectical differences between Postgres,
> MySQL, MS SQL Server, and Oracle or looking to port a SQL application
> between platforms.  It also has an informative overview of the several
> SQL standards (92, 99 and SQL 3).  As it does not contain any tutorial
> material and few examples, it is not useful to the beginner.  Also the
> book should not be used as a primary SQL reference dictionary due to
> weak indexing and several notable omissions.
> 
> REVIEW WANTED:  SQL Queries for Mere Mortals, by Michael Hernandez et
> al.
> 
> REVIEW WANTED:  SQL for Smarties, by Joe Celko  (plus other Joe Celko
> books)
> 
> Database Design and Administration Books:
> 
> Practical Issues in Database Management (Fabian Pascal, Addison-Wesley,
> ISBN: 0201485559)  This book covers in-depth a number of issues that are
> all too often neglected for the self-educated DBA, including: relational
> design, normalization, primary keys, and deviations from the SQL
> standard.  All is explained in a completely implementation-agnostic way,
> with many diagrams and examples.  A must for anyone required to create
> any complex database application from scratch.
> 
> REVIEW WANTED: Database Design for Mere Mortals, by Michael Hernandez.
> 
> -Josh
> 
> ______AGLIO DATABASE SOLUTIONS___________________________
>                                        Josh Berkus
>   Complete information technology      josh@agliodbs.com
>    and data management solutions       (415) 565-7293
>   for law firms, small businesses        fax 621-2533
>     and non-profit organizations.      San Francisco
> 
>   ------------------------------------------------------------------------
>        Name:
>        Type: Plain Text (text/plain)
>    Encoding: base64
> 
>        Name:
>        Type: Plain Text (text/plain)
>    Encoding: base64
> 
>        Name:
>        Type: Plain Text (text/plain)
>    Encoding: base64
> 
>   ------------------------------------------------------------------------
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org