It slows things down to an extent, but it's by far a better solution then the alternative.
Tom -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Woestman Sent: Thursday, August 25, 2005 8:25 AM To: [email protected] Subject: RE: mySql 5.0 They were. For the last several years we have had a strong tier development system in place which makes it fairly hard to damage production systems. On the other hand, while we are protected, the tiering slows some aspects of development. Tom -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, August 25, 2005 5:49 AM To: [email protected] Subject: RE: mySql 5.0 I hope they were working with a development database. Tom -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Woestman Sent: Thursday, August 25, 2005 7:27 AM To: [email protected] Subject: RE: mySql 5.0 Seems each new developer in our group does it once in their first month of using SQL. Twice in one week - ouch. Good luck, Tom -----Original Message----- From: Kevin Fricke [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 24, 2005 7:42 PM To: [email protected] Subject: RE: mySql 5.0 nope...but still hurts ;) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Matt Woodward Sent: Wednesday, August 24, 2005 9:36 PM To: [email protected] Subject: Re: mySql 5.0 Ouch--unfortunately there's nothing globally you can do to stop that. You *can* control specific rights in the datasource configuration for a particular user (e.g. limit to selects only) but if they have update rights, they can be dumb and do this. The only way to stop it is code reviews I suppose, and for the love of god I hope you aren't letting the newbies hit your production database directly. ;-) Matt On 8/24/05, Kevin Fricke <[EMAIL PROTECTED]> wrote: > Thanks for the info! > > Another question. Does anyone know a way to set up cf so that if you > run an > update query without a where it will error out? I have some new help > and this has happened twice in the last week. Open ended queries > updated the whole database...not good ;) > > kevin > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Behalf Of Adrian J. Moreno > Sent: Wednesday, August 24, 2005 9:24 PM > To: [email protected] > Subject: Re: mySql 5.0 > > > You think SQL Server's expensive, I'm trying to ditch Oracle. I've > been using the 64-bit version of MySQL 4.x in production (dual > Opteron) for almost a year and I've no doubt Oracle and MS are > sweating bullets right about now. > > Their August 2005 Newsletter came out today: > > --------------------------------------------------------------- > Products > New Release of MySQL (5.0.11 Beta) is Now Available > > This Beta release in a pre-production release in the 5.0 series. This > release includes support for Stored Procedures, Views, Triggers, > Information Schema (Data Dictionary), XA and more. Additional updates > include: > > - Security improvement: Applied a patch that addresses a potential > zlib data vulnerability that could result in an application crash. > This only affects the binaries for platforms that are linked > statically against the bundled zlib (most notably Microsoft Windows > and HP-UX) > - Mysqldump now dumps triggers for each dumped table. This can be > suppressed with the –skip-triggers option. > - Added an optimization that avoids key access with NULL keys for the > ref method when used in outer joins. > - Numerous bug fixes > > *All efforts are now being focused on fixing bugs and stabilizing > MySQL 5.0 for the upcoming production release. Get a head start on > your projects by testing MySQL 5.0 beta now.* > ----------------------------------------------------------------- > > Hopefully it'll hit GA around October. I know someone who writes their > documentation, but he won't even give me an "I heard" date. > > -- Adrian > > > Kevin Fricke wrote: > > that would save some serious $$. > > > > Thats what I am waiting for... > > > > Kevin > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Behalf Of Matt Woodward > > Sent: Wednesday, August 24, 2005 6:03 PM > > To: [email protected] > > Subject: Re: mySql 5.0 > > > > > > Haven't heard anything specific but I'm anxiously awaitin this one > > as well. It might mean I can dump SQL Server in some cases. > > > > Matt > > > > On 8/24/05, Kevin Fricke <[EMAIL PROTECTED]> wrote: > > > >> > >>Anyone heard when the expected release of 5.0 is? > >> > >>Kevin > > > > > > > > ---------------------------------------------------------- > To post, send email to [email protected] To unsubscribe: > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > To subscribe: > http://www.dfwcfug.org/form_MemberRegistration.cfm > > > > > ---------------------------------------------------------- > To post, send email to [email protected] To unsubscribe: > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > To subscribe: > http://www.dfwcfug.org/form_MemberRegistration.cfm > > > -- Matt Woodward [EMAIL PROTECTED] http://www.mattwoodward.com NŠ²Û×j)¢Xµ×qû¢¸¢é¹»®&†ÛÿüÁ×qû¢¸~Š1ézµ²ær¸yÇN‹nlj·¶Úÿ uü~订¹zfŠËjØÇ ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm Nj)Xq鹻&q~1zryNnlj u~zfj؝ Nh צj)mXq칻 &ކi0q?~1z'ryN.n+ 0u ~(ߢzfޭkjب Njqq~1zryNnu~zj N�h�� �צj)m�X����q������칻 �&ކ�i��0���q����?~��1��z�'���r��y��N�.n�+������ 0u� ~�(�ߢ��zfޭ���kjب��
