[mythtv] handling database structural changes

Ben Bucksch linux.news at bucksch.org
Fri Jun 6 23:01:29 EDT 2003


Bruce Markey wrote:

> embedding upgrade code is problematic.

You wouldn't need to do that. If the DB is detected to be at version 0.8 
while the app is 0.9, take the file 
$(PREFIX)/share/mythtv/database/08-to-09.sql and execute it against the 
DB. If the app is a certain CVS version and the DB has a lower CVS 
version or is from the latest release, then execute cvs.sql. As I 
understood it, that file is designed to be run in full everytime an 
update is needed, so you don't need extra code for each minor DB update, 
only the version.



More information about the mythtv-dev mailing list