LDAP vs SQL database for user authentication/user data storage -


I am starting to use kPPHP for the first time with the hockey project. It seems that KPHP supports LDAP easily enough as well as any DB. If the project is okay, then I am planning to use this site to the general public, which means that there will probably be a lot of users (very relative, I think, I will be stunned in thousands). It grows up, so I can think of running a business with it.

I am aware of the use of LDAP and I am aware of using SQL (specifically MySQL) to track user data. Before starting, I should be with an "easy" SQL or more hierarchical LDAP structure.

I should consider some things:

  1. Unauthenticated users will not be able to use the site
  2. Each user will be able to show access to parts of their profile / data
  3. Depending on the type of user, you have different users "Under your care," such as account management In order to manage individual accounts rather than accounts rather than Ment, this will be the people and information they share with you.

Long story short: Should I apply LDAP to a site that has a hierarchical user / group structure or try to work with SQL? Is LDAP commonly used in the production web application?

Thanks SO

The first thing I see is that the cost of a client access license on your server is You are Linux-based (which seems like your stack), so it's probably zero and you can stop reading ..;)

Microsoft and others have a charge that is quite important This can usually be done for your web server instead of purchasing a cal for each user. A one (or is less than equal) license

In addition, I would say go for it. This is a very safe way to handle authorization with user authentication. Apart from this, many tools are available for managing LDAP accounts.


Comments

Popular posts from this blog

c# - sqlDecimal to decimal clr stored procedure Unable to cast object of type 'System.Data.SqlTypes.SqlDecimal' to type 'System.IConvertible' -

Calling GetGUIThreadInfo from Outlook VBA -

Obfuscating Python code? -