PostgreSQL is an object database management system
released under a BSD-style
license. The project is commonly known by the name "Postgres", which was in fact its original
name.
The second edition of the best-selling PostgreSQL has been updated to completely cover new features and capabilities of the 8.0 version of PostgreSQL. You will be lead through the internals of the powerful PostgreSQL open source database chapter, offering an easy-to-read, code-based approach that makes it easy to understand how each feature is implemented, how to best use each feature, and how to get more performance from database applications. This definitive guide to building, programming and administering the powerful PostgreSQL open-source database system will help you harness one of the most widely used open source, enterprise-level database systems.
PostgreSQL is arguably the most powerful open-source relational database system. It has grown from academic research beginnings into a functionally-rich, standards-compliant, and enterprise-ready database used by organizations all over the world. And it's completely free to use.
Beginning Databases with PostgreSQL offers readers a thorough overview of database basics, starting with an explanation of why you might need to use a database, and following with a summary of what different database types have to offer when compared to alternatives like spreadsheets. You'll also learn all about relational database design topics such as the SQL query language, and introduce core principles including normalization and referential integrity.
The book continues with a complete tutorial on PostgreSQL features and functions and include information on database construction and administration. Key features such as transactions, stored procedures and triggers are covered, along with many of the capabilities new to version 8. To help you get started quickly, step-by-step instructions on installing PostgreSQL on Windows and Linux/UNIX systems are included.
In the remainder of the book we show you how to make the most of PostgreSQL features in your own applications using a wide range of programming languages, including C, Perl, PHP, Java and C#. Many example programs are presented in the book, and all are available for download from the Apress web site.
By the end of the book you will be able to install, use, and effectively manage a PostgreSQL server, design and implement a database, and create and deploy your own database applications.
Product Description: This manual is volume 2 of the official reference documentation for PostgreSQL 8.2.4. This volume documents the client and server interfaces to PostgreSQL: the C/C++ interface libpq, the embedded SQL/C compiler ECPG and the server-side languages PL/pgSQL, PL/Tcl, PL/Perl and PL/Python. Each chapter includes reference documentation and examples. In particular, the use of triggers, rules and views is described in detail. The PL/pgSQL chapter also includes a guide to porting Oracle PL/SQL functions to PostgreSQL. This book is part of a series including volume 1, the "SQL Language Reference" (ISBN 0954612027), and volume 3, the "Server Administration Guide" (ISBN 0954612043). For each copy of this manual sold $1 will be donated to the PostgreSQL project by the publisher.
Product Description: This manual is volume 3 of the official reference documentation for PostgreSQL 8.2.4. This volume is the system administration guide, and covers the installation, configuration and maintenance of PostgreSQL database servers. Topics covered include backups, security, tuning and upgrade procedures, as well as routine tasks such as creating and deleting databases. Later chapters provide a detailed explanation of advanced PostgreSQL features, including file-based and record-based log-shipping, continuous archiving and point-in-time recovery. This book is part of a series including volume 1, the "SQL Language Reference" (ISBN 0954612027), and volume 2, the "Programming Guide" (ISBN 0954612035). For each copy of this manual sold $1 will be donated to the PostgreSQL project by the publisher.
Product Description: This manual is volume 1 of the official reference documentation for PostgreSQL 8.2.4. The PostgreSQL commands and their syntax are described in this volume. The book begins with a specification of the SQL language, as implemented by PostgreSQL, covering syntax, data types, functions and operators. This is followed by detailed documentation for every PostgreSQL command (over 100 of them) from ABORT to VALUES, with a precise usage synopsis, description, annotated parameter list and examples. Important commands such as SELECT and GRANT receive extended coverage. Additional sections document the use of indexes, transactions and the PostgreSQL client and server command-line tools. This volume is part of a series including volume 2, the "Programming Guide" (ISBN 0954612035), and volume 3, the "Server Administration Guide" (ISBN 0954612043). For each copy of this manual sold $1 will be donated to the PostgreSQL project by the publisher.
Product Description: Arguably the most capable of all the open source databases, PostgreSQL is an object-relational database management system first developed in 1977 by the University of California at Berkeley. In spite of its long history, this robust database suffers from a lack of easy-to-use documentation. Practical PostgreSQL fills that void with a fast-paced guide to installation, configuration, and usage. This comprehensive new volume shows you how to compile PostgreSQL from source, create a database, and configure PostgreSQL to accept client-server connections. It also covers the many advanced features, such as transactions, versioning, replication, and referential integrity that enable developers and DBAs to use PostgreSQL for serious business applications. The thorough introduction to PostgreSQL's PL/pgSQL programming language explains how you can use this very useful but under-documented feature to develop stored procedures and triggers. The book includes a complete command reference, and database administrators will appreciate the chapters on user management, database maintenance, and backup & recovery. With Practical PostgreSQL, you will discover quickly why this open source database is such a great open source alternative to proprietary products from Oracle, IBM, and Microsoft. Also included is a CD-ROM with Command Prompt's PostgreSQL Application Server, LXP. The CD covers LXP version 0.8.0 and PostgreSQL version 7.1.3.
PostgreSQL Essential Reference is a reference book for developers and system administrators who are already familiar with SQL database concepts but that need clear and concise documentation that is specific to PostgreSQL. The book is divided into 3 parts; Basic SQL Reference, PostgreSQL specifics, and PostgreSQL administration. On a whole, it provides a command, the syntax, available options, description, and example code. Readers will be able to easily utilize the code and concepts into their use f the product. An added advantage to this book is that provides all reference material in two ways; alphabetically and by task. This is important because readers of the book will be looking for this information by both methods.
Product Description: 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
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
I think this is a great book for beginners especially those curious about PostgreSQL.
— Joe Topjian, Adminspotting.net
Beginning PHP and PostgreSQL 8 delves into some of the most popular open source web development technologies, the PostgreSQL 8 database server and PHP 5 scripting language. Youll learn to reap the benefits of these core technologies by using them in unison to create dynamic, data-driven web applications. This is an ideal read if you are a web designer, programmer, hobbyist, or novice who wants to create applications with PHP 5 and PostgreSQL 8.
News stories are provided by third parties, used with permission,
and copyright of their various respective owners.
Answers 2000 Limited has not necessarily reviewed,
and does not necessarily endorse or
agree with any content of, or views expressed in, all such items.
Answers 2000 Limited has not
necessarily reviewed,
and does not necessarily endorse or
agree with any content of, or views expressed in, comments posted by users.
