pytest-monitor icon indicating copy to clipboard operation
pytest-monitor copied to clipboard

Add postgres DB handler

Open Veritogen opened this issue 1 year ago • 1 comments

Describe the solution you'd like We'd like to keep track of different pipeline results in a dedicated database.

Describe alternatives you've considered

  • Implementing a server to collect the pipeline results seemed like a bigger overhead as it also includes more infrastructure to maintain compared to just pushing the results into a database.
  • Moving the sqlite database into the CI environment would be another option. This may lead to race conditions, if we have multiple pipelines running in parallel.

Additional context I got a working prototype (see https://github.com/CFMTech/pytest-monitor/pull/78) but would like to discuss the following points:

  • How do we want to test the postgres implementation?
    • Proposal: add postgres image to pipeline to be able to run the tests against a database in docker
  • What version of psychopg (2, 3 or both) do we want to support?
    • I'd propose to support both to be future proof
    • How do we add this to the requirements?
  • Does the implementation proposed match the architecture you envisioned?
  • How to ensure people don't need to install uneccessary dependencies? Maybe we could enable people installing pytest-monitor like this pip install pytest-monitor[postgres]

Veritogen avatar Dec 18 '23 14:12 Veritogen