[mythtv] [mythtv-commits] mythtv commit: r21563 by nigel

[Simon Kenyon]

Nigel Pearson wrote:
>>> Prompt for schema upgrades, to give users more testing flexibility.
>>> (e.g. new frontend non-destructively against old backend)
>>>
>> i know this is a feature request without a patch
>> but i would code it up if it was considered worthy of inclusion
> 
> 
> Thanks for the offer, though I suspect that
> the current database backups are enough?
> 
> 
> 
>> euby on rails has a concept of db migrations
>> the difference between what they do and what we do is that you can go
>> back as well as forward
> 
> I'm not a database theory expert, but from memory
> there were some situations that it is impossible,
> or very difficult, to rollback from?

this may well be true
but i will have a look and see if it is possible

i suppose the thing about rails is that when you code up the migration,
you supply the upgrade and the downgrade - so maybe that constrains the
changes to those that will go both ways

regards
--
simon