[Wifidog] More MySQL Problems (With Patch) in WifiDog-Auth
bock at step.polymtl.ca
Fri Oct 1 14:04:53 EDT 2004
> On a totally different subject.
> Is there any good reason for having a separate 'administrators' table, with
> just 1 column, instead of just adding a 1bit yes/no column to the 'users'
> table ??
> I know it is more ´correct´ according to database theory, but database
> theory was written when people were trying to save diskspace at all cost
> (including increased CPU overhead and complexity of queries), and we realy
> don´t have the diskspace problem in this database.
There are two reasons I did it that way, whether they are good ones is up to
interpretation. The first is to not polute the user's table with anything
beyond the ID and what is required by the authentication process. The reason
is to allow wifidog to authenticate users elsewhere eventually. Off course,
it's currently missing an abstracting "User" class to make it possible. The
second is for uniformity. Obviously the administrator's table could be
replaced by a flag. But what about the node owners table? Having a somewhat
uniform architecture for security seemed a good idea. Now not much tought
was put into it and it's still in the early stages, so somebody else may code
something much better...
Even if it doesn't sound this way, I didn't spend very much time on the
architecture of wifido-auth, Most decisions I took out of habbit of after 5
minutes of reflexion. So I'm very open to any properly justified change,..
assuming it's accompanied by code ;).
Benoit Grégoire, http://benoitg.coeus.ca/
Wifidog mailing list
Wifidog at isf.waglo.com
More information about the Wifidog