[44143] in North American Network Operators' Group

home help back first fref pref prev next nref lref last post

IP database ideas

daemon@ATHENA.MIT.EDU (Charles Sprickman)
Wed Nov 7 17:03:59 2001

Date: Wed, 7 Nov 2001 17:03:34 -0500 (EST)
From: Charles Sprickman <spork@inch.com>
To: <nanog@merit.edu>
Message-ID: <Pine.BSF.4.33.0111071659250.23158-100000@shell.inch.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
Errors-To: owner-nanog-outgoing@merit.edu


Hello all,

I just discovered Postgres (after having used MySQL for some time), and it
has some IP datatypes.  I'm looking to stuff all of our IP allocations
into a db for easier allocation/tracking, and I'm just thrilled to see
that I can store IPs/networks natively.

Before I get too far into this, are there any pre-existing packages out
there to help manage IP allocation?  Does anyone have anything homegrown,
and would you be willing to share some pieces, even just a schema, or
advice?  I don't want to dive in and find that I've laid everything out
poorly and painted myself into a corner...

Thanks,

Charles

| Charles Sprickman                  | Internet Channel
| INCH System Administration Team    | (212)243-5200
| spork@inch.com                     | access@inch.com


home help back first fref pref prev next nref lref last post