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

[Michal 'vorner' Vaner]

Hello

On Thu, Nov 17, 2011 at 02:51:12PM -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?

I think we should have a script which would detect and run all upgrade and
maintenance stuff on the first start, or at last said they need to be run to
the user. In the case of adding a table, I'd say we can safely just do it (it
would be reasonably fast and wouldn't broke the database even if the user was to
downgrade).

After this kind of b10-upgrade-check (which would have separate plugins or
something) script would be run, the rest of the system would start.

We could, of course, provide just the script for now and let the user run it
manually for now. This is just my vision for future.

With regards.

-- 
I have a theory that it's impossible to prove anything, but I can't prove it.

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/20111118/08d00aeb/attachment.bin>