Skip to main content
Answer

Image upload

  • October 17, 2023
  • 3 replies
  • 157 views

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.

This topic has been closed for replies.

3 replies

Forum|alt.badge.img+17
  • Moderator
  • October 19, 2023

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
  • Captain
  • Answer
  • October 20, 2023

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.


  • Rookie
  • November 21, 2023

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