Document pros/cons to store complete S3 url attachments or only attachment name in database

[stephane-klein]

Document pros/cons to store complete S3 url attachments or only attachment name in database.

Ressources:

• https://stackoverflow.com/questions/36962030/storing-files-in-s3-referencing-from-postgres
• https://stackoverflow.com/questions/47268512/best-practices-for-storing-references-to-aws-s3-objects-in-a-database

[stephane-klein]

Benefits to store only the attachment name in database:

• I can copy production database + attachments locally
• I can migrate from one S3 bucket to another without update the database