Best practices for data storage?

[Victor Rajewski]

Hi Folks,

I'm developing an app for the apps marketplace, but am unsure how best to segregate data between different domains. I can envisage:

• keeping a single database, with a domain attribute in each of my models/tables
• creating a separate database for each domain
• creating a separate app instance for each domain

What are the pros and cons of each of these, and are there any other possibilities I've missed? In the latter two is it possible to automate the database or instance creation when a new domain joins?

I will be using python/django for the app.

Cheers,

Victor