Asked by:
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.Sunday, May 10, 2020 5:56 PM
All replies
-
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
- VaibhavMonday, May 11, 2020 7:07 AM -
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 .
- Edited by Kalyan Chanumolu-MSFTMicrosoft employee Monday, May 11, 2020 12:09 PM
- Proposed as answer by Kalyan Chanumolu-MSFTMicrosoft employee Thursday, May 14, 2020 1:19 PM
Monday, May 11, 2020 12:08 PM -
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.
Thursday, May 14, 2020 1:19 PM