PostgreSQL 8 for Windows (Database Professional's Library) [Paperback]

Richard Blum (Author)

Book Description

ISBN-10: 0071485627 | ISBN-13: 978-0071485623 | Publication Date: March 22, 2007 | Edition: 1

The easiest way to set up a PostgreSQL database server on Windows

Get up-and-running on PostgreSQL quickly using this hands-on guide. Filled with real-world examples, PostgreSQL 8 for Windows offers you practical, step-by-step details on installing, configuring, and using PostgreSQL 8--the full-featured, open-source database management system--on Windows platforms. You'll learn to administer, secure, and tune your database and use SQL. You'll also discover how to interface Microsoft Access, Microsoft .NET, Visual C++, and Java with the PostgreSQL database.

• Install and configure PostgreSQL 8 on Windows
• Customize your system using the configuration files
• Work with the utilities
• Administer your database from the pgAdmin III graphical interface
• Use the psql command line program to manually execute SQL commands
• Take advantage of built-in functions or create your own stored procedures and triggers
• Implement tested security measures
• Maintain optimal database performance
• Access a PostgreSQL database from a Microsoft Access application and migrate Access databases to PostgreSQL
• Create .NET, Visual C++, and Java applications that interface with your PostgreSQL server

Editorial Reviews

About the Author

Richard Blum has worked for more than 18 years in the IT field as a network and systems administrator. During this time he has worked with database servers in UNIX, Linux, Novell, and Microsoft servers.

Product Details

• Paperback: 400 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (March 22, 2007)
• Language: English
• ISBN-10: 0071485627
• ISBN-13: 978-0071485623
• Product Dimensions: 9.1 x 7.4 x 0.8 inches
• Shipping Weight: 1.4 pounds (View shipping rates and policies)
• Average Customer Review: 2.7 out of 5 stars  See all reviews (3 customer reviews)
• Amazon Best Sellers Rank: #1,386,439 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

17 of 17 people found the following review helpful:

4.0 out of 5 stars A good overview, April 6, 2007

By 

MattK (Central Florida, US) - See all my reviews

This review is from: PostgreSQL 8 for Windows (Database Professional's Library) (Paperback)

I was interested in learning a bit about PostgreSQL, and coming from a SQL Server background on Windows systems, this seemed like a good place to start (I will pick up some more Linux knowledge another day). The book provides a good overview of components and processes, and for someone with experience in other database platforms, the material makes a good bridge.

It will probably not provide much new information to a PostgreSQL "expert", but that is not likely the intended audience. Basic admin topics are covered , as well as some development examples in MS Access, .NET, C++, and Java.

A highlight for me was the discovery of some SQL methods in PostgreSQL that were only supported in the latest release of MS SQL Server, and a few that still are not.

1 of 1 people found the following review helpful:

2.0 out of 5 stars Read the manual instead!, April 14, 2010

By 

Christopher Malins (Chile) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: PostgreSQL 8 for Windows (Database Professional's Library) (Paperback)

This book is largely an illustrated cut-down version of the manual for all important sections. I recommend saving yourself the money, biting the bullet and reading the (free!) PostgreSQL manual instead. I'd be very surprised if you need this book after doing so. Overall, a waste of money.

2.0 out of 5 stars Missed Server Side Functions, August 9, 2010

By 

Tim Child - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: PostgreSQL 8 for Windows (Database Professional's Library) (Paperback)

The book is a useful introduction to PostgreSQL on Windows. It covers the basics of PostgreSQL on the Windows platform. For C# programming it covers Npgsql. For Visual C++ it covers using libpq programming. What the book misses is using VC++ for building server side functions. For those who know about PostgreSQL much of its power and extensibility comes from using Server-side C functions. These can be built with VC++ and Visual Studio. For this book I view it as a big miss, but I still bought the book anyway.