Sorry if this has been asked before:
I am developing a month-to-month service similar to http://www.basecamphq.com/
and planning to operate it on a hosting site. I plan to simply deploy
a copy of my application for each customer with their own database
It doesn't appear as if my provider allows dynamic creation of
databases, which leads to my question: Does it even make sense to
create a production database for each customer or should I modify my
models so that customers share the tables.
This would be a lot of work (24 models) - it would certainly be much
DRYer though. I can imagine it would be a nightmare updating table
elements on 100s of databases...
What do you think? Should I look for a provider that will give me root
access to MySQL or bite the bullet and do the work now?
Thanks in advance.