On my project we use bit operators everywhere, usually in the context of a "flags" column with states such as: inactive, hidden, deleted, etc.... This allows developers to not worry about altering a table to add flag value to the ENUM. Would be nice to be able to index the bit fields though.
M On Fri, Aug 1, 2008 at 1:40 PM, Brian Aker <[EMAIL PROTECTED]> wrote: > Hi! > > Any feelings from the audience on the BIT operators? > > A couple of notes: > 1) I am not talking about BOOL > 2) SET/ENUM give you BIT operations at an abstracted level (aka not BIT > math which few folks know now a days). > 3) Not matter what in Drizzle a BIT costs 1byte, so there is no real > storage save that people magically assume. > 4) We are not an analytics solution (we will be keeping ROLLUP though!). > > Personally I do not believe these belong in the database, and I do not > consider them user friendly. > > Cheers, > -Brian > > -- > _______________________________________________________ > Brian "Krow" Aker, brian at tangent.org > Seattle, Washington > http://krow.net/ <-- Me > http://tangent.org/ <-- Software > _______________________________________________________ > You can't grep a dead tree. > > > > > _______________________________________________ > Mailing list: > https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss> > Post to : [email protected] > Unsubscribe : > https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss> > More help : https://help.launchpad.net/ListHelp >
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
