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 HYPERLINK "mailto:[EMAIL PROTECTED]"[EMAIL PROTECTED] - HYPERLINK "mailto:[EMAIL PROTECTED]"[EMAIL PROTECTED] HYPERLINK "http://bighead.net"http://bighead.net/ - HYPERLINK "http://eventpix.com"http://eventpix.com/ On Feb 22, 2007, at 1:15 AM, <HYPERLINK "mailto:[EMAIL PROTECTED]"[EMAIL PROTECTED]> <HYPERLINK "mailto:[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 [HYPERLINK "mailto:[EMAIL PROTECTED]"mailto:[EMAIL PROTECTED] Sent: Monday, February 19, 2007 11:22 To: HYPERLINK "mailto:[email protected]"[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 HYPERLINK "mailto:[EMAIL PROTECTED]"[EMAIL PROTECTED] - HYPERLINK "mailto:[EMAIL PROTECTED]"[EMAIL PROTECTED] HYPERLINK "http://bighead.net"http://bighead.net/ - HYPERLINK "http://eventpix.com"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: HYPERLINK "mailto:[EMAIL PROTECTED]"[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 HYPERLINK "http://www.webenergy-sw.com"www.webenergy-sw.com Shop online for computer systems, accessories, and much, much more! HYPERLINK "http://shop.webenergy-sw.com/"http://shop.webenergy-sw.com From: Stefan Gonick [HYPERLINK "mailto:[EMAIL PROTECTED]" mailto:[EMAIL PROTECTED] Sent: February 19, 2007 10:45 AM To: HYPERLINK "mailto:[email protected]"[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 HYPERLINK "http://www.webenergy-sw.com"www.webenergy-sw.com Shop online for computer systems, accessories, and much, much more! HYPERLINK "http://shop.webenergy-sw.com/"http://shop.webenergy-sw.com From: Wolf, Gene [HYPERLINK "mailto:[EMAIL PROTECTED]" HYPERLINK "mailto:[EMAIL PROTECTED]"mailto:[EMAIL PROTECTED] Sent: February 19, 2007 10:31 AM To: HYPERLINK "mailto:[email protected]"[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 HYPERLINK "http://dictionary.reference.com/wordoftheday/"http://dictionary.reference.c om/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 HYPERLINK "http://www.witango.com/developer/maillist.taf"http://www.witangocom/develop er/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to HYPERLINK "http://www.witango.com/developer/maillist.taf"http://www.witangocom/develop er/maillist.taf ===================================================== Database WebWorks: Dynamic web sites through database integration HYPERLINK "http://www.databasewebworks.com/"http://www.DatabaseWebWorks.com CoachVille: For coaches and people taking teleclasses HYPERLINK "http://www.cvcommunity.com/?af=69474"http HYPERLINK "http://www.cvcommunity.com/?af=69474":// HYPERLINK "http://www.cvcommunity.com/?af=69474"www.cvcommunity.com?af=69474 ________________________________________________________________________ TO UNSUBSCRIBE: Go to HYPERLINK "http://www.witango.com/developer/maillist.taf"; http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to HYPERLINK "http://www.witango.com/developer/maillist.taf"; http://www.witango.com/developer/maillist.taf ===================================================== Database WebWorks: Dynamic web sites through database integration HYPERLINK "http://www.databasewebworks.com/"http://www.DatabaseWebWorks.com CoachVille: For coaches and people taking teleclasses HYPERLINK "http://www.cvcommunity.com/?af=69474"http HYPERLINK "http://www.cvcommunity.com/?af=69474":// HYPERLINK "http://www.cvcommunity.com/?af=69474"www.cvcommunity.com?af=69474 ________________________________________________________________________ TO UNSUBSCRIBE: Go to HYPERLINK "http://www.witango.com/developer/maillist.taf"http://www.witangocom/develop er/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to HYPERLINK "http://www.witango.com/developer/maillist.taf"http://www.witangocom/develop er/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to HYPERLINK "http://www.witango.com/developer/maillist.taf"http://www.witango.com/develo per/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 HYPERLINK "http://www.witango.com/developer/maillist.taf"http://www.witango.com/develo per/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
