Re: Difference between PostgreSQL and MySQL

2004-08-11 Thread Josh Trutwin
On Tue, 10 Aug 2004 23:40:39 +0200 Jochem van Dieten [EMAIL PROTECTED] wrote: On Tue, 10 Aug 2004 16:49:26 -0400, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Well, since you admitted to being a newbie, I would suggest that you learn with MySQL. It supports several types of data storage

Re: Difference between PostgreSQL and MySQL

2004-08-11 Thread Josh Trutwin
On Tue, 10 Aug 2004 23:34:49 +0200 Jochem van Dieten [EMAIL PROTECTED] wrote: On Tue, 10 Aug 2004 16:00:12 -0500, Josh Trutwin wrote: One area where MySQL beat Postgres is in Windows installation. Installing postgres on Windohs is like pulling your fingernails off slowly. It is more

Re: Difference between PostgreSQL and MySQL

2004-08-11 Thread Jochem van Dieten
On Wed, 11 Aug 2004 10:00:32 -0500, Josh Trutwin wrote: On Tue, 10 Aug 2004 23:34:49 +0200 Jochem van Dieten wrote: On Tue, 10 Aug 2004 16:00:12 -0500, Josh Trutwin wrote: MySQL's command line interface and programming API also are nicer for newer users. Why in the world do I need to

Difference between PostgreSQL and MySQL

2004-08-10 Thread EWAGW
Hi all, mr.super newbie here, what is the best for cold fusion development? I know that NASA uses MySQL but I have also been told that more 'professionals'(???) use PostgreSQL. Let the flaming begin!! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Difference between PostgreSQL and MySQL

2004-08-10 Thread Brad Tilley
EWAGW wrote: Hi all, mr.super newbie here, what is the best for cold fusion development? I know that NASA uses MySQL but I have also been told that more 'professionals'(???) use PostgreSQL. Let the flaming begin!! No need for flames. I think the two are converging. PostgreSQL started out with a

Re: Difference between PostgreSQL and MySQL

2004-08-10 Thread Jochem van Dieten
On Tue, 10 Aug 2004 15:35:20 -0500, EWAGW [EMAIL PROTECTED] wrote: Hi all, mr.super newbie here, what is the best for cold fusion development? The best depends on the requirements. You have not told us any requirements, except that you work with ColdFusion. If that is *really* the only

Re: Difference between PostgreSQL and MySQL

2004-08-10 Thread EWAGW
3:45 PM Subject: Re: Difference between PostgreSQL and MySQL EWAGW wrote: Hi all, mr.super newbie here, what is the best for cold fusion development? I know that NASA uses MySQL but I have also been told that more 'professionals'(???) use PostgreSQL. Let the flaming begin!! No need

Re: Difference between PostgreSQL and MySQL

2004-08-10 Thread SGreen
Well, since you admitted to being a newbie, I would suggest that you learn with MySQL. It supports several types of data storage (memory only, ISAM, full-relational) and both transacted and non-transacted execution models. That's just about everything you could want a database to do.

Re: Difference between PostgreSQL and MySQL

2004-08-10 Thread Josh Trutwin
On Tue, 10 Aug 2004 16:45:29 -0400 Brad Tilley [EMAIL PROTECTED] wrote: No need for flames. I think the two are converging. One area where MySQL beat Postgres is in Windows installation. Installing postgres on Windohs is like pulling your fingernails off slowly. I hear they are close to full

Re: Difference between PostgreSQL and MySQL

2004-08-10 Thread Martijn Tonies
Subject: Re: Difference between PostgreSQL and MySQL Well, since you admitted to being a newbie, I would suggest that you learn with MySQL. It supports several types of data storage (memory only, ISAM, full-relational) and both transacted and non-transacted execution models. Ehm

Re: Difference between PostgreSQL and MySQL

2004-08-10 Thread Martijn Tonies
No need for flames. I think the two are converging. One area where MySQL beat Postgres is in Windows installation. Installing postgres on Windohs is like pulling your fingernails off slowly. I hear they are close to full Windows support though in the 8.x branch. FYI:

Re: Difference between PostgreSQL and MySQL

2004-08-10 Thread EWAGW
Thanks a lot Shawn, Josh and Brad for your great advice. The command line interface you talk about is that in MySQL administrator? MySQL's command line interface and programming API also are nicer for newer users. Why in the world do I need to remember to type \d to show my tables? That

Re: Difference between PostgreSQL and MySQL

2004-08-10 Thread EWAGW
Thank Jochem as well interesting reply got me thinking - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 10, 2004 3:51 PM Subject: Re: Difference between PostgreSQL and MySQL On Tue, 10 Aug 2004 15:35:20 -0500, EWAGW [EMAIL

Re: Difference between PostgreSQL and MySQL

2004-08-10 Thread Jochem van Dieten
On Tue, 10 Aug 2004 16:00:12 -0500, Josh Trutwin wrote: One area where MySQL beat Postgres is in Windows installation. Installing postgres on Windohs is like pulling your fingernails off slowly. It is more like following the manual. Not hard, you just have to take it one step at a time.

Re: Difference between PostgreSQL and MySQL

2004-08-10 Thread Jochem van Dieten
On Tue, 10 Aug 2004 16:49:26 -0400, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Well, since you admitted to being a newbie, I would suggest that you learn with MySQL. It supports several types of data storage (memory only, ISAM, full-relational) and both transacted and non-transacted execution

Re: Difference between PostgreSQL and MySQL

2004-08-10 Thread EWAGW
Thanks Emmett and Martijn!! - Original Message - From: EWAGW [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 10, 2004 4:31 PM Subject: Re: Difference between PostgreSQL and MySQL Thank Jochem as well interesting reply got me thinking - Original Message

Re: Difference between PostgreSQL and MySQL

2004-08-10 Thread mos
At 03:35 PM 8/10/2004, you wrote: Hi all, mr.super newbie here, what is the best for cold fusion development? I know that NASA uses MySQL but I have also been told that more 'professionals'(???) use PostgreSQL. Let the flaming begin!! One thing that wasn't mentioned is MySQL requires a license

RE: Difference between PostgreSQL and MySQL

2004-08-10 Thread Lachlan Mulcahy
Foundation or a lawyer as appropriate. Lachlan -Original Message- From: mos [mailto:[EMAIL PROTECTED] Sent: Wednesday, 11 August 2004 7:58 AM To: [EMAIL PROTECTED] Subject: Re: Difference between PostgreSQL and MySQL At 03:35 PM 8/10/2004, you wrote: Hi all, mr.super newbie here, what