User: Creating and Storing Pictures in Work Order

[Songtone]

Story: As a User, I want to take pictures when creating a work order.

Steps:

• Implement the ability to store pictures in DB & Update API endpoint and services: Image Storage in DB and Update API #84
• Frontend integration of API and camera usage: Implement taking pictures when creating work order #85

[Total SP: X]
[Priority: Medium]
[Risk: Medium]

Mila's Note: 1 hour spent on research.

[heyhellomila]

Reference for this inquiry: https://www.quora.com/In-how-many-ways-can-we-store-images-of-our-web-application

[heyhellomila]

According to my research, storing images in the DB is possible; However, it is best to use a third party cloud service. I am thinking of including AWS (Amazon Web Services).

The downside for storing images in DB table is the following:

File size increases and result-sets that contain many large files consume more memory. And, if you’re using a storage engine that uses table-locks for writes, the image files table may get locked depending on the size of image files being added/modified.

This is ideal for the future development of the app.

[heyhellomila]

Closed issue as new feature will be done for data analysis instead.