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

[Shane Kerr]

Michal,

On Thursday, 2013-01-10 15:11:12 +0100, 
Michal 'vorner' Vaner <michal.vaner at nic.cz> wrote:
> Also, speaking about new database implementation, I think there might
> be two more questions to answer first:

>  • Should it be „captive“ as current sqlite3, or should we allow
> external applications to modify it? And, should we allow configuring
> the database backend with exact SQL queries, so different schemas
> might be supported? 

There are 3 different levels of freedom with databases:

1. None
   We control the schema, and all data in the database. DO NOT TOUCH.
   This is still useful because we have quick startup and low memory
   use, and if we use a database you have installed for other reasons
   it is no additional administrator overhead.

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". :)

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...

Cheers,

--
Shane
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: not available
URL: <https://lists.isc.org/pipermail/bind10-dev/attachments/20130111/470ab06a/attachment.bin>