Page MenuHomeMusing Studio
Create Task
Maniphest T767

Move collection attributes to collections table
Open, Medium-HighPublic
Actions

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
Search...

StatusAssignedTask
 OpenNoneT928 Enable migration from Write.as to WriteFreely
 OpenNoneT924 Custom WriteFreely favicon and avatar
 ResolvedmattT546 Custom blog avatar
 OpenmattT562 eBook export
 ResolvedmattT802 Enable all add-ons for Publisher users
 OpenNoneT768 Support disabling eBook download
 OpenNoneT300 Customizable number of posts on blog index
Restricted Maniphest Task
Restricted Maniphest Task
 ResolvedmattT758 Upload photos via API
Restricted Maniphest Task
Restricted Maniphest Task
 OpenNoneT767 Move collection attributes to collections table
 ResolvedmattT884 Replaceable, single-purpose images

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
matt added a parent task: T768: Support disabling eBook download.Sep 21 2020, 10:50 PM
musing studio · developers