<avoiding the access question> It seems that people are very quick to suggest MySQL but I think the superior open source database is PostgreSQL, mainly because it supports transaction locking and stored procedures.
MySQL may have added transaction locking with version 4, I'm not sure. MySQL reads fast as heck so it performs well. I cannot find on the mysql.com if 4.0 has the transaction locking. They do point out that MySQL does now support the UNION statement, not really a new feature in databases from what I recall. MySQL 4.1 is the planned release version with stored procedures. The sample apps for CF on Linux use the PostgreSQL server, so I think it's safe to say that CF works with PostgreSQL quite well. Redhat's database server edition also uses PostgreSQL so you can get that version and still be able to pitch a nice support package to your decision makers too. Just thought that someone should stick up for the other DB out there. </avoiding the access question> Carry on, t ********************************************************************** Tyler M. Fitch Certified Advanced ColdFusion 5 Developer ISITE Design, Inc. 615 SW Broadway Ste. 200 Portland, OR 97205 503.221.9860 ext. 111 http://isitedesign.com ********************************************************************** -----Original Message----- From: Brian Fox [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 05, 2001 3:55 PM To: CF-Talk Subject: RE: MS Access: True/False Questions > > You really shouldn't use MS Access with Cold Fusion... > (it's probably a > > given that this is true, but with California State budget > cuts, it'll be a > > while before we save up enough pennies to buy anything better) > > What about MySQL? It's still Free to my knowledge... You > may want to look > into this. It'd be a hard sell for us. The decision makers tend to cringe whenever they can't add a $3000 support package. Freeware is frowned upon, although we did manage to get a Linux box to run WebCT. As it is, I think MS SQL is probably the forerunning candidate because the name is recognized by the decision makers and they view it as having better support. For the sake of argument though, MySQL is fairly robust? A definite improvement over Access? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
