[Pdns-users] Suggestion....

[Julian Mehnle]

Mark Martin wrote:
> This is trivial in the scheme of things, but, would it be possible to
> include in the db record, the decimal of the IP address?  This would
> enable front end providers to 'order' the ip addresses in the forward
> records, and better suits the db (i.e. a key....).

Let me guess, you are using MySQL?

In reality there are RDBMSes that _do_ support an IP address datatyle 
natively and that sort that datatype correctly, such as PostgreSQL.  
There's really no point in adding redundant data to the tables just to 
accommodate ignorant database systems.

If your RDBMS supports views, you can store IP addresses in integer format 
and generate the data required by PowerDNS on the fly from that.  Or you 
could make custom SQL queries in PDNS to do the same.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20060825/dd69322c/attachment-0001.sig>