PostgrtSQL instead of MySQL 4?

[wbnc1902]

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.

[Kronin555]

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.

[wbnc1902]

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?

[Kronin555]

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

[Wilgeno_wnt]

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.