Murakami Sale

Recently Viewed clear list

Q&A | August 19, 2014

Richard Kadrey: IMG Powell’s Q&A: Richard Kadrey

Describe your latest book. The Getaway God is the sixth book in the Sandman Slim series. In it, the very unholy nephilim, James Stark, aka Sandman... Continue »
  1. $17.49 Sale Hardcover add to wish list

Qualifying orders ship free.
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
3 Remote Warehouse Software Engineering- Programming and Languages

PHP and PostgreSQL Advanced Web Programming


PHP and PostgreSQL Advanced Web Programming Cover


Synopses & Reviews

Publisher Comments:

Sams¿ PHP and MySQL Web Development, by Luke Welling and Laura Thomson, showed that there is a strong demand for books that describe how to use PHP together with a specific open-source database to develop Web applications.

While MySQL is very popular, PostgreSQL is widely considered to be the more powerful of the two open-source databases. And PostgreSQL is rapidly gaining market share large organizations are beginning to use PostgreSQL instead of Oracle; the demand for PostgreSQL training and support has increased by some accounts 50% in the last six months; and Web hosting services increasingly offer PostgreSQL along with MySQL.

PHP and PostgreSQL Advanced Web Programming focuses on the specific needs of a PostgreSQL developer and will detail how to make use of PostgreSQL¿s unique, advanced features to develop high-availability, fail-safe Web applications with PHP and PostgreSQL.

About the Author

Ewald Geschwinde was born on June 21, 1976 in Vienna, Austria. After primary school, he attended the high school for economics in Oberpullendorf. During this time he dealt with computers and extended the work in his favorite field while studying at the Technical University in Vienna. A few months later he started working at the computer center of CA (an Austrian bank), where he was responsible for writing data converters and network solutions for backup systems. In February 1999 he joined Synthesis, where he focused on scientifically monitoring the development of unemployment in Austria and generating reports using C, EFEU, LaTeX, and Perl. In his spare time he developed a database solution for business consultants. After focusing on Oracle databases, he left Synthesis to found Cybertec Geschwinde & Schönig OEG¿a company providing commercial support, training courses, tuning, and remote administration for PostgreSQL ( as well as LDAP (

On August 9, 1978 Hans-Jürgen Schönig was born in Knittelfeld, a small town 125 miles southwest of Vienna. After primary school he attended a private school in Seckau. After the high school final exam, he started studying "Economics of Information" at the Technical University and the University of Vienna where he met Ewald Geschwinde. Just for fun, Hans started working on various projects and was finally employed at Synthesis (an Austrian research company focusing on forecasting the Austrian labor market), in September 1998. There he was responsible for the scientific analysis of data provided by the Austrian social security insurance (dozens of millions of records). During his time at Synthesis, he worked with Unix systems and automated text production, using EFEU, LaTeX, and Perl. In addition, he taught Unix classes in an adult education program once a week.

In the summer of 2000 Hans and Ewald left Synthesis to found Cybertec Geschwinde & Schönig OEG (, focused entirely on PostgreSQL, LDAP, and Unix databases.

Table of Contents

(NOTE: Each chapter concludes with a Summary.)



1. Getting Started.

Why Use PHP and PostgreSQL as a Team? What You Can Do with PHP and PostgreSQL. Web Sites Built on PHP and PostgreSQL.
2. Setting Up PHP.

About PHP. Installing Apache with PHP from Source. Installing Binaries on Linux. Configuring PHP.
3. PHP Basics.

Getting Started. Control Structures and Operators. Data Types and Functions. Building Functions. Exception Handling. Working with Files. Variables and Scope. Building Packages. Working with Forms. Debugging PHP.
4. Object-Oriented PHP.

The Concepts of Object Orientation. Building Classes. Working with Inheritance.


5. Relational and Object-Relational Database Concepts.

Normalization. Basic Operations in the Relational Model. PostgreSQL as an Object Relational Database. Modeling Techniques. Components of Relational Databases and Technical Terms.
6. Installing PostgreSQL.

Installing PostgreSQL on Unix. Installing PostgreSQL on Windows. Creating and Removing Databases. The User Interface. The Architecture of PostgreSQL. License.
7. Basic SQL.

Data Types. Building Tables. Building Simple SQL Statements. Updates and Deletes. Writing Joins. Aggregating Data. Inserting Huge Amounts of Data. Indexes. Modifying Objects. Mathematical Functions and Operators.
8. Advanced SQL.

Advanced Data Types. Working with Views. Working with Subselects. Working with Aliases and Self-Joins. Object-Oriented SQL. Transactions and Locking. Constraints. Basic Optimizations Using EXPLAIN. Sophisticated Joins. Working with Arrays. Combining Queries and Ranges of Values.
9. Embedded Languages.

Writing SQL Functions. PL/pgSQL. Writing Triggers. Embedded Languages Versus PHP Functions.
10. PostgreSQL Administration.

User Administration and User Rights. Maintenance and Database Internals. Configuring PostgreSQL. Preparing the Database for the Web.


11. Writing Database-Driven Applications.

Connecting to the Database. Inserting and Retrieving Data. Error Handling and Monitoring. Handling Huge Amounts of Data. Retrieving Objects from the Database. Tracing a PostgreSQL Connection. Locking. PHP and Transactions.
12. Working with BLOBs.

Working with PostgreSQL BLOBs Using SQL. Working with PostgreSQL BLOBs Using PHP. Managing File Uploads. Storing Files as Toasted Text. An Example of a Simple Image Management Tool.
13. Working with Persistent Database Connections.

The Concept of Persistent Database Connections. An Example. Persistent Connections and Performance. Dangers and Hardware Issues.


14. Managing Regular Expressions.

Perl Style. POSIX Style. Regular Expressions and SQL.
15. Session Management.

Managing Sessions with Cookies. Session Management.
16. Working with Dynamic Documents, Images, and Movies.

Creating Dynamic Images. Using Geometric Data Types. Creating Dynamic Flash Movies. Generating PDF Files.
17. Working with Dates and Time.

Dates and Time in SQL. Dates and Time in PHP.
18. Tuning.

Tuning PostgreSQL. Tuning PHP.
19. XML.

The Basic Concepts. Building a Simple XML-Based Application. XML and PostgreSQL.
20. Security Issues.

Potential Threats. Securing Your System. User Authentication with Apache and PHP.


21. Web Applications.

Mail Systems. Building a Web Shop. Building a Content Management System. Creating Stock Charts. PHP for Application Servers.
22. Extending PostgreSQL.

A User-Defined Data Type. Building Substring Indexes. Tolerant Search Algorithms.
23. High-Availability Systems.

An Introduction to High Availability. Building Failsafe Applications.


24 - Migration.

Migrating from MySQL to PostgreSQL. Migrating from Oracle to PostgreSQL.

Product Details

Geschwinde, Ewald
Schoenig, Hans-Juergen
Indianapolis, Ind.
Internet - General
Programming - General
Internet - World Wide Web
Internet programming
PHP (Computer program language)
Web - General
Software Engineering - Programming and Languages
Edition Description:
Trade paper
Developer's Guide
Series Volume:
v. 286
Publication Date:
June 2002
Grade Level:
9 x 7.4 x 1.8 in 1329 gr

Other books you might like

  1. Beginning PHP and PostgreSQL... Sale Trade Paper $13.27
  2. Beginning PHP and PostgreSQL 8: From... Used Trade Paper $24.00
  3. Practical PostgreSQL with CDROM Used Trade Paper $14.95
  4. Samba Pocket Reference 2ND Edition Used Trade Paper $5.95
  5. All the Math You Need to Get Rich:... New Trade Paper $16.25

Related Subjects

Computers and Internet » Internet » Web Publishing
Computers and Internet » Software Engineering » Programming and Languages

PHP and PostgreSQL Advanced Web Programming New Trade Paper
0 stars - 0 reviews
$44.95 In Stock
Product details 800 pages Sams - English 9780672323829 Reviews:
  • back to top
Follow us on...

Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at