Andrew Sullivan wrote:
On Thu, Aug 14, 2008 at 04:20:14PM -0700, Roderick A. Anderson wrote:
Anyone aware of an ER model for holding name server records?
What about a datatype? I have reason to believe that a company I used
to work for implemented such a thing. There was some talk of
releasing it, but I think there was some combination of insufficient
demand, worries about competitive advantage, and concern about long
term support.
Thanks A. I did a quick look and a custom TYPE may be useful.
Because of my involvement in that project, I can't make direct
recommendations about this topic. But supposing one was to go to
various DNS-related lists, it seems to me it wouldn't be that hard to
get information about the wire datatypes such that you'd have enough
information to implement them in Postgres (assuming you know something
about Postgres datatypes).
More research is on the schedule this week-end.
One hint: remember the "unknown" RRTYPE. If you have questions about
RRTYPEs, I'm happy to answer.
Thanks again. This is a pretty specialized application (at this time)
so the RRTYPEs used are limited. I am trying to make the model and Pg
implementation as generic as possible in case it gets released into the
wild later.
Thanks for the offer on the RRTYPEs. Zone files /can/ get pretty hairy
plus the company I'm doing this for gets some strange requests from
their customers -- not always correct or logical. :-(
Rod
--
