[mythtv] an idea from ruby on rails

[Andrew Williams]

On 25/01/2008, Simon Kenyon <simon at koala.ie> wrote:
> that is, for every db version, provide both upgrade and downgrade
> functionality. that way, you could move between versions without all the
> rigmarole (sp?) of messing around with mysql.

I had a similar idea a while ago, to provide a ruby script to move up
and down the relevant schema versions. After about 10 minutes you
realise why this hasn't already been done already... Over the time
alot of tables and created and dropped, columns rejiggled, created and
dropped. Recovering the lost data of a dropped table is impossible
without a backup, so theres no point.

It would be nice if the backend would take a snapshot of your database
before moving up to the next version, would be handy for us tracking
SVN and not realising theres a schema update in the recent revisions.

-- 
Andrew Williams
w: http://tensixtyone.com/
e: andy at tensixtyone.com