Re: [PHP] Survey: MySQL vs PostgreSQL for PHP

2002-07-09 Thread Richard Lynch
I've been using MySQL/PHP for quite some time. Several months ago, I wanted to port a project over to PostgreSQL. I found everything about pg (eg the website, documentation, installation process) far less straight ahead than MySQL. So much so, that I didn't get around to actually installing

RE: [PHP] Survey: MySQL vs PostgreSQL for PHP

2002-07-08 Thread Lazor, Ed
Thanks to everyone who contributed on this thread. It proved to be very informative and enjoyable. -Ed This message is intended for the sole use of the individual and entity to whom it is addressed, and may contain

Re: [PHP] Survey: MySQL vs PostgreSQL for PHP

2002-07-07 Thread Pete James
From the php.net manual for pg_fetch_array: Note: From 4.1.0, row became optional. Calling pg_fetch_array() will increment internal row counter by 1. Ilia A. wrote: On July 5, 2002 07:54 pm, Pete James wrote: Ilia A. wrote: The biggest annoyance I've come across is the fact that

Re: [PHP] Survey: MySQL vs PostgreSQL for PHP

2002-07-07 Thread Analysis Solutions
On Fri, Jul 05, 2002 at 01:59:48PM -0700, Lazor, Ed wrote: How many here feel PostgreSQL has surpassed MySQL as the better backend for PHP? This would be based on performance (speed, scalability, etc.) and features. I've been using MySQL/PHP for quite some time. Several months ago, I

Re: [PHP] Survey: MySQL vs PostgreSQL for PHP

2002-07-06 Thread Ilia A.
On July 5, 2002 07:54 pm, Pete James wrote: Ilia A. wrote: The biggest annoyance I've come across is the fact that while using PostgreSQL with PHP is that when you fetch a row you must specify the number of the result, while in MySQL, that is handled internally by PHP for you. This

Re: [PHP] Survey: MySQL vs PostgreSQL for PHP

2002-07-06 Thread Devrim GUNDUZ
Hi, On Fri, 5 Jul 2002, Lazor, Ed wrote: How many here feel PostgreSQL has surpassed MySQL as the better backend for PHP? This would be based on performance (speed, scalability, etc.) and features. Surely PostgreSQL!!! If you aim is creating a database, then use PostgreSQL. if you want

Re: [PHP] Survey: MySQL vs PostgreSQL for PHP

2002-07-05 Thread B i g D o g
I am there with you on PostgreSQL. B i g D o g - Original Message - From: Lazor, Ed [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 05, 2002 2:59 PM Subject: [PHP] Survey: MySQL vs PostgreSQL for PHP How many here feel PostgreSQL has surpassed MySQL as the better

Re: [PHP] Survey: MySQL vs PostgreSQL for PHP

2002-07-05 Thread Scott Fletcher
I dunno! Never tried it! I wonder which one is easier to work with? B I G D O G [EMAIL PROTECTED] wrote in message 00d201c22467$8c2e4830$[EMAIL PROTECTED]">news:00d201c22467$8c2e4830$[EMAIL PROTECTED]... I am there with you on PostgreSQL. B i g D o g - Original Message - From:

RE: [PHP] Survey: MySQL vs PostgreSQL for PHP

2002-07-05 Thread Lazor, Ed
I've always used MySQL, I don't know either. I suspect they are equal in ease of use. -Original Message- I dunno! Never tried it! I wonder which one is easier to work with? This message is intended for the

Re: [PHP] Survey: MySQL vs PostgreSQL for PHP

2002-07-05 Thread Ray Hunter
features like triggers and views. Check it out and see what you think... B i g D o g - Original Message - From: Lazor, Ed [EMAIL PROTECTED] To: 'Scott Fletcher' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, July 05, 2002 3:07 PM Subject: RE: [PHP] Survey: MySQL vs PostgreSQL for PHP

Re: [PHP] Survey: MySQL vs PostgreSQL for PHP

2002-07-05 Thread João Paulo Vasconcellos
I don't feel that. I run a web site with a big deal of traffic, and in speed and scalability, MySQL is better than PGSQL or Sybase. I know because I tryed each one of these before getting to MySQL in definitive. Sybase is WAY too slow, and Postgres has a habit of melting down from time to

Re: [PHP] Survey: MySQL vs PostgreSQL for PHP

2002-07-05 Thread Scott Fletcher
-- From: Lazor, Ed [EMAIL PROTECTED] To: 'Scott Fletcher' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, July 05, 2002 3:07 PM Subject: RE: [PHP] Survey: MySQL vs PostgreSQL for PHP I've always used MySQL, I don't know either. I suspect they are equal in ease of use. -Original

Re: [PHP] Survey: MySQL vs PostgreSQL for PHP

2002-07-05 Thread Ilia A.
I've recently had the 'pleasure' of porting a large MySQL application to support PostgreSQL, through that experience I've gained some insight into the differences between the two as well as how they are supported by PHP. First allow me to point out that MySQL support in PHP is a lot more

Re: [PHP] Survey: MySQL vs PostgreSQL for PHP

2002-07-05 Thread Alberto Serra
ðÒÉ×ÅÔ! That's interesting. I actually never used Postgres on production environments, so... How often does it melt? And is there a known reason or it's just a matter of *luck*? My opinion is that Mysql is after all nothing more than an ISAM file system, which can be queried by SQL. And it's