Given the information you have supplied, almost any database on the market would suit your needs.
The influencing factors are not usually performance (that is determined as much by application/schema design as by the RDBMS and can be mitigated by a variety of caching and/or distributed mechanisms), but features and availability. For example, you may want some of the features offered by Oracle 10g - but try finding a hosting provider in your price range! MySql tends to be more widely supported by ISPs than Postgres or at a lower cost but this is not always the case. Postgres has some nice features that are missing or incomplete in MySql but these can be often worked around in the application tier. You should also be asking yourself about some of the essential user requirements. For example: full text search is available for MyISAM but not InnoDB, but you can mix and match table types in a single database or use cake to read from different databases. I believe Postgres relies on contrib modules to fulfill this requirement. The great thing about cake is that you can swap in and out databases with very little hassle (provided all your logic is in the application tier), so take Chis' advice: "Just build it, damnit!" :) ~GreyCells On Mar 9, 7:43 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > I'm in the planning stage of what will hopefully become my first non- > trivial web app. I'm trying to minimize future pain resulting from > poor planning, and have been reading up on DB trivia. > > If I use MySQL, how do I choose between MyISAM and InnoDB? What are > the trade-offs? It seems InnoDB is the way to go if I want to handle > rollbacks and such, but MyISAM may produce considerably shorter query > times. Is this true? > > Should I use PostreSQL instead? I find the popularity of MySQL > comforting, but the PostreSQL crowd has some convincing zealots. > > At the end of the day, I'm not doing anything too complicated, and I > just want to minimize DB-related stress in the long run. > > Thanks in advance. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
