Skip to content

Move SQLite schema migration out of the request path into script #3

Description

@QuickWrite

Problem

On every request the SQLiteDatabases loadConnection() method is being called. This method does load the database, but also runs a simple migration of that database to ensure that the schema is still correct. However this is most likely overkill as the database only has to migrated once before the application runs.

Changes

  • The migration system shall be moved out of the loadConnection() method and be put into an external script that can be executed when the database changes or before starting the server.
  • The docker container has to also migrate the database on load to ensure the correct version.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

enhancementNew feature or request

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions