Page MenuHomeMusing Studio

Move collection attributes to collections table
Open, Medium-HighPublic

Description

Background

In T300#12742, @matt wrote:

We're now starting to add more custom properties on Collections (e.g. with Web Monetization support in #369 and {T464}). So with this, I think we should switch from using the collectionattributes table to a new collections column: attributes, containing a JSON object of properties for the collection.

Besides reducing database queries, it'll also ease Collection fetching and make the process more consistent.

Implementation

As part of this schema change, we'll also need to migrate existing rows from the collectionattributes table to the column.

Related Objects

StatusAssignedTask
Openmatt
Resolvedmatt
OpenNone
OpenNone
Openmatt
Resolvedmatt
OpenNone
Resolvedmatt

Event Timeline

matt renamed this task from Move collection_attributes to collections table to Move collection attributes to collections table.Sep 21 2020, 10:36 PM
matt triaged this task as Medium-High priority.
matt created this task.
matt created this object with edit policy "Restricted Project (Project)".
matt added a parent task: T546: Custom blog avatar.
matt added a parent task: Restricted Maniphest Task.
matt added a parent task: Restricted Maniphest Task.Sep 21 2020, 10:41 PM