0
PostgrtSQL instead of MySQL 4?
New Here
,
/t5/coldfusion-discussions/postgrtsql-instead-of-mysql-4/td-p/148652
Oct 27, 2008
Oct 27, 2008
Copy link to clipboard
Copied
There is another thread in the CFML general forum that
discusses the NULL POINTER EXCEPTION problems and how it seems to
be attributed to MySQL 4/5. I was wondering is PostgrtSQL a viable
alternative to MySQL? Does it have less NPE problems? For an
average to light average use database driven website is one better
than the other?
Disclamer, this is NOT a MySQL vs PostgrtSQL flame war. I am just wondering about these two databases reguarding the NPE problem and CF8 and if one has less of a problem than the other.
Disclamer, this is NOT a MySQL vs PostgrtSQL flame war. I am just wondering about these two databases reguarding the NPE problem and CF8 and if one has less of a problem than the other.
TOPICS
Database access
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
Advocate
,
/t5/coldfusion-discussions/postgrtsql-instead-of-mysql-4/m-p/148653#M13616
Oct 27, 2008
Oct 27, 2008
Copy link to clipboard
Copied
I've been using CF with PostgreSQL for about 6 years. Haven't
had any problems like the ones outlined in the Null Pointer
Exception thread.
Both MySQL and PostgreSQL will handily support an average use database-driven website. If you've been using nothing but MySQL, you would be well served to at least read up on PostgreSQL and find out if it meets your needs.
Both MySQL and PostgreSQL will handily support an average use database-driven website. If you've been using nothing but MySQL, you would be well served to at least read up on PostgreSQL and find out if it meets your needs.
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
wbnc1902
AUTHOR
New Here
,
/t5/coldfusion-discussions/postgrtsql-instead-of-mysql-4/m-p/148654#M13617
Oct 27, 2008
Oct 27, 2008
Copy link to clipboard
Copied
Thanks for the info. I will check it out. Until my company
got a dedicated linux host, I have never heard of PostgrtSQL.
On a side note, is there anything you do differently to connect CF8 to PostgrtSQL? Any special options, any special (updated) drivers?
On a side note, is there anything you do differently to connect CF8 to PostgrtSQL? Any special options, any special (updated) drivers?
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
Advocate
,
/t5/coldfusion-discussions/postgrtsql-instead-of-mysql-4/m-p/148655#M13618
Oct 27, 2008
Oct 27, 2008
Copy link to clipboard
Copied
I always update the driver, but I'm also on Postgres 8.3.
You can get the most recent driver at:
http://jdbc.postgresql.org/
I also setup the datasource using the following:
Pick database type as "Other"
CF Data Source Name: whatever you want to use
JDBC URL: jdbc:postgresql://127.0.0.1:5432/dbname
(where 127.0.0.1 is the IP address of your postgresql server, 5432 is the port number that the server is listening on, and dbname is the name of the postgresql database you want to connect to)
Driver Class: org.postgresql.Driver
Driver Name: leave blank
User Name: name of PostgreSQL user that has access to desired database
Password: password of above PostgreSQL user
You can get the most recent driver at:
http://jdbc.postgresql.org/
I also setup the datasource using the following:
Pick database type as "Other"
CF Data Source Name: whatever you want to use
JDBC URL: jdbc:postgresql://127.0.0.1:5432/dbname
(where 127.0.0.1 is the IP address of your postgresql server, 5432 is the port number that the server is listening on, and dbname is the name of the postgresql database you want to connect to)
Driver Class: org.postgresql.Driver
Driver Name: leave blank
User Name: name of PostgreSQL user that has access to desired database
Password: password of above PostgreSQL user
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
Explorer
,
LATEST
/t5/coldfusion-discussions/postgrtsql-instead-of-mysql-4/m-p/148656#M13619
Nov 03, 2008
Nov 03, 2008
Copy link to clipboard
Copied
I've been running PostgreSQL with Coldfusion for about 6
years as well. You should note that the SQL in PostgreSQL is a bit
more ANSI 99 complaint than other DB's and thus a bit different
than MS SQL or MY SQL. Not much. Just a few little differences. One
of my favorite O'reilly books is SQL in a Nutshell because it lays
out the diffs in SQL from ANSI, MS SQL, MySQL,PostgreSQL and
Oracle. It's nice to have on reference that covers all the
flavors.
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more

