Thread: Please Help me

Please Help me

From
"Waheed Rahuman"
Date:
Dear all
Please suggest me which database i can choose for my server setup like
 
1. Manrake Linux
2. ColdFusion
3. Apache Webserver
 
Now i dont know which database to choose
Whether MySQL or PostgreSQL
Please suggest me a.
Thank you
Expecting your reply
Regards
Waheed Rahuman
 
 
 

Re: Please Help me

From
"Christopher Kings-Lynne"
Date:
I have no experience with ColdFusion, but if you ask a question like whether MySQL or Postgres is better on a Postgres mailing list - we're going to say Postgres.
 
Postgres is in many, many ways vastly superior to MySQL.  However, if you are a newbie or are doing this on Win32 platform, you may still choose to use MySQL.
 
Postgres has these things that MySQL doesn't:
 
* SQL compatible date & time handling
* subselects
* stored procedures
* proper foreign keys
* proper transactions
* views
* custom types, aggregates, operators and functions
* 4 procedural languages
* ...and much, much more...
 
You haven't provided us with very much information, however...
 
Chris
-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Waheed Rahuman
Sent: Friday, 2 August 2002 1:11 AM
To: pgsql-sql@postgresql.org
Subject: [SQL] Please Help me

Dear all
Please suggest me which database i can choose for my server setup like
 
1. Manrake Linux
2. ColdFusion
3. Apache Webserver
 
Now i dont know which database to choose
Whether MySQL or PostgreSQL
Please suggest me a.
Thank you
Expecting your reply
Regards
Waheed Rahuman
 
 
 

Re: Please Help me

From
Michelle Murrain
Date:
<div>At 2:49 PM +0800 8/1/02, Christopher Kings-Lynne wrote:</div><blockquote cite="cite" type="cite"><font
color="#0000FF"face="Arial" size="-1">I have no experience with ColdFusion, but if you ask a question like whether
MySQLor Postgres is better on a Postgres mailing list - we're going to say Postgres.</font></blockquote><div><br
/></div><div>Yeah,except I do have experience with ColdFusion, and ColdFusion runs into some very problematic issues
withPostgres, sadly. Although I use Postgres almost exclusively, I had to switch to MySQL for use with
ColdFusion.</div><pre>--
 
</pre><div>.Michelle<br /><br /> --------------------------<br /> Michelle Murrain, Technology Consulting<br />
tech@murrain.net    http://www.murrain.net<br /> 413-253-2874 ph<br /> 413-222-6350 cell<br /> 413-825-0288 fax<br />
AIM:pearlbear0Y!:pearlbear9 ICQ:129250575</div> 

Re: Please Help me

From
"Chad Thompson"
Date:
I am running RedHat, with Apache and Cold Fusion.  I chose PostgreSQL for all of the aforementioned reasons.  It works very well with Cold Fusion.  I have done some optimizing and am able to run rather complex queries much faster than I ever was able to on any Windows platform database.  I had to bail on MySQL because it wouldnt run the sub-queries that i needed.
 
Thanks
Chad
----- Original Message -----
Sent: Thursday, August 01, 2002 11:10 AM
Subject: [SQL] Please Help me

Dear all
Please suggest me which database i can choose for my server setup like
 
1. Manrake Linux
2. ColdFusion
3. Apache Webserver
 
Now i dont know which database to choose
Whether MySQL or PostgreSQL
Please suggest me a.
Thank you
Expecting your reply
Regards
Waheed Rahuman
 
 
 

Re: Please Help me

From
Michelle Murrain
Date:
<div>At 8:32 AM -0600 8/1/02, Chad Thompson wrote:</div><blockquote cite="cite" type="cite"><font face="Arial"
size="-1">Iam running RedHat, with Apache and Cold Fusion.  I chose PostgreSQL for all of the aforementioned reasons. 
Itworks very well with Cold Fusion.  I have done some optimizing and am able to run rather complex queries much faster
thanI ever was able to on any Windows platform database.  I had to bail on MySQL because it wouldnt run the sub-queries
thati needed.</font></blockquote><div><br /></div><div>How did you solve the problem of large text fields? We ran into
thisproblem, and was unable to solve it. We'd get an error if we wanted to add more than, I think 200 or so characters.
Ithad to do with the connection between postgres and Cold Fusion.</div><pre>-- 
 
</pre><div>.Michelle<br /><br /> --------------------------<br /> Michelle Murrain, Technology Consulting<br />
tech@murrain.net    http://www.murrain.net<br /> 413-253-2874 ph<br /> 413-222-6350 cell<br /> 413-825-0288 fax<br />
AIM:pearlbear0Y!:pearlbear9 ICQ:129250575</div> 

Re: Please Help me

From
"Chad Thompson"
Date:
Unfortunatly i know of no such problem.  I have large text fields being submited to my database, but i restrict the submit page to 255 chars.  I will have to test larger numbers and see what errors i get.
 
Thanks
Chad
----- Original Message -----
Sent: Thursday, August 01, 2002 8:48 AM
Subject: Re: [SQL] Please Help me

At 8:32 AM -0600 8/1/02, Chad Thompson wrote:
I am running RedHat, with Apache and Cold Fusion.  I chose PostgreSQL for all of the aforementioned reasons.  It works very well with Cold Fusion.  I have done some optimizing and am able to run rather complex queries much faster than I ever was able to on any Windows platform database.  I had to bail on MySQL because it wouldnt run the sub-queries that i needed.

How did you solve the problem of large text fields? We ran into this problem, and was unable to solve it. We'd get an error if we wanted to add more than, I think 200 or so characters. It had to do with the connection between postgres and Cold Fusion.
-- 
.Michelle

--------------------------
Michelle Murrain, Technology Consulting
tech@murrain.net     http://www.murrain.net
413-253-2874 ph
413-222-6350 cell
413-825-0288 fax
AIM:pearlbear0 Y!:pearlbear9 ICQ:129250575

Re: Please Help me

From
"Christopher Kings-Lynne"
Date:
Michelle,
 
Have you tried it with Postgres 7.1 yet, which removed such limitations?
 
Chris
-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Michelle Murrain
Sent: Thursday, 1 August 2002 10:48 PM
To: Chad Thompson; Waheed Rahuman; pgsql-sql@postgresql.org
Subject: Re: [SQL] Please Help me

At 8:32 AM -0600 8/1/02, Chad Thompson wrote:
I am running RedHat, with Apache and Cold Fusion.  I chose PostgreSQL for all of the aforementioned reasons.  It works very well with Cold Fusion.  I have done some optimizing and am able to run rather complex queries much faster than I ever was able to on any Windows platform database.  I had to bail on MySQL because it wouldnt run the sub-queries that i needed.

How did you solve the problem of large text fields? We ran into this problem, and was unable to solve it. We'd get an error if we wanted to add more than, I think 200 or so characters. It had to do with the connection between postgres and Cold Fusion.
-- 
.Michelle

--------------------------
Michelle Murrain, Technology Consulting
tech@murrain.net     http://www.murrain.net
413-253-2874 ph
413-222-6350 cell
413-825-0288 fax
AIM:pearlbear0 Y!:pearlbear9 ICQ:129250575

Re: Please Help me

From
Jochem van Dieten
Date:
Michelle Murrain wrote:
> 
> Yeah, except I do have experience with ColdFusion, and ColdFusion
> runs into some very problematic issues with Postgres, sadly. Although
> I use Postgres almost exclusively, I had to switch to MySQL for use
> with ColdFusion.

I wonder what your issues are, because in my experience it is very 
version related. With PostgreSQL versions before 7.1 there were various 
problems. As of 7.1, the main problem has been drivers. ColdFusion came 
with old (obsolete) drivers that didn't support many of the new features 
in postgreSQL. A custom compilation of new drivers was required, but was 
a tricky process.

As of CF MX, IMHO PostgreSQL is the clear winner. For the very simple 
reason of full Unicode support, which means internationalization is a 
breeze. Simply save templates as UTF-8 and create a database with 
Unicode encoding and you are ready. And I am not aware of any problems 
with the JDBC drivers.

Jochem

PS Whichever you choose, use cfqueryparam exclusively in your queries.