Uploading Images to Azure(easy Tables)

user_5486366 0
Viewed 787

I am using Azure App Service (Mobile Apps) and would like to upload images via the mobile app. I would prefer to load it into a table with column of data type varbinary(max), which I can use to store images. However, in Easy Tables (in the Azure Portal), I only see data type options String, Number, Date and Boolean. Please cann any one show me a better way to achieve this.

azure-mobile-services local-storage azure sqlite sql
1 Answers

Azure Table Storage is not a relational database and only supports a subset of value data types: https://docs.microsoft.com/en-us/rest/api/storageservices/understanding-the-table-service-data-model#property-types

So you need to either...

  1. Store images in a Blob storage and the URLs in Easy Tables/Table Storage
  2. Store the images in the included "MySQL In App" database. But I wouldn't use this one since there are some limitations.
  3. Use the Azure SQL Database to store the images or just the URLs (and use again Azure blob storage to store the images)

I would suggest 1 or 3 with storing the images in a blob storage. Storing images in a database is not such a good idea since a) you have a higher load on your database and b) you might have a hard to using browser caching or a CDN.

user_51490620
Related