[bind10-dev] SQL in BIND 10

[Michal 'vorner' Vaner]

Hello

On Mon, Jan 28, 2013 at 06:35:21PM -0500, Robert Edmonds wrote:
> hey, this might sound crazy, but does that second use case strictly
> require that there be a really existing SQL server being used as the
> backing store, or does it only require that the _interface_ of a SQL
> server be provided?  what if the DNS data model were somehow mapped onto
> some subset of, say, the mysql client protocol?  if you had such a
> mapping layer from SQL client -> DNS for "flexible" use cases, your
> backing store could then be any "captive" data store that could support
> the DNS data model... including a SQL server.  in other words, treat SQL
> servers as data stores, and SQL clients as clients speaking a weird
> RPC protocol.

I'm not sure I understand you correctly. So you propose that instead of making
bind10 read data from real database somehow (either to memory or on demand), we
create our own database for DNS data with our specific needs and pretend to be
an SQL server so people can add and remove and query the data through well-known
protocol? I think that could work for some use cases, but that'd be definitely
much more work.

When I hear people want SQL, I usually imagine something like this:
 • They have some complex provisioning system. They store everything in it, from
   salaries to list of computers with locations, names and owners.
 • It's all already stored in some database.
 • There's bunch of web applications, scripts and fat GUI programs working with
   that database.
 • Currently, to get the data to DNS, there's a script that walks the database
   and converts it to a master file. Then it calls some magic to force the server
   to reload it.

I guess the people would really like the last one to disappear and let the
server take the data directly. Not to call anything, just change the data there.
And changing the database is probably completely out of question due to the size
of the rest. So they would say „Connect to server X on port Y with this name and
password. You get a required RRs by sending the query 'SELECT x, y, z FROM a
JOIN b ON a.m = b.n WHERE a.name = %1…'“.

It might be only my imagination, though. However, it illustrates what I mean
when we talk about free database.

With regards

-- 
BOFH Excuse #452:
Somebody ran the operating system through a spelling checker.

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/20130129/c547d83d/attachment.bin>