[98275] in North American Network Operators' Group
Re: Where did freeipdb IP utility site go?
daemon@ATHENA.MIT.EDU (Andrew Sullivan)
Fri Jul 27 14:15:18 2007
Date: Fri, 27 Jul 2007 14:11:31 -0400
From: Andrew Sullivan <andrew@ca.afilias.info>
To: nanog@merit.edu
Reply-To: Andrew Sullivan <andrew@ca.afilias.info>
In-Reply-To: <18090.8219.502032.960439@world.std.com>
X-SA-Exim-Mail-From: andrew@ca.afilias.info
Errors-To: owner-nanog@merit.edu
On Fri, Jul 27, 2007 at 12:40:59PM -0400, Barry Shein wrote:
> I know postgresql has an ipv6 type but I was hoping for something more
> portable.
I am a PostgreSQL weenie, I admit, but if you can at all use it, I
strongly suggest you use the inet and cidr datatypes in PostgreSQL for
this. Alternatives often give up the data rigour that you get from a
datatype. Portability is often a target that forces you to give up
all the nice features that you got when you chose your RDBMS.
I suppose in other systems, you could put a trigger on a varchar() or
whatever field that would validate the address on the way in. That's
what I'd do if I had to give up the datatype.
A
--
Andrew Sullivan 204-4141 Yonge Street
Afilias Canada Toronto, Ontario Canada
<andrew@ca.afilias.info> M2P 2A8
jabber: ajsaf@jabber.org +1 416 646 3304 x4110