Skip to main content
Solved

Image upload


Forum|alt.badge.img+3

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.

Best answer by AndreKemmeren

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.

View original
This topic has been closed for comments

Forum|alt.badge.img+17

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. 


AndreKemmeren
Captain
Forum|alt.badge.img+3

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?


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings