Just to add my 2c... Another way undervalued free database is Interbase/Firebird. Developed and sold for bucketloads by Borland for years, it's now gone open source. It's fully client server, we use it on our own boxes. Interbase comes in a Borland certified version for a couple hundred bucks I think, or you can use the free non-certified version. Firebird is from the same code base, developed by an open source group I believe.
Check it out, I think it's a viable alternative for SQL Server, way better than either Access or MySQL. K. "Tyler M. Fitch" <[EMAIL PROTECTED]> wrote in message: > <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? > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com 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
