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

Store the edit data in a JSONB column

XMLWordPrintable

      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.

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

              Created:
              Updated:
              Resolved:

                Version Package
                Schema change, 2016-05-23