One thing about open sourced software is commonly they have various levels of code releases.
Yyou have CVS snapshots / nightly builds etc These are bleeding edge and might not even work or compile, just the current version of the code. Should not be used in production. You have release candidates This is code that is under review for being released. Should not be used in production You have new releases These are new code versions put out which the devs have decided are stable. As with any new software, there could be undiscovered bugs as well as vulnerabilities. If you want to be safe and secure, these should not be used in production IMO. You have versions which have been out for a couple months These are the ones that you want to be using in a production environment. They are tried and true and the headaches of using freshly baked software have been endured by other people so that you dont have to. If mysql isn't releasing their code straight to the community center right away I don't think it's due to the fact that they don't value their community or want to keep anything away from them, I think it's that they want to make sure the community has the most stable software they can give them while still putting out new features. Make sense? Also if i recall the mysql licensing, you only have to pay the makers of mysql if you ship a software product which CONTAINS mysql. Working with web applications, your client never gets your binaries and they never get the binaries of mysql so you can use it free of charge. You might want to verify that with the community just to make sure but I was researching this about a year ago and this is what I found out and was pretty pleasantly surprised. On 2/22/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Alan, Robert, and anybody else that might still respond, thank you very much for your input. I am looking to replace a MS SBS 2003 + Witango which worked great so far with something else that is reasonably reliable, fast, easy to use and supported. This current system worked great, in more then four years it did not break once (it it true, the load is not very heavy), but I cannot legally use it anymore. MS does not allow more than 75 users on SBS, no matter how much the customer is willing to pay. How ridiculous is that?! So I am looking to alternatives that will make the licensing issue disappear. PostgreSQL seems to be basically "no strings attached", which makes it a first preference. MySQL has a dual licensing policy, and I am afraid to not get into something that later on will prove to be another nightmare. Another issue is that the code changes are not immediately made available to the "Community Server" (or, at least, CS is not the main focus of the company). Thanks again. Mike Bravu ________________________________ From: Robert Garcia [mailto:[EMAIL PROTECTED] Sent: Thursday, February 22, 2007 08:19 To: [email protected] Subject: Re: Witango-Talk: OT: Witango hosting + DB I have not used postgreSQL with it, but one thing to consider with wtiango. I have not found witango to just work perfectly with any DB. Even when other products seem to. It was one of the main reasons, I changed to mysql, and then fell in love for many other reasons. I spent months/years chasing down issues that usually only occur under very heavy load. Under very heavy load, there are issues of witango hanging and even crashing. Witango 5 was notorious for this, and 5.5 was much improved, but it still happens. But I have found it to be almost non-existent with mysql. Probably because witango tests with mysql, and probably a couple of others. All that to say, if your stuff is at all intensive, set up some scenarios, and hammer it on the bench, and see how witango likes it first. I only tested a few DBs, but I found witango/mysql combo to be about the most trouble free, and then probably witango/mssql. -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 13653 West Park Dr Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 [EMAIL PROTECTED] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/ On Feb 22, 2007, at 1:15 AM, <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> wrote: Does anybody have any experience in using PostgreSQL + Witango ? How does it compare with using MySQL? Would you recommend PostgreSQL ? [Sorry, I know this is OT but I checked the Witango-Talk archive and could not find any message related to "PostgreSQL".] Thank you, Mike Bravu ________________________________ From: Robert Garcia [mailto:[EMAIL PROTECTED] Sent: Monday, February 19, 2007 11:22 To: [email protected] Subject: Re: SPAM-MED: RE: Witango-Talk: OT: Witango hosting As far as ease of use, we purchased Navicat enterprise, that solved any "MS is easier" issues. And one more thing, we never chose mysql, especially for peach, because it was free. Peach, actually told me no before, because it was free. They just couldn't figure out, how anything free, could be any good. -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 13653 West Park Dr Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 [EMAIL PROTECTED] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/ On Feb 19, 2007, at 8:17 AM, Jason Pamental wrote: Stefan, Well put. I think that there is enough research out there supporting the speed and capabilities of both engines to argue forever. Simply put though, MySQL is in use in enough high-traffic and mission critical enterprise installations that any blanket statements should be taken with a grain of salt. Rick - I don't mean to take away from your own research - we all have to rely in many cases on our own perceptions and experiences. But we should all try to refrain from making statements that can so easily undermine what others in the community are doing. I would think that if Robert Garcia were to weigh in on this he could spell out a very convincing case for MySQL given the tremendous load his projects put it under on a daily basis. Of course, I use SQL Server (2000 and 2005) as well as MySQL daily, and the ease of management and use with SQL Server is amazing, so I tend to lean towards SQL Server simply because I have it - but were I faced with having to purchase the licenses myself, I'm not sure I'd feel compelled to do so. Cheers everyone- Jason ----- Jason Pamental Director of Web Services North Sails Office: 401.643.1415 Fax: 401.643.1420 Mobile: 401.743.4406 Email: [EMAIL PROTECTED] On Feb 19, 2007, at 10:21 AM, Stefan Gonick wrote: Hi Rick, Those arguments are a far cry from "yech". My point was just that Mysql is a reasonable database and it's free. It doesn't deserve that kind of negative comment, which indirectly casts aspersions on With. Obviously, their site doesn't need a super high performance database, so a free one is just fine. Stefan At 10:13 AM 2/19/2007, you wrote: Hi Stefan, I won't get into a debate, but on Windows in a high-volume production environment Microsoft SQL server is the fastest hands-down, followed by Pervasive SQL a close second. I've never bench-marked MSSQL on Windows vs. MYSQL on Linux, but the research I have done stated that MSSQL is faster. Also, I've done lots of work with MYSQL and in an environment where the traffic is high, MSSQL doesn't perform well. Again, my experience has been on Windows. <6b2db6b.jpg> Rick Sanders President 902-401-7689 www.webenergy-sw.com Shop online for computer systems, accessories, and much, much more! http://shop.webenergy-sw.com From: Stefan Gonick [ mailto:[EMAIL PROTECTED] Sent: February 19, 2007 10:45 AM To: [email protected] Subject: Re: SPAM-MED: RE: Witango-Talk: OT: Witango hosting What is "yech" about Mysql? Since version 4 it has been a quite usable database. Stefan At 09:37 AM 2/19/2007, you wrote: I can't believe they use MYSQL! Yech! <6b2db7a.jpg> Rick Sanders President 902-401-7689 www.webenergy-sw.com Shop online for computer systems, accessories, and much, much more! http://shop.webenergy-sw.com From: Wolf, Gene [ mailto:[EMAIL PROTECTED] Sent: February 19, 2007 10:31 AM To: [email protected] Subject: Witango-Talk: OT: Witango hosting This is a bit off topic. I'm looking for a hosting service for my personal use. No, not business related. *laughs* If any of you offer site hosting and Witango app hosting (and perhaps database support as well) would you please send me some information pertaining to costs? Yes, I did try the Witango e-mail search looking for Hosting in the message title and received the following error message: Error An error occurred while processing your request: File: searchforum.taf Position: DirectDBMS Class: DBMS Main Error Number: 1064 [MySQL][ODBC 3.51 Driver][mysqld-5.0.22-community-max]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY w1.datereceived DESC limit 50' at line 12 23000 File: searchforum.taf Position: DirectDBMS Class: Internal Main Error Number: -101 Gene Wolf Supervisor, Business Systems DRS Sensors & Targeting Systems-Optronics 2330 Commerce Park Drive NE Palm Bay, Florida 32905 Phone: 321-309-0685 321-309-0202 (fax) Dictionary.com Word of the Day http://dictionary.reference.com/wordoftheday/ This e-mail, including any attached files, may contain confidential and privileged information for the sole use of the intended recipient. Any review, use, distribution, or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive information for the intended recipient), please contact the sender by reply e-mail and delete all copies of this message. "This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior written approval from the U.S. Department of State." ________________________________________________________________________ TO UNSUBSCRIBE: Go
to
http://www.witangocom/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go
to
http://www.witangocom/developer/maillist.taf ===================================================== Database WebWorks: Dynamic web sites through database integration http://www.DatabaseWebWorks.com CoachVille: For coaches and people taking teleclasses http :// www.cvcommunity.com?af=69474 ________________________________________________________________________ TO UNSUBSCRIBE: Go to
http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO
UNSUBSCRIBE: Go to
http://www.witango.com/developer/maillist.taf
===================================================== Database WebWorks: Dynamic web sites through database integration http://www.DatabaseWebWorks.com CoachVille: For coaches and people taking teleclasses http :// www.cvcommunity.com?af=69474 ________________________________________________________________________
TO
UNSUBSCRIBE: Go to http://www.witangocom/developer/maillist.taf ________________________________________________________________________
TO
UNSUBSCRIBE: Go to http://www.witangocom/developer/maillist.taf ________________________________________________________________________
TO
UNSUBSCRIBE: Go to http://www.witangocom/developer/maillist.taf -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.441 / Virus Database: 268.18.2/692 - Release Date: 2/18/2007 16:35 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.441 / Virus Database: 268.18.3/696 - Release Date: 2/21/2007 15:19 ________________________________________________________________________
TO
UNSUBSCRIBE: Go to http://www.witangocom/developer/maillist.taf ________________________________________________________________________
TO
UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.441 / Virus Database: 268.18.3 - Release Date: 2/19/2007 00:00 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.441 / Virus Database: 268.18.3 - Release Date: 2/19/2007 00:00 ________________________________________________________________________
TO
UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
