Skip to content

Create "meta" table, maintain various stats useful for troubleshooting #7

@deoren

Description

@deoren

The content below is pulled from an old local todo.txt file. I've changed my mind on some of the details, but posting here as-is for now. I plan to loop back later and refine the details before working to implement this.


  • Create meta table for logging when any other table was last updated (presumably we won't be wholesale nuking the existing tables on each run by this point)

    • meta.db_last_modified
    • meta.db_revision (auto-increment for every update to database)
  • Create TRIGGER to handle updating meta.db_last_modified column when any other table is modified

    • possibly have this same TRIGGER handle updating the meta.db_revision column too

Metadata

Metadata

Assignees

Labels

enhancementNew feature or request

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions