Hi, my question is about creating right db architecture. Application will be served in sas model, which means that every client should have its own instance of the application.
In case of yiiframework I asume its always one base instance. But how do You deal with creating new account in case of db? Do You create new database for each client or do You model database in traditional manner (I mean all client s are managed in the same big database).
Having a database per user is going to be a BIG ballache. You’ll be faced with a number of challenging problems around synchronizing reference tables, and managing who owns what DB. Don’t forget, KISS.