2

I've got several applications and websites that will be built around one main application. In a perfect situation users will be able to register once and be able to log into the different applications and websites using that single account. The different parts will be:

  • Main application (Windows application) that uses the account to get access to it's features and to the server.
  • Second application with it's own specific tasks (Also a Windows Application) that uses the account to get access to it's features and to the server.
  • Main website which is based on Wordpress. The website has a bbPress forum that would use the account.
  • Data server which can be accessed for specific data using the account.

Most of the data that the users have will be the same for the different applications and websites so to me it seems that having a database for each separate part would complicate things more than having one database for everything.

My main concern is the Wordpress site and bbPress forum because of the fact that these already have their own account systems.

What would be a valid approach? Using one of the existing databases from Wordpress or the forums with the risk of having a lot of Wordpress/bbPress specific data with the accounts or making a database especially for the other applications and websites and somehow linking those to the website and forum databases? Would the valid approach be secure for use by these different applications and websites?

  • 1
    Are you more concerned about database purity (I would have a totally new dataabasee) or about users having multiple logins? It might be a trade-off when good design & user experience, – Mawg Nov 28 '14 at 14:00
  • The main reason for me is that I want to prevent my users from having multiple logins. Of course I do want to keep my databases as clean as possible. – Tim Dec 1 '14 at 8:16
1

I would recommend separate databases for the applications and one database for the user accounts.

I would put any fine-grained access control within the individual applications.

I would also look to make the one 'user database for the user accounts' be accessed via an authentication service using industry standard protocols such as LDAP.

  • I'm going to try to realize it with a separate database like you said. There should be some way to re-route just the accounts of the existing applications to the new database. Thank you for the help! – Tim Dec 1 '14 at 8:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.