PostgreSQL eBooks
PostgreSQL 9.0 High Performance
Learn the right techniques to obtain optimal PostgreSQL database performance, from initial design to routine maintenance. Discover the techniques used to scale successful database installations. Avoid the common pitfalls that can slow your system down. Filled with advice about what you should be doing; how to build experimental databases to explore performance topics, and then move what you've learned into a production database environment. Learn best practices culled from years of work scaling PostgreSQL installations to handle demanding applications ...
Learn the right techniques to obtain optimal PostgreSQL database performance, from initial design to routine maintenance. Discover the techniques used to scale successful database installations. Avoid the common pitfalls that can slow your system down. Filled with advice about what you should be doing; how to build experimental databases to explore performance topics, and then move what you've learned into a production database environment. Learn best practices culled from years of work scaling PostgreSQL installations to handle demanding applications ...
PostgreSQL 9 Admin Cookbook
How to implement PostgreSQL features for reliability and performance; How to use the latest PostgreSQL 9.0 features; Summaries to help DBAs with experience of other database systems; Advanced technical tips and scripts for experienced users; Best practice for planning and designing live databases; How and when to VACUUM your databases; Selecting and implementing robust backup techniques; Concise and clear guidance on replication and high availability. ...
How to implement PostgreSQL features for reliability and performance; How to use the latest PostgreSQL 9.0 features; Summaries to help DBAs with experience of other database systems; Advanced technical tips and scripts for experienced users; Best practice for planning and designing live databases; How and when to VACUUM your databases; Selecting and implementing robust backup techniques; Concise and clear guidance on replication and high availability. ...
Beginning PHP and PostgreSQL 8
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. ...
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. ...
Beginning PHP and PostgreSQL E-Commerce
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. 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. ...
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. 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. ...
Beginning Databases with PostgreSQL, 2nd Edition
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. ...
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. ...
PostgreSQL, 2nd Edition
The 2nd 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. ...
The 2nd 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: Introduction and Concepts
The most advanced, feature-rich SQL database server available, the open-source PostgreSQL system has rapidly become a key Internet technology. PostgreSQL: Introduction and Concepts, written by a founding member of the PostgreSQL Global Development Team, provides a much-needed tutorial and real-world guide to understanding and working with this complex yet essential system. ...
The most advanced, feature-rich SQL database server available, the open-source PostgreSQL system has rapidly become a key Internet technology. PostgreSQL: Introduction and Concepts, written by a founding member of the PostgreSQL Global Development Team, provides a much-needed tutorial and real-world guide to understanding and working with this complex yet essential system. ...