Where did freeipdb IP utility site go?
Jared Mauch
jared at puck.nether.net
Fri Jul 27 17:04:38 UTC 2007
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 jared at puck.nether.net
clue++; | http://puck.nether.net/~jared/ My statements are only mine.
More information about the NANOG
mailing list