han peng wrote: > Hi ppl, does anyone know wat kind of odbc/jdbc whatever etc, connection > does CF supports? > > Does CF works well with PostgreSQL? or MYSQL? > > i have used CF w/ oracle and mssql.. but due to budget contraints.. we r > looking into something cheaper.. > > wat i know abt this 2 software.. > > MySQL (fast but not very feature-complete, beta support for transactions > etc) > > PostgreSQL (slightly better cause got more features) > > so anyone hav any experience to share?
CF works very well with both PostgreSQL and MySQL. I would tend to recommend PostgreSQL because it is indeed more feature complete. But if you need to run it under Windows performance is not as fast as on *nix (due to the inability of Windows to handle process forking with decent overhead). Connect through ODBC and it works just fine. Jochem ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
