Useful Books and Software
|
Related PostgreSQL Books |
|
|
 |
| |
|
|
| |
| Web Hosting and Web Design Related PostgreSQL Books |
Page 2 of 4
Total results: 32 |
|
|
| |
|
|
| |
 |
|
PostgreSQL Developer's Handbook (Developer's Library) |
PostgreSQL is an object-relational database server that is widely considered to be the world¿s most advanced open-source database system. It is ANSI SQL-compatible, and it offers powerful features to enable more complex software design than would be possible with relational databases that are not object-oriented. PostgreSQL is extremely modular, it supports a large number of datatypes, and programming interfaces for PostgreSQL are available for all important programming languages, including C, Perl, Python, Tcl, Java, and PHP. PostgreSQL Developer¿s Handbook provides a complete overview of the PostgreSQL database server and extensive coverage of its core features, including object orientation, PL/pgSQL, and the most important programming interfaces. The book introduces the reader to the language and syntax of PostgreSQL and then moves quickly into advanced programming topics.
Publisher:
Sams
Authors:
Ewald Geschwinde, Hans-Juergen Schoenig
Release Date: 2001-12-28
ISBN/EAN: 0672322609 / 9780672322600
New Price: $9.98 /
Used Price: $0.53 |
| |
|
|
|
|
| |
|
|
| |
 |
|
Professional Linux Programming |
| As Linux increases its presence throughout the world as a target platform for professional application development, its growth as a powerful, flexible system offering many free development tools assures its place in the future. By giving you easy access to this comprehensive range of tools, supporting new and nascent technologies, at little or no cost, developing with Linux allows you to apply the solution that's right for you. In this follow-up to the best-selling Beginning Linux Programming, you will learn from the authors' real-world knowledge and experience of developing software for Linux; you'll be taken through the development of a sample 'DVD Store' application, with 'theme' chapters addressing different aspects of its implementation. Meanwhile, individual 'take-a-break' chapters cover important topics that go beyond the bounds of the central theme. All focus on the practical aspects of programming, showing how crucial it is to choose the right tools for the job, use them as they should be used, and get things right first time. Who is this book for? Experienced Linux programmers and aspiring developers alike will find a great deal of practical information in this book on libraries, techniques, tools and applications. You should be familiar with a simple Linux system, have a good working knowledge of programming in C, and a basic understanding of object-oriented programming with C++ for the Qt/KDE chapters. What does this book cover? Data storage in Linux - including coverage of PostgreSQL, MySQL and XML Implementation of Linux GUIs - covering both KDE and GNOME Web-based interfaces - using the PHP module for Apache Python - including extending and embedding the language Using RPC and CORBA to construct distributed object-based applications Versioning (with CVS), documentation, internationalization and project distribution Distributed hardware solutions such as diskless Linux and Beowulf clustering
By tapping the strengths of the open-source movement, developers can write custom Linux software without spending a dime on licensing fees. Aimed at the experienced C/C++ programmer, Professional Linux Programming provides a wide-ranging and hands-on guide to the different pieces of the puzzle that are required to program successfully on this exciting new platform.
The book is framed as a case study for building a custom database program in Linux for a video rental store. After a tour of the requirements and a brief look at project management for creating this software, the various Linux packages that are needed to implement this system are described, along with sample code, most of which is written in C. Some packages, such as the CVS version-control package, come with most distributions of Linux; others will require downloading additional software over the Internet. In every case, you're provided with the actual command-line arguments that are needed to install, configure, and run each package. Besides a great exploration of CVS for version control, this title offers excellent coverage of the free PostgreSQL and MySQL databases, which are two very popular choices for Linux databases. The book also does a good job of explaining UI design under both the GTK+/GNOME and KDE (two popular Linux desktops), and how to extend the reach of the sample database application by using Remote Procedure Calls (RPCs) and CORBA. Of course, the finished application doesn't use every Linux API that's covered here, but the book does cast a wide net, and introduces features and tools that are available. Two prominent chapters take you on a tour of the essentials of other programming languages. There's PHP for Web development and an appealing, enthusiastic introduction to Python (which probably will turn you into a Python convert). Later chapters provide practical tips for testing and debugging applications, including how to profile your code. The book closes with a useful guide to creating Red Hat Package Manager (RPM) packages for deploying applications, as well as an overview of your options for internationalization. By covering so many APIs, languages, and tools effectively, Professional Linux Programming gives experienced C/C++ programmers all that they need to get started with Linux development. With its remarkably clear presentation style and abundance of practical tips, the book is an admirably useful blueprint for building custom software. --Richard Dragan Topics covered: - Introduction to open-source software and Linux requirements
- Use cases and sample C objects for sample video rental store
- Version control and CVS (command-line options, revisions, branches, and multiuser version control)
- Open-source freeware packages compared (mSQL, MySQL, and PostgreSQL)
- Introduction to databases
- Installing and using PostgreSQL
- Tutorial on psql SQL
- PostgreSQL C database APIs using libcq and embedded SQL calls with ECPG
- Installing and using MySQL (command-line utilities and C database APIs)
- Debugging with gdb
- Introduction and tutorial to UI programming with glib
- GTK+ and GNOME
- Source trees and GNOME
- UI design with Glade
- Testing strategies (including regression testing, profiling, and memory bounds checking)
- KDE/Qt UI programming
- Introduction and quick tutorial to Python (keywords and basic syntax)
- PHP for Web programming
- Introduction to Remote Procedure Calls (RPCs) and CORBA
- XML basics (document structure, parsing, and libxml)
- Strategies for documentation (including custom man pages)
- Distributing Linux applications with Red Hat Package Manager (RPM) packages
- Code patches
Publisher:
Peer Information Inc.
Authors:
Neil Matthew and Richard Stones, Brad Clements, Andrew Froggatt, David J. Goodger, Ivan Griffin
Release Date: 2000-09
ISBN/EAN: 1861003013 / 9781861003010
New Price: $15.91 /
Used Price: $2.37 |
| |
|
|
|
|
| |
|
|
| |
 |
|
JDBC Pocket Reference |
JDBC--the Java Database Connectivity specification--is a complex set of application programming interfaces (APIs) that developers need to understand if they want their Java applications to work with databases. JDBC is so complex that even the most experienced developers need to refresh their memories from time to time on specific methods and details. But, practically speaking, who wants to stop and thumb through a weighty tutorial volume each time a question arises? The answer is the JDBC Pocket Reference, a data-packed quick reference that is both a time-saver and a lifesaver. The JDBC Pocket Reference offers quick look-ups for all methods of the standard JDBC classes. These include concise reviews of the procedures for common JDBC tasks such as connecting to a database, executing stored procedures, executing DDL and the like. You'll find documentation of the connect string formats for the most common databases, including Oracle, SQL-Server, and PostgreSQL. You'll even find information on working with large objects, and on using SQL99 user defined datatypes to work with object-relational data. Searching for this sort of material through large tutorials is frustrating and a waste of time, but this pocket-sized book is easy to take anywhere and makes finding the information you need a snap. O'Reilly's Pocket References have become a favorite among developers everywhere. By providing a wealth of important details in a concise, well-organized format, these handy books deliver just what you need to complete the task at hand. When you've reached a sticking point and need to get to the answer quickly, the new JDBC Pocket Reference is the book you'll want close at hand.
Publisher:
O'Reilly Media, Inc.
Author:
Donald Bales
Release Date: 2003-01-01
ISBN/EAN: 0596004575 / 9780596004576
New Price: $4.27 /
Used Price: $1.70 |
| |
|
|
|
|
| |
|
|
| |
 |
|
Practical PostgreSQL (O'Reilly Unix) |
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.
Publisher:
O'Reilly Media, Inc.
Authors:
John C. Worsley, Joshua D. Drake
Release Date: 2002-01
ISBN/EAN: 1565928466 / 9781565928466
New Price: $20.13 /
Used Price: $8.61 |
| |
|
|
|
|
| |
|
|
| |
 |
|
Postgresql Programmer's Guide |
| Postgres, developed originally in the UC Berkeley Computer Science Department, pioneered many of the object-relational concepts now becoming available in some commercial databases. It provides SQL92/SQL3 language support, transaction integrity, and type extensibility. PostgreSQL is an open-source descendant of this original Berkeley code. PostgreSQL Programmer's Guide describes version 7.0 of Postgres. Chapters include: * Extending SQL * The Postgres Rule System * Interfacing Extensions To Indices * Linking Dynamically-Loaded Functions * Triggers * Server Programming Interface *Large Objects * libpq-C Library * libpq-C++ Binding Library * pgtcl-TCL Binding Library * ODBC Interface * JDBC Interface * Lisp Programming Interface * Overview of PostgreSQL Internals * Frontend/Backend Protocol * Postgres Signals * gcc Default Optimizations
Publisher:
Iuniverse Inc
Author:
Release Date: 2000-12
ISBN/EAN: 0595149170 / 9780595149179
New Price: n.a. /
Used Price: $141.12 |
| |
|
|
|
|
| |
|
|
| |
 |
|
PostgreSQL: Introduction and Concepts |
The open source PostgreSQL database is soaring in popularity, as thousands of database and web professionals discover its powerful features, transaction support, performance, and industrial-strength scalability. In this book, a founding member of the PostgreSQL development team introduces everything you need to know to succeed with PostgreSQL, from basic SQL commands through database administration and optimization. PostgreSQL assumes no previous database expertise: it establishes a firm foundation of basic concepts and commands before turning to PostgreSQL's advanced, innovative capabilities. Bruce Momjian walks readers step-by-step from their first database queries through the complex queries needed to solve real-world problems. He presents proper query syntax, then explores the value and use of each key SQL commands in working applications. Learn to manipulate and update databases, customize queries, work with SQL aggregates, use joins, combine SELECTs with subqueries, work with triggers and transactions, import and export data, use PostgreSQL query tools, and more. Discover PostgreSQL techniques for server-side programming and multi-user control, and master PostgreSQL's interfaces to C, C++, ODBC, JDBC, Perl, and Tcl/TK. You'll also find detailed coverage of PostgreSQL administration, including backups, troubleshooting, and access configuration.
Publisher:
Pearson Education
Author:
Bruce Momjian
Release Date: 2000-12-15
ISBN/EAN: 0201703319 / 9780201703313
New Price: $6.98 /
Used Price: $0.33 |
| |
|
|
|
|
| |
|
|
| |
 |
|
PostgreSQL (Linux) |
This book is perfect for people who use PostgreSQL at work and on their Web site wherever they expose data on the Web using Linux and Apache. It covers the new features of PostgreSQL as well as the PostgreSQL processor, which defines all necessary objects in a database and can be used to get acquainted with SQL and to test ideas and verify joins and queries.
Publisher:
Muska & Lipman/Premier-Trade
Author:
Jeff Perkins
Release Date: 2001-10
ISBN/EAN: 193184142X / 9781931841429
New Price: $6.99 /
Used Price: $1.57 |
| |
|
|
|
|
| |
|
|
| |
 |
|
Database-SQL-Rdbms Howto: Postgresql Object Relational Database System |
| Database-SQL-RDBMS HOWTO is a practical guide to very quickly setup a SQL database engine and front end tools on a Unix system. It also discusses the International standard language ANSI/ISO SQL and reviews the merits/advantages of the SQL database engine developed by the world-wide Internet in an "open development" environment. Database-SQL-RDBMS HOWTO is about HOW-TO setup a next generation Object Relational SQL Database "PostgreSQL" on Unix system which can be used as a Application Database Server or as a Web Database Server. PostgreSQL attempts to implement current and future International ISO/ANSI SQL standards. This book also gives information on the database interface programs like Front End GUIs, RAD tools (Rapid Application Development), ODBC, JDBC drivers, "C," "C++," Java, Perl programming interfaces and Web Database Tools. Information given in Database-SQL-RDBMS HOWTO applies to all Unix/Windows NT platforms and to all other SQL databases. Included is an SQL tutorial, SQL helpful for beginners.
Publisher:
Iuniverse Inc
Author:
Al Dev
Release Date: 2000-11
ISBN/EAN: 0595136753 / 9780595136759
New Price: n.a. /
Used Price: $36.10 |
| |
|
|
|
|
| |
|
|
| |
 |
|
The PostgreSQL Reference Manual Volume 2: Programming Guide (The Postgresql Reference Manual) |
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.
Publisher:
Network Theory Ltd.
Author:
The PostgreSQL Global Development Group
Release Date: 2007-06-01
ISBN/EAN: 0954612035 / 9780954612030
New Price: $21.90 /
Used Price: $20.75 |
| |
|
|
|
|
| |
|
|
|
|
|
