Uploaded image for project: 'SonarQube'
  1. SonarQube
  2. SONAR-2570

Compress db column FILE_SOURCES.DATA

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.8
    • Fix Version/s: 5.1
    • Component/s: Database
    • Labels:
      None

      Description

      Presently the source code that is analyzed and stored in Sonar's database is stored uncompressed and in the clear. As databases grow this requires an enormous amount of disk space to house this data. I propose that this data is compressed prior to storage and expanded when returned to the UI. Whilst there will be a processing overhead in doing so, the benefit is that databases do not become over-bloated. Obviously not all the databases that Sonar supports provide CLOB/BLOB encryption, so I would suggest using a database agnostic mechanism such as the Zip classes in Java.

      This will also enable in the future the ability to encrypt the source so that it is no longer stored in the clear.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              simon.brandhof Simon Brandhof (Inactive)
              Reporter:
              boggybumblebee BoggyBumblebee
              Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Due:
                Created:
                Updated:
                Resolved: