Re: [GENERAL] [Q] DNS(bind) ER model

2008-08-23 Thread Stefan Kaltenbrunner
Andrew Sullivan wrote: On Fri, Aug 15, 2008 at 09:54:26PM +0200, Tino Wildenhain wrote: looks like you want to write your own powerdns ? :-) http://www.powerdns.com/ Oh, right, I forgot they use a SQL back end. They do EDNS0, too :) (Note, however, that if you plan to deploy DNSSEC you're

Re: [GENERAL] [Q] DNS(bind) ER model

2008-08-17 Thread Mark
On Thu, 2008-08-14 at 16:20 -0700, Roderick A. Anderson wrote: Anyone aware of an ER model for holding name server records? Working on the zone file data and I am getting close but keep running into the differences between MX records (with a priority) and the others that can hold either a

Re: [GENERAL] [Q] DNS(bind) ER model

2008-08-17 Thread Roderick A. Anderson
Mark wrote: On Thu, 2008-08-14 at 16:20 -0700, Roderick A. Anderson wrote: Anyone aware of an ER model for holding name server records? Working on the zone file data and I am getting close but keep running into the differences between MX records (with a priority) and the others that can hold

Re: [GENERAL] [Q] DNS(bind) ER model

2008-08-15 Thread David Goodenough
On Friday 15 August 2008, Roderick A. Anderson wrote: Anyone aware of an ER model for holding name server records? Working on the zone file data and I am getting close but keep running into the differences between MX records (with a priority) and the others that can hold either a

Re: [GENERAL] [Q] DNS(bind) ER model

2008-08-15 Thread Andrew Sullivan
On Fri, Aug 15, 2008 at 10:26:54AM +0100, David Goodenough wrote: Have you looked at mydns? It is a database driven DNS server - and it works just fine with Postgresql. Given that the references section of its documentation doesn't include a number of important RFCs, are you quite sure it's

Re: [GENERAL] [Q] DNS(bind) ER model

2008-08-15 Thread Roderick A. Anderson
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

Re: [GENERAL] [Q] DNS(bind) ER model

2008-08-15 Thread Roderick A. Anderson
David Goodenough wrote: On Friday 15 August 2008, Roderick A. Anderson wrote: Anyone aware of an ER model for holding name server records? Working on the zone file data and I am getting close but keep running into the differences between MX records (with a priority) and the others that can

Re: [GENERAL] [Q] DNS(bind) ER model

2008-08-15 Thread Andrew Sullivan
On Fri, Aug 15, 2008 at 07:44:36AM -0700, Roderick A. Anderson wrote: 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

Re: [GENERAL] [Q] DNS(bind) ER model

2008-08-15 Thread Steve Atkins
On Aug 15, 2008, at 12:16 PM, Andrew Sullivan wrote: On Fri, Aug 15, 2008 at 07:44:36AM -0700, Roderick A. Anderson wrote: 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

Re: [GENERAL] [Q] DNS(bind) ER model

2008-08-15 Thread Tino Wildenhain
Roderick A. Anderson wrote: Anyone aware of an ER model for holding name server records? Working on the zone file data and I am getting close but keep running into the differences between MX records (with a priority) and the others that can hold either a domain/sub-domain/host name or an IP

Re: [GENERAL] [Q] DNS(bind) ER model

2008-08-15 Thread Andrew Sullivan
On Fri, Aug 15, 2008 at 09:54:26PM +0200, Tino Wildenhain wrote: looks like you want to write your own powerdns ? :-) http://www.powerdns.com/ Oh, right, I forgot they use a SQL back end. They do EDNS0, too :) (Note, however, that if you plan to deploy DNSSEC you're out of luck with them.

Re: [GENERAL] [Q] DNS(bind) ER model

2008-08-15 Thread Roderick A. Anderson
Steve Atkins wrote: On Aug 15, 2008, at 12:16 PM, Andrew Sullivan wrote: On Fri, Aug 15, 2008 at 07:44:36AM -0700, Roderick A. Anderson wrote: 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

Re: [GENERAL] [Q] DNS(bind) ER model

2008-08-14 Thread Martin Gainty
Mr Anderson-you use an enum to indicate your DNSrecordtype as in this MySQL exampleCREATE TABLE dns_updates| Field |Type | Null | Key | Default | Extra || id| int(11) | NO | PRI | NULL | auto_increment || bd_order_id| int(11) | YES | | NULL

Re: [GENERAL] [Q] DNS(bind) ER model

2008-08-14 Thread Andrew Sullivan
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