4 ms·
FWIW, I'm no expert but... I don't really see much of a security benefit to "one DB per customer". The actual data will be stored on the same disks, the querie
by idan 16y ago
FWIW, I'm no expert but...
I don't really see much of a security benefit to "one DB per customer". The actual data will be stored on the same disks, the queries issued to through the same DB processes. This seems like a huge amount of overhead for very little realized gain.
- edanm 16y agosnprbob86's point from another comment makes sense: it gives you more control. For example, doing staged rollouts of different features for different customers, etc. I'm not saying it's worth the headaches, but there are advantages.
- snprbob86 16y agoAlso consider behind the firewall installs or premium dedicated hosting. One of the nice things about enterprise software is that you can charge for things like this. If you have a large enough customer, even if you are hosting, you can simply forward to them your bill for a dedicated server.
- yesimahuman 16y agoPoorly crafted and tested SQL queries or django ORM calls accidentally exposing customer information? Shouldn't happen, but it very well could.