User Tools

Site Tools


attachment

Attachments and Links

Terminology

  • Attachment : Anything that can be attached to a note
  • Link : Anything remote linked to in a note
  • AttachmentThumbnail : The thumbnail of an attachment

Not every Link has an attachment. An attachment is created for a link when it becomes something attachable. So happens when additional information on a link's URL becomes available.

Following how it is done with Links, anything with a thumbnail in GNU social must have an attachment as only attachments can have a thumbnail.

This design prevents file and thumbnail duplication, thus saving storage.

An example of a module making use of this system is the Avatar component. It creates an attachment and uses the thumbnail route to access different avatar sizes via the AttachmentThumbnail controller.

Migrating data from v2

File to Attachment

Direct transformation:

  • id => id
  • filehash => filehash
  • mimetype => mimetype
  • size => size
  • modified => modified

Requires computation:

  • filename => {if file is in storage then filename, else null}
  • width => {if file is known by V3, re-compute then width, else null}
  • height => {if file is known by V3, re-compute then height, else null}
  • Count references and fill lives

Only if url and urlhash are not null.

Direct transformation:

  • id => id
  • url => url
  • urlhash => url_hash

File and File_to_post to AttachmentToNote

Direct transformation by joining File f and File_to_post fp on id = file_id with fp.file_id, fp.post_id, f.title, f.filename, fp.modified:

  • file_id => attachment_id
  • post_id => note_id
  • modified => modified

Requires computation:

  • title ?? filename => title

File_thumbnail to AttachmentThumbnail

For every attachment where we have the original (filename not null), just let them be regenerated on request. For all the others, compute the mime-type and rescale to the new default sizes.

The field url from File_thumbnail has duplicated information that was already migrated in the tables above and can, therefore, be safely ignored now.

Embed and StoreRemoteMedia

// TODO

attachment.txt · Last modified: 2021/08/18 12:19 by diogo