Hi!
On Aug 1, 2008, at 2:37 PM, Pete Kruckenberg wrote:
I've seen BIT operators used in situations dealing with IP addresses
(i.e. network/security management applications). For example, to
determine if an IP address is part of a given network range (network
number and netmask), I bitwise AND the IP address with the netmask,
then compare the result to the network number.
I would rather hand folks functions for these (though I take your
point about being able to do this).
I have patches for both IPADDRESS and IPADDRESSV4. The question has
been how to handle these types.... have both? Have one?
If you can answer that, I can punch them in quickly.
Queries which group rows of IP addresses by network range would use
the BIT operators, as would queries which search rows of network
ranges for those that cover specific IP addresses.
I'd guess that work-arounds can be found for most situations (i.e.
pre-calculate the starting and ending IP address for a range and use
BETWEEN()), but there may be some that require BIT operators.
Yep. Though the issue with doing this is you assume a four byte into
which can represent IPV4.
Cheers,
-Brian
Pete.
On Fri, Aug 1, 2008 at 2: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
_______________________________________________
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
