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. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
