Älphä Blüë wrote: > Thanks a bunch Marnen - appreciate the input. I agree with you on your > concept of a teams table. I use mysql and each table houses up to 14 or > 17 fields each. As a great example, look at my present site: > > http://ncaastatpages.com
I'll look, but I rather doubt that the site will tell me a lot about your DB... > > The new site will be a lot better. That's the old php driven site and > it gives you an idea of how much data each table holds. > > I will use your suggestion and create a teams table and assign a team > ID. Do you by chance have a link for an up-to-date foreign keys > migration plugin? I see a bunch of outdated ones and would hate to get > the wrong one. Use the one at Github. I think the URL is http://github.com/harukizaemon/foreign_key_migrations . Check out his other stuff while you're there. > > Also, mysql was using myisam but I can just alter the tables to use > innodb. My worry with innodb was that they require a lot more disk > space. But, if I need to use innodb over myisam I will definitely do > so. MyISAM gets you speed at the expense of referential integrity and transaction support. For most applications, speed isn't at such a premium that MyISAM is at all a good idea. > I'm not all that familiar with postgresql, other than it's similar > to oracle.. Think of it as mySQL without the suckage. :) You don't have to choose between speed and referential integrity; the engine is extensible, so there are GIS solutions that actually work; the procedural language is actually useful; the syntax is closer to the SQL standard...and on and on. I don't recommend mySQL for most applications -- I know it's popular, but it's not that good. Best, -- Marnen Laibow-Koser http://www.marnen.org [email protected] -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
