Hi!
On Aug 1, 2008, at 1:58 PM, Michael Stoppelman wrote:
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.
Our ENUM should not cause a rewrite of the table (aka it is an online
operation).
Are you using the BIT operators in SQL, or in your application, and
just storing?
Would be nice to be able to index the bit fields though.
You can sort an ENUM, what are you wanting? Sorting requires a
collation. Would you want to create one?
Cheers,
-Brian
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
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
--
_______________________________________________________
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
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
