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 <kelleh...@gmail.com> 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 (Webobjects-dev@lists.apple.com) >>>>>> Help/Unsubscribe/Update your Subscription: >>>>>> http://lists.apple.com/mailman/options/webobjects-dev/probert%40macti.ca >>>>>> >>>>>> This email sent to prob...@macti.ca >>>>> >>>>> _______________________________________________ >>>>> Do not post admin requests to the list. They will be ignored. >>>>> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) >>>>> Help/Unsubscribe/Update your Subscription: >>>>> http://lists.apple.com/mailman/options/webobjects-dev/kelleherk%40gmail.com >>>>> >>>>> This email sent to kelleh...@gmail.com >>>> >>> _______________________________________________ >>> Do not post admin requests to the list. They will be ignored. >>> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) >>> Help/Unsubscribe/Update your Subscription: >>> http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net >>> >>> This email sent to ch...@global-village.net >> >> -- >> 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
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
