Uploaded image for project: 'Red Hat 3scale API Management'
  1. Red Hat 3scale API Management
  2. THREESCALE-2635

SaaS maintenance needed, remove columns from accounts and services

XMLWordPrintable

    • Icon: Task Task
    • Resolution: Done
    • Icon: Major Major
    • 2.9.1 GA
    • SaaS
    • Infra, System
    • None
    • 0
    • Not Started
    • Not Started
    • Not Started
    • Not Started
    • Not Started
    • Not Started
    • Engineering
    • 3scale 2019-08-12, 3scale 2019-10-28, 3scale 2019-11-11, 3scale 2019-11-25, 3scale 2019-12-23, 3scale 2020-01-13, 3scale 2020-01-27, 3scale 2020-02-03, 3scale 2020-02-17, 3scale 2020-03-09, 3scale 2020-03-23, Invalid Sprint

      Database cleaning

      Some tables like accounts and services have too many columns and some of them are not used anymore. We just programmatically hide them instead of removing them.

      https://github.com/3scale/porta/blob/ba76f595b24792f40292bf04e566087b3c75593f/app/models/account.rb#L9

      https://github.com/3scale/porta/blob/ba76f595b24792f40292bf04e566087b3c75593f/app/models/service.rb#L48

      Goal

      Having unused columns is not really good for database (taking time and place), unecessary indices and also for programming (code maintenance)

      Those columns are not used for years. It is time to drop them and make our database ligher.

      Maintenance window needed

      This needs a maintenance window as we are touching some important tables, not allowing any scripts and requests to update the database

          There are no Sub-Tasks for this issue.

              Unassigned Unassigned
              hramihaj Hery Ramihajamalala (Inactive)
              Marta Noya Marta Noya (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: