Thread: 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
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 meDear allPlease suggest me which database i can choose for my server setup like1. Manrake Linux2. ColdFusion3. Apache WebserverNow i dont know which database to chooseWhether MySQL or PostgreSQLPlease suggest me a.Thank youExpecting your replyRegardsWaheed Rahuman
<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>
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 -----From: Waheed RahumanSent: Thursday, August 01, 2002 11:10 AMSubject: [SQL] Please Help meDear allPlease suggest me which database i can choose for my server setup like1. Manrake Linux2. ColdFusion3. Apache WebserverNow i dont know which database to chooseWhether MySQL or PostgreSQLPlease suggest me a.Thank youExpecting your replyRegardsWaheed Rahuman
<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>
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 -----From: Michelle MurrainSent: Thursday, August 01, 2002 8:48 AMSubject: Re: [SQL] Please Help meAt 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
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 meAt 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
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.