Data Base with Azure

Question

I am doing an academic work on the construction of an image database. And I was left with the following doubt.
 I need to develop a database that will store about 20 images that must be cataloged by categories (for example, economy, travel, banks) and these images must be attached to a web page. I would like to know if my reasoning is correct in the construction:

1 -Think about the server that will host these images (in this case, I will use Azure);
2 - Choose the database language, in this case, SQL Server.
3 - Communicate between the server and the content of the web page.

Answer 1

You may also consider using Azure blob storage to store images and connect them to webpage. I would also suggest to post a question on below forum with a tag - azure-webapps

https://docs.microsoft.com/en-us/answers/questions/ask.html

References - connecting web page with blob storage 

https://docs.microsoft.com/en-us/azure/storage/blobs/storage-upload-process-images?tabs=dotnet

https://stackoverflow.com/questions/60715046/how-to-retrieve-images-from-azure-blob-storage-and-display-on-website-with-php

---

If the response helped, do "Mark as answer" and upvote it
- Vaibhav

Answer 2

How big are your images? 

Whether to store the images in a database or on a filesystem (blob) is a vastly discussed topic

Microsoft Research published a study on this.

In simple terms, objects smaller than 256K are best stored in a database while objects larger than 1M are best stored in the filesystem. Between 256K and 1M, the read:write ratio and rate of object overwrite or replacement are important factors.

Here is a step by step tutorial of a web app for uploading and saving images to Azure Blob Storage.

You can hold the metadata (categories) of the images in an Azure SQL Database

Please let us know if you have further questions.

-

If this answers your query, do click “Mark as Answer” and Up-Vote for the same which might be beneficial to other community members reading this thread .

Answer 3

Just checking in to see if the above answer(s) helped.

 

If this answers your query, do click “Mark as Answer” and Up-Vote for the same which might be beneficial to other community members reading this thread .

And, if you have any further queries do let us know.