tags:

views:

82

answers:

1
Q: 

Best structure for centralized User DB over multiple membership-driven sites?

We've built a social networking site for a client. It did very well and now they want to package it up and license multiple copies of the same site but branded for their client.

Each site is fairly autonomous except that users on one site can access the content from users on another site, requiring that user profiles be centralized.

We have an idea of how we're going to set this up but what would you do to make it functional and scalable?

A: 

Perhaps look into OpenID like SO has. The only thing you'd need to do is convert the existing site, but then the users will have to re-register ... or ... you could offer OpenID on the original site as a secondary login method for those users who want cross-site membership.

HardCode  2009-03-27 03:28:19
While OpenID is very cool, it doesn't guarantee a consistency of crossover since i'll need to accommodate both OpenID users and non-OpenId users.
jerebear  2009-03-27 03:40:55
Yes, for the first site if you already deployed it. Either way, unless you port the security scheme in "site #1" off into its own database, and never change anything, site #1 will need some kind of change, or layer transparent to the users.
HardCode  2009-03-28 02:58:19

related questions

How do you determine how far to normalize a database?
Tips for database design in a web application
How do you deal with polymorphism in a database?
Database Patterns
Is it okay to have a lot of database views?
Extra tables or non-specific foreign keys?
Implementing a '20 Questions'-like Wizard in a Database
Database Design for Revisions?
Which database table Schema is more efficient?
How do you build a ratings implementation?
How should I model a field that can contain both numeric and string values in SQL Server 2005?
What if analysis on multi dimensional cubes (OLAP)
Data model for a extensible web form
Database Schema Diagram Design Tool
Good strategy for leaving an audit trail/change history for DB applications?
How do you recommend implementing tags or tagging
One database or many?
Suitable E-R notation for introductory DB design course? Good/free diagram tools?
What is the best strategy for retainment of large data sets?
Query a union table with fields as columns.
When is a file just a file?
Database triggers
What are the advantages of using a single database for EACH client?
Database, Table and Column Naming Conventions?
Auto Generate Database Diagram MySQL