1
Good people, I thank you for being here helping me, come on.
I’m having a question I’m having a hard time getting answers to.
Let’s say I’m creating a system, OK. In this system each company will have user visiting their page, and here comes my question :/
These companies would have the same databases, but each with different information.
Then I wonder, I just make a database with all these companies and their respective items related to your company
Or
A database for each company, REMINDING q all will appear on a single page.
(For me a database would be right, but here comes the one to grieve for it support all companies and their items)
What do you guys have to say ?
Another related question (if you choose to have a single database serving multiple clients)
– mgibsonbr
Guy with this post VC mentioned I did not understand very well. . according to him the correct is to work with only 1 database supporting companies with their related items to foreign key base. My fear is to regret too much by accumulating too much information ... This will happen ?
– Pedro Soares
The problem with this type of question is that it is very broad and practically out of scope. Either you can post a very generic answer or you need to have so much detail that you will become a consultant. And detail is missing in the question. I even understand that those who are still learning have a hard time dealing with it, but there is no absolute answer to this. And one specific one depends on complete consulting. It’s better to close as a duplicate because that is more or less canonical for the subject. Much more specific doubts with a focus can still be made. What had to be said in general has already been there.
– Maniero
It’s hard to get answers because they don’t exist. Not the way you expect.
– Maniero
@Rocks can happen, yes. But don’t prematurely optimize - unless you’re working with a gigantic database (and when you are, you’re sure to have more experience, otherwise it’s impossible to put a database like this in the hands of a beginner)There’s a good chance that problem won’t turn up any time soon. And when it does, there are partitioning techniques that allow you to separate customers into different banks (or other strategies). However, note that there is no right answer, a bank or several banks. There are only pros and cons, and this you will have to weigh.
– mgibsonbr
Poxa :/ just needed some advice from those who are already experienced
– Pedro Soares