Save Base64 Image To Mobile Services Sql Or Blob Storage?

So here's the deal, i have an Ionic App and i'm using Azure Mobile Services with JavaScript backend and i need to save images to the cloud. I have a SQL database (auto-created when

Solution 1:

If it's just a demo app, do it as easy as possible. I'm not familiar with mobile development but maybe put image base64 string into database and then retrieve and render on your mobile, which might be the easiest way to implement.

But if it's a production, I'd recommend to use blob, which provides more benefits than database (especial SQL Database).

1. Blog storage is much cheaper than SQL Database.

2. Support CDN.

3. SQL Server data type length limitation. This might not be a problem if you are just saving users' avatar.

4. More bandwidth. It will not use SQL bandwidth when retrieving image and file.

5. Blob support auto-scale, which could scale-out by container, -up by request frequency.

Hope this helps,