Skip to main content

Hello,

 

I have created a basic database image upload functionality and I want to know if there is a possibility to switch from the database blob to azure blob storage depending on the image size. I saw that on the file storage locations you can pre-define a max size in MB.

What I want is to have that set up to a limit and if my picture exceed the limit, I want it to be automatically saved in azure blob and not in the database.

 

For example if I set up the file storage location to my database and I set up the limit on 5 MB and I try to upload a picture bigger than that I want the picture to be sent in azure blob storage and not in database.

For azure I have also set up a file storage location and I don't know if I can make them work together.

1 column can only have 1 storage type. If you really need this functionality you could create a process flow to determine the file size and based on that fill either column A or column B. Where column A uses azure blob and column B uses database blob. 


I'd recommend just putting any binary into a storage location.

Databases don't really like binaries and it helps to keep your database small while the Azure Storage is honestly dirt cheap and really fast.

 

We've noticed huge performance benefits from using Blob Storage even for smaller binaries.


Hi @TurcuPaulAndrei  it's been a while since you created this topic. Did you manage to solve your situation in the meantime?