Beginning Databases with PostgreSQL

( 2 )

Overview

PostgreSQL is rapidly on its way to becoming the most successful open source relational database system. It has had an explosive growth, from its roots in academia, to the Internet, through the efforts of a talented hard-working worldwide development team. The vast array of enterprise businesses migrating to PostgreSQL from proprietary databases are stark evidence for its success to come.

This book is a complete tutorial on PostgreSQL features and functions beginning with the ...

See more details below
Available through our Marketplace sellers.
See All Options
Other sellers (Paperback)
  • All (13) from $1.99   
  • New (3) from $31.92   
  • Used (10) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$31.92
surplus computer books
Seller since Tue Jan 01 01:01:01 EST 2008

Feedback rating:

(171)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
1861005156 BRAND NEW NEVER USED IN STOCK 125,000+ HAPPY CUSTOMERS SHIP EVERY DAY WITH FREE TRACKING NUMBER

Ships from: fallbrook, CA

Usually ships in 1-2 business days

  • •Standard, 48 States
  • •Standard (AK, HI)
$50.00
bluehouse
Seller since Tue Oct 07 09:37:03 EDT 2014

Feedback rating:

(184)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • •Standard, 48 States
  • •Standard (AK, HI)
$51.00
Books Revisited
Seller since Tue Oct 07 09:35:53 EDT 2014

Feedback rating:

(294)

Condition: New
Brand New Item.

Ships from: Chatham, NJ

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
  • •Express, 48 States
  • •Express (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

More About This Book

Overview

PostgreSQL is rapidly on its way to becoming the most successful open source relational database system. It has had an explosive growth, from its roots in academia, to the Internet, through the efforts of a talented hard-working worldwide development team. The vast array of enterprise businesses migrating to PostgreSQL from proprietary databases are stark evidence for its success to come.

This book is a complete tutorial on PostgreSQL features and functions beginning with the basics and building up to the design and construction of databases and integrating them with programming languages for the Web. Here we'll show you how to make the most of this fully programmable databases' powerful features like aggregate, join, transaction, inheritance, embedding your own C routines and more.

This book covers:

  • Detailed tutorial in PostgreSQL
  • Installing from binaries and source code on UNIX and Windows
  • Working with graphical tools
  • Various forms of queries, subqueries, aggregate functions and joins
  • Transactions, locking, stored procedures and triggers
  • Performance monitoring, tuning and server control
  • Connecting and executing SQL statements using C (libpq) and Embedded SQL
  • Developing applications in PHP, Perl and Java
Read More Show Less

Product Details

  • ISBN-13: 9781861005151
  • Publisher: Wrox Press, Inc.
  • Publication date: 10/10/2001
  • Series: Beginning Ser.
  • Edition number: 1
  • Pages: 650
  • Product dimensions: 7.22 (w) x 8.93 (h) x 1.38 (d)

Table of Contents

Introduction 1
Chapter 1 Introduction to PostgreSQL 7
Programming with Data 7
Flat File Databases 8
What is a Database? 10
Database Types 10
Query Languages 13
Database Management Systems 15
What is PostgreSQL? 16
Chapter 2 Relational Database Principles 23
Spreadsheets 23
Putting Data Into a Database 28
Adding Additional Information 32
Designing Tables 36
Basic Data Types 42
The Sample Database 45
Summary 45
Chapter 3 Getting Started with PostgreSQL 47
Install or Upgrade? 48
Installing PostgreSQL from the Linux Binaries 48
Installing PostgreSQL From the Source Code 52
Installing PostgreSQL on Windows 65
Summary 77
Chapter 4 Accessing Your Data 79
Using psql 80
Simple SELECT Statements 82
Performing Calculations 89
Choosing the Rows 90
Comparisons Using Other Types 96
Multiple Tables 103
Relating Three Tables 109
Summary 114
Chapter 5 PostgreSQL Graphical Tools 117
psql 117
ODBC 124
pgAdmin 128
Kpsql 132
PgAccess 132
Microsoft Access 135
Microsoft Excel 140
Resources 144
Summary 144
Chapter 6 Data Interfacing 147
Adding Data to the Database 147
Updating Data in the Database 163
Deleting Data from the Database 166
Summary 168
Chapter 7 Advanced Data Selection 171
Aggregate Functions 171
The UNION Join 181
Subqueries 183
Self Joins 190
Outer Joins 191
Summary 195
Chapter 8 Data Definition and Manipulation 197
Data Types 197
PostgreSQL Special Types 204
Manipulating Tables 210
Views 218
Foreign Key Constraints 222
Summary 229
Chapter 9 Transactions and Locking 231
What are Transactions? 232
Transaction with Single Users 235
Transactions with Multiple Users 238
Locking 245
Summary 249
Chapter 10 Stored Procedures and Triggers 253
Operators 254
Functions 259
Procedural Languages 261
Getting Started with PL/pgSQL 262
Anatomy of a Stored Procedure 266
SQL Functions 281
Triggers 282
Why Stored Procedures and Triggers? 288
Summary 289
Chapter 11 PostgreSQL Administration 291
Default Installation 292
Server Control 295
Users 298
Data Maintenance 304
Database Security 311
Configuration Options 313
Performance 316
Summary 321
Chapter 12 Database Design 323
Understanding the Problem 323
What is a Good Database Design? 324
Stages in Database Design 326
Convert to a Physical Model 336
Normal Forms 343
Common Patterns 345
Resources 348
Summary 348
Chapter 13 Accessing PostgreSQL From C Using libpq 351
Using the libpq Library 352
Database Connections 353
Executing SQL with libpq 357
Transactions 361
Printing Query Results 365
Cursors 368
Binary Values 374
Asynchronous Functionality 374
Summary 379
Chapter 14 Accessing PostgreSQL From C Using Embedded SQL 381
A First Embedded SQL Program 382
Summary 405
Chapter 15 Accessing PostgreSQL from PHP 407
Adding PostgreSQL Support to PHP 408
Using the PHP API for PostgreSQL 409
Summary 427
Chapter 16 Accessing PostgreSQL From Perl 429
The pgsql_perl5 or Pg Module 430
Using pgsql_perl5 431
The Perl DBI 437
Summary 450
Chapter 17 Accessing PostgreSQL from Java 453
JDBC Overview 453
JDBC Drivers 454
Building the PostgreSQL JDBC Driver 455
DriverManager and Driver 456
Connections 460
JDBC Resultsets 465
JDBC Statements 472
SQL Exceptions and Warnings 479
A JDBC GUI Application 480
Summary 497
Chapter 18 Further Information and Resources 499
Non-Relational Storage 499
OLTP, OLAP, and Other Database Terminology 500
Resources 502
Summary 504
Appendix A PostgreSQL Database Limits 507
Appendix B PostgreSQL data types 511
Logical Types 511
Exact Number Types 512
Approximate Number Types 512
Temporal Types 513
Character Types 513
Geometric Types 514
Miscellaneous Types 514
Appendix C PostgreSQL SQL Syntax 517
PostgreSQL SQL Commands 517
PostgreSQL SQL Syntax 518
Appendix D Psql Reference 531
Appendix E Database Schema and Tables 535
Appendix F Large Objects Support in PostgreSQL 539
Adding Images to the Database 539
Index 547
Read More Show Less

Customer Reviews

Average Rating 3
( 2 )
Rating Distribution

5 Star

(0)

4 Star

(1)

3 Star

(0)

2 Star

(1)

1 Star

(0)
Sort by: Showing 1 Customer Reviews

  • Anonymous

    Posted Tue Apr 16 00:00:00 EDT 2002

    The best book on Postres

    This is the best book that I found so far on learning the PostgreSQL database. It teaches everyting you'll need to write applications using Posgres and does it in a very clear and concise manner. It also covers many languages which can be used with Postgres to create very powerful applications. One thing that I would recommend is adding Python to that list.

    Was this review helpful? Yes  NoThank you for your feedback.   Report this reviewThank you, this review has been flagged.
Sort by: Showing 1 Customer Reviews
If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)