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. -Adam --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
