Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

keep track of timetrap release in database #97

Open
zerobuzz opened this issue Jun 8, 2014 · 1 comment
Open

keep track of timetrap release in database #97

zerobuzz opened this issue Jun 8, 2014 · 1 comment
Labels
in consideration Describes a feature worth taking into account

Comments

@zerobuzz
Copy link

zerobuzz commented Jun 8, 2014

for being able to changing the database format in the future, it would be cool to have a table that keeps track of the database schema version and the timetrap release. i propose:

create table 'version' ('timetrap' integer, 'schema' integer);

it's not a big deal that it has not been put in there from the start: should a schema change become necessary, timetrap can simply assume schema version 'old' on all databases that do not keep track.

i propose to do it now anyway because:

  1. schema version: current time trap code could constrain the newest schema version now, so if in the future somebody would run an old timetrap executable on a new database by accident, there would be a (better) error.
  2. timetrap release: interesting in case bugs become known that affect the consistency of the database.
@samg
Copy link
Owner

samg commented Jun 10, 2014

I've considered version of this idea, but never implemented it for fear I'd be over engineering. So far there has never been a breaking schema change, but perhaps timetrap has crossed the threshold where this kind of compatibility layer makes sense. Issue #96 is a great example of where this kind of tracking could come in handy.

@categulario categulario added the in consideration Describes a feature worth taking into account label May 16, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
in consideration Describes a feature worth taking into account
Projects
None yet
Development

No branches or pull requests

2 participants