Beginning Databases with PostgreSQL - Softcover

Richard Stones; Neil Matthew

Softcover

ISBN 10: 1861005156 ISBN 13: 9781861005151

Publisher: Apress, 2001

Synopsis

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

About this title

From the Publisher:

This book is designed for beginners and will lead you through your very first database query, to the complex database commands needed to solve 'real world' problems. However, it's an advantage if you know the essentials of SQL programming and for specific chapters, familiarity with PHP, Perl, and Java will be useful. You can set up your favourite PostgreSQL database on both Windows and UNIX systems.

About the Author:

Richard Stones and Neil Matthew are the authors of the first edition of Beginning Linux Programming. They are both experienced software professionals with many years' experience using and programming UNIX and Linux. They are also co-authors of Instant UNIX.

About this edition

• Publisher: Apress
• Publication date: 2001
• ISBN 10: 1861005156
• ISBN 13: 9781861005151
• Binding: Paperback
• Number of pages: 650