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.
Here are some books about Postgres:
Disclosure: Products details and descriptions provided by Amazon.com. Our company may receive a payment if you purchase products from them after following a link from this website.
Product Description: Beginning Databases with PostgreSQL: From Novice to Professional, Second Edition
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: 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 you to compile PostgreSQL from source, create a database, and configure PostgreSQL to accept client-server connections. It also delves into the many advanced features of the application, including support for transactions, versioning, replication, and referential integrity. And 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.Also included is a CD-ROM with Command Prompt's PostgreSQL ApplicationServer, LXP. The CD covers LXP version 0.8.0 and PostgreSQL version 7.1.3.
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.
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. You'll 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.
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
The PHP language and PostgreSQL database server have long offered an ideal blend of practicality and power for both the novice and experienced programmer alike. Yet the continued evolution of both technologies makes them better suited to drive enterprise-class applications than ever before. In Beginning PHP and PostgreSQL E-Commerce: From Novice to Professional, noted authors Cristian Darie, Emilian Balanescu, and Mihai Bucica show you how to take advantage of this powerful duo to build an e-commerce web site, guiding you step-by-step through the process of designing and developing the project.
Each chapter is devoted to a specific new feature. You'll learn how to build an online product catalog complete with pagination features, shopping cart, checkout mechanism, product search feature, product recommendations, administrative features, customer accounts, an order-management system, and more. You'll also learn how to process electronic payments by integrating several popular payment services, including PayPal, DataCash, and Authorize.net, and how to integrate the Amazon E-Commerce Service (ECS).
The book promotes good programming practices, including the separation of presentation code, business code, and data access code using a 3-tier architecture. PDO (PHP Data Objects) is used to connect to the database, and PostgreSQL functions are used to store the data logic. The Smarty templating engine is used to create the presentation layer. For a preview of what this book will teach you, take a look at the HatShop shopping cart demo.
Who This Book Is For
Beginning PHP and PostgreSQL E-Commerce: From Novice to Professional is aimed at developers looking for a tutorial approach to building a full e-commerce web site from design to deployment. However, its assumed that you have mastered the basics of PHP and have some experience working with relational databases (preferably PostgreSQL).
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.
Product Description: (Pearson Education) Presents the fundamentals of PostgreSQL, an advanced, feature-filled database server. Assumes no background in databases at all, but still moves quickly, going beyond mechanics and into the applications of simple commands in working database applications. Highlights common pitfalls and offers time and trouble-saving tips. Softcover. DLC: Database management.
Product Description: The book "PostgreSQL 8.4 Official Documentation - Volume III. Server Programming" is the part of the official documentation for PostgreSQL 8.4.
To make the large amount of information about PostgreSQL manageable, this information has been organized in several volumes. Each volume is targeted at a different class of users, or at users in different stages of their PostgreSQL experience.
Volume III consists from: Part V - contains information for advanced users about the extensibility capabilities of the server. Topics include user-defined data types and functions.
Product Description: The book "PostgreSQL 8.4 Official Documentation - Volume I. The SQL Language" is the part of the official documentation for PostgreSQL 8.4.
This book is the part of the official documentation of PostgreSQL 8.4.
To make the large amount of information about PostgreSQL manageable, this information has been organized in several volumes. Each volume is targeted at a different class of users, or at users in different stages of their PostgreSQL experience:
Volume I consists from: Part I - is an informal introduction for new users. Part II - documents the SQL query language environment, including data types and functions, as well as user-level performance tuning. Every PostgreSQL user should read this.
Answers 2000 Limited has no opinion about any stories or content of, or
views expressed in, any linked news resource or website.
Information about companies, organizations, products and services
was believed to be correct at the time it was first published on this website,
but may out of date by the time you read this website. For current
information about any company or organization,
readers are advised to check with the applicable company or organization.
Answers 2000 Limited expresses no opinion about any company or
organization (including expressing no opinion on any investments in, with, or relating to, any company or organization),
product or service. This website is not intended as investment or
financial advice.
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED 'AS IS' AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.
Disclosure:
Our company's websites' content (including this website's content) includes advertisements for
our own company's websites, products, and services,
and for other organization's websites, products, and services.
In the case of links to other organization's websites,
our company may receive a payment, (1) if you purchase products or services,
or (2) if you sign-up for third party offers, after following links from this website.
Unless specifically otherwise stated, information about other organization's products and services,
is based on information provided by that organization,
the product/service vendor, and/or publicly available information - and should
not be taken to mean that we have used the product/service in question.
Additionally, our company's websites contain some adverts which we are paid
to display, but whose content is not selected by us, such as Google AdSense ads. For more
detailed information, please see Advertising/Endorsements Disclosures
