[bind10-dev] MySQL vs PosgreSQL data source flamewar - FIGHT!

[Michal 'vorner' Vaner]

Hello

On Thu, Jan 10, 2013 at 02:24:29PM +0100, Shane Kerr wrote:
> Rather than spend a lot of efforts making hacks with more-or-less work
> around the problem, we should spend this time implementing support for
> an SQL data source that does not have these limitations. We intended
> this from the very beginning.

+1

> Arguments for MySQL:
> 
> * We use it for the first DHCP lease database store.
> * Developers tend to like it.

Also, Jinmei had some working experiment with mysql AFAIK. We could use it as a
base or inspiration of the work.

And, I in my impression it might be already installed on more systems than
postgre, so the admin would have one dependency less to solve. But maybe that's
true only in the linux world and it's exactly opposite in *BSD systems.

> * We are missing a bit of functionality:
>   https://lists.isc.org/pipermail/bind10-dev/2012-October/003868.html
>   We can work around this, but it is additional work.

I tend not to like this much. We have some amount of workarounds for Sqlite3, we
would have a workaround in postgre. I'd like to see one „clean“ implementation.

For these reasons, I'd have a slight preference for mysql (btw. we probably
should check it is compatible both with mysql and its fork mariadb).


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?
 • Should we solve the problem of names that are not representable in current
   implementation? I think there was some problem with escaping and the correct
   order.

With regards

-- 
Please enter password:

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/20130110/4c67d282/attachment.bin>