In a database-centric application that is designed for multiple clients, I've always thought it was "better" to use a single database for ALL clients - associating records with proper indexes and keys. In listening to the Stack Overflow podcast, I heard Joel mention that FogBugz uses one database per client (so if there were 1000 client...
I am developing a website that will manage data for multiple entities. No data is shared between entities, but they may be owned by the same customer. A customer may want to manage all their entities from a single "dashboard". So should I have one database for everything, or keep the data seperated into individual databases? Is there ...
We are building a multi-tenant website in ASP.NET, and we must let each customer configure their own security model. They must be able to define their own roles, and put users in those roles. What is the best way to do this? There are tons of simple examples of page_load events that have code like: if (!user.InGroup("Admin") ...
In StackOverflow podcast no. 19, Joe describe Fogcreek's decision to have one database PER client instead of one database for ALL clients. That kinda sets me thinking about the following. Assuming I have 1000 users. Each user has 100 clients. Each client has 1000 products. So that means I'm gonna have 1000 x 100 x 1000 = 100,000,00...
Hi everyone, I am working on a PHP application that intends to ease company workflow and project management, let's say something like Basecamp and GoPlan. I am not sure on what the best approach is, database-wise. Should I use a single database and add client-specific columns to each of the tables, or should I create a database for eac...
Hello, I'm changing our application from "one set of code & one database" to "one set of code to multiple databases (one database per customer)". The original code is VS2005 ASP.NET(VB) & lots of XSD's in a separate DLL. The web.config's ConnectionString would override the one stored in the DLL at runtime. Now I need to change the Con...
Having in mind that each webapp has its own separate database (but all databases are in the same database server). The scenario is that I have a multi-tenant saas application - I deploy the same application for each customer. Each customer works on a database that is called db_cid, where cid is the customer id, i.e. a a unique customer ...
what would be the best way to verify URLs in a multi-tenant architecture web-app to make sure that a user from one org does not gets access to the another org's data simply by changing the query string parameters. I dont want to be doing a verification on each page load. the app is being built on ASP.net 3.5. ...
I'm designing an ASP.Net application that must support 'SubSites'. The idea is to have a super admin manage all users, global application settings and SubSites. Each Subsite has a few of its own settings (such as a local admin, logo and welcome message) and each SubSite has its own list of registered users. This is very similar with...
Any experiences with Seam in a one-instance multi-tenant setup? Is Seam suited for that setup? How did you realise it? What were the costs involved? Our situation: A Seam 2.1 SaaS web-app (POJO, no EJB). Available development budget forced us towards a simplistic one-instance per tenant design. The application is not in production yet b...
Hi I think I am not getting the meaning of any of this. My purpose is to create a multi tenant ASP.NET MVC Application. I saw a great post on how to do this here , but Nhibernate isn't an option. One of the things I want to understand is: Is MVC (along with everything else) supposed to help in creating multi tenancy web apps? I have ...
How to design database and organize data if I have two or more domains and one database? All sites for e-commerce purpose and one good can be for sale on each site. So I have only two ideas: I need to create one more field (site_id) in almost every table and duplicate data. I need to create one table with site_id information for all ot...
Are there common patterns people use for creating multi-tenanted applications using Django. The built in "sites" framework seems like an option. Are there other approaches people have had success with? ...
We have a multi-tenant web-based Enterprise application using Hibernate over MySQL. We use Jasper Reports for any reports that our customers require, but now we also need to offer ad-hoc reporting so that Users can run their own queries. How have others accomplished this? I am thinking that I can either: Provide a full export in exce...
I am writing an aspx application that will host 1000's of small customers in a communal SQL Server database. All entities will be created and loaded via Linq-To-Sql. Surrogate keys (identity columns) will be used throughout the schema for all table relationships and so starting with a root customer object I should be able to navigate to...
I don't know what is true or not. Can you advise me? ...
For an Asp.Net software as a service application, I want to do account based subdomains like Basecamp and the rest of the 37Signals products have. E.g. acme.myapp.com will load the account for that customer and pull back only their information. This is easy to do in Ruby on Rails, but how would you handle this functionality in ASP.NET ...
A web application we wrote intended for one customer is going to be product-ized and sold to dozens of companies, and we will be doing the hosting. I could use some guidance about the pros and cons of rolling out a seperate instance for each customer versus going with a single (or very small number of) multi-tenant instances. At first...
Just curious as to how people are tackling multi tenancy using Zend (particularly directory structure, database, modularity, per tenant views, etc.). I haven't found too much myself, anyone? ...
Hi, I was hoping to get some suggestions on some best approaches to develop a multi tenant Django project on Google AppEngine. Some Thoughts to Consider. I would assume using djnago.contrib.sites is a must. I would like to use existing applications such as django-profiles and django-registration, I know their models would need porti...