Log DB file should be versioned

[Mikkel Kamstrup Erlandsen]

We should really store log DB schema version in the our sqlite. That way we can do smooth upgrades without hacks. Not only that, but we can also shave off a lot of SQL grinding at startup if we just check the db schema version...

I am thinking a new table:

  CREATE TABLE IF NOT EXISTS version_info (schema_name VARCHAR, version INT)

This table will have one row for our initial use case, but we may add more rows in the future. The schema_name of our core log db could be "main_log" and on startup we'd do:

 SELECT version FROM version WHERE name='main_log';

  if version != expected_version : do stuff
  else : no need to run all our initial sql

[Seif Lotfy (seif)]

how is progress on this issue...
is there a branch for it?

[Mikkel Kamstrup Erlandsen (kamstrup)]

@Seif: *pssst* look under the "Related Branches" header, but don't tell anyone ;-P