[kambodja]

As I can see Postqre SQL is not very popular...

[Archbob]

Its because intially php debuted with mysql.

[darkcarnival]

i never really see much programs written for it but mysql is very useful since it is runable on perl and php.

[MadDog]

Ive never even seen a script for Postgre SQL.

[darkcarnival]

i know me either much be either harder to code or not very good.

[Karl Austin]

PostgreSQL is far superior to mySQL. To start with, it is actually an RDBMS unlike mySQL (Well, tehcnically it is now, as it does support relations, but in the 3.x.x series it didn't qualify).

PostgreSQL supports many things mySQL does not yet support or not supprt very well e.g. Transactions, Stored Procedures, Triggers, Foreign Keys and a few more things besides.

The reason it is not so popular is that mySQL got there first when it came to the web and because of that, many people are under the impression that mySQL is the database you must use with PHP - when in fact for a lot of applications it's just not suited to the job e.g. Large vBulletin forums - mySQL caves in very quickly with large vBulletin forums, PostgreSQL would scale much better under large volumes of traffic.

[Radio]

phpBB supports PostgreSQL.

[darkcarnival]

i never that. but mysql is still better in some fields than other databases. plus mysql is much more popluar cause the ease of coding.but also more places support mysql y i dont know but you use what is out there most.

[MagnuM]

Originally posted by Radio
phpBB supports PostgreSQL.

Yes it supports Postgres, but in fact it does not use any of this database capabilities (triggers, functions, views). This is because the forum must run the same with each database server.

So the phpBB guys, can't use any particulary capability of a database that other DB does not support. For example, they can't use triggers, which are not supported by MySQL, but are suported by Oracle, PostgreSQL and MSSQL.

The diference between MySQL an PostgreSQL is not the speed or stability, but in the capabilities of each database system.

PostgreSQL is an Object Relational Database Server (wich means it has the posibilities to declare relations between the tables elements, and this relations are stored in the database as objects known as foreign keys). Also the developer have the posibility to declare his own data types and agregations. I will remind here the much many datatypes which is suported by Postgres like arrays, geometric types(circle, polygon) or network address data types (ip, MAC addresses).

And the most powerful thing is the PL/PGSQL which allows developers to create stored procedures, triggers, rules and functions.

Actually, the PostgreSQL slogan is true: The most advanced open source database in the world.

This is why, this database system is recommended for advanced websites and application, where MySQL is not enough.