Web application for multiple people

Question

I see many web applications that can be used for various companies.

How do they do it? They create only one bank and share between these various customers?

For example:

Company A has 10 users and Company B has 5 users of this system. They use different databases from company A and B, or through relational mapping of tables one achieves this?

Or what technology they employ for that?

Answer 1

There are both forms and even a hybrid form (part of the application accesses shared database and part uses alone). This can still vary whether companies are different customers or companies within the group. Each with its advantages.

There is no specific technology, can be applied virtually to any technology.

One of the forms of this technique is called multitenancy.

Particularly, in the vast majority of cases, I think having a database for each company is a better solution. It gives more flexibility to scale, to customize, it is easier to give more security, in short, it has a lot of specific advantages that are not the case. It takes more work to update, has more costs. It can automate to a certain extent. It depends on the application, depends on the need for data consolidation and a number of other technical and political factors. It takes extra work to keep it all together.

In some cases you don’t need to have separate seats, but yes schemas.

If you have specific questions applying the technique, go posting.