Uploaded image for project: 'MusicBrainz Server'
  1. MusicBrainz Server
  2. MBS-8716

Store the edit data in a JSONB column

    XMLWordPrintable

    Details

      Description

      PostgreSQL version 9.4 introduced a new JSONB type for storing JSON in a more space-efficient way. When we switch to a newer version, we should use that for storing the edit data.

      In addition to the space savings (which also mean performance improvements because more data can be hold in the in-memory cache), JSONB and the extraction operators that accompany it would allow us to remove the dependency on PL/Perl and the JSON::XS module (for the database user). Those can be difficult for database-as-a-service users in particular.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                chirlu Ulrich Klauer
                Reporter:
                chirlu Ulrich Klauer
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Due:
                  Created:
                  Updated:
                  Resolved:

                  Packages

                  Version Package
                  Schema change, 2016-05-23