nanog mailing list archives
RE: Where did freeipdb IP utility site go?
From: Barry Shein <bzs () world std com>
Date: Fri, 27 Jul 2007 12:40:59 -0400
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. 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. -- -Barry Shein The World | bzs () TheWorld com | http://www.TheWorld.com Purveyors to the Trade | Voice: 800-THE-WRLD | Login: Nationwide Software Tool & Die | Public Access Internet | SINCE 1989 *oo*
Current thread:
- Where did freeipdb IP utility site go? Brian Raaen (Jul 25)
- Re: Where did freeipdb IP utility site go? Ingo Flaschberger (Jul 25)
- RE: Where did freeipdb IP utility site go? Scott Berkman (Jul 25)
- RE: Where did freeipdb IP utility site go? Joseph W. Breu (Jul 26)
- Re: Where did freeipdb IP utility site go? randal k (Jul 26)
- <Possible follow-ups>
- RE: Where did freeipdb IP utility site go? Brandon Butterworth (Jul 26)
- RE: Where did freeipdb IP utility site go? Barry Shein (Jul 27)
- Re: Where did freeipdb IP utility site go? Jared Mauch (Jul 27)
- Re: Where did freeipdb IP utility site go? Andrew Sullivan (Jul 27)
- RE: Where did freeipdb IP utility site go? Barry Shein (Jul 27)