What is the best way to manage users and companies on a project with rails in the databases engine?

Question

I want to work in a project for enterprises. But I don't know that is most recommendable. For example, it is better that my rails app to create a database per enterprise when these create a account. I am thinking this because if a day the database of an enterprise have a problem not affect to other enterprises.

I want to do a project in which each time a company signs up this using your own database. In simple terms I do not want to cross the data, therefore, if a user has two companies for example can handle separately and stored in separate databases. This practice I have seen in the ERP software, where the person buying the product can manage your different businesses. Obviously the database will have the same design in common for all, but it's like creating two instances of the database in simple words.

Thanks

Answer 1

Check out a gem called "Apartment", which does exactly what you want:

https://github.com/influitive/apartment