[Wifidog] More MySQL Problems (With Patch) in WifiDog-Auth SQLcode,

Benoit Grégoire 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 mailing list