On 10/20/06, Adam Jones <[EMAIL PROTECTED]> wrote: > > > Chris Cioffi wrote: > > Hello all, > > > > I'm designing a site for some clients and I'm wondering if MySQL or > > Postgres would be more desirable. > > > > The site, as far as they've decided so far, will be transaction > > oriented and contain financial data. They are expecting 1000 > > concurrent users, possibly more, over time. > > Mark has a good point about using tg-admin sql create to make the > database. You can always get the generated sql code and hand modify it > for the install. It should work without further input after that. > > > > > This will be a brand new site so there aren't any legacy issues right now. > > > > I'm more familiar with MySQL but I'm leaning towards Postgres b/c it > > has better transaction support and b/c I'm going to start using Trac > > (which seems to prefer Postgres over MySQL.) > > Are you planning on using Trac on the same systems as this site? If not > I would suggest spending a little time playing with Postgres before you > commit to it. (insert bad transaction/commit/rollback pun here) > Administering a Postgres system is significantly different from working > with MySQL. If the issues Trac has with MySQL are not showstoppers I > think you can probably get MySQL to do what you want here with less > fuss since you already know it.
Trac also doesn't need either, it works fine with SQLite most of the time. In my experience, PostgreSQL is a lot easier to develop for and is far more reliable than MySQL. However, it's not as easy to administer and tune for performance (but I've definitely seen it outperform MySQL when tuned properly, but that's highly application dependent). It's also not as straightforward to replicate. In general I would lean towards what you know how to use... if you use MySQL for a large production site and you don't know what you're doing, you *will* screw it up. Same thing for PostgreSQL. Caveat emptor. -bob --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" 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/turbogears -~----------~----~----~----~------~----~------~--~---
