Uploaded image for project: 'UX Product'
  1. UX Product
  2. UXPROD-3172

Migrate file storage for Agreements and Licenses from database to file store

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Open (View Workflow)
    • Priority: TBD
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
    • Template:
      UXPROD features
    • Development Team:
      ERM
    • Calculated Total Rank:
      11
    • PO Rank:
      0
    • Rank: Cornell (Full Sum 2021):
      R4
    • Rank: GBV (MVP Sum 2020):
      R1

      Description

      Current situation or problem:

      • When you add a document to an Agreement or License you have the option to upload a file
        • This file is stored in the database as a large object
        • PostgreSQL can decide to store this in a different schema
        • This makes replication/migration of a database schema for (e.g.) agreements complicated because you have to also migrate the large storage schema
        • In a multi-tenant situation this means it becomes very challenging to separate out the tenants

      In scope

      Substitute in a file storage mechanism based S3 compatible protocols instead of the use of the database to store files

      Out of scope

      Implementation of other file storage mechanisms (e.g. box.com)

      Use case(s)

      Proposed solution/stories

      Links to additional info

      Questions

        TestRail: Results

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                Unassigned Unassigned
                Reporter:
                ostephens Owen Stephens
                Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                  Dates

                  Created:
                  Updated:

                    TestRail: Runs

                      TestRail: Cases