As long as there is a way to easily migrate my data, and someone can tell me what connection info I need to connect my eomodel to frontbase, I'd be happy to give it a shot.
And I'll even leave out auto-increment. On Dec 2, 2010, at 3:24 PM, Chuck Hill wrote: > > On Dec 2, 2010, at 12:04 PM, Andrew R. Kinnie wrote: > >> I might try that as well. It's one of the reasons I used Openbase >> originally, and Scott was always helpful. A similarly simple option now >> would be ideal. This is not going to be a huge database or get a lot of >> traffic. Not to mention I work for beer and eats. > > FWIW, FB is probably the better choice for a huge database. MySQL might well > outperform it for smaller datasets. But it does not sound like performance > is an issue for this app in any event. > > Chuck > > >> On Dec 2, 2010, at 3:01 PM, Chuck Hill wrote: >> >>> Just FYI, if what you are looking for is "free" and "just works", FrontBase >>> is a better choice than MySQL. IMHO. No admin, no dicking around with >>> configurations. >>> >>> Chuck >>> >>> >>> On Dec 2, 2010, at 11:59 AM, Andrew R. Kinnie wrote: >>> >>>> Ok, well that all sounds useful and helpful. Though at this point I have >>>> done little more than download mysql and sequel pro, then create a >>>> datamodel that matched my old openbase structure with som minor >>>> improvements (such as using lookup tables) >>>> >>>> So most of this may as well be Swahili at this point. >>>> >>>> One dumb question though... Will starting innodb in an existing database >>>> cause issues? >>>> >>>> Sent from my iPhone >>>> >>>> On Dec 2, 2010, at 1:36 PM, Kieran Kelleher <[email protected]> wrote: >>>> >>>>> InnoDB is free. It is a transactional database engine. MyISAM is for >>>>> logging and should not be used for relational databases where data >>>>> integrity matters. >>>>> >>>>> It is mandatory for WebObjects EOEditingContext >>>>> save/transaction-fail/rollback to work. >>>>> >>>>> If you existing databases and/or table-names have any uppercase in them, >>>>> convert those first before using the 'lower_case_table_names' option. >>>>> Also that option is important only if developing on Mac/Win and deploying >>>>> on Linux >>>>> >>>>> >>>>> Regards, Kieran >>>>> >>>>> PS. InnoDB can be faster than MyISAM since it caches rows in available >>>>> memory, whereas MyISAM only caches indexes in memory and must go to disk >>>>> for rwo data that is not available in the index used for the query. >>>>> >>>>> PPS. For low-effort high performance, try to ensure your memory >>>>> allocation to mysql is equal to the size of your dataset, also tell >>>>> innodb how much memory it can have in the /etc/my.cnf ...... hopefully I >>>>> can do a session at WOWODC next year, if Pascal approves, entitled "MySQL >>>>> for WebObjects Engineers" ..... which should hopefully save people having >>>>> to go learn more than they need to know to find out the bits they need to >>>>> know. ....... and maybe create a few well-documented boilerplate my.cnf >>>>> files for common dev-machine and server configs. >>>>> >>>>> >>>>> >>>>> On Dec 1, 2010, at 9:39 PM, Pascal Robert wrote: >>>>> >>>>>> At a minimum, create a file called my.cnf in /etc , and add this text in >>>>>> the file: >>>>>> >>>>>> [mysqld] >>>>>> lower_case_table_names = 1 >>>>>> default-storage-engine = InnoDB >>>>>> >>>>>> And restart MySQL. EOF will be more happy. The default table type in >>>>>> MySQL is MyISAM, which is fast but is not transactions safe (and it auto >>>>>> commit). >>>>>> >>>>>>> OK, so InnoDB appears to be part of the MySQL Community Server. I'll >>>>>>> have a look. Thanks. >>>>>>> >>>>>>> >>>>>>> On Dec 1, 2010, at 9:24 PM, Chuck Hill wrote: >>>>>>> >>>>>>>> It is free. Look in the community edition. >>>>>>>> >>>>>>>> >>>>>>>> On Dec 1, 2010, at 6:24 PM, Andrew R. Kinnie wrote: >>>>>>>> >>>>>>>>> eesh. I'm not being paid for my time (except in beer and wings) so I >>>>>>>>> don't think I can do a commercial transaction engine. :-/ >>>>>>>>> >>>>>>>>> Is there something else that is effectively free for something this >>>>>>>>> small? >>>>>>>>> >>>>>>>>> On Dec 1, 2010, at 9:09 PM, Chuck Hill wrote: >>>>>>>>> >>>>>>>>>> >>>>>>>>>> On Dec 1, 2010, at 6:06 PM, Andrew R. Kinnie wrote: >>>>>>>>>> >>>>>>>>>>> I don't know what InnoDB is, so I'd have to say no. >>>>>>>>>> >>>>>>>>>> I don't use MySQL. But I do know that MySQL without InnoDB is... >>>>>>>>>> not something I would trust data to. Check the Wiki or search for >>>>>>>>>> posts on this by Kieran. >>>>>>>>>> >>>>>>>>>> >>>>>>>>>>> I did delete all the bookings and add new ones. No change. :-/ >>>>>>>>>>> >>>>>>>>>>> The bookings for the feature are still not appearing either, even >>>>>>>>>>> though they are new, but I assume that's a different issue. >>>>>>>>>> >>>>>>>>>> Could be lack of InnoDB, but more likely something wrong in your app >>>>>>>>>> or model. >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> Chuck >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> On Dec 1, 2010, at 9:01 PM, Chuck Hill wrote: >>>>>>>>>>> >>>>>>>>>>>> On Dec 1, 2010, at 5:58 PM, Andrew R. Kinnie wrote: >>>>>>>>>>>>> On Dec 1, 2010, at 8:42 PM, Chuck Hill wrote: >>>>>>>>>>>>> On Dec 1, 2010, at 5:35 PM, Andrew R. Kinnie wrote: >>>>>>>>>>>>>> >>>>>>>>>>>>>>> Hmm. That was checked, but set as false. In any event, I was >>>>>>>>>>>>>>> using an auto-increment. I gather I should remove this? EOF >>>>>>>>>>>>>>> will do the right thing and create it's own pk? >>>>>>>>>>>>>> >>>>>>>>>>>>>> Yes. Auto-increment does not mix well with data created from >>>>>>>>>>>>>> EOF. >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>>> I changed the debug enabled to true and got this in the console >>>>>>>>>>>>>>> when I tried to delete a duplicate: >>>>>>>>>>>>>> >>>>>>>>>>>>>>> ... >>>>>>>>>>>>>>> SELECT t0.AGENT_ID, t0._rowid, t0.COMIC_ID FROM BOOKING t0 FOR >>>>>>>>>>>>>>> UPDATE >>>>>>>>>>>>>>> ... >>>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> That is a pretty clear sign that EOF is visibly upset. :-) See >>>>>>>>>>>>>> if removing the auto-increment helps. >>>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> I already tried that and it didn't help. :-/ >>>>>>>>>>>>> >>>>>>>>>>>>> Of course now the other issue is that the bookings for the >>>>>>>>>>>>> feature act are not showing up at all. >>>>>>>>>>>>> >>>>>>>>>>>>> This is a new site. Am I better off just deleting all the >>>>>>>>>>>>> bookings and adding new ones? (there's only about 25 of them) >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> That is worth a try. If you created data with auto-increment and >>>>>>>>>>>> don't have the FK constraints enforced in the database, the >>>>>>>>>>>> relationships might be broken (bad data). >>>>>>>>>>>> >>>>>>>>>>>> Are you running MySQL with InnoDB? >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> Chuck >>>>>>>>>>>> >>>>>>>>>>>> -- >>>>>>>>>>>> Chuck Hill Senior Consultant / VP Development >>>>>>>>>>>> >>>>>>>>>>>> Practical WebObjects - for developers who want to increase their >>>>>>>>>>>> overall knowledge of WebObjects or who are trying to solve >>>>>>>>>>>> specific problems. >>>>>>>>>>>> http://www.global-village.net/products/practical_webobjects >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> Chuck Hill Senior Consultant / VP Development >>>>>>>>>> >>>>>>>>>> Practical WebObjects - for developers who want to increase their >>>>>>>>>> overall knowledge of WebObjects or who are trying to solve specific >>>>>>>>>> problems. >>>>>>>>>> http://www.global-village.net/products/practical_webobjects >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> Chuck Hill Senior Consultant / VP Development >>>>>>>> >>>>>>>> Practical WebObjects - for developers who want to increase their >>>>>>>> overall knowledge of WebObjects or who are trying to solve specific >>>>>>>> problems. >>>>>>>> http://www.global-village.net/products/practical_webobjects >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> _______________________________________________ >>>>>>> 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/probert%40macti.ca >>>>>>> >>>>>>> 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/kelleherk%40gmail.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/chill%40global-village.net >>>> >>>> This email sent to [email protected] >>> >>> -- >>> Chuck Hill Senior Consultant / VP Development >>> >>> Practical WebObjects - for developers who want to increase their overall >>> knowledge of WebObjects or who are trying to solve specific problems. >>> http://www.global-village.net/products/practical_webobjects >>> >>> >>> >>> >>> >>> >>> >> > > -- > Chuck Hill Senior Consultant / VP Development > > Practical WebObjects - for developers who want to increase their overall > knowledge of WebObjects or who are trying to solve specific problems. > http://www.global-village.net/products/practical_webobjects > > > > > > > _______________________________________________ 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]
