PGSQL- Anyone using it here?

[Good Oyster]

I see the poor little PGSQL database I am allowed to have with my account just sitting there, and would like to make it useful. I finally learned what changes I had to make in my code to start getting away from Access and into using MySQL. Now I'd like to see about using my PGSQL db and wondered if anyone else here is using their PGSQL and what differences I may encounter with syntax, etc.

Also, is there any reason PGSQL would not work with ColdFusion? I am about to embark on a PHP crash course (New Year's resolution!) to force myself to learn it, but til then I will be using ColdFusion.

 

[hatton]

Also, is there any reason PGSQL would not work with ColdFusion? I am about to embark on a PHP crash course (New Year's resolution!) to force myself to learn it, but til then I will be using ColdFusion.

According to Macromedia's site it is possible with some work:

http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18338

I don't know if that's something that Jodo would set up for you bu they'd definitely have to be involved.

Also, a quick search revealed this page:
http://www.wlug.org.nz/PostgresVsMysql

Which compares PostGRE to MySQL, there appear to be a number of things that are more formal (and more functional) in PG though I've never used it myself.

Might be interesting to see a performance difference between PG and - say - SQL Server.

Hatton

 

[SubSpace]

For instance: PGSQL has supported subqueries for ages, while MySQL 4.0 doesn't support them. Support for subqueries was added in 4.1, but that version is not yet installed at JodoHost (or on my home machine for that matter)

 

[Good Oyster]

According to Macromedia's site it is possible with some work:

http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18338

I don't know if that's something that Jodo would set up for you bu they'd definitely have to be involved.

Judging from what I see on the control panel, I can create a PGSQL db and create the connection using a PostgresSQL driver. On the ODBC creation page it even allows for a CFMX DSN record, just as the MySQL did. So maybe Jodo already has it all done.

I'll do some more reading on pros and cons, as I am woefully behind the curve on so much when it gets beyond basic SQL and queries. It's one of the situations where the more I learn, the more ignorant I feel. But it felt so good to be able to get away from Access and start using MySQL, and now I am in the process of converting all my data over to MySQL where appropriate.

I appreciate all the suggestions, help, links, etc. If I find something astonishing when I begin using PGSQL, I'll let ya'll know!

Gary

 

[rotrap]

Personally I use sqllite for simplier dbs and postgresql for larger ones. I find no use for mysql, that these other two do not do better.