Member Avatar for titosd

Hello,

I developed web software.
And I have multi clients for this software.

I need your help to give me an idea for manage all this clients.
I"m Now built for every client a new database, but i discover that this idea nor good, because i want to get statics for every client from special API

I hope that you can help me for design the DB and to give idea to do the DB more effective


Thanks

  • 2 Contributors
  • 1 Reply
  • 57 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by BitBlt
Member Avatar for BitBlt

Pretty simple. Just add a ClientId column to appropriate tables in your data structure, then alter your web software to specify ClientId as part of the SQL you use to query the data.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.