I've been thinking a lot about mySQL, for main-job and side-job reasons. The price is compelling, ya must admit... Now, one school of though is this: The current mySQL doesnt do stored procs, FKeys, etc... BuTtTt, if you stick to writing plain SQL statements like SELECT INSERT UPDATE DELETE, and nothing more, you've got truly portable SQL that'll run on most any back-end DB with almost no mods. Probably the only thing you'd have to watch is the datatype diffs between the DBs. Now, you can always go and convert those raw SQL statements into stored procs in the future, if the option becomes available. For now, though, I think that keeping things plain could actually serve you well in the long run. > -----Original Message----- > From: Rob Schuff [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, March 15, 2001 8:56 AM > To: Fusebox > Subject: Re: OT: mySQL > > nor are there any referential integrity constraints (ie foreign keys). I > wouldn't touch mySQL with a ten foot pole at this point. Consider the for > InterBase product Firebird at http://sourceforge.net/projects/firebird/ or > perhaps postgres. I have been using Interbase for years and now am using > the Firebird version. very very nice product. To use with cf you'll need > an odbc driver. easysoft's ($100) works very well. > > rob > > > --------------------------------------------------------------------- > Robert Schuff Bull Run Software > [EMAIL PROTECTED] Portland, OR USA > --------------------------------------------------------------------- > ----- Original Message ----- > From: "Hal Helms" <[EMAIL PROTECTED]> > To: "Fusebox" <[EMAIL PROTECTED]> > Sent: Thursday, March 15, 2001 8:14 AM > Subject: RE: OT: mySQL > > > > Is it true there are no stored procs or triggers with MySQL? > > > > Hal Helms > > Team Allaire > > [ See www.halhelms.com <http://www.halhelms.com> for info on training > > classes ] > > > > > > -----Original Message----- > > From: Mats Stromberg [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, March 15, 2001 10:57 AM > > To: Fusebox > > Subject: Re: OT: mySQL > > > > > > To me MySQL isn't an alternative, it is the one! :) > > we've been running it for some years now and it really runs nice and > > extremely fast. > > Transactions have never been a problem for us, a lot due to the > stability > > of the product. Not one single crash. > > This is of course an issue for many and MySQL has addressed this and the > > current version of MySQL do support transaction. > > Unfortunately I can't give you any feedback on how good or bad this > works > > or affects the performance of the engine. > > Maybe someone else has some experience with this new feature of MySQL? > > > > /Mats/ > > At 05:00 AM 3/15/2001 -0800, you wrote: > > >Sorry for the OT, but I'm just curious as to weather > > >or not anyone is using mySQL and their opinions about > > >using it as an alternative to SQL Server ($$$$$$). > > > > > >I've been doing some testing with table locking etc. > > >but I would be very interested in hearing how others > > >are coding around transactions. > > > > > >Shawn > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
