Beginning Databases with PostgreSQLby STONES, Neil Matthew
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
Most Helpful Customer Reviews
See all customer reviews
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.