[Pdns-users] Suggestion....

[Mark Martin]

Julian Mehnle wrote:
> 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.
>   
> ------------------------------------------------------------------------
>
> _______________________________________________
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
> http://mailman.powerdns.com/mailman/listinfo/pdns-users
>   
So I guess it would be safe to say, that all databases that are not like 
postgres
should be destroyed?  Or not used?   Even if your shop, uses one kind and
does not use the other?  For whatever reasons, maybe it is a business 
decision.

Thanks for your input, nonetheless.