North American Network Operators Group Date Prev | Date Next | Date Index | Thread Index | Author Index | Historical Re: Where did freeipdb IP utility site go?
On Fri, Jul 27, 2007 at 12:40:59PM -0400, Barry Shein wrote: > > > > > > > Are there any "good" tools for IPv6 address management? > > > > Is there a "BCP" (convention, whatever) for storing IPv6 addresses > into SQL databases? Particularly where you need to mix them with IPv4 > addresses. PostgreSQL supports this. Check out the data types. (yes, 8.2 is the latest, but google to the first hit is easier) http://www.postgresql.org/docs/8.0/interactive/datatype-net-types.html#DATATYPE-INET > I know postgresql has an ipv6 type but I was hoping for something more > portable. The best I could come up with was packed decimal(39) and > assume that if more than 32 bits are set it's IPv6 (ignoring the > special case of all zeros etc.) The other would be to just use 4 > unsigned long ints similarly but it makes comparison and other ops > clunky. um, lots of folks have written modules for almost every language to do ip/subnet comparisons for both v4 and v6. While I can understand the desire to use locally derived code, etc.. it does make sense to not reinvent the wheel daily :) OT: Speaking of which, someone know of something like the multicast beacon software that works for unicast stuff that is "free"? I've wanted to make some udp-like probe matrix like this and with all the folks that are asking about cogent, l3, etc.. outages was thinking that a user community of this type of a test matrix could be interesting :) Think like the "internet health report" but with more sites (possibly hundreds). - jared -- Jared Mauch | pgp key available via finger from [email protected] clue++; | http://puck.nether.net/~jared/ My statements are only mine.
|