We use both SQL Server 2K and MySQL. I've found that there are slight differences in syntax between the two and as you've already stated, MySQL doesn't have the features that SQL Server has. The biggest one, imo, is that MySQL doesn't support stored procedures, triggers, etc. MySQL is probably a better alternative to MS Access with small sites. But if you working on a large site with the potential of quite a bit of traffic, I would stick with SQL Server or Oracle.
I understand budget constraints and the need to save wherever you can. But... It's been my experience that when you try to go cheap where you shouldn't, you'll end up spending more money in the long run when you figure out that a cheap product just didn't scale and wasn't flexible enough when you needed it to be. Not to mention the additional development time to figure out work-arounds and fixes when the clients are pissed off. Mark -----Original Message----- From: han peng [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 03, 2002 10:29 PM To: CF-Talk Subject: CF DB enquiries... 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? thanx, han ______________________________________________________________________ Get Your Own Dedicated Windows 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=coldfusionb 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
