Re: Where did freeipdb IP utility site go?

[Jared Mauch <jared () puck nether net>]

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 () puck nether net
clue++;      | http://puck.nether.net/~jared/  My statements are only mine.