On Wed, Dec 2, 2009 at 8:43 AM, Luis Villa <[email protected]> wrote: > On Wed, Dec 2, 2009 at 5:07 AM, Eric Allen <[email protected]> wrote: >> I wonder if you could use SQLite's .dump command to save the data, blow away >> the database and create one with the right schema using rake, then re-import >> the data into SQLite. You might need to manually translate the 1/0's to >> t/f's, but once you're in a text file it shouldn't be too bad. Obviously >> keep copious backups... > > Yeah, I started that process last night. > > One thing I noticed while doing that- the 'tracks-17-blank.db' in your > branch is not actually, you know, 'blank' :) It looks like it contains > a bunch of Henrik's stuff- his user account, five todos ('learn > ruby'), etc. Might want to revert that to a truly blank db before > merging to bsag's trunk.
(Or alternately a blank db except for a few default contexts; 'home', 'work', 'phone', 'computer', 'someday-maybe'?) One other observation is that my database seems to have essentially no indexes, whereas the blank db has a large number of them. Are the db:migrates properly adding them? Luis _______________________________________________ Tracks-discuss mailing list [email protected] http://lists.rousette.org.uk/mailman/listinfo/tracks-discuss
