Using PostgreSQL With PHP

Grok Headline matches for Using PostgreSQL With PHP

PHP and PostgreSQL

PHP and PostgreSQL 06/13/2002 08:43 AM
When you talk about PHP and databases, people tend to assume you're talking about MySQL. But hang on to your horses - difficult though it may be to believe, PHP does include support for a number of other databases. One of them is PostgreSQL, the *other* open-source database - and this article tells you everything you need to know about using it with PHP.

PostgreSQL 7.4

PostgreSQL 7.4 11/25/2003 10:24 PM

Last week's release of PostgreSQL 7.4 made a great open source project even better - it even managed to impress hard-core MySQL advocate Jeremy Zawodny. The detailed release notes show that most of the improvements were with regards to performance, but the thing that really caught my eye was tsearch2, the new full text indexing suite. A bit of digging brought up the CVS tree for the new module, which in turn lead me to this tutorial style overview of its capabilities.

I make extensive use of MySQL's built in full text indexing on this blog for both the search engine and the "related entries" lists, so it's a feature I've really been missing in my experiments with PostgreSQL.

PostgreSQL 7.4.3

PostgreSQL 7.4.3 06/15/2004 10:38 PM
The latest version of the sophisticated Object-Relational DBMS.

[USN-71-1] PostgreSQL vulnerability

[USN-71-1] PostgreSQL vulnerability 02/01/2005 09:28 PM
Martin Pitt (Feb 01 2005)

PostgreSQL 7.4 (Stable)

PostgreSQL 7.4 (Stable) 11/18/2003 03:16 PM
A robust Object-Relational DBMS.

PostgreSQL 7.4 Released

PostgreSQL 7.4 Released 11/18/2003 03:14 PM

PostgreSQL 8.0 will run on Windows

PostgreSQL 8.0 will run on Windows 08/20/2004 02:22 PM
Open-source database to jump from beta testing to production within three months.

Postgresql AutoDoc 1.23

Postgresql AutoDoc 1.23 06/02/2004 10:59 PM
A Postgres Automatic Documentation Agent.

Postgresql AutoDoc 1.20

Postgresql AutoDoc 1.20 11/03/2003 02:33 PM
A Postgres Automatic Documentation Agent.

MySQL vs. PostgreSQL

MySQL vs. PostgreSQL 07/07/2002 11:37 PM
CNET Jul 7 2002 10:16PM ET

PostgreSQL 8.0.0 beta 1

PostgreSQL 8.0.0 beta 1 08/10/2004 05:53 PM

EMS PostgreSQL Manager Pro v2.5.5.2

EMS PostgreSQL Manager Pro v2.5.5.2 09/15/2004 05:51 PM
EMS PostgreSQL Manager is a powerful graphical tool for PostgreSQL administration and development. It makes creating and editing PostgreSQL database objects easy and fast, and allows you to run SQL scripts, manage users and their privileges, build SQL queries visually, extract, print and search metadata, export data to 14 available formats and import them from most popular formats, view and edit BLOB fields, and many more. [Shareware $195.00 30 Days 5,08 MB]

PostgreSQL Hierarchical Queries 0.5.3

PostgreSQL Hierarchical Queries 0.5.3 07/11/2004 09:11 AM
Hierarchical queries support for PostgreSQL.

PgSqlClient-PostgreSQL ADO.NET Provider

PgSqlClient-PostgreSQL ADO.NET Provider 12/18/2003 07:00 AM
PgSqlClient 1.0 Beta 5 Released

ADO.Net drivers for MySql and PostgreSql

ADO.Net drivers for MySql and PostgreSql 09/01/2004 10:40 PM
First Beta1 released from MySQL

UML, PostgreSQL Get Corporate Support

UML, PostgreSQL Get Corporate Support 07/01/2004 02:08 PM

PostgreSQL Query Analyzer 0.6

PostgreSQL Query Analyzer 0.6 04/23/2004 07:10 PM
Produces HTML reports on query statistics.

Plug OpenOffice.org into PostgreSQL

Plug OpenOffice.org into PostgreSQL 07/30/2004 08:37 AM
Did you know that you can connect the OpenOffice.org office suite to a PostgreSQL database? Maybe your database contains valuable customer or inventory information that your staff could use to generate a personalized sales letter. With OpenOffice.org Writer, and a connection to your PostgreSQL database, you can do just that for each customer. I'm sure you can think of many other uses for such a connection.

PostgreSQL 8.0 Enters Beta

PostgreSQL 8.0 Enters Beta 08/10/2004 12:21 PM
Slashdot Aug 10 2004 4:15PM GMT

PostgreSQL Query Analyzer 0.7

PostgreSQL Query Analyzer 0.7 04/28/2004 04:08 PM
Produces HTML reports on query statistics.

PostgreSQL Query Analyzer 1.0

PostgreSQL Query Analyzer 1.0 05/17/2004 04:36 PM
Produces HTML reports on query statistics.

PostgreSQL Query Analyzer 1.1

PostgreSQL Query Analyzer 1.1 06/07/2004 03:43 PM
Produces HTML reports on query statistics.

PostgreSQL Query Analyzer 0.8

PostgreSQL Query Analyzer 0.8 05/07/2004 03:09 PM
Produces HTML reports on query statistics.

PostgreSQL Cocoa Framework

PostgreSQL Cocoa Framework 01/24/2004 10:19 AM
PostgreSQL Cocoa Framework 0.6d3

PostgreSQL 8.0.2 (Stable branch)

PostgreSQL 8.0.2 (Stable branch) 04/12/2005 11:54 PM
PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS), derived from the Berkeley Postgres database management system. While PostgreSQL retains the powerful object-relational data model, rich data types and easy extensibility of Postgres, it replaces the PostQuel query language with an extended subset of SQL.

---

Changes:
This release includes a new, patent-free buffer replacement policy (2Q) that replaces a patent-pending algorithm from IBM (ARC). Write performance on Windows has been significantly improved. The major version number of the libpq library has been incremented, and a number of bugs have been fixed.

Acaba salir PostgreSQL 7.4

Acaba salir PostgreSQL 7.4 11/17/2003 08:07 AM

PostgreSQL Database Server

PostgreSQL Database Server 11/19/2003 02:44 AM
PostgreSQL 7.4 Now Available For Download

PostgreSQL Hierarchical Queries 0.4

PostgreSQL Hierarchical Queries 0.4 12/08/2003 10:32 AM
Hierarchical queries support for PostgreSQL.

OSDir: A Chat with PostgreSQL

OSDir: A Chat with PostgreSQL 04/17/2005 07:39 PM
"When most people think of open source database products what comes to mind more often than not is MySQL..."

You pay peanuts, you get postgresql
consultants?

You pay peanuts, you get postgresql
consultants? 01/07/2003 02:46 PM
Linux Productivity Magazine featured PostgreSQL in their January 2003 issue. It's a very nice introduction to PostgreSQL that i wished i had read when i first tried the database out. Most of the article is great (from a geekish point of view), except for the following:

TCO (Total Cost of Ownership) is all the rage these days, so consider the following PostgreSQL assets:

• Zero purchase cost
• Zero barrier to entry
  
• Zero license compliance tracking cost
• Legal to copy throughout the enterprise
• Voluminous documentation online at no cost
• Several books on Postgres are available
• Community support via Postgres mailing lists
• Zero license cost for evaluation -- you can easily back out of Postgres
  
• Postgres knowledgeable contractors can be cheaper than Oracle or DB2 gurus

-- Steve Litt

The last point is most interesting. Open source software is free, but skills are not. From a professional viewpoint, it makes little sense for a really smart contractor to learn PostgreSQL if DB2 or Oracle skills pay better and are in demand. PostgreSQL advocates should avoid such statements, which to me is equivalent to saying You pay peanuts, you get postgresql consultants...

"zeldman.wooden"

PostgreSQL: pgsqlformac Project
Announced

PostgreSQL: pgsqlformac Project
Announced 03/14/2005 05:04 PM
For users of the PostgreSQL database that have wanted an easy way to install it on a Mac-based platform, a new package from the PostgreSQL group just might interest you.

Trouble in the Kernel, VMware, and
PostgreSQL

Trouble in the Kernel, VMware, and
PostgreSQL 03/14/2005 05:29 PM
In this weeks Security Alerts, we look at problems in the Linux kernel, VMware, PostgreSQL, Squid, MySQL, mailman, Apple OSX HFS+, movemail with GNU Emacs or XEmancs, KStars, typespeed, awstats, and synaesthesia.

PostgreSQL vs. MySQL vs. Commercial
Databases

PostgreSQL vs. MySQL vs. Commercial
Databases 04/24/2004 06:43 PM
"This article compares PostgreSQL and MySQL, both to each other as well as with their commercial counterparts. Rather than examining the MySQL MAX product based on SAP's database engine, it looks at the more widely deployed "original" MySQL. Questions about MySQL and PostgreSQL often relate to speed." Story

guile-dbd-postgresql 1.0.2 (Default
branch)

guile-dbd-postgresql 1.0.2 (Default
branch) 03/22/2005 04:18 PM
guile-dbd-postgresql is a PostgreSQL database driver for guile-dbi.

---

Changes:
A connection handling bug was fixed.

Automatically start PostgreSQL at boot

Automatically start PostgreSQL at boot 04/19/2005 11:26 AM
Today I installed PostgreSQL on my iBook. I used the very good how-to on the Apple site, but it's not complete. It does not describe how to startup (and shutdown) the database automatically. So I wrote a little addition to th...

guile-dbd-postgresql 1.0.3 (Default
branch)

guile-dbd-postgresql 1.0.3 (Default
branch) 03/24/2005 08:05 AM
guile-dbd-postgresql is a PostgreSQL database driver for guile-dbi.

---

Changes:
Automatic reconnection after a database server failure such as broken sockets or network problems was implemented. The number of reconnection attempts can be set by an optional parameter in the connection string. If omitted, no attempts are made. Query return value checks were improved. The connection string format was documented in the README file.

Fixing sequence problems in PostgreSQL

Fixing sequence problems in PostgreSQL 04/21/2004 03:39 PM

This one's mainly for my own future reference. The following error message in PostgreSQL:

ERROR:  Cannot insert a duplicate key into unique index
auth_permissions_pkey

Is caused by a table with an automatically incremented primary key (set up using the SERIAL keywords in the table creation statement) getting out of sync somehow with the sequence that tracks the next available primary key. You can re-sync the sequence with the following query:

SELECT setval('auth_permissions_id_seq', 
  (SELECT max(id) FROM auth_permissions));

PostgreSQL & PHP, Open Source, and
Tables

PostgreSQL & PHP, Open Source, and
Tables 06/26/2002 01:01 PM

Perl/Postgresql Software Developer (2
Positions)

Perl/Postgresql Software Developer (2
Positions) 03/23/2005 07:46 PM
AWeber Communications, Inc. - United States, PA, Philadelphia (2005-03-23)
Grok Description matches for Using PostgreSQL With PHP
GrokA matches for Using PostgreSQL With PHP

Using PostgreSQL With PHP

The following phrases have been identified by the grok system as matching this entry: