A week or so ago I peeked at the PostGreSQL web site and looked over their Windows port. All of the "Experimental" and "total rewrite" and "not fully tested" messages convinced me to keep waiting, as my needs are for full production.
But from the sound of it some of you out there have bitten the bullet, so I ask: What are the quirks in PostGreSQL insofar as what you write for your cfquery statements? Field type idiosyncracies? Whats its memory footprint like compared to other platforms? Whats it take to get PostGresSQL into CF 6.1 (and I assume 7) as a jdbc resource? Looked at CF's odbc xml config files a few seeks back when I config'd a SeeFusion trial. Looks like there are hooks in there for PostGres already. I use mySQL primarily in production, although I have clients using MS SQL and work in it a fair bit every day. The code I write has to *always* port interchangeably between these two platforms, as well as Access and Oracle, so I don't get fancy with *any* platform's functions. Just SQL propped up with CF if I need it. What I'm doing is exploring a)whether I can support the platform at this stage without reinventing the wheel and b) whether I can move to it myself for my own hosting needs. Cheers, -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196356 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
