Re: bdbhpt driver - additional data

There is no hard in storing any amount of arbitrary data in the same  
table as the one in which bind-dlz is looking.  I had at one point a  
toggle of "active" that would allow me to turn on and off a zone as as  
measure to quickly disable DNS for an entire zone, but not delete it  
entirely.

You can even used stored procedures, and triggers to do more fancy  
things.  In the end, I found that I was needing too much MySql power  
to keep up with the DNS requests I had coming in, so I went back to a  
non DLZ setup, but what you ask is indeed harmless, and you can be  
very powerful with what you do in your database.
-- 
Scott * If you contact me off list replace talklists@ with scott@ *

On Sep 26, 2009, at 1:18 PM, Chris Hastie wrote:

> I find myself having to move a server over to using bdbhpt due to an
> issue with MySQL, and in putting together a script periodically update
> the bdbhpt database from the MySQL database I find myself wondering...
>
> is there any reason why I should not put a value in dns_zone? My
> experiments seem to suggest bind-dlz has no problem with a value in  
> here
> - have I missed anything?
>
> What I actually want to store is the zone's serial. That way I have an
> easy way to check if the zone needs replacing in the bdbhpt database.


------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf