[bind10-dev] #1376 will require upgrading sqlite3 database file

[Shane Kerr]

Jinmei,

On Thu, 2011-11-17 at 14:51 -0800, JINMEI Tatuya / 神明達哉 wrote:
> I've completed initial development of sqlite3 (storing IXFR diffs to
> the data source).  If we merge this as it is, however, IXFR-in will
> not work for older versions of sqlite3 database files that don't have
> the "diffs" table.
> 
> How should we solve this issue?
> 
> If this is a matured product, I suspect there's no other option than
> introducing transparent migration hack within our source code.  But
> since BIND 10 is still in a relatively early development phase
> involving many other backward incompatible changes, I personally would
> rather avoid making the code dirtier (and more difficult to maintain)
> due to such workaround that will be of no use for most of the lifetime
> of the software.
> 
> So my suggestion is to provide a separate python script or something
> to upgrade the database file and ask the user to run it before
> upgrading BIND 10 itself.  We'll eventually (after several snapshot
> releases maybe) remove this script from the tar ball.

> Opinions?

I think we need a utility for this. Here is a ticket I made 6 months ago
with my thoughts on this:

http://bind10.isc.org/ticket/963

:)

I was in favor of automatic upgrades because I have systems that do it
and it's nice, but realistically it can cause major problems if done on
a large system. Think of the poor administrator who's system does a
database upgrade taking 6 hours after an upgrade... "automatically". :(

--
Shane