I have been extremely pleased with it. I have not had any strange problems with modeling, data type/WO compatibility. Were it not for the aforementioned pressure to include FileMaker Pro as a report writer, I'd probably not be looking away from it at all. Although, it does cost money and times are tight. With version 10 there was a free single-connection developer option but I don't think there is in version 11.
Tim Worman UCLA GSE&IS On Dec 3, 2009, at 4:14 PM, André Mitra wrote: > So, why not use OpenBase? Or does it have to be free... > > On 2009-12-03, at 6:20 PM, Mike Schrag wrote: > >> Also, full disclosure -- i DO use Postgresql and I think it's a great >> database, but I always feel a little queasy when I do a deployment with PG >> without clustering support. There's always the feeling of "i sure hope this >> doesn't screw me." FrontBase has clustering, but has an obnoxious bug with >> clustered sequences which basically requires that you use guid pks, which >> none of our stuff does, so it's pretty likely MySQL is in my future. >> >> ms >> >> On Dec 3, 2009, at 6:18 PM, Mike Schrag wrote: >> >>> Caveat here -- I don't use MySQL (yet) for anything real. InnoDB is acid, >>> though. I agree that you should never run a myisam mysql for most normal >>> systems and that it's strange that this is the default, but the fact is >>> that you CAN set it to innodb, and it's a perfectly capable (if not VERY >>> capable) database. >>> >>> Soooooo -- I'm calling this out as FUD. Search google for "postgresql >>> corruption" and you'll get plenty of matches, too: >>> Results 1 - 10 of about 164,000 for postgresql corruption. >>> Results 1 - 10 of about 12,700 for mysql innodb corruption. >>> >>> There are quite a few huge systems that are running on MySQL. And the >>> simple fact that you can cluster it actually makes it far more resilient >>> than postgresql. Go try to setup a fault tolerant deployment of PG. Have >>> fun and let me know when you're done. >>> >>> ms >>> >>> On Dec 3, 2009, at 6:10 PM, Miguel Arroz wrote: >>> >>>> Hi! >>>> >>>> There is nothing "specifically" wrong about using MySQL as a database for >>>> WO. What's wrong is using MySQL at all! ;) >>>> >>>> Essentially, it sucks. The first concern of MySQL authors is speed, and >>>> only then correctioness. This may be seen my the existence of InnoDB >>>> itself. First, speeeeeed. A few years later, yeah, this actually might be >>>> usable in something else than a blog if we actually add ACID properties to >>>> it! >>>> >>>> In my Univ, the IT team who deals with the central systems moved >>>> everything they could from mysql to PostgreSQL. Among other reasons, once >>>> in a while a MySQL table corrupted itself. PostgreSQL is much more robust. >>>> >>>> As always in software engineering, everything is a compromise. There may >>>> be a few situations where MySQL is dramatically faster than PostgreSQL, >>>> and the inverse is also true, it depends on the usage and the DB >>>> architecture. This to say that you should use what better suits your >>>> needs. But what I would not expect is MySQL to... you know... work! ;) >>>> >>>> Yours >>>> >>>> Miguel Arroz >>>> >>>> On 2009/12/03, at 22:58, Kieran Kelleher wrote: >>>> >>>>> Miguel, anyone, please enlighten me as to what specifically is wrong with >>>>> using MySQL InnoDB as a database for WO because I have not seen any >>>>> problem, but then I have not used PostgreSQL or FrontBase either - so >>>>> maybe I don't see a problem that I should be concerned about. >>>>> >>>>> -Kieran >>>>> >>>>> On Dec 3, 2009, at 5:41 PM, Miguel Arroz wrote: >>>>> >>>>>> Hi! >>>>>> >>>>>> On 2009/12/03, at 22:32, Kieran Kelleher wrote: >>>>>> >>>>>>>>> I create new OSCs for most background tasks. The one thing is that I >>>>>>>>> dispose() on it at the end of the task .... and the dispose() is only >>>>>>>>> useful if you use ERXJDBCAdaptor is used since the regular WO 5.3 >>>>>>>>> jdbc adaptor opens two connections for every OSC and leaves the >>>>>>>>> stupid things open forever. ERXJDBCAdaptor only opens one db >>>>>>>>> connection and releases it when u call dispose() IIRC. >>>>>>>> >>>>>>>> Dude! >>>>>>>> <http://terminalapp.net/webobjects-postgresql-and-db-growing-and-growing/> >>>>>>>> ;) >>>>>>> >>>>>>> Dude! www.mysql.com - innodb (or cluster NDB) .... doesn't "grow and >>>>>>> grow" (and it is not a "toy", no matter what Chuck says ;-) ) >>>>>> >>>>>> No, it's a disaster! ;) >>>>>> >>>>>> The "growing" is a side effect of leaving the transaction opening that >>>>>> happens on PostgreSQL due to its architecture, but the point is the >>>>>> same, do what I say there to avoid the dumb connection. :) >>>>>> >>>>>> Yours >>>>>> >>>>>> Miguel Arroz >>>>>> >>>>> >>>>> _______________________________________________ >>>>> Do not post admin requests to the list. They will be ignored. >>>>> Webobjects-dev mailing list ([email protected]) >>>>> Help/Unsubscribe/Update your Subscription: >>>>> http://lists.apple.com/mailman/options/webobjects-dev/arroz%40guiamac.com >>>>> >>>>> This email sent to [email protected] >>>> >>>> >>>> _______________________________________________ >>>> Do not post admin requests to the list. They will be ignored. >>>> Webobjects-dev mailing list ([email protected]) >>>> Help/Unsubscribe/Update your Subscription: >>>> http://lists.apple.com/mailman/options/webobjects-dev/mschrag%40mdimension.com >>>> >>>> This email sent to [email protected] >>> >>> >>> _______________________________________________ >>> Do not post admin requests to the list. They will be ignored. >>> Webobjects-dev mailing list ([email protected]) >>> Help/Unsubscribe/Update your Subscription: >>> http://lists.apple.com/mailman/options/webobjects-dev/mschrag%40mdimension.com >>> >>> This email sent to [email protected] >> >> >> _______________________________________________ >> Do not post admin requests to the list. They will be ignored. >> Webobjects-dev mailing list ([email protected]) >> Help/Unsubscribe/Update your Subscription: >> http://lists.apple.com/mailman/options/webobjects-dev/andre%40geometria.net >> >> This email sent to [email protected] > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list ([email protected]) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/lists%40thetimmy.com > > This email sent to [email protected] _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
