[bind10-dev] "captive" vs. open databases, was MySQL vs PosgreSQL data source flamewar - FIGHT!

[Michal 'vorner' Vaner]

Hello

On Fri, Jan 11, 2013 at 12:30:20PM +0100, Shane Kerr wrote:
> 2. Data
>    Here we dictate the schema, but you can insert data if you are
>    careful. We have options here, depending on database support.
> 
>    For example we might provide utility functions to allow users to
>    add/remove zone data that fills in our specific fields properly and
>    possibly manages SOA values. For databases with stored procedures
>    we can even do this in the database itself. We need to consider how
>    to cause NOTIFY to work, if we want to do that.
> 
>    But at the basic level we can just say... "be careful". :)

This is just too similar to 1. If you have to hop through the loops (eg. fill in
rname, etc…), you can just as well use DDNS and let bind10 handle the database.
Not that it would be completely the same, but the main advantage of 3., that you
can use the data you already have in your database for other purposes, is just
not available.

> 3. Schema
>    Here administrators can provide any old schema, as long as we can be
>    told how to get the information out, as you propose by having
>    specific queries defined (this is how PowerDNS does it, IIRC).
> 
>    In this case we probably want to live without zone history, so IXFR
>    and the like would be disabled. It is possible to support such a
>    thing, but that's probably a research project rather than a common
>    use case. Nice to have eventually, but...

Well, I see some options here. IMO it does make sense to have a read-only mode
here, something else maintains the database and we just query it. But having the
history is nice, because you then can provide IXFR-out, which is a good thing
with larger zones.

Then we could have an optional configuration values for things like „Get me the
differences between version this and that“. I don't see much added complexity
(maybe except the handling to detect if all queries for particular feature are
configured).

I'm thinking about the master having the database, and slaves be synced the
usual way over DNS.

With regards

-- 
  vvvvv
 oOOOOO<  Death to the bugs!

Michal 'vorner' Vaner
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: Digital signature
URL: <https://lists.isc.org/pipermail/bind10-dev/attachments/20130111/af12ac9e/attachment.bin>